| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>, pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support which sets these values |
| Date: | 2005-05-26 22:30:39 |
| Message-ID: | 200505270030.41028.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-patches |
Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Does Oracle support GET DIAGNOSTICS? If so, couldn't we just use
> > that? I can't see what good will become of making any slightly
> > useful information become available as magic variables of some
> > kind.
>
> Oracle actually defines these things as parameterless functions that
> are called without parentheses (like CURRENT_USER). "Magic
> variables" are about as close as we can get to matching that.
What I was aiming for is this: If Oracle supported GET DIAGNOSTICS, then
we could ask people to switch to that instead of using the magic
variables and they'd still have code that works both ways.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Andrewd | 2005-05-27 00:49:22 | pgbuildfarm - client-code: experimantal code to enable vpath builds - |
| Previous Message | Tom Lane | 2005-05-26 20:05:03 | pgsql: Document that utility commands such as DROP FUNCTION allow |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-05-26 23:14:37 | Re: Implement support for TCP_KEEPCNT, TCP_KEEPIDLE, TCP_KEEPINTVL |
| Previous Message | ￥９８００ねっと | 2005-05-26 19:50:38 | L@VDVDIwV[YxDVDI |