Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cannot open relation pg_cast_source_target_index

Cannot open relation pg_cast_source_target_index

From
Devrim GUNDUZ
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

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"

Quoted 'sometimes', since I really get this error rarely! This is a simple
SELECT query.

What are the possible causes of this? Google didn't help me...

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
            http://www.TDMSoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFAjuantl86P3SPfQ4RAnRnAJwJq3mcVopahOeFkkEY0YOje2sQ1wCdE0w4
0sWo73dZNp/H3eMMTiBpAD8=
=Zm9+
-----END PGP SIGNATURE-----

Re: Cannot open relation pg_cast_source_target_index

From
Tom Lane
Date:
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

Re: Cannot open relation pg_cast_source_target_index

From
Devrim GUNDUZ
Date:
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

help building datetime from varchars

From
Brent Wood
Date:
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

Re: help building datetime from varchars

From
Jean-Luc Lachance
Date:
You 30 minutes are getting converted to 30 months.
Use DD/MM/YYYYHH24:MI:SS instead.



Brent Wood wrote:

> 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
limit1; 
>       ?column?       |      to_timestamp
> ---------------------+------------------------
>  01/10/1989 00:30:00 | 1991-06-05 00:00:00+12
> (1 row)
>
>
>
> Thanks,
>
>    Brent Wood
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>