Re: get sequence from remote server

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: "Stefan" <db(at)ventasoft(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: get sequence from remote server
Date: 2005-07-24 19:41:16
Message-ID: 18a0683c5a0f7552def61796b0dcb963@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-07-24 20:04:25 Re: PostgreSQL + windows xp + ipv6
Previous Message Stefan 2005-07-24 19:23:58 get sequence from remote server