Re: [Pypgsql-users] timestamp and mxDateTime

[Karsten H. <Kar...@gm...>]

> There is only one column in that table as it is a "test" for the 
> timestamp type since that is what is giving me trouble. Here is the SQL 
> that created it:
> 
> CREATE TABLE dailylog (
>    enttime        timestamp     -- time entered by the operator
> );
> 
> Which is why the error about "varchar(4)" is puzzling since I have none.
OK

- does it work manually via psql ?
- what happens if you do change the timestamp to varchar(4) ?
- which PG version is this on ?
- did you ever drop/add columns to that table after creation ?
- have you tried on a clean and empty database ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346