Skip site navigation (1) Skip section navigation (2)

Re: cannot insert or update

From: "stephen" <mail(at)xesoftware(dot)com(dot)au>
To: "'Phillip Smith'" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: cannot insert or update
Date: 2007-04-27 00:26:14
Message-ID: 001101c78862$ab2bdea0$6701a8c0@tablet (view raw or flat)
Thread:
Lists: pgsql-novice
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 

In response to

pgsql-novice by date

Next:From: kvnsmnsnDate: 2007-04-27 15:18:59
Subject: removing duplicate entries in a <JOIN> statement
Previous:From: Tom LaneDate: 2007-04-27 00:04:23
Subject: Re: How long does commit take?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group