Re: [GENERAL] plpgsql and prep statements (performance and sql injection)

2011-07-06 Thread Pavel Stehule
Hello there is not reason for using PP from plpgsql. PostgreSQL's prepared statement are limited by session too. Regards Pavel Stehule 2011/7/6 Wim Bertels : > Hallo, > > good reasons to use prep statements > seem > - performance > - some sql injection defence > > but when i look at plpgsql > h

[GENERAL] plpgsql and prep statements (performance and sql injection)

2011-07-06 Thread Wim Bertels
Hallo, good reasons to use prep statements seem - performance - some sql injection defence but when i look at plpgsql http://www.postgresql.org/docs/8.4/interactive/plpgsql-implementation.html i see that sql statements are translated into prep statements, and live (the plan) as long the db conne