[BUGS] Foreign keys breaks tables permissions

2000-04-11 Thread Raul Chirea
Hi, If one does: create table master ( id integer not null, primary key (id) ); create table detail ( id integer not null, master_id integer not null, primary key (id), foreign key (master_id) references master (id) ); insert into master (id) values (1); grant select on mas

Re: [BUGS]

2000-04-11 Thread Oleg Broytmann
On Tue, 11 Apr 2000, Tom Lane wrote: > Oleg Broytmann <[EMAIL PROTECTED]> writes: > > gcc -O2 -I../../backend -I../../include -I../../interfaces/libpq -fPIC -c >pgconnection.cc > > In file included from pgconnection.cc:18: > > pgconnection.h:76: syntax error before `(' > > Hmm. Something br

Re: [BUGS]

2000-04-11 Thread Tom Lane
Oleg Broytmann <[EMAIL PROTECTED]> writes: > gcc -O2 -I../../backend -I../../include -I../../interfaces/libpq -fPIC -c >pgconnection.cc > In file included from pgconnection.cc:18: > pgconnection.h:76: syntax error before `(' Hmm. Something broken about "string"? My guess is that configure

[BUGS] WinODBC driver doesn't abort transaction on refint violation

2000-04-11 Thread Kovacs Zoltan Sandor
Hi, in fact this is a resent bug report. The Windows ODBC driver doesn't detect that a reference integrity violation occured. It realizes the fact that there was an error, but doesn't abort the transaction. I didn't found SC_log_error (in SC_execute) being executed. IMHO it should abort the tran

[BUGS]

2000-04-11 Thread Oleg Broytmann
POSTGRESQL BUG REPORT TEMPLATE Your name : Oleg Broytmann Your email address : [EMAIL PROTEC