From: Don Baccus <dhogaza@pacifier.com>
To: Postgres Hackers List <hackers@postgreSQL.org>
Subject: Unable to create tables...
Date: Fri, 06 Aug 1999 09:42:28 -0700
Message-ID: <3.0.1.32.19990806094228.00e0388c@mail.pacifier.com> (raw)
In-Reply-To: <199908061552.LAA09631@candle.pha.pa.us>
References: <37AAFF29.958CE9F2@alumni.caltech.edu>
I mentioned this earlier in the context of pg_dump, which fails
trying to create the table "pgdump_oid".
After a bit, a memory jog reminded me that I've seen this
before, with the table "foo", which I once used for testing.
After a fair number of "create/drop" cycles, making then
dropping tables for testing, pgsql now refuses to let me
"create table foo...", giving the same simple error message
"can't create foo" as pg_dump's getting on pgdump_oid.
I can't "drop table foo", getting an error message telling
me the class doesn't exist, so that's not the problem.
I CAN create/drop other tables, i.e. "create table bar..."
followed by "drop table bar" works fine.
So it doesn't appear to be a general permissions problem,
i.e. it's not as though the system thinks I don't have
create table rights.
It would seem as some system table is being corrupted???
Does this sound at all familiar?
Unfortunately, I don't know how to reproduce this other
than create/drop tables until eventually it fails. As
I mentioned in my first note, pg_dump has been running
nightly on this database for weeks, at least, with no
errors reported. Suddenly - poof! can't create pgdump_oid.
- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: dhogaza@pacifier.com, hackers@postgreSQL.org
Subject: Re: Unable to create tables...
In-Reply-To: <3.0.1.32.19990806094228.00e0388c@mail.pacifier.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox