Simple insert not returning

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 }=-

Browse pgsql-general by date

  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)

Browse pgsql-sql by date

  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