From: | mike <mike(at)redtux1(dot)uklinux(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: confused newbie (to pg not db's) |
Date: | 2004-02-12 19:40:18 |
Message-ID: | 1076614818.11650.10.camel@datacc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Thu, 2004-02-12 at 15:45, Tom Lane wrote:
> mike <mike(at)redtux1(dot)uklinux(dot)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
>
I worked out what was happening - I was missing the ;
Not helped by pgaccess and pgadmin not working right in different ways
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sandro Dentella | 2004-02-12 20:26:29 | libpgtcl.dll for tcl 8.4? |
Previous Message | Jeroen T. Vermeulen | 2004-02-12 19:35:55 | Re: Cannot compile libpq for Win 32 Environment |