Re: Timestamp Error - 7.2
Josh Berkus <josh@agliodbs.com>
From: "Josh Berkus" <josh@agliodbs.com>
To: Keith Gray <keith@heart.com.au>, SQL PostgreSQL <pgsql-sql@postgresql.org>
Date: 2002-09-25T16:13:21Z
Lists: pgsql-sql
Keith,
> We have moved from 7.1 to 7.2 and get the following error when
> extracting dates.
>
> Bad timestamp external representation ' '
>
>
> eg. INSERT INTO mytable VALUES('1', '2001-09-24')
The error, as you have described it, is highly unlikely. You will
need to provide more information if you still want help. Please:
1. Post table defintions.
2. Post your *actual* SQL statements which trigger the error, not
example ones which you have nto actually tested.
-Josh Berkus