On 10/08/10 12:08, Boxuan Zhai wrote:Thanks for your feedback. I fixed all the above waring bugs. Find the newpatch in attachement.Thanks.I'm getting an assertion failure with this statement:CREATE TABLE foo (id int4);MERGE into foo tUSING (select id FROM generate_series(1,5) id) AS sON t.id = s.id WHEN NOT MATCHED THEN INSERT (id) VALUES (s.id);
Thanks for your feedback. I fixed all the above waring bugs. Find the newpatch in attachement.
TRAP: FailedAssertion("!(ActiveSnapshotSet())", File: "postgres.c", Line: 749) That's easily fixed - you need to add "case T_MergeStmt" to the list of optimizable command types in analyze_requires_snapshot() function.Unfortunately that doesn't get you far, the query then trips another assertion:TRAP: FailedAssertion("!(list_length(resultRelations) == list_length(subplans))", File: "createplan.c", Line: 3929)
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных