X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2357ED1C9CF for ; Thu, 12 Feb 2004 14:17:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15554-05 for ; Thu, 12 Feb 2004 10:17:43 -0400 (AST) Received: from mail2.uklinux.net (s4.uklinux.net [80.84.72.14]) by svr1.postgresql.org (Postfix) with ESMTP id 3E1D9D1BB89 for ; Thu, 12 Feb 2004 10:17:29 -0400 (AST) Received: from bristolreccc.co.uk (bts-0690.dialup.zetnet.co.uk [194.247.50.178]) by mail2.uklinux.net (Postfix) with ESMTP id 6DB7B409FAE for ; Thu, 12 Feb 2004 14:17:17 +0000 (UTC) Received: from mike by bristolreccc.co.uk with local (Exim 4.30 #3 (Red Hat Linux)) id 1ArHci-00035u-Ez for ; Thu, 12 Feb 2004 14:15:24 +0000 Subject: confused newbie (to pg not db's) From: mike To: pgsql-interfaces@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1076595324.3818.8.camel@datacc> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Thu, 12 Feb 2004 14:15:24 +0000 X-SA-Exim-Scanned: No; Exit with error (see exim mainlog) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/23 X-Sequence-Number: 4716 I have setup a database that I am the owner of, and I am trying to setup constraints and it doesn't seem to be working Example - Table: public."Invoice_Header" -- DROP TABLE public."Invoice_Header"; CREATE TABLE public."Invoice_Header" ( "Inv_ID" int4 NOT NULL DEFAULT nextval('public."Invoice Header_ID_seq"'::text), "client_ID" int2 NOT NULL, payable_recievable varchar(5), "date_CREATED" date, "AMOUNT" money, amount_paid money, date_paid date ) WITH OIDS; 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 this is from psql with PG 7.3.2 any help appreciated