[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 UNIQUE

[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] 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

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...