Postgres Pro
Downloads
Home   >   mailing lists

updating a sequence - Mailing list pgsql-sql

From John Fabiani
Subject updating a sequence
Date
Msg-id 201111150806.30911.johnf@jfcomputer.com
Whole thread Raw
Responses Re: updating a sequence  (Richard Broersma <richard.broersma@gmail.com>)
Re: updating a sequence  (John Fabiani <johnf@jfcomputer.com>)
List pgsql-sql
Tree view 
Hi,
I have need of a statement that updates the sequence but uses a max() to find 
the number.

alter sequence somename restart with (select max(pk) from sometable).

I need this for automating an ETL (using pentaho).

Postgres 8.4

Thanks in advance,
Johnf

pgsql-sql by date:

Previous
From: Brice André
Date:
Subject: pg_dump : problem with grant on table columns
Next
From: Richard Broersma
Date:
Subject: Re: updating a sequence