Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-27 Thread Peter Koczan
> Please share the ending with us, I'm really curious after following this > thread :). It turns out that it was part DBD::Pg and part our app (a big part). A plugin for the app creates a separate db handle which listens, but never does anything with the notifications. Apparently, the recv-q clear

Re: [BUGS] BUG #3582: CREATE USER via ODBC

2007-08-27 Thread Tom Lane
"Zoltan Szmutku" <[EMAIL PROTECTED]> writes: > I try save a new account: > ?SQLEXEC(1,"CREATE ROLE TESZT LOGIN ENCRYPTED PASSWORD 'nincsen' SUPERUSER > CREATEDB NOCREATEROLE") This isn't a bug. Since you didn't double-quote the role name, it's converted to lower case, the same as any other unquot

Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-27 Thread Andrew Sullivan
On Fri, Aug 24, 2007 at 05:56:29PM -0400, Bruce Momjian wrote: > We moved the "you should upgrade for all minor releases" from FAQ text > to a link to our web site: > > http://www.postgresql.org/support/versioning > > The problem is that instead of those words being in the FAQ, they are > n

Re: [SPAM] Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-27 Thread Feng Chen
We've got the invalid page header again: ERROR: invalid page header in block 18223 of relation "calllegstart" bash-3.00# pg_controldata /var/lib/pgsql/data pg_control version number:812 Catalog version number: 200510211 Database system identifier: 5101280766299

[BUGS] BUG #3582: CREATE USER via ODBC

2007-08-27 Thread Zoltan Szmutku
The following bug has been logged online: Bug reference: 3582 Logged by: Zoltan Szmutku Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Win XP Description:CREATE USER via ODBC Details: Hi , I use VFoxpro 9 client program via Postgre ODBC