Hi,
sorry, some strange key-combination made my mail client send too early...
I myself wrote:
I was trying to say that Postgres-R internally relies only on a unique
index with not null constraint. It doesn't care if you name it PRIMARY
KEY or REPLICATION KEY or whatever.
So, it's just a question of the syntax. We already have PRIMARY KEYs,
and those are pretty much what I think is needed in 99% of all cases as
the pointer to the replication
.. as the pointer to the index to use for replication.
Offering the user a possibility to choose another (index + not null)
would require something like ALTER TABLE ... ADD REPLICATION KEY ... or
some such. Mostly syntactic sugar, which can be added as soon as we
really need it.
While I'm normally an absolute fan of generality,
I think you didn't quite get the point.
Iiik.. that's what I didn't want to send and wanted to delete before
sending... :-) Sorry.
Regards
Markus
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
