On Tue, 27 Jan 1998, Oliver Elphick wrote:
The message you are getting appears to be a PostgreSQL message, but the
syntax you are using works OK in psql. Is it possible that Python is
mangling the data being sent to the backend? Can you run a debugger to
check what is happening?
I am
Johann Spies wrote:
On Tue, 27 Jan 1998, Oliver Elphick wrote:
Try running the postmaster in the foreground and have the backend echo
queries, to check what requests the backend is seeing.
I also do not know how to do this. I will have to study some more
documentation to do this.
Thank you for everyone who responded to my message.
The problem was an empty date field. I had to change the empty date
fields to something like '01/01/0001'.
Johann
Johann Spies
[EMAIL PROTECTED]
Windsorlaan 19
Pietermaritzburg
3201
Suid
When I want to write a date to a postgres table in the following query
(using python and pygresql)
INSERT INTO lidmate VALUES (3157,864,'ACKERMAN','MARTHINUS THEODORUS','MNR',
'','ACKERMAN','','O','M','B','','','17/06/1997','19/08/1997')
the following error message occurs:
Traceback
Johann Spies wrote:
When I want to write a date to a postgres table in the following query
(using python and pygresql)
INSERT INTO lidmate VALUES (3157,864,'ACKERMAN','MARTHINUS THEODORUS','MNR',
'','ACKERMAN','','O','M','B','','','17/06/1997','19/08/1997')
the following error
5 matches
Mail list logo