Re: [GENERAL] Problem removing Sequence in Postgresql 8.0.3

2008-10-19 Thread Alvaro Herrera
That Fat Guy wrote: > Hi > > I'm trying to remove a sequence from my production database (postgresql > 8.0.3 running on RHEL4 PowerPC), but am getting an error that doesn't > make sense. When I run: In 8.2 and later (or was it 8.1?) there is ALTER SEQUENCE ... OWNED BY to solve this problem. In

[GENERAL] Problem removing Sequence in Postgresql 8.0.3

2008-10-19 Thread That Fat Guy
Hi I'm trying to remove a sequence from my production database (postgresql 8.0.3 running on RHEL4 PowerPC), but am getting an error that doesn't make sense. When I run: DROP SEQUENCE tbl_id_seq1 RESTRICT; I get the following error: ERROR: cannot drop sequence tbl_id_seq1 because t