Re: Shared Sequences?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "C(dot) Duncan Hudson" <postgresql(at)dunc-it(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared Sequences?
Date: 2005-01-02 18:21:16
Message-ID: 20050102182115.GA44519@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2005-01-02 18:36:38 Re: PostgreSQL 8.0.0 Release Candidate 3
Previous Message Timothy Perrigo 2005-01-02 18:07:32 OS X shared memory problems 8.0rc3