[BUGS] config option --with-pgport does not update postgresql.conf

2004-12-24 Thread Josh Berkus
Folks, Summary: --with-pgport option does not update postgresql.conf Severity: trivial Version: 8.0rc1 Platform: SuSE Linux 9.2, Celeron 1800mhz laptop Description: On a lark, I tried compiling RC1 using --with-pgport=5480, since I'm still using 7.4 on this machine as well. Once I finished

Re: [BUGS] BUG Postgresql 7.4.6 : usecreatedb flag

2004-12-24 Thread Tom Lane
Stephane Raimbault <[EMAIL PROTECTED]> writes: > This bug (I suppose it's a bug) is very simple. > Fedora Core 3/postgresql-7.4.6-1.FC3.2 > su - postgres > createuser pguser > Answer yes and no so pguser can create db but can't create new user > ... > The flag in usecreatedb's column is false inst

Re: [BUGS] [pgsql-www] BUG #1356: pg_get_serial_sequence can not find a table that existing.

2004-12-24 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 23 December 2004 15:30 > To: Kamp Kaibo Huang > Cc: [EMAIL PROTECTED]; pgsql-bugs@postgresql.org > Subject: Re: [pgsql-www] BUG #1356: pg_get_serial_sequence > can not find a table

Re: [BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
Found the problem...it's been reported before. http://archives.postgresql.org/pgsql-bugs/2004-11/msg00195.php I was a bad boy and left off the part about the missing ordinal in libeay32.dll... Dunno if that's something that still needs to be fixed, but at least I've got a workaround. Scott -

Re: [BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
I assume the script is broken..._I_ sure didn't send it to -www :) No, no real lockdown except for the Windows Firewall that installs with SP2, but it didn't complain or offer to block or unblock as usual. The postgres account that it created was granted the 'logon as a service' right, but I have

Re: [BUGS] postgresql-8.0.0 beta5 & postgresql-7.4.6 can't compile

2004-12-24 Thread Luojia Chen
Hi, Bruce, Good news is that I've found that the reason caused the compilation error messages about signal.h header file I reported to you before - I used GCC binary built on Solaris 9 x86,which has old header files to work with. The error got fixed after using the gcc binary for Solaris 10 x86.

[BUGS] [pgsql-www] BUG #1355: 8.0.0 rc2 installer fails

2004-12-24 Thread Scott Stillwell
The following bug has been logged online: Bug reference: 1355 Logged by: Scott Stillwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro SP2 Description:8.0.0 rc2 installer fails Details: When installing PostgreSQL 8.0.0 rc2

[BUGS] BUG Postgresql 7.4.6 : usecreatedb flag

2004-12-24 Thread Stephane Raimbault
Hi, This bug (I suppose it's a bug) is very simple. Fedora Core 3/postgresql-7.4.6-1.FC3.2 su - postgres createuser pguser Answer yes and no so pguser can create db but can't create new user psql template1 template1=# select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | useca