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
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 |