[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Simple insert not returning
From:       Kyle <someuser () someaddress ! com>
Date:       2004-03-31 18:06:28
Message-ID: EMDac.98806$KB.8706 () twister ! nyroc ! rr ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]