Re: pg_get_viewdef() drops casts, causing broken definitions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_get_viewdef() drops casts, causing broken definitions
Date: 2016-05-14 03:01:54
Message-ID: 32135.1463194914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Christophe Pettus <xof(at)thebuild(dot)com> writes:
> PostgreSQL 9.5.2.

> Summary: The view text returned by pg_get_viewdef() strips some casts, which can result in an error in trying to recreate the view. This means you can't successfully recreate those views from a pg_dump.

Fixed as of 9.5.3.

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1f7c85b820814810f985a270e92cde4c12ceded4

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message cooper.charles.m 2016-05-15 18:37:14 BUG #14138: Inconsistent rounding behavior in float4 coercion
Previous Message David G. Johnston 2016-05-14 03:01:02 Re: pg_get_viewdef() drops casts, causing broken definitions