Re: Feature request: Reget oid of tables/views when doing a reload

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Mark Murawski <kobaz(at)kobaz(dot)net>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Feature request: Reget oid of tables/views when doing a reload
Date: 2009-08-17 10:22:41
Message-ID: 937d27e10908170322i62322479j46d140a6ea4d1d41@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Thanks, logged: http://code.pgadmin.org/trac/ticket/44

On Fri, Aug 14, 2009 at 3:20 AM, Mark Murawski<kobaz(at)kobaz(dot)net> wrote:
> When I'm doing heavy development I'm always removing and recreating tables
> and views.
>
> If you
> - drop a view
> - create a view with the same name
> - and have the data window for the view open from before it was dropped
> - and do a refresh
>
> You lose the column names, since the oid for the view/table is cached.  So
> if upon refresh, it rechecked the oid of the thing you are viewing, that
> would fix the issue.
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2009-08-17 10:26:26 Re: sudden program termination: no warning, error, or crash
Previous Message Dave Page 2009-08-17 10:19:56 Re: Feature request: Refresh data when doing 'create script'