Skip site navigation (1) Skip section navigation (2)

Re: BUG #1610: rewrite rule and sequence

From: Richard Huxton <dev(at)archonet(dot)com>
To: Olleg Samoylov <olleg(at)mipt(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1610: rewrite rule and sequence
Date: 2005-04-21 15:57:51
Message-ID: 4267CD7F.3090100@archonet.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-docs
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
> Details: 
> 
> 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.

HTH
-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-docs by date

Next:From: Olleg SamoylovDate: 2005-04-22 06:33:10
Subject: Re: BUG #1610: rewrite rule and sequence
Previous:From: Olleg SamoylovDate: 2005-04-21 12:19:44
Subject: BUG #1610: rewrite rule and sequence

pgsql-bugs by date

Next:From: Sokolov YuraDate: 2005-04-21 17:56:48
Subject: BUG #1614: Bug in contrib/btree_gist for text
Previous:From: Bruce MomjianDate: 2005-04-21 15:28:59
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group