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.  PostgreSQL
wants to create a file for each table.  I was able to create table mptemp
using the code below.

> -----Original Message-----
> From:    Bruce Tong [SMTP:zztong@laxmi.ev.net]
> Sent:    Monday, May 03, 1999 1:10 PM
> To:    Michael J Davis
> Cc:    PostgreSQL General
> Subject:    RE: [GENERAL] Thing that makes me go "Hmmm"
>
> > Are you out of disk space?
>
> Ooo, I didn't think of that... Nope. 49% used.
>
> > try
> >     CREATE TABLE mytemp
> >     (
> >       id    int4 unique not null,
> >       mystr varchar(50)
> >     );
>
> Cannot create mytemp
>
>
> 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
>
>