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