Re: [ADMIN] deadlock detected during insert

2003-03-07 Thread A.Bhuvaneswaran
> > Can you able to give some test cases? Here i have tried, but unable to > > detect deadlock. > > Not a complete or tested example, but: > create table a (a int primary key); > create table b ( b int references a); > insert into a values (1); > insert into a values (2); > Transaction 1: begin;

Re: [ADMIN] Querying multiple databases...

2003-03-07 Thread Bruce Momjian
See /contrib/dblink. --- Douglas Mayle wrote: > In Oracle, it is possible to use DB links to run a query across more than > one database (ie. Select * from table_in_thisdb, [EMAIL PROTECTED]). Is > there any way to perform

[ADMIN] Querying multiple databases...

2003-03-07 Thread Douglas Mayle
In Oracle, it is possible to use DB links to run a query across more than one database (ie. Select * from table_in_thisdb, [EMAIL PROTECTED]).  Is there any way to perform something similar in Postgres?   Doug   

Re: [ADMIN] Appliying Rules and Triggers

2003-03-07 Thread Stephan Szabo
On Fri, 7 Mar 2003, Daniel Rubio wrote: > Does anyone knows if it's possible to apply an determinated rule or > trigger to all the tables of an databese without having to declare it > specifically? AFAIK no.What are you trying to do specifically? ---(end of broadcast)---