Re: Incomplete pg_dump operation

The semicolon makes a tremendous difference. Thank you for your patience.

select * from news limit 0; displays a nice little table and 0 rows of data.
select * from news limit 1; displays the same table and the contents of 1 data record.
select * from news limit 5000000000; returns an "ERROR: integer out of range" message.

select * from news limit 439579; returns an "out of memory for query result" message.
select * from news limit 439580; returns an "ERROR: could not open relation with OID 2196359751" message.

-------

At 10:11 PM 2/8/2010, Tom Lane wrote:
>peter(at)vfemail(dot)net writes:
>> None of these commands return any message of any kind:
>
>> select * from news limit 1000000000
>> select * from news limit 1000
>> select * from news limit 100
>> select * from news limit 10
>
>Um .... maybe you're forgetting to terminate them with a semicolon?
>
> regards, tom lane