[imp] horde prefs and pgsql errors

[Jan Schneider]

Zitat von Stephen Grier <s.e.grier@qmul.ac.uk>:

> Would it not be more reasonable for horde to do a select statement on
> the
> horde_prefs table first to see if the value already exists, followed by
> an update
> if it does, or an insert if not? Is there a reason why this would not
> work? I'll
> be making this change to our code if not.

What about using REPLACE INTO? Is that portable across DBMS'?

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft