Funny questions...

Поиск
Список
Период
Сортировка
От Douglas Mayle
Тема Funny questions...
Дата
Msg-id 000501c2e46a$f01e5060$0a0310ac@Tablet
обсуждение исходный текст
Список 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?

 

Doug 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: [pgsql-advocacy] uppercase = lowercase
Следующее
От: Aspire Something
Дата:
Сообщение: Re: New Interface for Win