Re: defaut value '1' in smallint column is a string value '1' inpgsql >= 9.5

I see you have posted three bug reports related to PDO but the Postgres
community has no idea how your report relates to a bug in Postgres.

---------------------------------------------------------------------------

On Fri, Dec  1, 2017 at 12:36:48PM +0300, Bogdan Stepanenko wrote:
> related
> https://github.com/yiisoft/yii2/issues/15247
> https://github.com/yiisoft/yii2/issues/15254
> 
> 1. create table with
> 
> CREATE TABLE "type" (
>   int_col integer NOT NULL,
>   int_col2 integer DEFAULT '1',
>   smallint_col smallint DEFAULT '1',
>   char_col char(100) NOT NULL,
>   char_col2 varchar(100) DEFAULT 'something',
>   char_col3 text,
>   float_col double precision NOT NULL,
>   float_col2 double precision DEFAULT '1.23',
>   blob_col bytea,
>   numeric_col decimal(5,2) DEFAULT '33.22',
>   time timestamp NOT NULL DEFAULT '2002-01-01 00:00:00',
>   bool_col boolean NOT NULL,
>   bool_col2 boolean DEFAULT TRUE,
>   ts_default TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
>   bit_col BIT(8) NOT NULL DEFAULT B'10000010',
>   bigint_col BIGINT
> );
> 
> 2. Get declaration of `types` from the information schema throw PDO
> 3. Get data about `smallint_col`
> Result: Default value of `smalint_col` is a raw string '1', not convert to int
> 1
> 
> I try with this versions (official docker images like `image: postgres:9.4`):
> 9.4 is convert string to int.
> 9.5 and 10.1 is not convert string to int.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +