Re: Shared Sequences? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Shared Sequences?
Date
Msg-id 20050102182115.GA44519@winnie.fuhr.org
Whole thread Raw
In response to Shared Sequences?  ("C. Duncan Hudson" <postgresql@dunc-it.com>)
Responses Re: Shared Sequences?
List pgsql-general
On Sun, Jan 02, 2005 at 10:44:16AM -0500, C. Duncan Hudson wrote:

> Is there any way, with PG 8 rc 3, to share a sequence across databases -
> assuming all databases are on the same machine?

As Andreas Kretschmer mentioned, you might be able to use dblink.

Why do you want to share a sequence across databases?  Could you
use separate schemas in one database instead of separate databases?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Timothy Perrigo
Date:
Subject: OS X shared memory problems 8.0rc3
Next
From: Jeff Davis
Date:
Subject: Re: PostgreSQL 8.0.0 Release Candidate 3