Re: [SQL] Calling a table residing in another database from Plpgsql

2005-01-04 Thread Kenneth Gonsalves
On Wednesday 05 January 2005 10:43 am, [EMAIL PROTECTED] wrote: > Hi, > > I have function called test1() in database 1. I need to input the value > from this function into another table which is in database2. shouldnt you be using schemas instead? kg ---(end of broadcast)

[SQL] Calling a table residing in another database from Plpgsql

2005-01-04 Thread deepthi
Hi, I have function called test1() in database 1. I need to input the value from this function into another table which is in database2. How can i achieve this task in plpgsql. I went through some documentation and found out that it is possible through dblink. I infact downloaded the dblink pack

[SQL] Calling a table in another database from plpgsql

2005-01-04 Thread deepthi
Hi, I have function called test1() in database 1. I need to input the value from this function into another table which is in database2. How can i achieve this task in plpgsql. I went through some documentation and found out that it is possible through dblink. I infact downloaded the dblink pack

Re: [SQL] foreign key problems

2005-01-04 Thread Stephan Szabo
On Tue, 4 Jan 2005, [iso-8859-2] BARTKO, Zoltán wrote: > if I create the tables that are in the attached file, I can't insert > rows into the AAttachment table, even though the rows in DObject with > the given primary key exist (PgSQL 8.0 rc1 complains about > (ownerid)=(insert the number here) n

[SQL] foreign key problems

2005-01-04 Thread BARTKO, Zoltán
Dear all, I have a problem: if I create the tables that are in the attached file, I can't insert rows into the AAttachment table, even though the rows in DObject with the given primary key exist (PgSQL 8.0 rc1 complains about (ownerid)=(insert the number here) not available in DObject. The same h