Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE
Michael Paquier <michael@paquier.xyz>
Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE The grammar IF NOT EXISTS for CTAS is supported since 9.5 and documented as such, however the case of using EXECUTE as query has never been covered as EXECUTE CTAS statements and normal CTAS statements are parsed separately. Author: Andreas Karlsson Discussion: https://postgr.es/m/2ddcc188-e37c-a0be-32bf-a56b07c3559e@proxel.se Backpatch-through: 9.5
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/parser/gram.y | modified | +18 −0 |
| src/test/regress/expected/create_table.out | modified | +14 −0 |
| src/test/regress/sql/create_table.sql | modified | +8 −0 |
Discussion
- Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; 10 messages · 2019-02-06 → 2019-03-10