Re: [HACKERS] [GENERAL] Strange problem with create table as select * from table;

2011-11-06 Thread Tom Lane
hubert depesz lubaczewski writes: > checked lengths of the text/varchar columns in database. > there are 16 such columns in the table. > full report of lengths is in > http://www.depesz.com/various/lengths.report.gz > it was obtained using: > select length( "first_text_column" ) as length_1, cou

Re: [HACKERS] [GENERAL] Strange problem with create table as select * from table;

2011-11-06 Thread Tom Lane
hubert depesz lubaczewski writes: > Any chance of getting the fix in patch format so we could test it on > this system? http://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=23998fe99c1220ba3a9eefee194e37ec1f14ae07 regards, tom lane -- Sent via pgsql-hackers mail

Re: [HACKERS] [GENERAL] Strange problem with create table as select * from table;

2011-11-05 Thread Tom Lane
I wrote: > A different line of thought is that there's something about these > specific source rows, and only these rows, that makes them vulnerable to > corruption during INSERT/SELECT. Do they by any chance contain any > values that are unusual elsewhere in your table? One thing I'm > wondering

Re: [HACKERS] [GENERAL] Strange problem with create table as select * from table;

2011-11-05 Thread Adrian Klaver
On Friday, November 04, 2011 6:04:02 pm Tom Lane wrote: > I wrote: > > A different line of thought is that there's something about these > > specific source rows, and only these rows, that makes them vulnerable to > > corruption during INSERT/SELECT. Do they by any chance contain any > > values th