Обсуждение: Possible Bug regarding temp tables (sql or psql?)

Поиск
Список
Период
Сортировка

Possible Bug regarding temp tables (sql or psql?)

От
Mark Frazer
Дата:
When using the attached script in psql, the temp variables disappear as
far as \distv shows, but running the script a second time fails.

To reproduce, save the following script as bug.sql, then start psql on an
test database.
\i bug.sql
\distv
-- no relations should be shown
\i bug.sql
-- this will fail.

However, if you run psql again, you can
\i bug.sql
successfully.  It will only fail if run twice in the same script.

cheers
-mark

--
Hardy Boys: too easy. Nancy Drew: too hard! - Fry

Вложения