Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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)

In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group