Tue Jan 24 21:42:50 PST 2012
- Previous message: [Slony1-general] Slave can't catch up, postgres error 'stack depth limit exceeded'
- Next message: [Slony1-general] timestamp in unique key
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello everybody, I need help. let's to say, there is a table: \d molot.sens_data ... device_id | integer | not null time_stamp | timestamp with time zone | not null ... Indexes: "sens_data_device_id_key" UNIQUE, btree (device_id, time_stamp) slonik script: create set (id=3, origin=1); set add table ( set id=3, origin=1, id=32, fully qualified name = 'molot.sens_data', key = 'sens_data_device_id_key'); subscribe set ... Everything is ok, copy_set went well, replication has begun. Inserts are successfully, but updates and deletes are not. Append "serial primary key" column really don't want as long (table is about 250 mil records). Is there any other way? slony1 - 1.2.21, Pg - 8.4.9 -- Sergey Suleymanov
- Previous message: [Slony1-general] Slave can't catch up, postgres error 'stack depth limit exceeded'
- Next message: [Slony1-general] timestamp in unique key
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list