[Bug 265155] QPSQL: Unable to create query (WARNING: nonstandard use of \\ in a string literal)

[Ivan Vasin]

https://bugs.kde.org/show_bug.cgi?id=265155





--- Comment #5 from Ivan Vasin <nisavid gmail com>  2011-02-03 19:01:53 ---
(In reply to comment #4)
> Using an external Postgres server is not supported.

then why is it an option in AkonadiTray?  why is it, in fact, the only option?

are you implying that Akonadi can be configured to run its own postgres
process?

for MySQL, there is a checkbox in AkonadiTray to "Use internal MySQL server",
but there is no such option for PostgreSQL.  simply clearing all of the
settings for the external server and running ``akonadictl start`` triggers an
error, "Cannot connect to PostgreSQL server.", and subsequent related errors.

i don't see anything obvious in $HOME/.config/akonadi/akonadiserverrc that
would indicate a setting to use an internal server.  after clearing external
server settings via AkonadiTray, for my QPSQL section i have:

[QPSQL]
Name=
Host=
User=
Password=
Port=
Options=
ServerPath=/usr/lib/postgresql/8.4/bin/pg_ctl
InitDbPath=/usr/lib/postgresql/8.4/bin/initdb
StartServer=true

> You may add standard_conforming_strings = on to your system postgresql config.

indeed, this resolves the issue.  thanks!

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.