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 по дате отправления: