Re: [GENERAL] CORRUPTION on TOAST table

2016-04-03 Thread Adrian Klaver
On 04/02/2016 08:38 PM, Soni M wrote: Hello Everyone, We face TOAST table corruption. One master and two streaming replicas. The corruption happen only on both streaming replicas. We did found the corrupted rows. Selecting on this row, return (on both replica) : unexpected chunk number 0 (expe

Re: [GENERAL] CORRUPTION on TOAST table

2016-04-03 Thread Adrian Klaver
On 04/02/2016 08:38 PM, Soni M wrote: Hello Everyone, We face TOAST table corruption. One master and two streaming replicas. The corruption happen only on both streaming replicas. We did found the corrupted rows. Selecting on this row, return (on both replica) : unexpected chunk number 0 (expe

Re: [GENERAL] plpgsql update row from record variable

2016-04-03 Thread Adrian Klaver
On 04/02/2016 06:07 PM, Seamus Abshere wrote: hi, I want to write a function that updates arbitrary columns and here's my pseudocode: CREATE OR REPLACE FUNCTION update_pet(id int, raw_data jsonb) RETURNS VOID AS $$ DECLARE data record; BEGIN SELECT jsonb_populate_record(null::pets, raw_da