Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Bricklen Anderson
germ germ wrote: > Thank you all for your help. I got it working, once. > > Right after I made the change and tested it, > everything worked perfect. Then I had a freak nose > bleed- (This has to be my 3rd nose bleed in my life > ever). I frantically starting closing windows and > shells. While i

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread germ germ
Thank you all for your help. I got it working, once. Right after I made the change and tested it, everything worked perfect. Then I had a freak nose bleed- (This has to be my 3rd nose bleed in my life ever). I frantically starting closing windows and shells. While in my frantic state, I deleted m

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Tom Lane
germ germ <[EMAIL PROTECTED]> writes: > This is the error: 2005-07-28 08:51:08 ERROR: > permission denied for sequence requests_req_num_seq > I've tried these grants, but no luck: > GRANT ALL ON FUNCTION nextval(integer) TO wwwrun, > postgres; > GRANT ALL ON FUNCTION nextval('requests_req_num_seq

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Douglas McNaught
germ germ <[EMAIL PROTECTED]> writes: > This is the error: 2005-07-28 08:51:08 ERROR: > permission denied for sequence requests_req_num_seq > > I've tried these grants, but no luck: > GRANT ALL ON FUNCTION nextval(integer) TO wwwrun, > postgres; > GRANT ALL ON FUNCTION nextval('requests_req_num_s

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Michael Fuhr
On Thu, Jul 28, 2005 at 07:04:54AM -0700, germ germ wrote: > This is the error: 2005-07-28 08:51:08 ERROR: > permission denied for sequence requests_req_num_seq > > I've tried these grants, but no luck: > GRANT ALL ON FUNCTION nextval(integer) TO wwwrun, > postgres; > GRANT ALL ON FUNCTION nextva

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread germ germ
This is the error: 2005-07-28 08:51:08 ERROR: permission denied for sequence requests_req_num_seq I've tried these grants, but no luck: GRANT ALL ON FUNCTION nextval(integer) TO wwwrun, postgres; GRANT ALL ON FUNCTION nextval('requests_req_num_seq') TO wwwrun, postgres; GRANT ALL ON FUNCTION next

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Richard Huxton
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, r

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Michael Fuhr
On Thu, Jul 28, 2005 at 05:32:03AM -0700, 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 > us

Re: [GENERAL] problem inserting with sequence

2005-07-28 Thread Gnanavel S
On 7/28/05, germ germ <[EMAIL PROTECTED]> wrote: I have been trying to figure out why I can't insertinto a table and I think it has something to do withthe sequnce.I am able to use able to properly insert into thetable using the the shell, but I am not able to insert using a php script:INSERT INTO

[GENERAL] problem inserting with sequence

2005-07-28 Thread germ germ
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