Owner and privileges on sequences

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgadmin-support(at)postgresql(dot)org
Subject: Owner and privileges on sequences
Date: 2009-10-09 07:50:22
Message-ID: hampvl$kol$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

For sequences, the DDL script generated looks like:

CREATE SEQUENCE ...;
ALTER TABLE ... OWNER TO ...;
GRANT ... ON TABLE ... TO ...;
...

... but should be:

...
ALTER SEQUENCE ... OWNER TO ...;
GRANT ... ON SEQUENCE ... TO ...;
...

Regards,
Dmitry.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rhonalf Martinez Villa 2009-10-10 00:16:31 The server list is not saved
Previous Message Twendilonge Valery VLT 2009-10-09 07:42:16 whatvshould be the next step