---------------------------------------------------------------------------
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