Re: [GENERAL] PostgreSQL + Hibernate, Apache Mod Security, SQL Injection and you (a love story)

ation instead of parameterized queries, then you can encounter the same injection problems like SQL. -- Best Regards / Viele Grüße Sebastian Hennebrueder - Software Developer and Trainer for Hibernate / Java Persistence http://www.laliluna.de -- Sent via pgsql-general mailing list (pgsql-g

[GENERAL] Asyncron replication from wan to lan with PostgreSQL 8

a local application selecting the data for the ids and updating the data in the local database Are there any other solutions than doing the syncronisation manually? -- Kind Regards / Viele Grüße Sebastian Hennebrueder - http://www.laliluna.de/tutorials.html Tutorials for Java, Struts

[GENERAL] Technical FAQ collecting of infos from the mailing list

this, I am having a question. Do you see in this collecting, rewriting and structuring of mailing list information a misuse or a copyright infringement or just would you prefer that something like this does not happen? -- Best Regards / Viele Grüße Sebastian Hennebrueder http

Re: [GENERAL] Generating random values.

not > match > > > > Create an array of characters and numbers. Estimating the array size at 30 Calculate something like round(random * 30) and fetch a character from the array. Repeat this for each character -- Best Regards / Viele Grüße Sebastian Hennebrueder http:

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

losing connections or if you can create an connection pool. Use select * from pg_stat_activity to see wheach connections are open from which client and if they are iddle or not. See the postgreSQL doc for more information on these queries. - -- Best Regards / Viele Grüße Sebastian Hennebruede

Re: [GENERAL] Schema design question

Bill Moseley schrieb: >On Wed, Aug 17, 2005 at 10:05:39PM +0200, Sebastian Hennebrueder wrote: > > >>> Con: Column duplication in the two tables -- two tables look a lot alike >>> Need to have duplicate link tables (one pointing to each table) >>&g

[GENERAL] Exception in Query when mixing explicit join and implicit join

is: ERROR: relation a does not exist It happens when a implicit join and a inner join is mixed. Do I have to except this as a fact or is there a logical explication for this behaviour. -- Best Regards / Viele Grüße Sebastian Hennebrueder http://www.laliluna.de Tutorials for JSP

Re: [GENERAL] Exception in Query when mixing explicit join and implicit

Tom Lane schrieb: >Sebastian Hennebrueder <[EMAIL PROTECTED]> writes: > > >>-- the following query has a inner join and an implicit join and does >>not work. >>select a.name as act_name, >>u.name as trainer >>from >>activity a, >

Re: [GENERAL] FAQ/Documentation about Postgresql on Windows XP

tion that can help me >figure out how to set up and use Postgresql on a local, stand alone, >Windows XP machine? > >Thanks in Advance, >Adam > > >---(end of broadcast)--- >TIP 6: explain analyze is your friend >

Re: [GENERAL] Debug plpgSQL stored procedures

when valid code was not debugged. In generally it seems to work. You should test it with your code carefully. -- Best Regards / Viele Grüße Sebastian Hennebrueder http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB ---(end of bro

Re: [GENERAL] Replicating databases

-- Best Regards / Viele Grüße Sebastian Hennebrueder http://www.laliluna.de * Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB * Seminars and Education at very fair prices. * Get professional support and consulting for these technologies. --