[BUGS] I find a bug (IMHO)

2004-01-13 Thread Danger Dancer
Sorry for my bad English. The report in the attach If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [

Re: [BUGS] I find a bug (IMHO)

2004-01-13 Thread Tom Lane
Danger Dancer <[EMAIL PROTECTED]> writes: > #little example > create table a (d int check (d<5)); > create table b () inherits (a); > alter table b drop constraint "a_d"; I think the bug is that it allowed you to do this. You should not be able to drop an inherited constraint, any more than you c

Re: [BUGS] Probably a security bug in PostgreSQL rule system

2004-01-13 Thread Tom Lane
"Sergey N. Yatskevich" <[EMAIL PROTECTED]> writes: > Next -- test and it's output, that shows, that if view has INSERT, > UPDATE and DELETE rules then _ANY_ user can insert, update and delete > data in tables, that affected by this rules even user has no INSERT, > UPDATE and DELETE privileges on vi