your advice, and use EXTRACT instead, if that is going to be more
robust.
--- On Mon, 13/7/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [GENERAL] Problem with Check Constraint in pg_restore
To: "Alan Millington"
Cc: pgsql-general@postgresql.org
Date: Monday, 13 July, 2009, 3:06
Alan Millington writes:
> CONSTRAINT "RP_DATE_check" CHECK (date IS NULL AND accuracy = '?'::bpchar OR
> date IS NOT NULL AND date > '1099-12-31'::date AND (accuracy = 'D'::bpchar OR
> accuracy = 'M'::bpchar AND date::text ~~ '%-01'::text OR (accuracy =
> 'Y'::bpchar OR accuracy = '?'::bpchar)
I am running Postgres 8.1.4 on Windows XP Professional Service Pack 3.
I recently tried to make a copy of an existing database. I made a dump using
pg_dump -Fc, I created a new database from template0, and attempted to restore
into it using pg_restore. The tables were created and about half we
