Re: Server crash when using dblink_build_sql_* after alter table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Voinea <robert(dot)voinea(at)topex(dot)ro>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Server crash when using dblink_build_sql_* after alter table
Date: 2010-06-14 17:36:27
Message-ID: 15794.1276536987@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robert Voinea <robert(dot)voinea(at)topex(dot)ro> writes:
> I attached the server log (for the crash case) and a test case with logs.
> For that test case this is the error I get, no server crash.

> ERROR: invalid memory alloc request size 4294967293

> The scenario is this:
> Create a table, drop a column, any column then add a varchar column and an int
> column. Then use dblink_build_sql_update.

Yeah, it looks like dblink is simply wrong about how to count the
columns in a case with dropped columns. Thanks for the report, will
fix.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ricardo Bayley 2010-06-15 06:09:11 Rules
Previous Message Robert Voinea 2010-06-14 11:15:09 Re: Server crash when using dblink_build_sql_* after alter table