Re: changing sequence in serial field - Mailing list pgsql-admin

From Tom Lane
Subject Re: changing sequence in serial field
Date
Msg-id 23310.1215186596@sss.pgh.pa.us
Whole thread Raw
In response to Re: changing sequence in serial field  (Julius Tuskenis <julius@nsoft.lt>)
List pgsql-admin
Julius Tuskenis <julius@nsoft.lt> writes:
> b_prekes_br_kodas_pbk_id_seq1 was created automatically creating serial field and is in some way connected to it.
Thatswhy I get error saying "...column pbk_id requires it." Any way I can't find a way to find and alter this
dependency.

It's a row in pg_depend.  In 8.2 and up you can create/delete the row
with ALTER SEQUENCE OWNED BY, but in earlier releases you'd have to do
it manually.

            regards, tom lane

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: how to get fy info from the parent table
Next
From: Jessica Richard
Date:
Subject: How many table scans in a delete...