Re: [HACKERS] Open 6.4 items - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Open 6.4 items
Date
Msg-id 35E9DB1B.F59BE928@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Open 6.4 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> > Works fine _if_ the user has database creation privileges:
> Can I ask why sequence creation is related to database CREATION.
> Seems very strange to me.

I'd guess that it is related to being allowed to put entries into
whatever supports sequences (a view or table?). If you created the
database you get some other privileges too??

> > tgl=> create table test (x text,
> > tgl-> i int default nextval('test_s_seq'));
> > ERROR: pg_aclcheck: class "test_s_seq" not found
> > it looks like the sequence should internally be created before the
> > table, though in some cases it doesn't matter. I was concerned that
> > this might be the case, and the parser is not at the moment
> > configured to allow this.

                   - Tom

pgsql-hackers by date:

Previous
From: Keith Parks
Date:
Subject: Re: [HACKERS] Core dump in regression tests.
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: [HACKERS] Release 6.4