| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | That Fat Guy <thatfatguy(at)fastmail(dot)fm> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem removing Sequence in Postgresql 8.0.3 |
| Date: | 2008-10-19 19:17:38 |
| Message-ID: | 20081019191738.GA3884@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 8.0 I think you'd have to resort to manually
playing with the system catalogs (pg_depend in particular) to do the
same that the command would do.
Note that this is dangerous and unsopported, and if you break your
database it'll be your fault only, but it does work.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-10-20 09:25:29 | Hot Standby utility and administrator functions |
| Previous Message | hubert depesz lubaczewski | 2008-10-19 14:19:42 | Re: cost variable into function |