Re: [Sqlgrey-users] Working on SQLgrey

[Lionel B. <lio...@bo...>]

Kenneth Marshall wrote the following on 27.02.2007 22:58 :
> Lionel,
>
> Do you have an idea as to what would be the best choice of a primary
> key for the connect table? All the other tables have one, and without
> it Slony1 replication will not work. The two more obvious choices would
> be to add an ID column with a default value from a sequence or to use
> a unique index on src, sender_domain, sender_name, rcpt.

The unique index is ok. I couldn't add it because MySQL didn't support
indexes for large columns (from memory the total size of the columns
must be less than ~500 chars).

PostgreSQL is OK with it so you can add it. Pay attention to future
schema migrations: your schema will be customized and if SQLgrey tries
to convert the connect table to another format you will lose your index
(as I didn't looked much into Slony1 I'm not sure that it would even
support the replication of a database on which the schema changes...).

Lionel.