Olleg Samoylov wrote:
> The following bug has been logged online:
> Bug reference: 1610
> Logged by: Olleg Samoylov
> Email address: olleg(at)mipt(dot)ru
> PostgreSQL version: 7.4.7
> Operating system: Linux debian-amd64
> Description: rewrite rule and sequence
> Rule on view can't insert in table with "serial" field under not owner. Need
> grant privilege on sequence explicitly.
That's not a bug, it's a feature (as they say).
Although you can automatically generate sequences with the serial pseudo
-type, they are separate objects. Not only can you create them
separately from a table, you can have many columns using
nextval('my_sequence') as their default.
I suppose you could argue that a sequence only used by one table could
inherit that table's permissions by default, but I can see problems when
people reorder GRANT statements.
In response to
pgsql-docs by date
|Next:||From: Olleg Samoylov||Date: 2005-04-22 06:33:10|
|Subject: Re: BUG #1610: rewrite rule and sequence|
|Previous:||From: Olleg Samoylov||Date: 2005-04-21 12:19:44|
|Subject: BUG #1610: rewrite rule and sequence|
pgsql-bugs by date
|Next:||From: Sokolov Yura||Date: 2005-04-21 17:56:48|
|Subject: BUG #1614: Bug in contrib/btree_gist for text|
|Previous:||From: Bruce Momjian||Date: 2005-04-21 15:28:59|
|Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps|