Re: [BUGS] WARNING: 01000: could not dump unrecognized node type: 928

2010-11-12 Thread Jon Nelson
On Fri, Nov 12, 2010 at 9:29 PM, Tom Lane wrote: > Jon Nelson writes: >> I get this whenever debug_print_rewritten = on >> WARNING:  01000: could not dump unrecognized node type: 928 >> LOCATION:  _outNode, outfuncs.c:2787 >> right before >> LOG:  0: rewritten parse tree: > >> PostgreSQL 8.4.

Re: [BUGS] WARNING: 01000: could not dump unrecognized node type: 928

2010-11-12 Thread Tom Lane
Jon Nelson writes: > I get this whenever debug_print_rewritten = on > WARNING: 01000: could not dump unrecognized node type: 928 > LOCATION: _outNode, outfuncs.c:2787 > right before > LOG: 0: rewritten parse tree: > PostgreSQL 8.4.5 on Linux x86-64 Hm, do you use CREATE TABLE LIKE a lot?

[BUGS] BUG #5752: installer does not give proper os privileges on folders

2010-11-12 Thread Kasia Tuszynska
The following bug has been logged online: Bug reference: 5752 Logged by: Kasia Tuszynska Email address: ktuszyn...@esri.com PostgreSQL version: 9.0.1 Operating system: Windows 2008 R2 (64bit) Description:installer does not give proper os privileges on folders Details:

[BUGS] WARNING: 01000: could not dump unrecognized node type: 928

2010-11-12 Thread Jon Nelson
I get this whenever debug_print_rewritten = on WARNING: 01000: could not dump unrecognized node type: 928 LOCATION: _outNode, outfuncs.c:2787 right before LOG: 0: rewritten parse tree: PostgreSQL 8.4.5 on Linux x86-64 Does this sound familiar? -- Jon -- Sent via pgsql-bugs mailing li

Re: [BUGS] BUG #5751: pg_restore does not work correctly with BLOBs

2010-11-12 Thread Tom Lane
"Michael Feldmann" writes: > [ pg_dump -c doesn't delete BLOBs ] This appears to be fixed in 9.0. I fear it's impractical to do anything about it before that, because pg_dump didn't treat BLOBs as first-class objects before 9.0. regards, tom lane -- Sent via pgsql-bugs

[BUGS] BUG #5751: pg_restore does not work correctly with BLOBs

2010-11-12 Thread Michael Feldmann
The following bug has been logged online: Bug reference: 5751 Logged by: Michael Feldmann Email address: michael.feldm...@uni-muenster.de PostgreSQL version: 8.4.5 Operating system: Ubuntu Description:pg_restore does not work correctly with BLOBs Details: I start wi

Re: [BUGS] BUG #5721: EnterpriseDB linux one-click installer missing libuuid.so.16

2010-11-12 Thread Alvaro Herrera
Excerpts from Bruce Momjian's message of vie nov 12 15:09:17 -0300 2010: > Alexia Lau wrote: > > I'm running into the same problem reported with bug #5677, but I'm > > installing on SUSE 11 and RedHat 5.5. I saw a thread below and Dave Page > > mentioned that there's a bug which didn't copy the l

Re: [BUGS] BUG #5721: EnterpriseDB linux one-click installer missing libuuid.so.16

2010-11-12 Thread Bruce Momjian
Alexia Lau wrote: > > The following bug has been logged online: > > Bug reference: 5721 > Logged by: Alexia Lau > Email address: a...@esri.com > PostgreSQL version: 9.0.1 > Operating system: SUSE 11/RHEL 5.5 32-bit & 64-bit > Description:EnterpriseDB linux one-click i

Re: [BUGS] BUG #5750: dropping objects owned by user fails

2010-11-12 Thread Heikki Linnakangas
On 12.11.2010 15:06, Chetan wrote: postgres=# create user t; CREATE ROLE postgres=# create foreign data wrapper wrap123; CREATE FOREIGN DATA WRAPPER postgres=# grant usage on foreign data wrapper wrap123 to t; GRANT postgres=# drop owned by t; ERROR: unexpected object class 2328 postgres=# Fix

[BUGS] BUG #5750: dropping objects owned by user fails

2010-11-12 Thread Chetan
The following bug has been logged online: Bug reference: 5750 Logged by: Chetan Email address: chetan.suttra...@enterprisedb.com PostgreSQL version: 9.0.1 Operating system: Ubuntu 9.10 Description:dropping objects owned by user fails Details: steps to reproduce: ps