Re: Permissions problem with sequences - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Permissions problem with sequences
Date
Msg-id 3655.1094436279@sss.pgh.pa.us
Whole thread Raw
In response to Permissions problem with sequences  ("Gary Doades" <gpd@gpdnet.co.uk>)
Responses Re: Permissions problem with sequences  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-bugs
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> However, of course the best thing is to just fix it, which I guess I'll
> have a crack at...

Given that pg_dump does put out GRANT/REVOKE operations on the sequence,
it's certainly aware that the sequence exists.  I suspect this is just a
fixable bug (ie, suppression of output of the sequence CREATE command is
being done at the wrong place).

            regards, tom lane

pgsql-bugs by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: plpgsql error handling bug
Next
From: "Koju Iijima"
Date:
Subject: transaction block: server closed the connection unexpectedly