Skip site navigation (1) Skip section navigation (2)

Re: Wrong column default values

From: Andre Rothe <phosco(at)gmx(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Wrong column default values
Date: 2009-09-19 18:07:12
Message-ID: c905e559-5a4f-48ee-9e6a-04b61fbddeca@o21g2000vbl.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
That's my own tool, I simply ask the DatabaseMetaData.getColumns()
for the structure of the table and I read the value from COLUMN_DEF
column of the result set.
So it seems, that this is a problem of the JDBC driver. I would never
await an annotation as part of the default value...

Andre

On Sep 18, 10:15 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> I'm thinking that this has less to do with what the server thinks
> and more to do with whatever tool the OP is using to examine the
> table ...

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2009-09-19 18:45:09
Subject: Re: Wrong column default values
Previous:From: Andre RotheDate: 2009-09-19 18:00:01
Subject: Re: Wrong column default values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group