Re: [GENERAL] hard limit on result handles reached

1999-09-15 Thread Peter Mount
On Wed, 15 Sep 1999, Robert Wagner wrote: > Hello all, > > Ran into this while regression testing my app. > > Does anybody know if this is a physical limitation of postgress, or is this > a parameter to the database that I can change? Kinda limits the database's > usefulness in the real world.

[GENERAL] hard limit on result handles reached

1999-09-15 Thread Robert Wagner
Hello all, Ran into this while regression testing my app. Does anybody know if this is a physical limitation of postgress, or is this a parameter to the database that I can change? Kinda limits the database's usefulness in the real world... On the 128th query, this is the error I get... up unt

[GENERAL] Re: [HACKERS] Permission problem with COPY FROM

1999-09-15 Thread Tom Lane
Nuchanach Klinjun <[EMAIL PROTECTED]> writes: > I've faced that problem too, then I use '\copy' instread > of 'copy' because 'copy' command will asked for super user previlege. > example > ^^ -> \copy '/your location/your filename' to tablename; It's not that; the error message Stephane

[GENERAL] Re: [HACKERS] BUG with UNIQUE clause

1999-09-15 Thread Tom Lane
"=?iso-8859-1?Q?St=E9phane_FILLON?=" <[EMAIL PROTECTED]> writes: > The UNIQUE constraint doesn't work on a field if I use a DEFAULT clause > on a table. This sounds closely related to a fix that Thomas Lockhart just made. IIRC the complained-of symptom was that PRIMARY KEY on one column plus UNIQ