Re: Incomplete pg_dump operation
От | peter@vfemail.net |
---|---|
Тема | Re: Incomplete pg_dump operation |
Дата | |
Msg-id | 20100209145843.01FBA65B065@mail.postgresql.org обсуждение исходный текст |
Ответ на | Re: Incomplete pg_dump operation (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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@vfemail.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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: