Re: Postgresql Relations disappear

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql Relations disappear
Дата
Msg-id 13984.1266369632@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgresql Relations disappear  (sergio dominguez <dgsergio84@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error