Re: Postgresql Relations disappear - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgresql Relations disappear
Date
Msg-id 13984.1266369632@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql Relations disappear  (sergio dominguez <dgsergio84@gmail.com>)
List pgsql-bugs
sergio dominguez <dgsergio84@gmail.com> writes:
> I started to work with postgresql but i find that all the relations I create
> disappear when I quit (\q) from the interactive terminal or after load a sql
> file.

It's difficult to say for sure when you haven't showed us exactly what
you did, but one possibility is that you created the relations inside
a transaction and then forgot to commit the transaction before quitting.
Or perhaps you're creating them in a different database or different
schema than where you're subsequently looking.  Note that \d without
any parameter will only show relations that are in your current
search_path.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error