Hi all,
If anyone's using Druid, the Java based Database Management GUI
(http://druid.sourceforge.net) with PostgreSQL, here's a tip from it's
author!
:-)
Regards and best wishes,
Justin Clift
-------- Original Message --------
Subject: Re: Druid and PostgreSQL
Date: Sat, 12 May 2001 01:11:09 +0200
From: Andrea Carboni <carboni.andrea@tiscalinet.it>
To: Justin Clift <justin@postgresql.org>
References: <3AFAA8C6.8D8BC6C@postgresql.org>
I have not tested druid on PostgreSQL but a friend of mine did.
He says that the generated sql-script works. The only issue is with the
serial
type because druid, resolving the fkey, use the serial type and not an
int
type. This problem will be solved with version 2.5 (planned for the end
of
May).
In the meanwhile, use the int type instead of the serial one and use an
index
attrib to generate the sequence. My friend uses something like this:
CREATE SEQUENCE $TABLE$_seq start 100 increment 1 maxvalue
Best regards,
Andrea Carboni