Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-25 Thread Magnus Hagander
On Sun, Jan 20, 2013 at 4:59 PM, Tom Lane wrote: > Magnus Hagander writes: >> + PGresult *res = ExecuteSqlQueryForSingleRow(fout, "SELECT >> pg_is_in_recovery()"); > > That function call needs to be schema-qualified for security. Applied and backpatched, with that fix and a sentence

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-20 Thread Magnus Hagander
On Sun, Jan 20, 2013 at 4:59 PM, Tom Lane wrote: > Magnus Hagander writes: >> + PGresult *res = ExecuteSqlQueryForSingleRow(fout, "SELECT >> pg_is_in_recovery()"); > > That function call needs to be schema-qualified for security. Ha! I wonder if I can set up an autoresponder to *mys

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-20 Thread Tom Lane
Magnus Hagander writes: > + PGresult *res = ExecuteSqlQueryForSingleRow(fout, "SELECT > pg_is_in_recovery()"); That function call needs to be schema-qualified for security. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) T

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-20 Thread Magnus Hagander
On Tue, Jan 15, 2013 at 10:35 PM, Magnus Hagander wrote: > On Tue, Jan 15, 2013 at 12:13 AM, wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7809 >> Logged by: Joe Van Dyk >> Email address: j...@tanga.com >> PostgreSQL version: 9.2.2 >> Operati

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-15 Thread Magnus Hagander
On Tue, Jan 15, 2013 at 12:13 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7809 > Logged by: Joe Van Dyk > Email address: j...@tanga.com > PostgreSQL version: 9.2.2 > Operating system: Ubuntu > Description: > > Running pg_dump on a streami

[BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-14 Thread joe
The following bug has been logged on the website: Bug reference: 7809 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL version: 9.2.2 Operating system: Ubuntu Description: Running pg_dump on a streaming replication slave with a database that has unlogge