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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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