-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 19, 2002 6:40 PM
To: Joel Burton
Cc: Joe Conway; Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
Joel Burton [EMAIL PROTECTED] writes
Joel Burton [EMAIL PROTECTED] writes:
Well, sort of, but if we had been promoting a function tableoid(text)
returns oid, we wouldn't have to make any change for the move to regclass,
would we? I mean, it's specific to PG, but a simple wrapper might outlive
the next under-the-hood change.
I
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 1:33 PM
To: Joel Burton
Cc: Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
At the moment regclass conversion raises an error
Joel Burton [EMAIL PROTECTED] writes:
At the moment regclass conversion raises an error if the item isn't
found; this follows the historical behavior of regproc. We could
possibly have it return 0 (InvalidOid) instead, but I'm not convinced
that that's better. In the case of regproc, not
I'm writing a function that accepts a table name and digs some information
out about it. I'm developing on 7.3cvs w/schemas, and wanted my function to
use schemas.
If the user gives a full schema name (s.table), I find the table in pg_class
by comparing the ns oid and relname.
However, if the
Joel Burton wrote:
Is there a function already in the backend to return a class oid, given a
name, by looking up the table in the current_schemas path? Would it make
sense for us to expose this, or write one, so that this small wheel doesn't
have to be re-invented everytime someone wants to
-Original Message-
From: Joe Conway [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 19, 2002 5:25 PM
To: Joel Burton
Cc: Pgsql-Hackers@Postgresql. Org
Subject: Re: [HACKERS] Exposed function to find table in schema search
list?
Joel Burton wrote:
Is there a function already
Joel Burton [EMAIL PROTECTED] writes:
Is the use of regclass going to prove to be very
implementation-specific?
Sure, but so would any other API for it.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9'