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
