Re: Cosmetically-varying casts added to view definitions

2018-07-30 Thread Adrian Klaver
On 07/30/2018 04:57 PM, Ken Tanzer wrote: On Mon, Jul 30, 2018 at 4:52 PM Adrian Klaver > wrote: On 07/30/2018 04:29 PM, Ken Tanzer wrote: > On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver mailto:adrian.kla...@aklaver.com> > Thanks Adrian.  I do

Re: Cosmetically-varying casts added to view definitions

2018-07-30 Thread Ken Tanzer
On Mon, Jul 30, 2018 at 4:52 PM Adrian Klaver wrote: > On 07/30/2018 04:29 PM, Ken Tanzer wrote: > > On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver > > 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 > > u

Re: Cosmetically-varying casts added to view definitions

2018-07-30 Thread Adrian Klaver
On 07/30/2018 04:29 PM, Ken Tanzer wrote: On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver 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 s

Re: Cosmetically-varying casts added to view definitions

2018-07-30 Thread Ken Tanzer
On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver wrote: > On 07/30/2018 02:26 PM, Ken Tanzer wrote: > > > This doesn't impair the view's functionality, so I can't necessarily > > complain. But it does make it harder for me to know if the views were > > recreated correctly. I'd be curious to know w

Re: Cosmetically-varying casts added to view definitions

2018-07-30 Thread Adrian Klaver
On 07/30/2018 02:26 PM, Ken Tanzer wrote: Hi.  As background/context, I'm working on a script to take a series of databases and make them timezone-aware.  This basically involves saving all the view definitions, dropping all the views, changing all the timestamp columns without time zones to TS

Cosmetically-varying casts added to view definitions

2018-07-30 Thread Ken Tanzer
Hi. As background/context, I'm working on a script to take a series of databases and make them timezone-aware. This basically involves saving all the view definitions, dropping all the views, changing all the timestamp columns without time zones to TS with TZ, and then recreating all the views.