Thanks. It must be new in postgres 7.2 as I don't remember having that issue with earlier releases.
Aaron On Tue, 5 Mar 2002, Martin Richard wrote: > Aaron - > > I've read on some msg board that its a known issue with postgres.. To > fix it you need to GRANT permissions on the sequences to the user you > connect with. I've never worked with that DB before, so here's something > handy I just found, if you connect with 'psql freeipdb' (usually as the > postgres superuser) you can use '\dS' to get a list of all the tables in > the DB. Then > > SELECT * FROM pg_statio_all_sequences; > > Will give you a list of the defined sequences. If you're like me and are > using this DB only for freeipdb, you get 6 rows. These are the ones you > need to give permissions to: > > GRANT ALL ON ipdb_id_seq TO freeipdb; > > Where you have first the seq name then the account name... Rinse and > repeat for the others and voila.. should now be able to add data (first a > RA in your case) to the system. > > Martin Richard > Sp�cialiste Technique / Technical Specialist > Internet Solutions, COGNICASE > Tel.: (514) 732-8000 x4086 > Cel.: (514) 234-3636 ****Please note recent change of number**** > Fax.: (514) 732-8002 > >
