From: | Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is this a bug? (changing sequences in default value) |
Date: | 2008-05-13 16:16:03 |
Message-ID: | 20080513161603.GC1200@bal740r0.mecon.gov.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
En un mensaje anterior, Merlin Moncure escribió:
> On Tue, May 13, 2008 at 8:50 AM, Fernando Schapachnik
> <fernando(at)mecon(dot)gov(dot)ar> wrote:
> > > > ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
> > > > [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO
> > > > MAXVALUE ]
> > > > [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
> > >
> > > oop, you are using 8.1 :-). This was added in a later version. drop
> > > sequence ... cascade should probably work. you can try it out in a
> > > transaction to be sure.
> >
> > Thanks for your help, but cascade doesn't make a difference.
>
> What do you mean? PostgreSQL 8.1 has 'drop sequence cascade':
> http://www.postgresql.org/docs/8.1/interactive/sql-dropsequence.html
>
> If this isn't working, can you paste the text of the error message?
Sorry I wasn't clear. I mean to say that the error message is the same
with or without cascade:
sso=# drop SEQUENCE table1_id_seq cascade;
ERROR: cannot drop sequence table1_id_seq because table
ambitos column id requires it
HINT: You may drop table table1 column id instead.
Thanks.
Fernando.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-05-13 16:16:56 | Re: PG -v- MySQL |
Previous Message | Scott Marlowe | 2008-05-13 16:14:05 | Re: PG -v- MySQL |