Re: Cosmetically-varying casts added to view definitions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Cosmetically-varying casts added to view definitions
Date
Msg-id a6444e8b-038c-7009-e50d-5f43991719e6@aklaver.com
Whole thread Raw
In response to Re: Cosmetically-varying casts added to view definitions  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses Re: Cosmetically-varying casts added to view definitions
List pgsql-general
On 07/30/2018 04:29 PM, Ken Tanzer wrote:
> On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver <adrian.klaver@aklaver.com 

> Thanks Adrian.  I do have what are supposed to be the original view 
> definitions, but I'm less than 100% confident they are accurate and 
> up-to-date, which is why I thought to use the actual definitions as 
> stored.  Might have to rethink that one though, or just take a leap of 
> faith that the views will functionally be the same!

Or write a test or tests to verify they are the same.

> 
> Cheers,
> Ken
> 
> p.s.,  I forgot to mention this in my original post, but for the record, 
> PG version 9.6.9.
> -- 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restore relhaspkey in PostgreSQL Version 11 Beta
Next
From: Ken Tanzer
Date:
Subject: Re: Cosmetically-varying casts added to view definitions