I have a DB (PostgreSQL of course) which has in the definition of one of
its tables that the default is nextval(public.rr_id_seq'::text). When I look
in the sequence I see that the "last_value" column is 40, but the largest
value in the relevant column is 45. I tried using the SQL update command
to update this value but it would not let me. How do I get rr_id_seq in step
with the data in the table?
David
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
