Replication question
От | Dann Corbit |
---|---|
Тема | Replication question |
Дата | |
Msg-id | D90A5A6C612A39408103E6ECDD77B829408CC8@voyager.corporate.connx.com обсуждение исходный текст |
Ответы |
Re: Replication question
|
Список | pgsql-hackers |
When replication is implemented, what is going to happen with database systems that rely heavily on sequences for primary keys? For example, consider this simple table: CREATE SEQUENCE "IntervalType_IntervalTypeID_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; CREATE TABLE "IntervalType" ("IntervalTypeID" integer DEFAULT nextval('"IntervalType_IntervalTypeID_seq"'::text) NOT NULL,"IntervalTypeDescription" character varying(255),"MaximumValue"integer,"FrequencyUnits" double precision,Constraint "PK_IntervalType" Primary Key ("IntervalTypeID") ); Now, when we replicate this table to other systems, will the sequence parameters also flow to the targets? A more interesting question is what happens if we need to revert to a prior version (where -- for instance -- the maximum value of the sequence was smaller than it is right now). Will the target system have the sequence value reduced?
В списке pgsql-hackers по дате отправления: