Dropping a type
От | Steve Erickson |
---|---|
Тема | Dropping a type |
Дата | |
Msg-id | 7F530486A8695049AD320187BC36D78CD03F82AD@DIGI-MAIL10.digitilitiprod.int обсуждение исходный текст |
Ответы |
Re: Dropping a type
|
Список | pgadmin-support |
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">I'm using pgAdmin 1.12.3 on Mac OSx. I havefunctions that use a Type rowtype to hold the results of a query. When I change the query to add/remove columns, I alsochange the Type, then do a drop, then create, and get a success message. However, I then need to drop and create alldependent objects, including functions. If I don't, users will get an error. Refreshing the database in pgAdmin showsthe type has indeed changed, but users will still get an error until I drop and create the affected object (function).<br/><br /> Earlier versions of pgAdmin would give an error when dropping a Type, letting me know what objectswere dependent on that Type. I would then do the drop with cascade, then create the function(s) affected.<br /><br/></div>
В списке pgadmin-support по дате отправления: