From: | stormbyte(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13655: Incorrect Syntax Error |
Date: | 2015-09-30 19:25:26 |
Message-ID: | 20150930192526.359.78719@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13655
Logged by: David
Email address: stormbyte(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Haribabu Kommi | 2015-10-01 01:42:32 | Re: BUG #13655: Incorrect Syntax Error |
Previous Message | Jeff Janes | 2015-09-30 17:03:29 | Re: GRANT USAGE ON SEQUENCE missing from psql command completion |