From: | "Lic(dot) Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | dfx <dfx(at)dfx(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Case sensitivity? |
Date: | 2005-12-27 15:04:40 |
Message-ID: | Pine.LNX.4.61.0512271203100.9214@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 27 Dec 2005, dfx wrote:
> Dear Sirs,
>
> I have a little problem:
>
> - Contest: Server side: Linux Fedora core 4 with PostgreSQL v. 8.0
> Client side: both Linux Fedora core 4 with pgAdmin III v.
> 1.4 and/or Windows 2000 server vith pgAdmin III v. 1.4
>
> - I Made a table:
>
> CREATE TABLE "Accoglienza"
> (
> "IdAccoglienza" int4 NOT NULL DEFAULT
> nextval('public."Accoglienza_IdAccoglienza_seq"'::text),
> "IdCongresso" int4 NOT NULL DEFAULT 0,
> CONSTRAINT "Accoglienza_Pk" PRIMARY KEY ("IdAccoglienza")
> )
> WITHOUT OIDS;
>
> if I try "INSERT INTO Accoglienza (IdCongresso) VALUES (23)"
>
> I get an error "ERROR: la relazione "accoglienza" non esiste" (The relation
> "accoglienza does not exist")
>
> please note the change of the case of "A" to "a";
>
> if I rename the table to "accoglienza" the error disappear, but arise
> another error on "IdAccoglienza" that change in "idaccoglienza". (i.e. all
> converted to lower case)
>
> The same error arise with window client and linux client.
>
> How I can set case-insensitive the system, or avoid the conversion to lower
> case?
Create the table without closing the relation's name with doble quotes:
CREATE TABLE Accoglienza
(
IdAccoglienza int4 NOT NULL DEFAULT
nextval('public.Accoglienza_IdAccoglienza_seq'::text),
IdCongresso int4 NOT NULL DEFAULT 0,
CONSTRAINT Accoglienza_Pk PRIMARY KEY (IdAccoglienza)
)
WITHOUT OIDS;
--
12:00:02 up 4 days, 23:12, 1 user, load average: 0.35, 0.54, 0.70
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-12-27 15:14:14 | Re: Case sensitivity? |
Previous Message | Jaime Casanova | 2005-12-27 13:51:12 | Re: solving wraparound |