472,328 Members | 1,102 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Relation does not exist


We are having a problem where intermittently a query will not work,
returning an error:

ERROR: Relation "x" does not exist

It will do this for a variable period, typically not lasting more than 5

I have searched through list archives and only find this reference in
regards to entities that are capitalized, which is *not* the case here.

Our setup may be 'bad', but I'm not sure; here is some background:

I have one database with 13 schemas
The code used to access data for the most part does not use schema.entity
naming convention
as we have the search_path set in postgresql.conf set to include all 13

Entity names are not duplicated across schemas.

If I use the qualified schema.entity in my database calls, I don't get the

I can go through all the code used to access data and add the schema name as
appropriate, but would prefer not to.

Has anyone seen an issue like this. We have had this setup for about a year
without problems until just last week.

We are using PG_VERSION 7.3 on RedHat 7.0
System has 512 Mb RAM

I have tried tweaking some of the memory settings thinking maybe there was
an issue with that. . . .here are the details of that:

max_connections = 150
shared_buffers = 15200
sort_mem = 32168
fsync = false

We did change RedHat's shared memory setting to: kernel.shmmax = 134217728

Not sure if any other information would be useful. I appreciate any



Rob Klaus
Manager of Information Systems
Unique Management Services, Inc
119 East Maple Street
Jeffersonville, IN 40206

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Nov 23 '05 #1
0 2421

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

Similar topics

by: S.Peppe | last post by:
Hi there! I'm really new at this game, so please forgive me if my request is at all irritating. I have installed PostgreSQL onto a Debian/Linux...
by: Terrence Brannon | last post by:
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before...
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more ...
by: Hi5 | last post by:
Hi, I am designing a database for a client in which It has a client table including the followings: 1-Table Client 2-Table lookupcategory ...
by: Juris Krumins | last post by:
I have a problem with postgresql tables. periodicaly, I would say frequently about 5-10 time per hour i have such errors in my server log file: ...
by: Kuti Attila | last post by:
Hi, I have a pgplsql function. It is quite short and simple. The problem:
by: Rob Klaus | last post by:
Hello, We are having a problem where intermittently a query will not work, returning an error: ERROR: Relation "x" does not exist It will...
by: hlnet | last post by:
I am newbie. I want use query : SELECT public.Master.ID, public.Master.Description from Master , but ->Error missing table Master .If use query...
by: Shree111 | last post by:
I am having some problems understanding how the temp tables work in PG. I have a relatively lengthy function I am creating that makes frequent use of...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

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.