Re: pg_get_serial_sequence and table inheritence

From: Rafa Couto <rafacouto(at)gmail(dot)com>
To: Timothy Perrigo <tperrigo(at)wernervas(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_get_serial_sequence and table inheritence
Date: 2005-05-31 14:36:50
Message-ID: 22df564b05053107367b31ea95@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2005/5/31, Timothy Perrigo <tperrigo(at)wernervas(dot)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(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message josue 2005-05-31 14:58:35 Missing numbers
Previous Message David Pradier 2005-05-31 13:45:24 Re: How to add an INHERITS to an already populated table