From: | M Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
---|---|
To: | reinke(at)e-softinc(dot)com (Thomas Reinke) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] More information |
Date: | 1999-03-11 00:26:17 |
Message-ID: | 199903110026.AAA27274@argh.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the response. However, this is only part of the problem, and this
will not fix it.
I have done a vacuum, which seems to succede, but does not fix the error.
If I destroy the database, and recreate it, I get amcreate: relationship
already exists *as I create the tables for the first time in the
database* The database and tables are of the same name as the old
ones, of course, but the old ones *should be gone* but they arent.
Example:
*************************
$destroydb mydb
$destroydb mydb
ERROR: destroydb: database mydb does not exist.
destroydb: database destroy failed on mydb.
$createdb mydb
$echo create table beep \( test int \)\; | psql mydb
create table beep ( test int );
ERROR: amcreate: beep relation already exists
EOF
*************************
This means no matter what i do, I cannot even use the same database
name again!
Any further ideas would be *greatly* appreciated. Surely there has to
be something like a fsck for the database where it just does an
integrity check and asks you if something is an error, should it be
removed/fixed... ?
Thanks again
M Simms
>
> Try the vacuum command and see if that cleans up the database.
> Then, if that fails, instead of dumping the entire db, use
> the "pg_dump -t table dbname > dbname.table.out" to dump
> each table that is still in good shape. Sorry I can't help
> you with what the root cause is, but the above may get you
> out of the jam.
>
> Thomas
>
> M Simms wrote:
> >
> > Okee - more information on my problem.
> >
> > Postgresql version 6.3.2 on redhat linux 5.2
> >
> > Here is a cut&paste from what happens
> > ************************
> > $ psql mydb
> > Welcome to the POSTGRESQL interactive sql monitor:
> > Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> >
> > type \? for help on slash commands
> > type \q to quit
> > type \g or terminate with semicolon to execute query
> > You are currently connected to the database: mydb
> >
> > mydb=>\d
> >
> > Database = mydb
> > +------------------+----------------------------------+----------+
> > | Owner | Relation | Type |
> > +------------------+----------------------------------+----------+
> > | myuid | beep | table |
> > | myuid | history | table |
> > | myuid | history_seq | sequence |
> > | myuid | historyb | table |
> > | myuid | other | table |
> > | myuid | record | table |
> > | myuid | recordb | table |
> > +------------------+----------------------------------+----------+
> > mydb=> select * from history_seq;
> > sequence_name|last_value|increment_by|max_value|min_value|cache_value|is_cycled|is_called
> > -------------+----------+------------+---------+---------+-----------+---------+---------
> > (0 rows)
> > mydb=> drop sequence history_seq;
> > ERROR: DeletePgTypeTuple: history_seq type nonexistent
> > mydb=>
> > ************************
> >
> > I have no idea what to do about this, cos I need to update my database
> > but I cant do it with this happening, cos when I dump the database I
> > get
> >
> > ************************
> >
> > $ pg_dump mydb > dump.out
> > dumpSequence(history_seq): 0 (!= 1) tuples returned by SELECT
> >
> > ************************
> >
> > I need some solution to this if anyone knows. Surely a database this
> > complex HAS to have some sanity-checking routines and database
> > restoration. The documentation helpfully says that this section is
> > missing, however. I have based a LARGE project on this, and so far, I
> > cant start this project till this problem is fixed.
> >
> > Thanx
> >
> > M Simms
>
From | Date | Subject | |
---|---|---|---|
Next Message | Statistical Solutions | 1999-03-11 01:08:06 | Re: [GENERAL] More information |
Previous Message | Kevin Heflin | 1999-03-10 23:20:19 | Re: [GENERAL] pg_dump bug with default date |