[GENERAL] MkLinux & ODBC compile error

1999-03-24 Thread Mark
I have successfully compiled & run PostgreSQL on MkLinux many times. I added the --with-odbc arguement and now I get an error when I compile. misc.c:100: request for member `overflow_arg_area' in something not a structure or union misc.c:111: warning: passing arg 3 of `vfprintf' from incompatib

[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) =

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

1999-03-24 Thread Ordini
bug: HAVING IN SUBQUERIES This is a known bug. Jose' > > We are trying to execute a query that has several sub-queries embedded > > in it. Below is a snippet of the sql code. > > > > "Select ordnum from ordinace where dept='Finance' and ordnum in > > (Select ordnum f

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

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

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

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 i