Re: problem inserting with sequence - Mailing list pgsql-general

From Gnanavel S
Subject Re: problem inserting with sequence
Date
Msg-id eec3b03c050728054612315a2c@mail.gmail.com
Whole thread Raw
In response to problem inserting with sequence  (germ germ <super_code_monkey@yahoo.com>)
List pgsql-general


On 7/28/05, germ germ <super_code_monkey@yahoo.com> wrote:
I have been trying to figure out why I can't insert
into a table and I think it has something to do with
the sequnce.

I am able to use able to properly insert into the
table using the the shell, but I am not able to insert
using a php script:

INSERT INTO requests (time_stamp, req_num,
recommended_by) VALUES (now(),
nextval('requests_req_num_seq'), 'foo');

Here is the schema I'm using:
DROP SEQUENCE requests_req_num_seq;
DROP TABLE requests;

CREATE SEQUENCE requests_req_num_seq INCREMENT BY 1
START WITH 1000;

CREATE TABLE requests (
        time_stamp              timestamp       PRIMARY KEY DEFAULT 'now',
        req_num                 integer         DEFAULT
nextval('acq_requests_req_num_seq') NOT NULL,

 where is this sequence 'acq_requests_req_num_seq' created. You have created only 'requests_req_num_seq'

        recommended_by          varchar(35)     NOT NULL
);
GRANT ALL ON requests TO wwwrun, postgres;

If I reconfigure the schema by removing the sequence
from the table, I am able to insert into the table
using both the shell and php script:
DROP SEQUENCE requests_req_num_seq;
DROP TABLE requests;

CREATE SEQUENCE requests_req_num_seq INCREMENT BY 1
START WITH 1000;

CREATE TABLE requests (
        time_stamp              timestamp       PRIMARY KEY DEFAULT 'now',
        recommended_by          varchar(35)     NOT NULL
);

INSERT INTO requests (time_stamp, recommended_by)
VALUES (now(), 'foo');

I'm a little stumped on this one. I'm running
PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC
gcc (GCC) 3.3.3 (SuSE Linux).

Thanks in advance for any help or advice.



__________________________________
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.

pgsql-general by date:

Previous
From: germ germ
Date:
Subject: problem inserting with sequence
Next
From: Michael Fuhr
Date:
Subject: Re: problem inserting with sequence