Re: cannot insert or update

["stephen" <mail(at)xesoftware(dot)com(dot)au>]

I am running the perl dbi module on windows xp as a client and pg 8.2.3 on windows xp for the server.  I can do selects from the client including those concerning schema data but not updates, etc

 

The actual sql being used is:

 

SELECT *  FROM marketlayout

 

which works, but this

 

INSERT INTO marketlayout\nVALUES('07-05-12', 'Leichhardt', 276, 349, 280, 297, 'test case')

 

doesn’t work.

 

 

Stephen Choularton

0413 545 182

02 9999 2226

 

PS Phil – I don’t know anything about the message you are getting.

 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Phillip Smith
Sent: Friday, 27 April 2007 8:48 AM
To: 'stephen'
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] cannot insert or update

 

I can’t offer any advice then, but I’m sure the first question from those who can, will be what version of PG and what platform are you running on?

 

Cheers,

~p

 

-----Original Message-----
From: stephen [mailto:mail(at)xesoftware(dot)com(dot)au]
Sent: Friday, 27 April 2007 08:10
To: phillip(dot)smith(at)weatherbeeta(dot)com(dot)au
Subject: RE: [NOVICE] cannot insert or update

 

I do a select afterwards and they haven’t had any effect.  I am working from a remote computer and the sql works on the server running pg so that is why I thought it might be permissions.

 

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.

Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments