Dropping a type

Поиск
Список
Период
Сортировка
От Steve Erickson
Тема Dropping a type
Дата
Msg-id 7F530486A8695049AD320187BC36D78CD03F82AD@DIGI-MAIL10.digitilitiprod.int
обсуждение исходный текст
Ответы Re: Dropping a type  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Crash on delete record with filter in place
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgadmin string data output...