Re: [BUGS] BUG #1610: rewrite rule and sequence

2005-04-25 Thread Olleg Samoylov
Richard Huxton wrote: Hmm - perhaps the documentation needs expanding. Certainly, if your view references functions you need to make sure permissions are set correctly on those. How about changes along the lines of: Ch 33.4, para 2 "... Relations that are used due to rules get checked against th

Re: [BUGS] BUG #1610: rewrite rule and sequence

2005-04-22 Thread Olleg Samoylov
Richard Huxton wrote: That's not a bug, it's a feature (as they say). 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 It's not feature, it's bug. From postgresql docu

Rules and Permissions docs change (was Re: [BUGS] BUG #1610: rewrite rule and sequence)

2005-04-22 Thread Richard Huxton
Olleg Samoylov wrote: Richard Huxton wrote: That's not a bug, it's a feature (as they say). 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. It's not feature, it's bug. F

Re: [BUGS] BUG #1610: rewrite rule and sequence

2005-04-21 Thread Richard Huxton
Olleg Samoylov wrote: The following bug has been logged online: Bug reference: 1610 Logged by: Olleg Samoylov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Linux debian-amd64 Description:rewrite rule and sequence Details: Rule on view ca

[BUGS] BUG #1610: rewrite rule and sequence

2005-04-21 Thread Olleg Samoylov
The following bug has been logged online: Bug reference: 1610 Logged by: Olleg Samoylov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Linux debian-amd64 Description:rewrite rule and sequence Details: Rule on view can't insert in table