This worked:

CREATE SEQUENCE phpgw_ttrack_job__job_id_seq START 245;

ALTER TABLE phpgw_ttrack_jobs
ALTER job_id SET DEFAULT nextval('phpgw_ttrack_job__job_id_seq');


Brian Johnson (bjohnson@jecinc.on.ca) wrote*:
Somehow one of my tables lost the sequence that was auto-incrementing the job_id
field

Can someone tell me how to recreate it, relink it (if necessary), and reset it's
number to one more than the highest number in that field?


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 8, '03 at 4:22a
activeJan 8, '03 at 4:52a
posts2
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Brian Johnson: 2 posts

People

Translate

site design / logo © 2022 Grokbase