From: | "blay bloo" <blaybloo(at)googlemail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Schema access in PL/PGSQL for custom objects - i.e. type access? |
Date: | 2007-09-21 13:59:58 |
Message-ID: | 66c468170709210659uc8f86eap27bfd62eab0ab4c1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I was wondering how to access the schema of a type in PL/PGSQL
Basically, we've created some custom objects in the database, which
are somewhat similar to database/composite types (i.e. Create type..)-
essentially a named list of name/type pairs.
In PL/PGSQL you can define variables to be custom database types, but
when we try to do it with our custom objects we get:
ERROR: "myet is not a table"
Essentially we just want some way to create a variable (type
instance, or even row) with the appropriate name/type pairs for OUR
objects in PL/PGSQL.
Where would we start looking to 'hack' the code for this - i.e.
how/where in pgsql can i either a) add my object to be recognised as a
'type' or b) make it seem the equivalent to a custom db type
Thanks
BB
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-09-21 14:16:37 | Re: Dynamically adding index types (was GIT indexes) |
Previous Message | Marshall, Steve | 2007-09-21 11:55:24 | Re: PL/TCL Patch to prevent postgres from becoming multithreaded |