eksey M Boltenkov. 15.08.2020, 08:39, Pavel Stehule <pavel.steh...@gmail.com>
so 15. 8. 2020 v 7:35 odesílatel Aleksey M Boltenkov <holyb...@rambler.ru> napsal: Is this a bug? Executing of malformed (quote symbols) select in psql results in unexpected behaviour: pg01:5432 postgres@db=# select 'any expression'any expression\d+; List of relations Schema │ Name │ Type │ Owner │ Size │ Description ════════╪══════════════════════════╪══════════╪══════════╪════════════╪══════════════ public │ geography_columns │ view │ postgres │ 0 bytes │ public │ geometry_columns │ view │ postgres │ 0 bytes │ public │ pg_buffercache │ view │ postgres │ 0 bytes │ public │ pg_stat_statements │ view │ postgres │ 0 bytes │ public │ raster_columns │ view │ postgres │ 0 bytes │ public │ raster_overviews │ view │ postgres │ 0 bytes │ public │ spatial_ref_sys │ table │ postgres │ 4616 kB │ ... I tested psql-12 and psql-14 and I don't see this issue Pavel Aleksey M Boltenkov. You must have relations in search path, ifaiu. engineer@pg02:~$ psql -U postgres -h localhost -p 5432 kaad SET Timing is on. Null display is "¤". Line style is unicode. Unicode border line style is "single". Unicode column line style is "single". Unicode header line style is "double". Output format is wrapped. SET Time: 0.234 ms SET Time: 0.206 ms psql (12.4 (Ubuntu 12.4-1.pgdg18.04+1)) Type "help" for help.2020-08-15 09:29:18 localhost:5432 postgres@kaad=# select version(); version ═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════ PostgreSQL 12.4 (Ubuntu 12.4-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit (1 row)Time: 6.682 ms 2020-08-15 09:29:24 localhost:5432 postgres@kaad=# select 'any expression'any expression\d+; List of relations Schema │ Name │ Type │ Owner │ Size │ Description ════════╪═══════════════════╪═══════╪══════════╪═════════╪═════════════ public │ geography_columns │ view │ postgres │ 0 bytes │ public │ geometry_columns │ view │ postgres │ 0 bytes │ public │ raster_columns │ view │ postgres │ 0 bytes │ public │ raster_overviews │ view │ postgres │ 0 bytes │ public │ spatial_ref_sys │ table │ postgres │ 4616 kB │ (5 rows)[more] - > ; -- semicolon is manually added ERROR: 42601: syntax error at or near "any" LINE 1: select 'any expression'any expression ^ LOCATION: scanner_yyerror, scan.l:1149 Time: 0.530 ms Aleksey M Boltenkov.
