Re: User Defined Types in Java

From: Thomas Hallgren <thomas(at)tada(dot)se>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: User Defined Types in Java
Date: 2006-02-09 17:54:07
Message-ID: 43EB81BF.3060107@tada.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
>> On Thu, Feb 09, 2006 at 09:33:35AM -0500, Tom Lane wrote:
>>> You'd have to go over a lot of code with a fine-tooth comb before
>>> putting this ability into the hands of ordinary users, else you'd be
>>> creating loopholes for DOS attacks (or worse).
>
>> Would it be reasonable to set this up so you can only create a shell
>> type within an explicit transaction and that you are required to define
>> the type completely before commit.
>
> I don't see any very easy way to enforce that, and it would break
> existing datatype-definition scripts if we did.
>

What do you think of my earlier suggestion. Skip all the 'create function' statements and
just add the "AS 'filename' LANGUAGE C" to the CREATE TYPE. It could be implemented while
maintaining backward compatibility I think?

Regards,
Thomas Hallgren

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-02-09 18:08:28 Re: pg_hba.conf alternative
Previous Message Tom Lane 2006-02-09 17:28:45 Re: User Defined Types in Java