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 14:22:25 |
Message-ID: | 1379427745300-5771257.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thomas Kellerer wrote
> Kimberly Israel, 17.09.2013 14:33:
>> Yesterday I created several tables and was able to run queries that
>> combined data from more than one table at a time, but when I reopened
>> pgAdmin III today, the database I had created was there, but the
>> tables were all gone. I tried to save my work, but what got saved
>> was a .sql file that seems to only contain the code for creating the
>> database. Basically what I need to know is how do I put my tables
>> somewhere where I'll be able to continue working with them after a
>> period of having the computer off?
>
> This all sounds like you forgot to commit your changes.
>
> When you have auto-commit disabled you need to commit every change you
> make to the database - including a CREATE TABLE statement.
All true; and while I didn't actively ponder this scenario I find it
unlikely given the log file. Given all of the syntax errors that we saw I
would have expected to see a large number of (paraphrased) "current
transaction is aborted; ignoring all statements until Rollback has been
issued" messages.
Unless the OP was re-creating the table every time a typo occurred those
tables had to have been committed at some point during the session.
Also, I do not think the OP likely turned off auto-commit and so if that is
the default mode I would presume that said default is still in effect.
The temporary table thought is pretty much just as improbable but nothing
else readily comes to mind.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-do-I-save-my-tables-tp5771217p5771257.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kimberly Israel | 2013-09-17 14:40:48 | Re: How do I save my tables? |
Previous Message | Thomas Kellerer | 2013-09-17 13:12:52 | Re: How do I save my tables? |