Lost - one sequence - Mailing list pgsql-novice

From Brian Johnson
Subject Lost - one sequence
Date
Msg-id 20030107.TRd.46673400@192.168.0.1
Whole thread Raw
List pgsql-novice
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?


pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Delete from right join
Next
From: "Brian Johnson"
Date:
Subject: Re: Lost - one sequence