Cannot open relation pg_cast_source_target_index

Hopefully someone can point me in the proper direction....

I have a table containg (amongst others) two varchar attrs date_s &
time_s.

They contain strings like:

date_s | time_s
------------+----------
01/10/1989 | 00:30:00

Can someone suggest an sql to turn these into a single datetime?

I have tried the following with results I don't understand:

env2003=# select date_s || time_s, to_timestamp(date_s || time_s,'DD/MM/YYYYHH:MM:SS') from event limit 1;
?column? | to_timestamp
--------------------+------------------------
01/10/198900:30:00 | 1991-06-05 00:00:00+12
(1 row)

env2003=# select date_s || ' ' || time_s, to_timestamp(date_s || ' ' || time_s,'DD/MM/YYYY HH:MM:SS') from event limit 1;
?column? | to_timestamp
---------------------+------------------------
01/10/1989 00:30:00 | 1991-06-05 00:00:00+12
(1 row)

Thanks,

Brent Wood

Devrim GUNDUZ <devrim@gunduz.org> writes:

I've just upgraded a production database from 7.3.4 to 7.4.2.
I 'sometimes' get the following error while executing a PHP code:
"mdfd_getrelnfd cannot open relation pg_cast_source_target_index"

There is no such message text in 7.4.*. Better double-check that
upgrade procedure...

(Actually, there is *no* version that produces that error message
without including a kernel error message to go with; why are you
failing to provide the most important part of the message?)

regards, tom lane

Hi,

On Tue, 27 Apr 2004, Tom Lane wrote:

I've just upgraded a production database from 7.3.4 to 7.4.2.
I 'sometimes' get the following error while executing a PHP code:
"mdfd_getrelnfd cannot open relation pg_cast_source_target_index"

There is no such message text in 7.4.*. Better double-check that
upgrade procedure...

Yep, I've re-installed 7.4 and now everthing runs fine. Thanks.

(Actually, there is *no* version that produces that error message
without including a kernel error message to go with; why are you
failing to provide the most important part of the message?)

That was the only message from the web, and at that time I was unable to
access the server to find out what's wrong in the logs...

Regards,
--
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.TDMSoft.com
http://www.gunduz.org

You 30 minutes are getting converted to 30 months.
Use DD/MM/YYYYHH24:MI:SS instead.

Brent Wood wrote: