X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 29E7DD1C513
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue,  5 Aug 2003 12:53:45 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 03873-09
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Tue,  5 Aug 2003 09:52:29 -0300 (ADT)
Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57])
	by svr1.postgresql.org (Postfix) with ESMTP id CA666D1C4B7
	for <pgsql-interfaces@postgresql.org>;
	Tue,  5 Aug 2003 09:53:32 -0300 (ADT)
Received: from 192.168.0.4 (220-244-72-6.tpgi.com.au [220.244.72.6])
	by mail1.tpgi.com.au (8.11.6/8.11.6) with ESMTP id h75CrUg14499
	(using TLSv1/SSLv3 with cipher RC4-MD5 (128 bits) verified NO);
	Tue, 5 Aug 2003 22:53:31 +1000
From: "Alastair G. Hogge" <agh@tpg.com.au>
To: darcy@PyGreSQL.org, pgsql-interfaces@postgresql.org
Subject: Re: Seeking PyGreSQL help
Date: Tue, 5 Aug 2003 22:53:37 +1000
User-Agent: KMail/1.5.3
References: <200308051816.06256.agh@tpg.com.au>
	<200308052241.10612.agh@tpg.com.au>
	<200308050845.23344.darcy@PyGreSQL.org>
In-Reply-To: <200308050845.23344.darcy@PyGreSQL.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308052253.37438.agh@tpg.com.au>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/17
X-Sequence-Number: 4371

On Tuesday, 05 August 2003 22:45, D'Arcy J.M. Cain wrote:
> On Tuesday 05 August 2003 08:41, Alastair G. Hogge wrote:
> > "db.query("INSERT INTO test VALUES (temp, 'none')")" is the line causing
> > the problem. The internel server error from apache.
>
> What happens when you try doing that line directly into psql?  I don't know
> what your schema for test is but perhaps what you want is this:
>
> db.query("INSERT INTO test VALUES (temp, NULL)")
In pyhton?
temp = "hello"
>>> db.query("INSERT INTO test VALUES (temp, NULL)")
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
_pg.error: ERROR:  Attribute "temp" not found