[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Postgres Access Timing



Right chaps/chapesses - found it!

I was using 

nextval('id'::regclass) for inserting parts

and

nextval('partsvendor_entry_id_seq'::regclass)

for inserting to partsvendor

because it seemed sensible.

However, removing these two makes it all work wonderfully! Quite why it
should have been ok for a couple of weeks and then start falling over
I've no idea.

Thanks for the help on this - hopefully this will prevent anyone else
having to bang their head against the wall for quite so long! 

Cheers
Richard