View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 06:00 PM
Dave Page
 
Posts: n/a
Default Re: view data causes pgadmin to hang or die



> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailtogadmin-hackers-owner@postgresql.org] On Behalf Of Miha Radej
> Sent: 28 March 2006 08:27
> To: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] view data causes pgadmin to hang or die
>
> > i have a table with 204 rows of data which contain about

> 700k of text
> > alltogether. when i tried to use "view data" in the table, pgadmin
> > either crashes or hangs, no apparent pattern so far. in

> pgadmin log, set
> > to debug, there is nothing to indicate the problem. but

> according to it
> > (and to pgsql log) it seems pgadmin gets the data, then

> sends a query to
> > get the column names. here are the last lines from pgsql log:


Does the query tool display it properly if you increase the "Max
characters per column" option under File->Options->Query so it is large
enough to hold the data?

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote