Re: Unable to CREATE SCHEMA and INSERT data in table in that schema in same EXECUTE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Unable to CREATE SCHEMA and INSERT data in table in that schema in same EXECUTE
Дата
Msg-id 11691.1377884822@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Unable to CREATE SCHEMA and INSERT data in table in that schema in same EXECUTE  (vibhuti nataraj <vvnataraj@gmail.com>)
Список pgsql-general
vibhuti nataraj <vvnataraj@gmail.com> writes:
> EXECUTE 'CREATE SCHEMA test; CREATE TABLE test.t (id integer ); INSERT INTO
> test.t (id) VALUES (0);';

That's not going to work because the whole string is parsed before any of
it is executed.  In particular, parse analysis of the INSERT is going to
spit up because neither the table nor even the schema exist yet.

> EXECUTE 'CREATE SCHEMA test; CREATE TABLE test.t (id integer );';
> EXECUTE 'INSERT INTO test.t (id) VALUES (0);';

The reason this happens to work is that CREATE TABLE is a utility
statement, which doesn't do any parse analysis to speak of, in
particular it doesn't notice at parse time whether the mentioned
schema exists.  However, that's an implementation detail that
could change from release to release.  By and large, trying to
EXECUTE multiple statements in one query string is something best
avoided, especially if any of them are DDL.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: vibhuti nataraj
Дата:
Сообщение: Unable to CREATE SCHEMA and INSERT data in table in that schema in same EXECUTE
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: What is the relationship between checkpoint and wal