Table referenced by OID in a view? - Mailing list pgsql-novice

From Michael Weaver
Subject Table referenced by OID in a view?
Date
Msg-id 3B663B41B350D311AEEF00A0C9254563201A2F@VISION1
Whole thread Raw
Responses Re: Table referenced by OID in a view?
List pgsql-novice

I've got a view that is currently reporting that a table it uses,  with a specific OID, no longer exists.
The table does exist, however it _may_ have been droped and recreated, or coloumns added/removed.

I take it views reference tables not by the table name but by OID?

MIKE WEAVER
Software Developer


5, 42 Ladner Street
O'Connor, WA, 6163

All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832

P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0419 299 170
W:
http://www.corpusglobe.com/
E:
mweaver@corpusglobe.com

This email is intended only for the use of the individual or entity named above and may contain information that is confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this email is strictly prohibited. When addressed to our clients, any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing Corpus Globe client engagement letter. If you have received this Email in error, please notify us immediately by return email or telephone +61 8 9331 2700 and destroy the original message. Thank You.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: The pg_hba.conf file
Next
From: "etsuko shimabukuro"
Date:
Subject: Which DBD/DBI drivers for postgres 7.2.1 ?