Re: [BUGS] Missing Make Files

2003-06-16 Thread Tom Lane
David Rickard <[EMAIL PROTECTED]> writes: > Downloaded postgresql-7.3.3.tar.gz and unpacked it on our system > (sparc-sun-solaris2.6); ran the configure script, apparently successfully > (non-fatal warnings about not finding flex, bison, and zlib), The zlib error was fatal: configure:5964: erro

Re: [BUGS] bug in pg.py and the fix

2003-06-16 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Chih-Hao Huang wrote: > If PostgreSQL fai

[BUGS] bug in pg.py and the fix

2003-06-16 Thread Chih-Hao Huang
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem

[BUGS] Missing Make Files

2003-06-16 Thread David Rickard
Don't know if this indicates a bug or an incomplete download, but: Downloaded postgresql-7.3.3.tar.gz and unpacked it on our system (sparc-sun-solaris2.6); ran the configure script, apparently successfully (non-fatal warnings about not finding flex, bison, and zlib), and then attempted to do make

[BUGS] Bug: ipcclean didn't work on HP-PA platform

2003-06-16 Thread Durai
Hello Sir,   I executed the PostgreSQL binary ipcclean on HP-PA 11.11 platform.When I executed the ipcclean binary, it gives the following error:   $ su postgres   $ ipccleanYou cannot run ipcclean as root. Please log in (using, e.g., 'su')as the (unprivileged) user that owned the server pro

[BUGS] fe-connect build failure (Solaris 9, PGSQL 7.3.3, OpenSSL 0.9.7b)

2003-06-16 Thread Paul Eggert
I ran into the following problem building PostgreSQL 7.3.3 on Solaris 9 (sparc) using GCC 3.3 and OpenSSL 0.9.7b. gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC -I. -I../../../src/include -I/opt/reb/include -I/opt/sfw/include -DFRONTEND -DSYSCONFDIR='"/opt/reb/etc/postgresql"'

[BUGS] commands

2003-06-16 Thread subbiah K
i want how to start the postsql in redhat linux 8 & how to access the data base postgresql in linux i have ms access 2000 db its possible to access in linux go throw in postgresql ---(end of broadcast)--- TIP 2: you can get off all lists at once wit

Re: [BUGS] 7.3.3 ADD COLUMN wierdness

2003-06-16 Thread Tom Lane
"Brian O'Donoghue" <[EMAIL PROTECTED]> writes: > I was thinking something along the lines of > ALTER TABLE blah ADD COLUMN whatever integer not null default 1; > should work, It should, we just haven't got round to implementing that combination yet. regards, tom lane

Re: [BUGS] 7.3.3 ADD COLUMN wierdness

2003-06-16 Thread Tom Lane
"Brian O'Donoghue" <[EMAIL PROTECTED]> writes: > ALTER TABLE blah ADD COLUMN whatever integer not null; > Adding NOT NULL columns is not implemented. > Add the column, then use ALTER TABLE ... SET NOT NULL. > Hmm, the last time I checked, this should have worked. Although 7.1 allowed that

Re: [BUGS] 7.3.3 ADD COLUMN wierdness

2003-06-16 Thread Brian O'Donoghue
Ah yes. ALTER TABLE blah ADD COLUMN whatever integer; UPDATE blah set whatever=1; ALTER TABLE blah ALTER COLUMN whatever SET NOT NULL; Produces the desired effect. I was thinking something along the lines of ALTER TABLE blah ADD COLUMN whatever integer not null default 1; should work, but the

Re: [BUGS] 7.3.3 ADD COLUMN wierdness

2003-06-16 Thread Rod Taylor
On Mon, 2003-06-16 at 07:53, Brian O'Donoghue wrote: > I'm running two different strains of PostgreSQL > > 7.1.3, which is what our website is running off of now and 7.3.3, which we > hope to move to (sometime). > > In 7.1.3 I can say > > ALTER TABLE blah ADD COLUMN whatever integer not null; C

[BUGS] 7.3.3 ADD COLUMN wierdness

2003-06-16 Thread Brian O'Donoghue
I'm running two different strains of PostgreSQL 7.1.3, which is what our website is running off of now and 7.3.3, which we hope to move to (sometime). In 7.1.3 I can say ALTER TABLE blah ADD COLUMN whatever integer not null; and as expected, that works fine on 7.3.3 the same command returns A