Theo Kramer <theo@flame.co.za> writes:
> Just noticed that limit is ignored when using a select to insert
> into a table.
> Eg. insert into mytable (f1, f2) select f1, f2 from myothertable limit 10;
> selects all records from myothertable.
Ugh, you're right. Not sure if this will be easily fixable or not.
Worst case, the fix might have to wait for the long-planned query tree
redesign.
Or it might be a one-liner. Will look into it.
regards, tom lane