MOD: Reset/Recalculate Sequence

From: "Traci Sumpter" <Traci(dot)Sumpter(at)opus(dot)co(dot)nz>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: MOD: Reset/Recalculate Sequence
Date: 2005-11-20 20:31:22
Message-ID: 20051120203127.E51A4F0B50@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I am often transferring data from one system to another , and I would really
like a command ( even single sequence level)
To get the highest value in a sequence field and set the sequence to it..

E.G Right click on the sequence and select 'Reset to Highest in Table' I
grabs the Highest value from the table and sets the current value to that
+1.

Cheers

Traci

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-11-20 20:58:25 Re: BUG: Grant Wizard
Previous Message Traci Sumpter 2005-11-20 20:31:10 Re: BUG: Grant Wizard