Remove gratuitous uses of deprecated SELECT INTO
Peter Eisentraut <peter@eisentraut.org>
Remove gratuitous uses of deprecated SELECT INTO CREATE TABLE AS has been preferred over SELECT INTO (outside of ecpg and PL/pgSQL) for a long time. There were still a few uses of SELECT INTO in tests and documentation, some old, some more recent. This changes them to CREATE TABLE AS. Some occurrences in the tests remain where they are specifically testing SELECT INTO parsing or similar. Discussion: https://www.postgresql.org/message-id/flat/96dc0df3-e13a-a85d-d045-d6e2c85218da%40enterprisedb.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/sepgsql/expected/label.out | modified | +1 −1 |
| contrib/sepgsql/sql/label.sql | modified | +1 −1 |
| doc/src/sgml/hstore.sgml | modified | +1 −1 |
| src/bin/pg_basebackup/t/010_pg_basebackup.pl | modified | +2 −2 |
| src/bin/pg_checksums/t/002_actions.pl | modified | +1 −1 |
| src/test/regress/expected/create_index.out | modified | +1 −1 |
| src/test/regress/expected/create_misc.out | modified | +1 −1 |
| src/test/regress/expected/random.out | modified | +2 −1 |
| src/test/regress/expected/select_implicit_1.out | modified | +4 −2 |
| src/test/regress/expected/select_implicit_2.out | modified | +4 −2 |
| src/test/regress/expected/select_implicit.out | modified | +4 −2 |
| src/test/regress/sql/create_index.sql | modified | +1 −1 |
| src/test/regress/sql/create_misc.sql | modified | +1 −1 |
| src/test/regress/sql/random.sql | modified | +2 −1 |
| src/test/regress/sql/select_implicit.sql | modified | +4 −2 |
Documentation touched
Discussion
- SELECT INTO deprecation 18 messages · 2020-12-02 → 2021-03-30