[BUGS] Postgresql Relations disappear
Hello, good morning! 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. I tried to find something about this bug but I haven't found anything about that, I would really appreciate if you could tell me why this is happening. I'm triying to load my database scheme from a sql file (psql -f myscheme.sql mydb or, from interactive terminal: \i my_scheme.sql) but the only thing I get is No relations found.. I also tried installing several versions of postgresql 8.1, 8.2, etc under Snow Leopard, ubuntu and debian and every time I get the same answer: No relations found. -- Sergio Jhovanne Domínguez González Mat. a0213100H Maestría en Ciencias en Ingeniería Eléctrica, División de Estudios de Posgrado, FIE, U.M.S.N.H.
Re: [BUGS] Postgresql Relations disappear
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
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
