| From: | "Chris" <chris(at)paymentonline(dot)com> | 
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> | 
| Subject: | malformed array literal in 8beta1 | 
| Date: | 2004-08-29 21:35:13 | 
| Message-ID: | 06aa01c48e10$1192c9b0$0500a8c0@home | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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(at)paymentonline(dot)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(at)paymentonline(dot)com,US,X
FsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkTl1pQ2GT9Uxwe2Mip61TLOUI
        y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
        4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW53SD0p3tOTo0JLe+qTRA8EGnrA
        Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj+MsyBDOFw7vZBXEVAi8TrZ2NdQ
        AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
        ,1,4,545454,123 abc st}"
LOG:  statement: rollback
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-08-29 21:38:45 | Re: Single Row Table? | 
| Previous Message | Bruno Wolff III | 2004-08-29 21:30:44 | Re: Single Row Table? |