Re: [HACKERS] Case sensitivity bug with large objects! - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Case sensitivity bug with large objects!
Date
Msg-id 3f9e8d9377fbb3a03f30a4bab74ac146
Whole thread Raw
List pgsql-hackers
> ...and xinx for the respective index files.
>
> Since pg_ is already a "system" reserved prefix, how about pg_v[oid]
> and pg_x[oid]?  Would kill two birds with one stone...would identify
> them as system tables/indexes while not clashing with user tables.
>
> This would simply the psql queries for the \d commands...would pg_dump
> be able to filter out pg_[xv][0-9]+ tables/indexes?

I think we have this inv* thing worked around for 6.1.  The code now
expects large objects to look like xinv[0-9], which drastically limits
the namespace, and should prevent user-table name collision.

The real answer is to give large objects their own reltype, as Vadim
suggested.


- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------

pgsql-hackers by date:

Previous
From: David Friend
Date:
Subject: [HACKERS] Press release, second draft
Next
From: "Vadim B. Mikheev"
Date:
Subject: [HACKERS] Re: [PORTS] GEQO broken on 6-6-97?!?