Re: [HACKERS] Referential integrity problem postgresql 7.2 ?

2002-06-11 Thread Stephan Szabo
On Tue, 11 Jun 2002, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > As a related side note. The other part of the original patch (the NOT > > EXISTS in the upd/del no action trigger) was rejected. For match > > full and match unspecified the same result can be reached by doing

[HACKERS] referential integrity problem

2002-04-24 Thread Tatsuo Ishii
It seems we can create a forein key using REFERENCES privilege but cannot drop the table if its owner is not same as the referenced table. Is this a feature or bug? -- create a table as user foo \c - foo create table t1(i int primary key); -- grant reference privilege to user bar grant references