BUG #13655: Incorrect Syntax Error
| От | stormbyte@gmail.com |
|---|---|
| Тема | BUG #13655: Incorrect Syntax Error |
| Дата | |
| Msg-id | 20150930192526.359.78719@wrigleys.postgresql.org обсуждение |
| Ответы |
Re: BUG #13655: Incorrect Syntax Error
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13655
Logged by: David
Email address: stormbyte@gmail.com
PostgreSQL version: 9.4.4
Operating system: Gentoo Linux
Description:
When using field names with "", and custom data type, with its name also
with "", a syntax error is triggered in CREATE TABLE when tab character is
used instead of spaces.
To reproduce, create a sql file with: (Insert tab and NOT space when <TAB>
is specified)
CREATE TYPE "GPSPoint" AS ("lat" DECIMAL(9,6), "lon" DECIMAL(9,6));
CREATE TABLE "TestTable" ("testGPS"<TAB>"GPSPoint" NOT NULL);
Save it, and copy/paste to psql, you will see an syntax error near NOT.
That is workarounded by inserting <SPACE> before or instead of <TAB>, but
should not trigger any syntax error, as the same syntax works for bundled
types, so the following does not fail:
CREATE TABLE "TestTable" ("test"<TAB>SMALLINT NOT NULL);
This is a low priority bug, but a bit annoying
В списке pgsql-bugs по дате отправления: