[BUGS] Failed to connect to database. Procedural languages files are installed,but are not activated in any database.

2004-09-04 Thread Harald Armin Massa
Failed to connect to database. Procedural languages files are installed,but are not activated in any database. Noted error appears on windows XP, Serice Pack 1 with postgresql 8.0 beta 1 using the installer. After that, connection attempts via psql end with psql: server closed the connection

[BUGS] Permissions problem with sequences

2004-09-04 Thread Gary Doades
Using PostgreSQL 7.4.2 on Fedora core 2 I have a problem with permissions on sequences when restored to another PC. I cannot find this specific bug reported. I have a database with lots of tables & sequences with no problems. I have taken a dump of this database and restored onto another PC (s

Re: [BUGS] Permissions problem with sequences

2004-09-04 Thread Tom Lane
"Gary Doades" <[EMAIL PROTECTED]> writes: > I have a problem with permissions on sequences when restored to > another PC. This is not a dump/restore bug, because in fact you would have had the same behavior before dumping. You never granted permissions on the c1 sequence to user1_test in the firs

[BUGS] readline selection (was Re: [GENERAL] psql leaking? - SOLVED)

2004-09-04 Thread Tom Lane
"Russ Brown" <[EMAIL PROTECTED]> writes: > It seems that the postgesql build process picked up and > used libedit instead of readline: don't know if that's a core issue or a > gentoo ebuild issue... Hmm. Our configure code is *supposed* to be biased to choose readline over libedit, but I thin

Re: [BUGS] Permissions problem with sequences

2004-09-04 Thread Gary Doades
On 4 Sep 2004 at 18:18, Tom Lane wrote: > "Gary Doades" <[EMAIL PROTECTED]> writes: > > I have a problem with permissions on sequences when restored to > > another PC. > > This is not a dump/restore bug, because in fact you would have had the > same behavior before dumping. You never granted per

Re: [BUGS] Permissions problem with sequences

2004-09-04 Thread Michael Fuhr
On Sat, Sep 04, 2004 at 06:18:00PM -0400, Tom Lane wrote: > "Gary Doades" <[EMAIL PROTECTED]> writes: > > I have a problem with permissions on sequences when restored to > > another PC. > > This is not a dump/restore bug, because in fact you would have had the > same behavior before dumping. You

Re: [BUGS] readline selection (was Re: [GENERAL] psql leaking? - SOLVED)

2004-09-04 Thread Peter Eisentraut
Tom Lane wrote: > (1) modify PGAC_CHECK_READLINE so that it really does prefer readline > over libedit consistently. I think all this would take is switching > the loop order: > > for pgac_rllib in -lreadline -ledit ; do > for pgac_lib in "" " -ltermcap" " -lncurses" " -lcurses" ; do > > but pos