Re: pgadmin3 1.6 handling of tables with bytea's

From: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgadmin3 1.6 handling of tables with bytea's
Date: 2006-11-06 21:12:15
Message-ID: 1162847535.454fa52f10602@webmail.vcsn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Quoting Dave Page <dpage(at)postgresql(dot)org>:

> Keith C. Perry wrote:
> > I meant to ask this question weeks ago but is v1.6's handling of byteas the
> same
> > as v1.4.3's? With v1.4.3. I noticed that when I open tables with byteas,
> it
> > either takes a "very long time " or the client hangs. I think I asked
> this
> > before but isn't there a way to "handle" (i.e. ignore?) bytea data when
> editing
> > tables since as a far as I can think, such a data type would not be
> entered
> > manually anyway?
> >
> > To work on my tables with this type, I've been using a view of that type
> with
> > everything except the bytea field so I can at least see the data but
> updating is
> > a pain because I have use the SQL dialog and do things manually. I'm a
> little
> > out of touch with what PG supports at this point but are updatable views
> an
> > option? If so does 1.6 support it?
> >
> > I'll leave it to you good people to tell me what is the best way to proceed
> :)
>
> Hi Keith,
>
> I vaguely remember this issue now that you mention it, but it has
> obviously slipped through the net :-(.
>
> I've now committed a change that prevents the data being displayed in
> the grid (instead displaying "<Binary data>"), and makes the cell
> read-only. It will still select the data from the database though so if
> your bytea's are large and on the end of a slow network this fix won't
> help much unfortunately, but it should prevent any hangs or editting
> issues. Preventing the select will take more effort than I'd like at
> this stage of the release cycle.
>
> Regards, Dave.
>

Ahhh, ok- wow. I wasn't even expecting anything for 1.6.0. I thought I had
missed something :) How do I get what you commited?

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

______________________________________
This email account is being hosted by:
VCSN, Inc : http://vcsn.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-11-06 21:16:29 Re: pgadmin3 1.6 handling of tables with bytea's
Previous Message Dave Page 2006-11-06 20:24:30 Re: pgadmin3 1.6 handling of tables with bytea's