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
>
>