Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Joe Conway <joe(at)conway-family(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal
Date: 2001-06-08 04:06:05
Message-ID: 8865.991973165@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Since these functions will primarily be used in building a sort of
> information schema and for querying system catalogs, we should use the
> approach that is or will be used there: character type values contain the
> table name already case-adjusted.

Weren't you just arguing that such cases could/should use the OID, not
the name at all? ISTM the name-based variants will primarily be used
for user-entered names, and in that case the user can reasonably expect
that a name will be interpreted the same way as if he'd written it out
in a query.

The nextval approach is ugly, I'll grant you, but it's also functional.
We got complaints about nextval before we put that in; we get lots
fewer now.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Pritchard 2001-06-08 04:35:31 PostgreSQL and replication
Previous Message James Buchanan 2001-06-08 01:28:27 Re: place for newbie postgresql hackers to work

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-08 16:09:50 Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal
Previous Message Peter Eisentraut 2001-06-07 14:16:33 Re: Re: [PATCHES] Fw: Isn't pg_statistic a security hole - Solution Proposal