Re: [BUGS] Wrong default values of columns

2009-09-17 Thread Andre Rothe
The problem is, that I get the default values from a metadata query with JDBC, so I have to parse every return value for such an annotation before I can use them. So it seems that I could change the jdbc driver to a newer version. I use the PostgreSQL 8.1 JDBC3 with SSL (build 407). Thanks Andre

[BUGS] Wrong default values of columns

2009-09-17 Thread Andre Rothe
Hi, I have installed Postgres 8.3.8 on Fedora Linux. If I create a table, the default values will be set by the database to NULL::timestamp without time zone for a timezone column and to NULL::character varying for a varchar column. How I can prevent such a behaviour? Both column defaults shou