[Bucardo-general] b5 / pg84 : "arguments of row IN must all be row expressions"

Bill McGonigle bill at bfccomputing.com
Wed Sep 19 19:24:34 UTC 2012


Hi, everybody,

I did a b4-b5 migration last week (howto to follow) and it's been going 
great, but today I'm seeing an error that prevents replication from 
proceeding.  The offending statement follows.  I think it's a 
Bucardo-generated statement based on the sqlprefix.  Figured I'd put it 
up here while I'm trying to figure out what's going on, in case others 
have run into this.

Thanks,
-Bill


ecommerce=# EXPLAIN /* Bucardo 4.99.5 */DELETE FROM public.related WHERE 
(parent_id,child_id) IN ( 
('3839','5854S'),('3837','1849S'),('3826','1796'),('3834','4558BTRMLK'),('3839','4654S'),('3939','3819'),('9532','1195485284390'),('3834','3785'),('3874','3837'),('3954','1849S'),('3839','8751'),('9532','176'),('3939','1837S'),('3865','1849S'),('3839','1837S'),('3826','128'),('3967','3795S'),('3967','3865'),('3837','3909DRKPUM'),('3939','3837'),('3838','1849S'),('1750A','1290'),('3874','3865'),('3865','1837S'),('3826','7599'),('3826','1859'),('3839','4558BTRMLK'),('3838','1887S'),('3874','1837S'),('3874','1849S'),('3939','3795S'),('3954','3785'),('3826','5'),('3939','3796'),('3826','3483'),('3939','3865'),('3967','10595S'),('3874','3819'),('3954','8751'),('3967','3837'),('3838','1837S'),('3967','1849S'),('3865','5854S'),('3939','3834'),('3954','4558BTRMLK'),('3839','1849S'),('3874','10595S'),('3865','3785'),('3967','1837S'),('3865','4654S'),('3954','5854S'),('9532','2059'),('3939','10595S'),('3834','5854S'),('3939','1849S'),('3954','1837S'),('3967','3819'),('3865','8751'),('3
865','4558BTRMLK'),('3838','3955'),('9532','1290'),('1750A','236'),('3826','3667'),('3838','4479S'),('3954','4654S'),('1750A','176'),('3837','3909ALASOU'),('3967','3834'),('3839','3785'),('3826','25'),('9532','236'),('3834','1849S'),('3967','3796'),('3837','1950S'),('1750A','1195485284390'),('3834','1837S'),('3826'),('3837','3827S'),('3834','8751'),('3834','4654S'));
ERROR:  arguments of row IN must all be row expressions
LINE 1: ...TE FROM public.related WHERE (parent_id,child_id) IN ( ('383...


-- 
Bill McGonigle, Owner
BFC Computing, LLC
http://bfccomputing.com/
Telephone: +1.855.SW.LIBRE
Email, IM, VOIP: bill at bfccomputing.com
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle


More information about the Bucardo-general mailing list