Tom Lane wrote:
Don Y <[EMAIL PROTECTED]> writes:
Jim C. Nasby wrote:
This is a very minor reason why you should be running the most recent
8.0.x release and not 8.0.3. A much bigger reason is that there are
data-loss bugs that have been fixed.
The folks watching the Postgres releases haven'
Don Y <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>> This is a very minor reason why you should be running the most recent
>> 8.0.x release and not 8.0.3. A much bigger reason is that there are
>> data-loss bugs that have been fixed.
> The folks watching the Postgres releases haven't yet sai
Tom Lane wrote:
Tim Allen <[EMAIL PROTECTED]> writes:
Don Y wrote:
So, I'll deploy them and get feedback on which features I
may need to add (some of the data types are probably a bit
too exotic for most users). I figure I can always contribute
them just before a release...
Just before a rel
Jim C. Nasby wrote:
On Wed, May 17, 2006 at 03:00:48PM -0700, Don Y wrote:
I see the documentation mention added August 1, 2005 byt Tom Lane.
Date tag on the bottom of my man pages is "2005-01-17" -- so that
explains *that*! :>
This is a very minor reason why you should be running the most r
Tom Lane wrote:
"Oliver A. Rojo" <[EMAIL PROTECTED]> writes:
I've just recently upgraded my database from 7.4.8 to 8.0.1. Im dumping
data i got from my old db to my new db but eventually an error occured
ERROR: invalid byte sequence for encoding "UNICODE": 0xd141
That's de
"Oliver A. Rojo" <[EMAIL PROTECTED]> writes:
> I've just recently upgraded my database from 7.4.8 to 8.0.1. Im dumping
> data i got from my old db to my new db but eventually an error occured
> ERROR: invalid byte sequence for encoding "UNICODE": 0xd141
That's definitely not valid UNICODE (UTF-
Hi!
I've just recently upgraded my database from 7.4.8 to 8.0.1. Im dumping
data i got from my old db to my new db but eventually an error occured
ERROR: invalid byte sequence for encoding "UNICODE": 0xd141
I tried setting the client encoding to UNICODE but to no avail.
Please help! Thanks!
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> This seems to work for me. I'd appreciate input, as I'm not sure how
> would other archs (or even my own) cope with the zeroed client address
> trick (note the memcmp ...)
AFAICS that should work; I can't imagine all-zeroes being a valid client
address
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > The problem is that pgstat_bestart (called in InitPostgres, which
> > autovac calls) deliberately ignores autovacuum, due to not having a
> > client address. We could create a fake client address (which doesn't
> > seem easy to do),
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> The problem is that pgstat_bestart (called in InitPostgres, which
> autovac calls) deliberately ignores autovacuum, due to not having a
> client address. We could create a fake client address (which doesn't
> seem easy to do), or we could change pg_stat
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >>> Hmm, autovacuum won't show up in pg_stat_activity because it never
> >>> calls pgstat_report_activity(). Seems like maybe it should, though.
>
> > Yep. I'll fix it. Should I backpatch to 8.1?
>
> Yeah, proba
Florian G. Pflug wrote:
A.M. wrote:
Excellent catch! I was wondering why I couldn't get it to freeze. I now
have a backtrace:
poll()
wxPaletteBase::~wxPaletteBase
g_main_context_check()
g_main_run_loop_run()
gtk_main()
wxEventLoop::Run()
So the evidence points to a wx bug in the destructor to w
A.M. wrote:
Excellent catch! I was wondering why I couldn't get it to freeze. I now
have a backtrace:
poll()
wxPaletteBase::~wxPaletteBase
g_main_context_check()
g_main_run_loop_run()
gtk_main()
wxEventLoop::Run()
So the evidence points to a wx bug in the destructor to wxPaletteBase
perhaps?
H
Florian G. Pflug wrote:
It took me a while to find out how exactly to reproducte the hang (It
would happen to me about once a day when using pgadmin3 heavily on
gnome/metacity, but when trying to reproduce it, I couldn't).
You have to select some text, and then _doubleclick_ on the selected
Dave Page wrote:
-Original Message-
From: A.M. [mailto:[EMAIL PROTECTED]
Sent: 15 May 2006 15:05
To: Dave Page
Subject: Re: [GENERAL] GUI Interface
I'm unable to reproduce this problem with pgAdmin SVN-trunk
built with
wxGTK 2.6.3 on Slackware-current with KDE.
Can anyone else repr
* Matteo Beccati:
> Hi,
>
> Florian Weimer wrote:
>> Closed source? It's a PHP framework. 8-)
>> Anyway, for a web application, the GPL is usually *less* restrictive
>> than various BSD license variants because you do not need to mention
>> the software in the end user documentation. The viral a
* Kenneth Downs:
>>Many proprietary software vendors think that if you program to an
>>interface which has a sole implementation, your code becomes a derived
>>work of that implementation. If you sell different licenses for
>>run-time and development environments, such an attitude towards
>>copyr
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>>> Hmm, autovacuum won't show up in pg_stat_activity because it never
>>> calls pgstat_report_activity(). Seems like maybe it should, though.
> Yep. I'll fix it. Should I backpatch to 8.1?
Yeah, probably, because this is really a re
Alvaro Herrera wrote:
> Larry Rosenman wrote:
> > Bruce Momjian wrote:
> > > Tom Lane wrote:
> > >> Casey Duncan <[EMAIL PROTECTED]> writes:
> > >>> however, when I did "select * from pg_stat_activity" on the pg
> > >>> server, it showed no connection to that db. Then I looked at the
> > >>> proces
Larry Rosenman wrote:
> Bruce Momjian wrote:
> > Tom Lane wrote:
> >> Casey Duncan <[EMAIL PROTECTED]> writes:
> >>> however, when I did "select * from pg_stat_activity" on the pg
> >>> server, it showed no connection to that db. Then I looked at the
> >>> processes: tmp0% ps ax | grep test_seg1
>
Bruce Momjian wrote:
> Tom Lane wrote:
>> Casey Duncan <[EMAIL PROTECTED]> writes:
>>> however, when I did "select * from pg_stat_activity" on the pg
>>> server, it showed no connection to that db. Then I looked at the
>>> processes: tmp0% ps ax | grep test_seg1
>>> 10317 ?D 0:36 postg
Tom Lane wrote:
> Casey Duncan <[EMAIL PROTECTED]> writes:
> > however, when I did "select * from pg_stat_activity" on the pg
> > server, it showed no connection to that db. Then I looked at the
> > processes:
> > tmp0% ps ax | grep test_seg1
> > 10317 ?D 0:36 postgres: autovacuum
Ivan Zolotukhin wrote:
> Hello,
>
> I've recently set up statement_timeout setting in postgresql.conf to
> terminate long running queries from web clients. When I run long
> maintance queries (that should not be terminated) like VACUUM FULL in
> psql client, I can specify per session setting like
Peter Kovacs wrote:
> Sorry for the naive question, but: is there a problem with analyze doing
> full table scans? Analyze will not lock anything, will it?
It used to do that, but the read overhead was too great.
---
>
> P
To refresh people's memory I have a simple Delphi interface (TEdit and
TNavigator) connected via ODBC to a Postgresql 8.0 table.
I've tried the earlier suggestions in various forms with no success.
I again was successful in updating the table with the table containing no
serial column. With th
Emi Lu wrote:
No. It is not for select.
I have tens of tables with very clean structure. For example, username,
application_code, last_modified_by, etc in specific orders.
Since the business model is changed, I have to add some columns to
serveral tables.
I prefer columns orders followin
Jim C. Nasby wrote:
On Wed, May 17, 2006 at 05:48:52PM -0400, Emi Lu wrote:
I think it is a very useful feature for postgresql to support it.
If we have this feature supported, I do not have to recreate the table
and resetup all foreign key constraints, views, triggers, etc that are
based
On May 17, 2006, at 12:34 PM, Tom Lane wrote:
Casey Duncan <[EMAIL PROTECTED]> writes:
however, when I did "select * from pg_stat_activity" on the pg
server, it showed no connection to that db. Then I looked at the
processes:
tmp0% ps ax | grep test_seg1
10317 ?D 0:36 postgres: aut
On Thu, May 18, 2006 at 01:16:02PM +0200, Sim Zacks wrote:
> What I am trying to do is write a multi step query, where it would be
> much much much more efficient to create a temp table, so a single insert
> and then populate it with update statements.
> The problem is that you can't use a temp t
Hello,
I've recently set up statement_timeout setting in postgresql.conf to
terminate long running queries from web clients. When I run long
maintance queries (that should not be terminated) like VACUUM FULL in
psql client, I can specify per session setting like `SET
statement_timeout TO 0` not t
Florian Weimer wrote:
* Kenneth Downs:
If you seek to provide a closed source app that is built upon
Andromeda, you are required to provide the source code to Andromeda
itself. However, your app is not a derivative work in the strict
sense because your code is not mixed in with m
Florian Weimer wrote:
* Joshua D. Drake:
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for
Hi,
Florian Weimer wrote:
Closed source? It's a PHP framework. 8-)
Anyway, for a web application, the GPL is usually *less* restrictive
than various BSD license variants because you do not need to mention
the software in the end user documentation. The viral aspect of the
GPL does not come in
Are there table variables in postgresql that you can include in a join?
If there are other suggestions as to how I can get done what I need
done, I would appreciate those as well.
What I am trying to do is write a multi step query, where it would be
much much much more efficient to create a te
On Sat, May 06, 2006 at 12:08:32AM -0300, Marcelo Fabiano da Silveira wrote:
> I Have some questions of use PQtrace in Windows' systens
>
> 1- The implementation of PQtrace, is possible ONLY with non bloking
> connections ???
> 2- Please, I need same samples of implementation of PQtrace.
PQt
* Joshua D. Drake:
>>> Sounds great! But why GPL? Are you looking to sell licenses?
>> GPL is to spread it as far and wide as possible as fast as possible.
>
> LGPL?
>
> My concern would be, I can't use this toolkit for a closed source
> application if it is GPL.
Closed source? It's a PHP framew
* Kenneth Downs:
> If you seek to provide a closed source app that is built upon
> Andromeda, you are required to provide the source code to Andromeda
> itself. However, your app is not a derivative work in the strict
> sense because your code is not mixed in with mine in any sense. You
> never
37 matches
Mail list logo
