Re: Unable to drop a table due to seemingly non-existent dependencies - Mailing list pgsql-general

From David Brain
Subject Re: Unable to drop a table due to seemingly non-existent dependencies
Date
Msg-id 849c74160909101418wa014859yc990bfd001b8ac56@mail.gmail.com
Whole thread Raw
In response to Re: Unable to drop a table due to seemingly non-existent dependencies  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

On Thu, Sep 10, 2009 at 2:55 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>
> The "ownership" link is still there, evidently, and should be switched
> to the new table.  Read up on ALTER SEQUENCE OWNED BY.
>
>                        regards, tom lane
>

Thank you - that was the issue, once the ownership was switched to the
new tables I was able to drop the old ones.  That's certainly
something I've learned about Postgres today.

David

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Getting the oid of an anyelement
Next
From: Grant Maxwell
Date:
Subject: Re: "show all" command crashes server