On Jan 21, 2010, at 10:06 AM, Tom Lane wrote:
> Well, without a context that explains *why* you're doing that, it's hard
> to consider what a better solution would look like. Personally I
> usually prefer solutions involving WHERE oid = 'foo.bar'::regclass,
> because that scales easily to either
"David E. Wheeler" writes:
> The names of schemas in which to find functions, tables, views, triggers,
> etc. etc. I have lots of stuff like this:
> SELECT true
> FROM pg_catalog.pg_namespace n
> JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
> WHERE c.
On Jan 21, 2010, at 11:56 AM, Tom Lane wrote:
David Christensen writes:
Enclosed is a patch adding a 'regschema' OID type.
What in the world is the point of that? The regfoo types are for
things
that have schema-qualified names.
Perhaps the naming is a bit disingenuous, and I'm not ti
On Jan 21, 2010, at 9:57 AM, Tom Lane wrote:
> Schema names of what? It sounds to me like you're failing to use the
> existing regfoo types in appropriate places ...
The names of schemas in which to find functions, tables, views, triggers, etc.
etc. I have lots of stuff like this:
SELE
"David E. Wheeler" writes:
> OOh, /me likey! This would save me a ton of code in pgTAP (about half its
> queries have to join to pg_namespace to get schema names).
Schema names of what? It sounds to me like you're failing to use the
existing regfoo types in appropriate places ...
David Christensen writes:
> Enclosed is a patch adding a 'regschema' OID type.
What in the world is the point of that? The regfoo types are for things
that have schema-qualified names.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.o
On Jan 21, 2010, at 9:46 AM, David Christensen wrote:
> It uses the same quoting mechanism as regclass, and I've tested against some
> odd schema names such as "foo""schema"; I updated the docs as I was able, but
> am not familiar enough with the regression tests to add those yet. I hope to
>
Hey -hackers,
Enclosed is a patch adding a 'regschema' OID type. I'm really just
hoping to get this out there, don't worry about committing it at this
point. This is something that I've always wanted in the field (yes,
I'm lazy). Many thanks to RhodiumToad for pointers about the
necess
