[GENERAL] "ERROR: could not read block 4459549 in file "base/16384/16956.34": Result too large"

Hey, I got a huge database which I am populating in batches. One of the tables seemed to got 'corrupted.' I cannot query it anymore. I'm pretty sure that I could identify the batch of rows where the mistake must be, so if I could somehow revert it to an earlier state or temporary query it, I could

[GENERAL] how to append records from dump to existing database?

Hi, I would like to know how I could append a database dump to an existing database without clearing it. Example: I got a database 'db' with a tables 't1' including variables 'var1' and 'var2', and table 't2' with variables 'var3' and 'var4'. Earlier this year, I stored records 1 to 100 in this d

Re: [GENERAL] Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac

! Help much appreciated! 2014-12-14 10:51 GMT-05:00 Adrian Klaver : > > On 12/14/2014 07:44 AM, Andy Colson wrote: > >> On 12/13/2014 10:03 PM, wetter wetterana wrote: >> >>> Hi, >>> >>> I'm passing rows from SAS to PostgreSQL (I assign a l

[GENERAL] Error: "Out of memory while reading tuples." in pushing table from SAS to PostgreSQL on Mac

Hi, I'm passing rows from SAS to PostgreSQL (I assign a libname and use a PROC APPEND). This works fine with smaller tables (~below 1 million rows). However, as tables get larger I receive the following error messages: "ERROR: CLI describe error: Out of memory while reading tuples.; No query ha