Re: How do I save my tables?

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do I save my tables?
Date: 2013-09-17 12:59:21
Message-ID: 1379422761108-5771228.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

An errors-only log is useless for this kind of analysis. its the successful
statements that truly matter (in combination with the errors). You should
log all statements during our next session so a complete log is available
for review. You should also annotate said log with your thoughts/comments
before posting it (and trim out the errors that you subsequently corrected).

You do not "save" tables. If you issue a successful CREATE TABLE statement
that table will be permanent.

You need replicate what you did "yesterday" and document what you did in
much more detail if you want someone to try and figure out what went wrong.
So go in, create one table. Insert and query it. Close out pgAdmin and
reboot if you like. Then go back in and see if the table is still there.
If not note any changes to the pgAdmin dialogs hat your made while adding
said table. My on.y thought is that you created temporary tables (which go
away at session end).

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-do-I-save-my-tables-tp5771217p5771228.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2013-09-17 13:11:31 Re: How do I save my tables?
Previous Message Kevin Grittner 2013-09-17 12:51:17 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data