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

Dropping sequences

From: Robert Fitzpatrick <robert(at)webtent(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Dropping sequences
Date: 2004-11-30 19:11:11
Message-ID: 1101841871.9204.62.camel@columbus.webtent.org (view raw or flat)
Thread:
Lists: pgsql-general
I have changed the default sequence on a primary key integer (created as
SERIAL) field in a table, but it will not let me drop the old sequence
and continues to tell me that the sequence is required by the table. Can
someone tell me what is required to get this dropped? I am just paranoid
that it could be using the old sequence still even though it seems all
is coming from the new sequence.

-- 
Robert


Responses

pgsql-general by date

Next:From: Steve AtkinsDate: 2004-11-30 19:18:10
Subject: Re: Maximum limit on int in plpgsql
Previous:From: Net Virtual Mailing ListsDate: 2004-11-30 17:46:02
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...

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