From: | Steve Erickson <serickson(at)digitiliti(dot)com> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Dropping a type |
Date: | 2011-09-21 14:04:21 |
Message-ID: | 7F530486A8695049AD320187BC36D78CD03F82AD@DIGI-MAIL10.digitilitiprod.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I'm using pgAdmin 1.12.3 on Mac OSx. I have functions that use a Type rowtype to hold the results of a query. When I change the query to add/remove columns, I also change the Type, then do a drop, then create, and get a success message. However, I then need to drop and create all dependent objects, including functions. If I don't, users will get an error. Refreshing the database in pgAdmin shows the type has indeed changed, but users will still get an error until I drop and create the affected object (function).
Earlier versions of pgAdmin would give an error when dropping a Type, letting me know what objects were dependent on that Type. I would then do the drop with cascade, then create the function(s) affected.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-09-23 19:28:11 | Re: pgadmin string data output... |
Previous Message | Dave Page | 2011-09-21 13:17:06 | Re: Crash on delete record with filter in place |