[BUGS] Unlisten / listen in a transaction failure

I came across some unusual behavior with listen. Basically, if you unlisten and listen inside of a transaction, new notices are not picked up right away - but they will show up if you send yourself a notice. It also works as expected if you unlisten, commit, and then re-listen. Tested on 9.1 an

Re: [BUGS] Unlisten / listen in a transaction failure

Greg Sabino Mullane writes: > I came across some unusual behavior with listen. Basically, if you > unlisten and listen inside of a transaction, new notices are not > picked up right away - but they will show up if you send yourself > a notice. It also works as expected if you unlisten, commit,

[BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist

The following bug has been logged on the website: Bug reference: 7873 Logged by: Dave Rolsky Email address: auta...@urth.org PostgreSQL version: 9.2.3 Operating system: Linux Description: When you pass the --clean option to pg_restore it tries to drop tables without c

[BUGS] BUG #7874: GUC's not in database dumps

The following bug has been logged on the website: Bug reference: 7874 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL version: 9.2.1 Operating system: OSX, Linux Description: If I run: alter database foo set my.name = 'joe'; that GUC isn't availabl