Re: [HACKERS] [GENERAL] pg_restore casts check constraints differently

Hey, I work with Josh Ma and we were troubleshooting this problem together. We ended up creating a workaround by taking the dumps from different DBs, initializing new DBs based on those dumps, and then dumping these new DBs. This work around worked since the dumps of databases that were

Re: [HACKERS] [GENERAL] pg_restore casts check constraints differently

On Thu, Mar 31, 2016 at 1:00 AM, Tom Lane wrote: > I wrote: >> Amit Langote writes: >>> destdb=# ALTER TABLE c ADD CONSTRAINT p_a_check CHECK (a IN ('a', 'b', >>> 'c')); >>> destdb=# \d c >>> ... >>> Check constraints: >>> "p_a_check" CHECK (a::text

Re: [HACKERS] [GENERAL] pg_restore casts check constraints differently

I wrote: > Amit Langote writes: >> destdb=# ALTER TABLE c ADD CONSTRAINT p_a_check CHECK (a IN ('a', 'b', 'c')); >> destdb=# \d c >> ... >> Check constraints: >> "p_a_check" CHECK (a::text = ANY (ARRAY['a'::character varying, >> 'b'::character varying, 'c'::character