From: | Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com> |
---|---|
To: | "'Bruce Tong'" <zztong(at)laxmi(dot)ev(dot)net> |
Cc: | PostgreSQL General <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] Thing that makes me go "Hmmm" |
Date: | 1999-05-03 19:15:04 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC145469@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)laxmi(dot)ev(dot)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(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Tong | 1999-05-03 19:24:54 | RE: [GENERAL] Thing that makes me go "Hmmm" |
Previous Message | Bruce Tong | 1999-05-03 19:10:11 | RE: [GENERAL] Thing that makes me go "Hmmm" |