Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Dave Page
On Saturday, December 3, 2011, Aren Cambre wrote: > Could pgAdmin detect if the view has no dependents and offer to drop and replace the view? Potentially, though that might be a a little tricky to do given the way that code is architected. It would probably have to do the check when the dialogue

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Aren Cambre
Could pgAdmin detect if the view has no dependents and offer to drop and replace the view? My views generally have no dependents. Don't know if that's typical, however. Aren On Fri, Dec 2, 2011 at 3:08 AM, Dave Page wrote: > > > On Fri, Dec 2, 2011 at 3:47 AM, Aren Cambre wrote: > >> If I cha

Re: [pgadmin-support] Problems changing a view

2011-12-02 Thread Dave Page
On Fri, Dec 2, 2011 at 3:47 AM, Aren Cambre wrote: > If I change this view: > * SELECT dallas_rlc_locations.location_code, > count(dallas_rlc."CitationId") AS count, dallas_rlc_locations.location, > dallas_rlc_locations.the_geom* > * FROM raw.dallas_rlc_locations* > * LEFT JOIN raw.dallas_rlc