Skip site navigation (1) Skip section navigation (2)

insert into table (column) values ('string'); fail

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: insert into table (column) values ('string'); fail
Date: 2001-06-30 03:21:22
Message-ID: 200106300321.f5U3LMq32301@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Derek Tam (kmtam(at)yahoo(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
insert into table (column) values ('string'); fail

Long Description
my system is i586/RedHat 6.2, using v7.1.2 RPM - postgresql-*-7.1.2-4PGDG




Sample Code
derek=#CREATE TABLE test(testing text);
CREATE
derek=#INSERT INTO test VALUES ('123');
INSERT 78832 1
derek=#INSERT INTO test (testing) VALUES ('123');
ERROR:  parser: parse error at or near ")"

what happen??



No file was uploaded with this report


pgsql-bugs by date

Next:From: Zhan YiDate: 2001-06-30 05:10:17
Subject: performance
Previous:From: pgsql-bugsDate: 2001-06-29 20:49:23
Subject: Comments on Triggers and Rules are broken by pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group