Is there any way, with PG 8 rc 3, to share a sequence across databases -
assuming all databases are on the same machine? Thanks,
Dunc
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
begin C. Duncan Hudson [EMAIL PROTECTED] wrote:
Is there any way, with PG 8 rc 3, to share a sequence across databases -
assuming all databases are on the same machine? Thanks,
Possibly via contrib/dblink, also on ealier versions.
I'm not sure about sequences, but with tables this is
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
Michael Fuhr wrote:
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
On Sun, 2005-01-02 at 16:19 -0500, C. Duncan Hudson wrote:
[about databases sharing a sequence]
I have 3 instances of the application
(each for a different business unit) and I don't want them generating
the same numbers for different things. I want the numbers, across