New Talk / Postgres Bug

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.