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

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 (view raw or flat)
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

pgsql-general by date

Next:From: Tom LaneDate: 2008-11-25 13:54:56
Subject: Re: Effect of stopped status collector process
Previous:From: Siddharth ShahDate: 2008-11-25 13:44:18
Subject: Effect of stopped status collector process

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