On Jul 24, 2005, at 3:23 PM, Stefan wrote:
Hi,
is there a way to get a sequence from another Postgres-Server?
I have some "data servers" an one admin server. When a new row is
inserted
on one of the data servers, the server should ask automatically for a
sequence number from the admin server.
How can I do this? Maybe using pl/pgsql?
Check out DBI-link:
http://pgfoundry.org/projects/dbi-link
and as part of a tidbits column here:
http://www.pervasive-postgres.com/postgresql/tidbits.asp
Sean
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster