Re: cannot insert or update

Hi Stephen,

Can you please "Reply to All" so the whole list gets your response?

Also, any chance you can stop this somewhat annoying message that we get
when we reply to you? You request we check your website for the "real"
address but your website lists this same address.

We are sorry, but we do not read mail sent to the address that you used

due to the high volume of spam that we receive. Please check our website

for the real address.

Any further messages you send to this address will be automatically

deleted. We apologize for the inconvenience.

Best regards.

-----Original Message-----
From: stephen [mailto:mail(at)xesoftware(dot)com(dot)au]
Sent: Friday, 27 April 2007 09:14
To: 'Phillip Smith'
Subject: RE: [NOVICE] cannot insert or update

Sorry

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

-----Original Message-----
From: Phillip Smith [mailto:phillip(dot)smith(at)weatherbeeta(dot)com(dot)au]
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

*******************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