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

Re: Incomplete pg_dump operation

From: peter(at)vfemail(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Incomplete pg_dump operation
Date: 2010-02-09 06:14:27
Message-ID: 20100209145843.01FBA65B065@mail.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
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 3000000000; also returns an "ERROR:  integer out of range" message.  
select * from news limit 2000000000; returns the too-familiar "ERROR:  could not open relation with OID 2196359751" message.  
select * from news limit 1000000000; also returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 500000000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 250000000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 125000000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 62500000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 31250000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 15625000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 7812500; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 3906250; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 1953125; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 1000000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 500000; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 250000; returns an "out of memory for query result" message.
select * from news limit 375000; returns an "out of memory for query result" message.
select * from news limit 437500; returns an "out of memory for query result" message.
select * from news limit 468750; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 453125; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 445312; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 441406; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439453; returns an "out of memory for query result" message.
select * from news limit 440429; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439941; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439697; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439575; returns an "out of memory for query result" message.
select * from news limit 439636; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439605; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439590; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439582; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439579; returns an "out of memory for query result" message.
select * from news limit 439581; returns an "ERROR:  could not open relation with OID 2196359751" message.
select * from news limit 439580; returns an "ERROR:  could not open relation with OID 2196359751" message.

I have repeated and and confirmed these results:

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
>
>-- 
>Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-novice



In response to

pgsql-novice by date

Next:From: peterDate: 2010-02-09 12:12:36
Subject: Re: Incomplete pg_dump operation
Previous:From: Tom LaneDate: 2010-02-09 03:11:22
Subject: Re: Incomplete pg_dump operation

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