RE: [GENERAL] Thing that makes me go "Hmmm" - Mailing list pgsql-general

From Bruce Tong
Subject RE: [GENERAL] Thing that makes me go "Hmmm"
Date
Msg-id Pine.LNX.4.04.9905031538380.16777-100000@laxmi.ev.net
Whole thread Raw
In response to RE: [GENERAL] Thing that makes me go "Hmmm"  (Michael J Davis <michael.j.davis@tvguide.com>)
List pgsql-general
>     drop table mytemp;

pg_ownercheck: class "mytemp" no found

> and then recreate mytemp.  The existence of mytemp in your data directory
> indicates that it has already been created.  Make sure no other object is
> named mytemp?  Try a different table name?  Sorry, I am all out of
> suggestions.

The first time I try to create a table the backend closed the channel
unexpectedly. After that point, if I try to create that table after that I
get the "ERROR: cannot create XXXXXX" message. At least the pattern has
emerged.

Thanks for looking into it.

I don't suppose there's a place I can look for postmaster error messages?
I haven't seen anything written to my system log files.


Bruce Tong                 |  Got me an office; I'm there late at night.
Systems Programmer         |  Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE  |
zztong@laxmi.ev.net        |  -- Joe Walsh for the 21st Century



pgsql-general by date:

Previous
From: Michael J Davis
Date:
Subject: RE: [GENERAL] Thing that makes me go "Hmmm"
Next
From: Chris Bitmead
Date:
Subject: Re: [GENERAL] Trying using Postgresql on FreeBSD