Re: ESTERROR

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: Michael Guerin <guerin(at)rentec(dot)com>
Subject: Re: ESTERROR
Date: 2006-03-14 22:54:26
Message-ID: 441749A2.2040809@rentec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


> "EST" looks suspiciously like "Eastern Standard Time," considering
> that the timezone in your email is -0500. Does a timestamp immediately
> precede the above string? Have you set log_line_prefix without a
> trailing space?
>

Yep, its East Std. Time.. I've already awarded myself the DA award for
today... :(

> As for "relation with OID X does not exist," see if the FAQ's
> explanation fits your situation:
>
> http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
>
No, no temp tables are used in any of our functions. It seems to have
gone away after I stopped and restarted the database.

Here's a little background on the db that was having this problem.
The database is not typical, its created using files and tables are
basically dropped and recreated every time one of the source files
change. Temp tables are created and populated then within a transaction
the live table is dropped and the tmp table is renamed to be the live
table.

thanks
-mike

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Guerin 2006-03-15 16:30:07 Re: ESTERROR
Previous Message Michael Guerin 2006-03-14 22:14:51 Re: ESTERROR