germ germ 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,
recommended_by varchar(35) NOT NULL
);
GRANT ALL ON requests TO wwwrun, postgres;
Check you server logs and it should tell you why. Actually, check the
error code in your PHP and it should tell you why.
My immediate guess - you haven't granted permission to the sequence for
user "wwwrun".
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
