After looking closer at the logs, what seems to be happening is that it doesn't like the empty array values. All functions that I call with an array that have one or more empty elements are returning this error. Should I be setting the value to NULL instead of just leaving it empty?
Chris
----- Original Message ----- From: "Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 29, 2004 2:35 PM
Subject: malformed array literal in 8beta1
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_customers('{poi2-10000064,poi2,test1,10000064,1,MC,,John,Doe,,,123
abc st,mytown,WA,98101,,[EMAIL PROTECTED],US,XFsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ
AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
,1,4,545454,123 abc st}')
ERROR: malformed array literal: "{poi2-10000064,poi2,test1,10000064,1,MC,,John,Doe,,,123 abc st,mytown,WA,98101,,[EMAIL PROTECTED],US,X
FsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA== ,1,4,545454,123 abc st}" LOG: statement: rollback
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
