Thread: cannot insert or update

cannot insert or update

From
"stephen`"
Date:

I am accessing a database remotely and I can use the select instruction but nothing happens when I use insert or update.  I can use those instructions directly on the computer running  postgresql.

 

I have tired to give public permissions to the table but that didn’t work.

 

Any suggestions?

 

 

Stephen Choularton

0413 545 182

02 9999 2226

 

 

 

Re: cannot insert or update

From
Phillip Smith
Date:
How do you know it's not updating / inserting? What's the exact error message?

Cheers,
~p

On Thu, 2007-04-26 at 17:54 +1000, stephen` wrote:
I am accessing a database remotely and I can use the select instruction but nothing happens when I use insert or update.  I can use those instructions directly on the computer running  postgresql.
I have tired to give public permissions to the table but that didn’t work.

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

Re: cannot insert or update

From
"Phillip Smith"
Date:

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@xesoftware.com.au]
Sent:
Friday, 27 April 2007 08:10
To: phillip.smith@weatherbeeta.com.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

Re: cannot insert or update

From
"Phillip Smith"
Date:

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@xesoftware.com.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.smith@weatherbeeta.com.au]
Sent:
Friday, 27 April 2007 8:48 AM
To: 'stephen'
Cc: pgsql-novice@postgresql.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@xesoftware.com.au]
Sent:
Friday, 27 April 2007 08:10
To: phillip.smith@weatherbeeta.com.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

Re: cannot insert or update

From
"stephen"
Date:

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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Phillip Smith
Sent:
Friday, 27 April 2007 8:48 AM
To: 'stephen'
Cc: pgsql-novice@postgresql.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@xesoftware.com.au]
Sent: Friday, 27 April 2007 08:10
To: phillip.smith@weatherbeeta.com.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