From: | "Warren W(dot) Gay VE3WWG" <ve3wwg(at)cogeco(dot)ca> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Case bug in SQL Constraint |
Date: | 2002-08-01 16:52:55 |
Message-ID: | 3D496767.9040202@cogeco.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The SQL query below reports an error if the value "uid" is
provided in uppercase ("UID"). The error reported is:
ERROR: CREATE TABLE: column "UID" named in key does not exist
The problem is eliminated if "UID" is made "uid".
Here is the full text of the query:
CREATE TABLE PASSWD (
NAME VARCHAR(32) NOT NULL,
PASSWD VARCHAR(32),
UID INTEGER NOT NULL,
GID INTEGER NOT NULL,
GECOS VARCHAR(80) NOT NULL,
DIR VARCHAR(256) NOT NULL,
SHELL VARCHAR(256) NOT NULL,
CONSTRAINT "PASSWD_PKEY" PRIMARY KEY ("UID")
)
Thanks, Warren.
Other Info:
$ uname -a
FreeBSD hibiscus.ve3wwg.org 4.4-RC FreeBSD 4.4-RC #1: Wed Oct 17
22:46:11 EDT 2001
root(at)hibiscus(dot)ve3wwg(dot)org:/usr/src/sys/compile/hibiscus i386
wwg=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.2.1 on i386-portbld-freebsd4.6, compiled by GCC 2.95.3
(1 row)
--
Warren W. Gay VE3WWG
http://home.cogeco.ca/~ve3wwg
From | Date | Subject | |
---|---|---|---|
Next Message | Olcsák József | 2002-08-02 07:19:54 | TEMP TABLE USING PROBLEM |
Previous Message | Tom Lane | 2002-08-01 14:23:57 | Re: Bug #728: Interactions between bytea and character encoding when doing analyze |