RE: [GENERAL] Thing that makes me go "Hmmm"

Поиск
Список
Период
Сортировка
Искать

RE: [GENERAL] Thing that makes me go "Hmmm"

От:
Michael J Davis <michael.j.davis@tvguide.com>
Дата:
try 
	drop table mytemp;

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.  

> -----Original Message-----
> From:	Bruce Tong [SMTP:zztong@laxmi.ev.net]
> Sent:	Monday, May 03, 1999 1:25 PM
> To:	Michael J Davis
> Cc:	PostgreSQL General
> Subject:	RE: [GENERAL] Thing that makes me go "Hmmm"
> 
> > Does your user have permissions to create files in
> > $PGDATA/base/database_name?  This is the directory where PostgreSQL
> stores
> > its data.  If you have not altered the location of your databases you
> could
> > also look in /usr/local/pgsql/databases/base/database_name.
> 
> Nope. None only the "postgres" user has permission to write there. This
> would make sense since the postmaster is doing everything, not the user.
> The user is making requests of the postmaster via the psql program.
> 
> > PostgreSQL wants to create a file for each table.
> 
> /var/lib/pgsql/base/zztong/*
> 
> There is a file there named "mytemp" but it is empty.
> 
> 
> 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
> 
>

RE: [GENERAL] Thing that makes me go "Hmmm"

От:
Bruce Tong <zztong@laxmi.ev.net>
Дата:
> 	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
FAQ