Re: lastval exposes information that currval does not - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: lastval exposes information that currval does not
Date
Msg-id 20060710214817.GA17269@kenobi.snowman.net
Whole thread Raw
In response to Re: lastval exposes information that currval does not  (Phil Frost <indigo@bitglue.com>)
List pgsql-hackers
* Phil Frost (indigo@bitglue.com) wrote:
> I haven't found a way to do this yet, but I wouldn't be suprised if
> there is a clever way, especially considering C extensions that might
> come from contrib or other sources. It seems like there is a good deal
> of potential for non-malicious developers to open unknowingly serious
> security holes. I think lastval is a great example of this potential;
> fortunately sequence values are rarely compromising. Imagine the
> consequences of a function which returns the last inserted row in a
> similar manner.

Yes, you can compromise the security of the system by loading C modules.
That's not going to change.  If you find examples of such compromises in
core, or in contrib, please bring them to our attention.  As for from
other sources, well, you'd have to bring it up with that source..
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Tzahi Fadida
Date:
Subject: Re: CTIDs invalidations and dropping columns.
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql-patches considered harmful