Re: [BUGS] Postgresql Relations disappear

2010-02-16 Thread Euler Taveira de Oliveira
sergio dominguez escreveu:
 I started to work with postgresql but i find that all the relations I
 create disappear when I quit (\q)
 
This is not a bug. I bet your tables are loaded into a schema that is not in
the search_path.


-- 
  Euler Taveira de Oliveira
  http://www.timbira.com/

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] Postgresql Relations disappear

2010-02-16 Thread Tom Lane
sergio dominguez dgsergi...@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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs