Thread: [Keystone Slip # 16] pg_dump, psql CURRENT_DATE problems

---------------------------------------------------------------------------
Slip number -----: 16
Problem ---------: pg_dump, psql CURRENT_DATE problems
Opened by -------: guybrush@icon.co.za on 07/25/99 15:19
Assigned To -----: thomas
---------------------------------------------------------------------------
Summary:
pg_dump dumps the following table:

CREATE TABLE t (d datetime DEFAULT CURRENT_DATE NOT NULL);

as follow:

connect - postgres
DROP TABLE "t";
CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);

When trying to restore the table with psql it would typically result in the following error:

QUERY: CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);
ERROR:  parser: parse error at or near "'"


---------------------------------------------------------------------------
History:
07/26/99 12:43 by scrappy:
Dependency changed to 0 from
Current tech changed to thomas from
Status changed to O from U
Contact changed to  from ANONYMOUS
Summary changed to pg_dump dumps the following table:

CREATE TABLE t (d datetime DEFAULT CURRENT_DATE NOT NULL);

as follow:

connect - postgres
DROP TABLE "t";
CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);

When trying to restore the table with psql it would typically result in the following error:

QUERY: CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);
ERROR:  parser: parse error at or near "'"

 from pg_dump dumps the following table:

CREATE TABLE t (d datetime DEFAULT CURRENT_DATE NOT NULL);

as follow:

connect - postgres
DROP TABLE "t";
CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);

When trying to restore the table with psql it would typically result in the following error:

QUERY: CREATE TABLE "t" (
        "d" datetime DEFAULT date( 'current'::datetime + '0 sec') NOT NULL);
ERROR:  parser: parse error at or near "'"


Scheduled Close Date changed to 0 from
Scheduled Open Date changed to 0 from
Public setting changed to 1 from 0
Policy changed to 0

---------------------------------------------------------------------------


          Full information on this slip is available at:
http://www.postgresql.org/bugs/visitor.php3?sid=16&v_func=zoom

---------------------------------------------------------------------------
This message was generated automatically by Keystone at http://www.postgresql.org