| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Inability to cast regclass is too restrictive |
| Date: | 2004-10-09 00:25:01 |
| Message-ID: | 1097281501.30202.947.camel@linda |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Release 8.0.0.0beta3
I tried to use regclass() in a plpgsql function to derive a tablename
from its oid so as to build a command string, but I am unable to use the
value returned because it cannot be cast to anything. Therefore I will
have to use a complex query on the catalog to do the same work.
This seems overly restrictive. Would there be a problem in allowing
regclass() to be cast to text?
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Let no man say when he is tempted, I am tempted of
God; for God cannot be tempted with evil, neither
tempteth he any man; But every man is tempted, when he
is drawn away of his own lust, and enticed."
James 1:13,14
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-10-09 00:32:56 | Re: Rollback on Error |
| Previous Message | Sailesh Krishnamurthy | 2004-10-09 00:01:33 | Re: plans for bitmap indexes? |