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" <chris@paymentonline.com>
To: <pgsql-general@postgresql.org>
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,,chris@paymentonline.com,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,,chris@paymentonline.com,US,X
> FsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
>
> y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
>
> 4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
>
> Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ
> AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
> ,1,4,545454,123 abc st}"
> LOG: statement: rollback
>