| From: | "Douglas Mayle" <douglas(at)mayle(dot)org> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Funny questions... |
| Date: | 2003-03-07 05:32:26 |
| Message-ID: | 000501c2e46a$f01e5060$0a0310ac@Tablet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I'm trying to upgrade a Postgres 7.0.3 database to something current, and
the new version spits out an error when I try and import the data file,
complaining that 'invalid' is no longer supported as a timestamp.
The funny thing is, when I try and run a query in psql like "select * from
mytable where mydate = 'invalid'" nothing is returned.
When I run a query like "select mydate from mytable where myprimarykey = 5"
I get :
mydate
------------
invalid
(1 row)
How can I either update these values with a query, or get the upgrade to
work?
<http://dmayle.com/dotsig.gif>
Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aspire Something | 2003-03-07 05:33:14 | Re: New Interface for Win |
| Previous Message | Justin Clift | 2003-03-07 02:04:24 | Re: [pgsql-advocacy] uppercase = lowercase |
