Re: [SQL] cross-database references are not implemented

2008-06-03 Thread Paul Dam
erwerp: Re: [SQL] cross-database references are not implemented On Tuesday 03 June 2008 6:12 am, Paul Dam wrote: > Hoi, > > > > I have a database with 2 schemas: > > - public > > - export > > > > In the export schema I have tables that are filled during an export

Re: [SQL] cross-database references are not implemented

2008-06-03 Thread Adrian Klaver
On Tuesday 03 June 2008 6:12 am, Paul Dam wrote: > Hoi, > > > > I have a database with 2 schemas: > > - public > > - export > > > > In the export schema I have tables that are filled during an export > process. > > There is some data I want to have in a table in the public schema as > well. > > I w

Re: [SQL] cross-database references are not implemented

2008-06-03 Thread Pavel Stehule
Hello it works for me postgres=# create schema export; CREATE SCHEMA Time: 45,918 ms postgres=# create table public.a(a varchar); CREATE TABLE Time: 91,385 ms postgres=# create table export.a(a varchar); \CREATE TABLE Time: 9,462 ms postgres=# create function ftrg() returns trigger as $$begin ins

[SQL] cross-database references are not implemented

2008-06-03 Thread Paul Dam
Hoi, I have a database with 2 schemas: - public - export In the export schema I have tables that are filled during an export process. There is some data I want to have in a table in the public schema as well. I wrote a trigger function that after insert in the export table does an expor

Re: [SQL] Cross-database references

2003-01-28 Thread Roberto Mello
On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the >implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? Olá Pedro, Look at th

Re: [SQL] Cross-database references

2003-01-28 Thread Jason Turner
On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the >implementation of cross database references in pgsql ? > Would have some future release with this great functionality ? This is usually left u

[SQL] Cross-database references

2003-01-28 Thread Pedro Igor Craveiro e Silva
Title: AIP - Assessoria Informática e Proteção LTDA Someone knows how is going the implementation of cross database references in pgsql ? Would have some future release with this great functionality ?   Thanks,   Pedro Igor