> -----Original Message-----
> From: Hiroshi Saito [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 06:58
> To: Hiroshi Saito
> Cc: [EMAIL PROTECTED]; Dave Page
> Subject: Re: [pgadmin-hackers] SystemObject show patch more.
>
>
> Hi Andreas.
>
> One more.
> pgLanguage patch.
>
> Check it.
>
Hi Hiroshi,
I beleive the SQL changes you have made are incorrect. The validator is
optional (not the handler) so should use the left outer join, and we
want lanispl = TRUE to get only user defined procedural languages. In
actual fact, I think that's best removed altogether, and SystemObject =
(lanispl == FALSE); so that with SystemObjects on, we see SQL & C etc.
What do you think?
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
