Lost - one sequence

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Lost - one sequence
Date: 2003-01-08 04:22:06
Message-ID: 20030107.TRd.46673400@192.168.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Johnson 2003-01-08 04:52:33 Re: Lost - one sequence
Previous Message Josh Berkus 2003-01-07 20:55:47 Re: Delete from right join