Re: [GENERAL] COPY with default values won't work?

1999-03-24 Thread Oleg Broytmann
On Wed, 24 Mar 1999, Vadim Mikheev wrote: Or instead of eating tons of memory inserting all those record in one I think this was fixed ~ 1.5-2 years ago... I have the same problem in 6.4.2. I splitted COPY into small chunks (about 500 rows) to overcome this. I beleive Jan fixed this in

[GENERAL] PAM module for Postgres?

1999-03-24 Thread Matthew Hixson
Hello, I'm searching for a PAM module that is capable of authenticating users against information contained in a PostgreSQL database. Does something like this exist arleady? This is to be used on a Linux system. Any info would be greatly appreciated. Thanks, -M@ -- Matthew Hixson -

Re: [GENERAL] COPY with default values won't work?

1999-03-24 Thread Brett W. McCoy
On Wed, 24 Mar 1999, Charles Tassell wrote: @#$#!! Any way to make COPY use default, or shove a lot of data in with a single INSERT query? According to older messages in the mailing list, it is *possible*, but I can't get it to work. My problem is that I might be using this to put a few

Re: [GENERAL] COPY with default values won't work?

1999-03-24 Thread Herouth Maoz
At 07:15 +0200 on 24/03/1999, Charles Tassell wrote: I'm trying to copy data into the following table: CREATE SEQUENCE seq_account_type_ndx; CREATE TABLE accounts ( Account_Type_NDXint4 not null default nextval('seq_account_type_ndx'), Account_Name

[GENERAL] Re: [INTERFACES] Problem using Having in a sub-query wit the Count function.

1999-03-24 Thread Tom Lane
Matthew [EMAIL PROTECTED] writes: "Select ordnum from ordinace where dept='Finance' and ordnum in (Select ordnum from squareview where square='A') and ordnum in (select ordnum from keywordview where keyword='Parade' or keyword='Public Gathering' group by ordnum having count(ordnum) =2)" I