Re: timestamp and mxDateTime

> 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


-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl