BUG #13655: Incorrect Syntax Error

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

Responses

Browse pgsql-bugs by date

  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