From: | Kyle <someuser(at)someaddress(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org(dot)pgsql-sql"(at)postgresql(dot)org |
Subject: | Simple insert not returning |
Date: | 2004-03-31 18:06:28 |
Message-ID: | EMDac.98806$KB.8706@twister.nyroc.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
PostgreSQL v7.4 on Solaris 9
I've got a simple table....
CREATE TABLE public.tbl_system
(
system_id int4 NOT NULL DEFAULT nextval('public.id_seq'::text),
system_name varchar(50) NOT NULL,
description varchar(300),
active bool DEFAULT true,
CONSTRAINT pk_tbl_system PRIMARY KEY (system_id),
CONSTRAINT unique_system_name UNIQUE (system_name)
) WITHOUT OIDS;
GRANT ALL ON TABLE public.tbl_system TO postgres WITH GRANT OPTION;
GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE public.tbl_system TO GROUP
webapps;
I then try to issue the following statement in psql...
INSERT INTO tbl_system ( system_name, description ) VALUES ( 'test',
'test system' );
after executing this query, it just sits there and never returns...
Am I missing something?
-={ Kyle }=-
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2004-03-31 18:06:58 | Re: Wich hardware suits best for large full-text indexed databases |
Previous Message | Tom Lane | 2004-03-31 18:03:40 | Re: Question about rtrees (overleft replacing left in nodes) |
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Sugawara | 2004-03-31 18:55:57 | left join on a view takes significantly more time. |
Previous Message | Tom Lane | 2004-03-31 15:33:20 | Re: Is it normal that functions are so much faster than inline queries |