malformed array literal in 8beta1

Chris

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,,ch***@paymentonline.com,US,XFs WsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkfkT l1pQ2GT9Uxwe2Mip61TLOUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW 53SD0p3tOTo0JLe+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,,ch***@paymentonline.com,US,X
FsWsbpBwQJHNK7z41QMv5bpoOLDefsljIXpaWMLeETb4DmStkf kTl1pQ2GT9Uxwe2Mip61TLOUI
y8iFwEQV7/Jz3eqvhbwAe6Bc8IQqmQOm84/rPRYRxWZ/SGhc014P7luhSQkV9FHzOJcdvxDzOCCS
4siOC1Q1wETqhfs5fe0VCcydzahhgspRWeyKyboHWq61B032CW 53SD0p3tOTo0JLe+qTRA8EGnrA
Kx6eWXn98wjyHJa7gGyHNQEJK+tlgkTxZmT7BYtkYGxhPOqsbj +MsyBDOFw7vZBXEVAi8TrZ2NdQ
AvDg6XSJBG9qDa9S954afLv9L7Z922bkt55krA==
,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 YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1

Subscribe Post Reply

1412

Similar topics

Changing an array value to upper case?

by: Mike S. Nowostawsky | last post by:

I tried using the "toUpperCase()" property to change the value of an array entity to uppercase BUT it tells me that the property is invalid. It seems that an array is not considered an object when...

Javascript

Reassigning array to string literal

by: songkv | last post by:

Hi, I am trying to reassign an array of char to a string literal by calling a function. In the function I use pointer-to-pointer since I want to reassign the "string array pointer" to the string...

C / C++

walking through an array of char pointers

by: gaga | last post by:

I can't seem to get this to work: #include <stdio.h> #include <stdlib.h> #include <string.h> int main() { char *names; char **np;

C / C++

Array assignment via cast

by: James Mcguire | last post by:

Hi, I frequently do non-initialisation type structure assignment via casting: e.g. struct s{int i,j,k;} mys; .... mys=(struct s){3,4,5};

C / C++

dump/restore from 7.4.3linux to 8beta1 win32

by: Josué Maldonado | last post by:

I did the pg_dump with the Linux 7.4.3 version and tried to pg_restore with Win32 8beta1 version and I got: C:\TEMP>pg_restore -d desarrollo -i -U postgres xdump pg_restore: input file does not...

PostgreSQL Database

is the object literal form the same as an array?

by: Jake Barnes | last post by:

I was just reading this article on Ajaxian: http://ajaxian.com/archives/show-love-to-the-object-literal This is a newbie question, but what is the object literal? I thought it was like an...

Javascript

Is array notation special?

by: Sam Kong | last post by:

Hello! My question would not be very practical but just out of curiosity. In JavaScript, Array is a subclass of Object. Well maybe not exactly... but sort of... For normal objects, you can...

Javascript

Malformed Header from script. Bad header.

by: Shalako | last post by:

I check my error log and see these entries: malformed header from script. Bad header= Missing gauge reports are ind: padata.pl /perl/pema/padata.pl did not send an HTTP header malformed...

Apache Web Server

152

multi dimensional arrays as one dimension array

by: vippstar | last post by:

The subject might be misleading. Regardless, is this code valid: #include <stdio.h> void f(double *p, size_t size) { while(size--) printf("%f\n", *p++); } int main(void) { double array = { {...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice