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

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 this.

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

Dates, postgresql and pygresql

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

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 error