Thread: get sequence from remote server

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?

thx

Stefan

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