Thread: pg_dump does not handle default dates correctly

If I use pg_dump to backup a database table (or just its schema) and the
table contains a date field defaulted to the current date then the resulting
table create statement is invalid.

These shell commands demonstarte the problem:
createdb db1
createdb db2
psql -c'create table t (d date default current_date)' db1
pg_dump -s db1 | psql db2

psql reports ERROR: parser: parse error at or near "'"

This is using Postgres 6.5.0

Bryan White

> If I use pg_dump to backup a database table (or just its schema) and the
> table contains a date field defaulted to the current date then the
resulting
> table create statement is invalid.
>
> These shell commands demonstarte the problem:
> createdb db1
> createdb db2
> psql -c'create table t (d date default current_date)' db1
> pg_dump -s db1 | psql db2
>
> psql reports ERROR: parser: parse error at or near "'"
>
> This is using Postgres 6.5.0

I also should have listed the create statement produced by pg_dump

CREATE TABLE "t" (
 "d" date DEFAULT date( 'current'::datetime + '0 sec'));