Re: is there anyway to get the backends IP address from - Mailing list pgsql-general

From Bruce Momjian
Subject Re: is there anyway to get the backends IP address from
Date
Msg-id 200502211547.j1LFlZP27084@candle.pha.pa.us
Whole thread Raw
In response to Re: is there anyway to get the backends IP address from  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tony Caduto wrote:
> Bruce,
> On another note, is there plans to improve the type checking of stored
> functions during the save/compile?
> Currently I can pretty much make tons of mistakes (on purpose of course
> :-) and they are not flagged as errors until runtime.
> The biggest complaint I see from other DBAs (MS SQL, Oracle) is that
> Postgres does little to no pre-runtime type checking.

We have no plans to improve that.  We do have 'check_function_bodies'
which defaults to true and does some checking.  Would you give us a
particular example you would like improved?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Geoffrey KRETZ
Date:
Subject: Re: PGS 7.2 : Insert with wrong number of values did not
Next
From: "Magnus Hagander"
Date:
Subject: Re: Deadlock and FK triggers