<sequence_name>.sequence_name != <sequence_name>?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: <sequence_name>.sequence_name != <sequence_name>?
Date: 2003-04-04 16:52:13
Message-ID: 200304040952.13927.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

When a sequence is created in 7.3.2, it appears you get a new table for each
sequence object. Is it ever possible for the sequence_name in a sequence
relation not to match the name of the relation itself?

For example, suppose I create a table:

CREATE TABLE t1(id serial);

A new relation called 't1_id_seq' is created where

t1_id_seq.sequence_name = 't1_id_seq'

Is that always true?

Ed

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ed L. 2003-04-04 17:04:25 Re: more contrib: log rotator
Previous Message Merlin Moncure 2003-04-04 16:47:56 Re: [PERFORM] OSS database needed for testing