From: | "Sergey Karin" <sergey(dot)karin(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_catalog.pg_get_serial_sequence() returns NULL |
Date: | 2007-06-26 15:28:49 |
Message-ID: | b78883bf0706260828u67cc1264h541ff1316464cc55@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I use PG 8.1.5
I execute in psql next comands:
create table t_table (gid serial, name varchar);
select pg_catalog.pg_get_serial_sequence('t_table', 'gid');
pg_get_serial_sequence
------------------------
public.t_table_gid_seq
create table t_table_1() inherits (t_table);
\d t_table_1
Table "public.t_table_1"
column | Type | Модификаторы
---------+-------------------+-------------------------------------------------------
gid | integer | not null default
nextval('t_table_gid_seq'::regclass)
name | character varying |
Inherit: t_table
select pg_catalog.pg_get_serial_sequence('t_table_1', 'gid');
pg_get_serial_sequence
------------------------
<NULL>
How I can get name of sequence used by gid column of partition table? And
why for t_table_1 pg_get_serial_sequence() returns NULL?
It returns NULL also if I create new sequence manually and use ALTER TABLE
ALTER COLUMN <column> SET DEFAULT nextval(<my_new_sequence>::regclass).
In http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-SERIAL I
can read that type SERIAL is equivalent to
CREATE SEQUENCE *tablename*_*colname*_seq;
CREATE TABLE *tablename* (
*colname* integer DEFAULT nextval('*tablename*_*colname*_seq') NOT NULL
);
Thanks in advance
Sergey Karin
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2007-06-26 15:33:39 | Re: Duplicate records returned |
Previous Message | news.gmane.org | 2007-06-26 15:16:11 | Re: a JOIN on same table, but 'slided over' |