Re: Migration - not null default '0' -> not null default 0 - confused - Mailing list pgsql-general

On Tue, 2010-03-30 at 16:32 -0700, Adrian Klaver wrote:
> 8.3 tightened up type casting. You cannot INSERT a '0' without casting it to an
> integer i.e '0'::integer.

I don't think that's accurate:

  postgres=# select version();

version

--------------------------------------------------------------------------------------------------------------------
--
 PostgreSQL 9.0devel on x86_64-unknown-linux-gnu, compiled by GCC
gcc-4.3.real (Ubuntu 4.3.2-1ubuntu12) 4.3.2, 64-bit
(1 row)

  postgres=# create table ints(i int);
  CREATE TABLE
  postgres=# insert into ints values('0');
  INSERT 0 1


Regards,
    Jeff Davis