"=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <[EMAIL PROTECTED]> writes:
> On 5/11/07, Collin Peters <[EMAIL PROTECTED]> wrote:
>> Is there any way to remove the sequence fully?

> ALTER SEQUENCE dtab_i_seq OWNED BY NONE;

Pre-8.2 that command doesn't exist, but you can get the same effect if
you manually remove the pg_depend entry that links the sequence to the
column.  Be sure you're removing the right entry ;-)

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to