Re: Cosmetically-varying casts added to view definitions

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cosmetically-varying casts added to view definitions
Date: 2018-07-30 23:52:10
Message-ID: a6444e8b-038c-7009-e50d-5f43991719e6@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/30/2018 04:29 PM, Ken Tanzer wrote:
> On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2018-07-30 23:57:48 Re: Cosmetically-varying casts added to view definitions
Previous Message David G. Johnston 2018-07-30 23:32:14 Re: Restore relhaspkey in PostgreSQL Version 11 Beta