Re: New Talk / Postgres Bug

Awesome Lloyd, nice catch

regards

Robert

On Tuesday, September 18, 2012 11:14:16 am Albin, Lloyd P wrote:
> To All:
>
> I ran across an interesting Postgres Bug that I have tested and found in versions 8.3 through 9.2.
>
> When you change schema and table names that a view references. The view is still viewable with a select statement but if you try and execute the view definition contained within the pg_catalog.pg_views, then it fails. This also affects GUI tools such as PG Admin III, if you view the view definition in PG Admin and just save it without any changes, the save will fail.
>
> I will be adding an upcoming talk about this bug. If you are interested in reading about this bug, you can lookup bug #7553 on the psql-bugs mailing list.
>
> Lloyd
>
>
>
> Lloyd Albin
> Database Programmer
>
> Statistical Center for HIV/AIDS Research and Prevention (SCHARP)
> Vaccine and Infectious Disease Division (VIDD)
> Fred Hutchinson Cancer Research Center (FHCRC)
> 1100 Fairview Ave N., LE-400
> P.O. Box 19024 · Seattle, WA 98109-1024
> 206.667.6477 · 206.667.4812 fax
> Hours: 8:00am-4:30pm (Pacific)
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential, proprietary, and/or privileged information protected by law. If you are not the intended recipient, you may not use, copy, or distribute this e-mail message or its attachments. If you believe you have received this e-mail message in error, please contact the sender by reply e-mail and destroy all copies of the original message.
>
> P Please consider the environment before printing this email.
>
>