Re: confused newbie (to pg not db's) - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: confused newbie (to pg not db's)
Date
Msg-id 4485.1076600703@sss.pgh.pa.us
Whole thread Raw
In response to confused newbie (to pg not db's)  (mike <mike@redtux1.uklinux.net>)
Responses Re: confused newbie (to pg not db's)
List pgsql-interfaces
mike <mike@redtux1.uklinux.net> writes:
> CREATE TABLE public."Invoice_Header"                     ^^^^^^^^^^^^^^^^

> I am trying to make Inv_ID a primary key as follows

> alter table Invoice_Header ADD CONSTRAINT PK_inv PRIMARY KEY (Inv_ID)             ^^^^^^^^^^^^^^

> which runs without error, but nothing changes

I think you have tables named "Invoice_Header" and "invoice_header",
and the latter table is what's getting affected by your ALTER.  If you
are going to use mixed-case names then you have to be consistent about
double-quoting them all the time.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: kwiles81@earthlink.net
Date:
Subject: Re: Can not connect with pgin.tcl
Next
From: Daniel Gerardo Lucero Baylon
Date:
Subject: Cannot compile libpq for Win 32 Environment