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

Reply via email to