Re: bug report: slow getColumnTypeName

I agree, my only doubt is about the reasons behind the change, the driver was reporting int4, int8, and then was changed, why?

Luis Flores

On 12/10/2012, at 08:04, Craig Ringer  wrote:

> On 10/12/2012 02:33 PM, Thomas Kellerer wrote:
> 
>> When looking at a CREATE TABLE statement in a SQL tool, users expect to
>> see "serial" there if the table was created that way.
> 
> Applications can check the metadata and make any transformations they want for display. The fact remains that the data type is "integer" or "biginteger".
> 
> JDBC isn't for the "end user", it's an API for developers, much like libpq.
> 
> I maintain that presenting "serial" or "bigserial" as a *type* is just plain wrong. If nothing else:
> 
> regress=# create table blah ( id serial primary key );
> CREATE TABLE
> regress=# PREPARE insert_blah(serial) AS INSERT INTO blah(id)
> regress-# VALUES ($1);
> ERROR:  type "serial" does not exist
> LINE 1: PREPARE insert_blah(serial) AS INSERT INTO blah(id) VALUES (...
> 
> Also:
> 
> regress=# SELECT '1'::serial;
> ERROR:  type "serial" does not exist
> LINE 1: SELECT '1'::serial;
> 
> Seriously, reporting the type as "serial" is just plain wrong.
> 
> --
> Craig Ringer
> 
> 
> 
> -- 
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc