Re: pg_get_serial_sequence and table inheritence - Mailing list pgsql-general

From Rafa Couto
Subject Re: pg_get_serial_sequence and table inheritence
Date
Msg-id 22df564b05053107367b31ea95@mail.gmail.com
Whole thread Raw
In response to pg_get_serial_sequence and table inheritence  (Timothy Perrigo <tperrigo@wernervas.com>)
List pgsql-general
2005/5/31, Timothy Perrigo <tperrigo@wernervas.com>:

> I'd like to be able to call pg_get_serial_sequence passing "derived"
> for the table and "id" for the sequence column (to get, in this case
> "base_id_seq").  If nothing like this currently exists, any
> suggestions on how I could write a plpgsql function to get this
> behavior?

  You have one sequence for every serial field in sequences (from psql: "\ds").


--
Rafa Couto (caligari)
mailto:rafacouto@gmail.com

pgsql-general by date:

Previous
From: David Pradier
Date:
Subject: Re: How to add an INHERITS to an already populated table
Next
From: dave
Date:
Subject: Re: enable_sort optimization problem