Re: [GENERAL] possible pg_dump bug

2009-01-30 Thread Joao Ferreira
On Wed, 2009-01-28 at 09:09 -0800, David Miller wrote: > Pg Dump does not include schema name on insert statement generated from > pg_dump with a -d option when exporting data for a particular table using the > -t . in version 8.3. I believe this same bug exists in 8.4 but > have not confirmed i

Re: [GENERAL] possible pg_dump bug

2009-01-28 Thread Asko Oja
Hi For the record. Using search_path for schema name handling is most annoying feature of pg_dump for us. I have run into many cases where separating schema is inconvenient but don't seem to remember any upsides. regards Asko On Wed, Jan 28, 2009 at 7:39 PM, Tom Lane wrote: > "Raymond O'Donnel

Re: [GENERAL] possible pg_dump bug

2009-01-28 Thread Tom Lane
"Raymond O'Donnell" writes: > On 28/01/2009 17:09, David Miller wrote: >> Pg Dump does not include schema name on insert statement generated >> from pg_dump with a -d option when exporting data for a particular >> table using the -t . in version 8.3. I believe this >> same bug exists in 8.4 but ha

Re: [GENERAL] possible pg_dump bug

2009-01-28 Thread Joao Ferreira gmail
On Wed, 2009-01-28 at 09:09 -0800, David Miller wrote: > Pg Dump does not include schema name on insert statement generated from > pg_dump with a -d option when exporting data for a particular table using the > -t . in version 8.3. I believe this same bug exists in 8.4 but > have not confirmed i

Re: [GENERAL] possible pg_dump bug

2009-01-28 Thread Raymond O'Donnell
On 28/01/2009 17:09, David Miller wrote: > Pg Dump does not include schema name on insert statement generated > from pg_dump with a -d option when exporting data for a particular > table using the -t . in version 8.3. I believe this > same bug exists in 8.4 but have not confirmed it. I believe pg_d

[GENERAL] possible pg_dump bug

2009-01-28 Thread David Miller
Pg Dump does not include schema name on insert statement generated from pg_dump with a -d option when exporting data for a particular table using the -t . in version 8.3. I believe this same bug exists in 8.4 but have not confirmed it. I believe pg_dump should have an option to retain schema in