Re: get sequence from remote server - Mailing list pgsql-general

From Sean Davis
Subject Re: get sequence from remote server
Date
Msg-id 18a0683c5a0f7552def61796b0dcb963@mail.nih.gov
Whole thread Raw
In response to get sequence from remote server  ("Stefan" <db@ventasoft.de>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Stefan"
Date:
Subject: get sequence from remote server
Next
From: "Magnus Hagander"
Date:
Subject: Re: PostgreSQL + windows xp + ipv6