Robert Haas <robertmh...@gmail.com> writes: > On Thu, Sep 17, 2009 at 10:44 AM, Andre Rothe <pho...@gmx.de> wrote: >> 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.
> That sounds annoying, but it's not a PostgreSQL bug. I think the type decoration must be getting injected on the client side, actually. Postgres won't insert that for itself, not even if you explicitly say "default null". Pre-8.3, if you say "default null::varchar" then Postgres will regurgitate it that way (8.3 and up throw the cast away even in that case). But it had to have come from the client initially. So pgsql-jdbc are the folks to talk to. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs