Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> 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 req
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 c
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Fri, Jun 20, 2003 at 11:14:25AM -0600, scott.marlowe wrote:
>> Actually, template0 is the "oh dear god, what have I done to template1"
>> recovery database that the initdb script (now program) creates when run.
> I think template0 is also used to co
On Thu, 19 Jun 2003, Erik Price wrote:
> Hi,
>
> I have a database with a few tables in it (this is just a "learning"
> database). Originally I set these tables up with sequences on them
> which increment the primary key of the table when a new record is
> inserted. I would like to drop thes
Tom Lane wrote:
Erik Price <[EMAIL PROTECTED]> writes:
So, is the solution to drop the column first, then drop the sequence,
then re-create the column by using ALTER TABLE ?
Perhaps what you are really looking to do is just to reset the sequence
counters with setval() ?
Believe it or not, I r
Erik Price <[EMAIL PROTECTED]> writes:
> So, is the solution to drop the column first, then drop the sequence,
> then re-create the column by using ALTER TABLE ?
Perhaps what you are really looking to do is just to reset the sequence
counters with setval() ?
regards, tom
Hi,
I have a database with a few tables in it (this is just a "learning"
database). Originally I set these tables up with sequences on them
which increment the primary key of the table when a new record is
inserted. I would like to drop these sequences.
1. First I wanted to copy the database
