Some changed behavior in 8beta1 bit me here and I'm not sure what it is I am
doing wrong. This works fine on 7.4.
Chris
LOG: statement: select
insert_customer s('{poi2-10000064,poi2,t est1,10000064,1 ,MC,,John,Doe,, ,123
abc
st,mytown,WA,98 101,,ch***@paym entonline.com,U S,XFsWsbpBwQJHN K7z41QMv5bpoOLD efsljIXpaWMLeET b4DmStkfkTl1pQ2 GT9Uxwe2Mip61TL OUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8 IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQk V9FHzOJcdvxDzOC CS
4siOC1Q1wETqhfs 5fe0VCcydzahhgs pRWeyKyboHWq61B 032CW53SD0p3tOT o0JLe+qTRA8EGnr A
Kx6eWXn98wjyHJa 7gGyHNQEJK+tlgk TxZmT7BYtkYGxhP Oqsbj+MsyBDOFw7 vZBXEVAi8TrZ2Nd Q
AvDg6XSJBG9qDa9 S954afLv9L7Z922 bkt55krA==
,1,4,545454,123 abc st}')
ERROR: malformed array literal:
"{poi2-10000064,poi2,t est1,10000064,1 ,MC,,John,Doe,, ,123 abc
st,mytown,WA,98 101,,ch***@paym entonline.com,U S,X
FsWsbpBwQJHNK7z 41QMv5bpoOLDefs ljIXpaWMLeETb4D mStkfkTl1pQ2GT9 Uxwe2Mip61TLOUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8 IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQk V9FHzOJcdvxDzOC CS
4siOC1Q1wETqhfs 5fe0VCcydzahhgs pRWeyKyboHWq61B 032CW53SD0p3tOT o0JLe+qTRA8EGnr A
Kx6eWXn98wjyHJa 7gGyHNQEJK+tlgk TxZmT7BYtkYGxhP Oqsbj+MsyBDOFw7 vZBXEVAi8TrZ2Nd Q
AvDg6XSJBG9qDa9 S954afLv9L7Z922 bkt55krA==
,1,4,545454,123 abc st}"
LOG: statement: rollback
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)