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 119d5ad95d7f70759afaf0ee6bf25f16
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: Igor
Date:
Subject: Re: [HACKERS] packetBuf size
Next
From: Bruce Momjian
Date:
Subject: [HACKERS] TODO list