473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Cannot open relation pg_cast_source_target_index

-----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)

iD8DBQFAjuantl86P3SPfQ4RAnRnAJwJq3mcVopahOeFkkEY0Y Oje2sQ1wCdE0w4
0sWo73dZNp/H3eMMTiBpAD8=
=Zm9+
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
4 1479
Devrim GUNDUZ <de****@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2
Devrim GUNDUZ <de****@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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #3
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Krish | last post by:
I have created 2 tables, both tables have the same column names (property ColumnName) it is priceDate,priceTime and priceValue I get an error saying that Column priceDate already belongs to...
3
by: Fabio Negri Cicotti [MCP] | last post by:
Hi All. I'm trying to insert data into 2 tables (parent-child) using the ADO.NET's SetParentRow method. The parent table has an identity column as primary key. When I execute the code below I...
1
by: bitwxtadpl | last post by:
-First I add and relate the tables A and B. Create a new instance of TableA Add TableA to DataSetX Create a new instance of TableB Add TableB to DataSetX Create a relation between TableA and...
1
by: Random | last post by:
I don't understand why this error is happening when I try to load my xml into my DataSet. "Cannot add a nested relation or an element column to a table containing a SimpleContent column." Can...
7
by: Wayne Brantley | last post by:
I have found what appears to be an error in streaming with Datasets. It causes an error of 'Cannot find relation 0' when recreating the dataset from a stream. Here is how you reproduce it. ...
0
by: Devrim GUNDUZ | last post by:
-----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:
0
by: Holger Marzen | last post by:
I had tomatoes on my eyes. I wrote laufverke but meant laufwerke. Sorry. ---------- Forwarded message ---------- Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST) From: Holger Marzen...
1
by: Hennesey | last post by:
Hello all, I am developing a Visual Studio .Net 2005 application that consumes an Axis 1.3 web service. Importing the WSDL file generates an error "cannot resolve apachesoap:Map type" ...
0
by: mansooralia | last post by:
Hi, While reading an XML with DTD, I get the "Cannot add a nested relation or an element column to a table containing a SimpleContent column." error. Can anyone help me resolve this issue. I am...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.