| From: | Juris Krumins <juriskr(at)komin(dot)lv> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | CREATE TEMP TABLE |
| Date: | 2004-03-24 09:54:04 |
| Message-ID: | 20040324114733.T43822@juriskr_workstation |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everybody. I have a problem with my PostgreSQL DBMS.
In serverl log file I periodicly have errors like:
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
2004-03-24 11:43:18 ERROR: Relation 'tmp_table1' already exists
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
I figure out that this is connected with query I use in one of the
function:
CREATE TEMP TABLE tmp_table1 AS SELECT bla-bla-bla.
The problem is that when I had no so many users I have rigth now
everything was ok, but now I have quite more users, so this problem
appeared. Function , which use this query, is used all over my web site,
which is base on PostgreSQL.
So anybody have any idea how to correct this or maybe I have to change my
query. Any help would be appreciated.
I'm using PostgreSQL 7.3.4
Thanks a lot.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-24 10:18:03 | Re: createused + createdb problems with passwords |
| Previous Message | Dustin Sallings | 2004-03-24 08:28:42 | Re: linked list rewrite |