| From: | gp0072000(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14551: Simple Table Creation via GUI fails due to missing semi-colon |
| Date: | 2017-02-17 17:53:51 |
| Message-ID: | 20170217175351.6098.73954@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14551
Logged by: Gareth Parris
Email address: gp0072000(at)gmail(dot)com
PostgreSQL version: 9.6.2
Operating system: Windows 10
Description:
Just installed 9.6.2 as a clean install on Windows.
Start up pgAdmin 4.
Create a new database called "test".
Create a new table in that database, called "sample".
Add one column called "name", character(100), not null.
Click save and you get an error message:
ERROR: syntax error at or near "ALTER"
LINE 9: ALTER TABLE public."Test"
^
The SQL tab shows:
CREATE TABLE public."Test"
(
name character varying(100) NOT NULL
)
WITH (
OIDS = FALSE
)
ALTER TABLE public."Test"
OWNER to postgres;
The problem is a missing semi-colon after line 7.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Linas Vepstas | 2017-02-18 00:17:54 | Re: BUG #14494: Regression - Null arrays are not queryable |
| Previous Message | Tom Lane | 2017-02-17 16:54:21 | Re: BUG #14549: pl/pgsql parser |