Skip site navigation (1) Skip section navigation (2)

Re: BUG #3291: Query tool not returning all results

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Todd Frankson <tfrankson(at)medtrials(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3291: Query tool not returning all results
Date: 2007-05-21 17:43:55
Message-ID: 4651DA5B.3020005@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Todd Frankson wrote:
> I have not Tried PSQL.
> 
> I use PG Admin.
> 
> Forgive me as i am not familiar with Postgres as much as other
> databases.
> 
> I open the Query tool from PGAdmin
> 
> Type Select X from y
> Where Z
> 
> I get back only a Portion of a field that is Defined as "text".
> In the PGAdmin, the Max. Return is set to 5000

Try to connent into database by psql command line tool
e.g: psql mydatabase -U myaccount

and perform same command. Check if you get the same result.


	Zdenek

In response to

pgsql-bugs by date

Next:From: Philip IvesDate: 2007-05-21 19:10:34
Subject: BUG #3295: pg_get_serial_sequence returns wrong sequence name for a serial column
Previous:From: Stephan SzaboDate: 2007-05-21 15:52:56
Subject: Re: ON DELETE CASCADE with multiple paths

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group