BUG #8811: pg_dumpall broken against pre-8.1 (resubmit 4)

Started by Andrew Gierthover 12 years ago2 messagesbugs
Jump to latest
#1Andrew Gierth
andrew@tao11.riddles.org.uk

The following bug has been logged on the website:

Bug reference: 8811
Logged by: Andrew Gierth
Email address: andrew@tao11.riddles.org.uk
PostgreSQL version: 9.3.2
Operating system: any
Description:

Commit db00d837 changed a query in dumpRoles in pg_dumpall.c such that it
now fails to run, affecting versions before 8.1.

Specifically,

"rolname = current_user AS is_current_user"

should have been "usename = ..." since there is no rolname column.

Per a report on IRC.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Bruce Momjian
bruce@momjian.us
In reply to: Andrew Gierth (#1)
Re: BUG #8811: pg_dumpall broken against pre-8.1 (resubmit 4)

On Mon, Jan 13, 2014 at 03:09:00AM +0000, andrew@tao11.riddles.org.uk wrote:

The following bug has been logged on the website:

Bug reference: 8811
Logged by: Andrew Gierth
Email address: andrew@tao11.riddles.org.uk
PostgreSQL version: 9.3.2
Operating system: any
Description:

Commit db00d837 changed a query in dumpRoles in pg_dumpall.c such that it
now fails to run, affecting versions before 8.1.

Specifically,

"rolname = current_user AS is_current_user"

should have been "usename = ..." since there is no rolname column.

Per a report on IRC.

Thanks. Fixed and backpatched to 9.3.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs