pg_get_serial_sequence Strangeness/Unreliable?

From: Jeff MacDonald <oss(at)bignose(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_get_serial_sequence Strangeness/Unreliable?
Date: 2008-11-25 13:46:37
Message-ID: 5E86D353-2823-4338-A12E-E339D3E68E51@bignose.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I'm using "PostgreSQL 8.2.5 on amd64-portbld-freebsd6.1, compiled by
GCC cc (GCC) 3.4.4 [FreeBSD] 20050518"

The issue, is that when I run pg_get_serial_sequence on a particular
table/column it returns NULL.

Here are my tests:

simplyas_associations=> \d news_status
Table "public.news_status"
Column | Type |
Modifiers
---------------+-----------------------
+------------------------------------------------------------
status_id | integer | not null default
nextval('status_status_id_seq'::regclass)
newsletter_id | integer | not null
status | boolean | not null
indate | character varying(15) | not null
Indexes:
"status_pkey" PRIMARY KEY, btree (status_id)
"status_newsletter_id" btree (newsletter_id)

simplyas_associations=> select
pg_get_serial_sequence('news_status','status_id');
pg_get_serial_sequence
------------------------

(1 row)

So, for fun I added a new column to this table , and ran
pg_get_serial_sequence there

simplyas_associations=> alter table news_status add column test_id
serial;
NOTICE: ALTER TABLE will create implicit sequence
"news_status_test_id_seq" for serial column "news_status.test_id"
ALTER TABLE
simplyas_associations=> select
pg_get_serial_sequence('news_status','test_id');
pg_get_serial_sequence
--------------------------------
public.news_status_test_id_seq
------------------------

(1 row)

So my new column works. The only next step I could think of was to
compare my 2 sequences with \d, turns out their attributes are both
identical.

Ideas?

Thanks

Jeff MacDonald

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-25 13:54:56 Re: Effect of stopped status collector process
Previous Message Siddharth Shah 2008-11-25 13:44:18 Effect of stopped status collector process