unqualified function calls in system_views.sql
Do these need to be fixed in backend/catalog/system_views.sql to have
pg_catalog. before everything?
eg.
CREATE VIEW pg_rules AS
SELECT
N.nspname AS schemaname,
C.relname AS tablename,
R.rulename AS rulename,
pg_get_ruledef(R.oid) AS definition
FROM (pg_rewrite R JOIN pg_class C ON (C.oid = R.ev_class))
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE R.rulename != '_RETURN';
Chris
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
Do these need to be fixed in backend/catalog/system_views.sql to have
pg_catalog. before everything?
No, because the references are all resolved when the views are created.
We do have to be cautious about qualifying references that appear within
the bodies of SQL functions declared during initdb.
regards, tom lane