Re: Dates, postgresql and pygresql

1998-01-28 Thread Johann Spies
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 Afrika

Re: Dates, postgresql and pygresql

1998-01-28 Thread Oliver Elphick
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

Re: Dates, postgresql and pygresql

1998-01-28 Thread Johann Spies
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 ine

Re: Dates, postgresql and pygresql

1998-01-27 Thread Oliver Elphick
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