Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 378904 Details for
Bug 513248
net-mail/dbmail-3.1.13 - LMTP daemon fails to connect to PostgreSQL database - dbmail/lmtpd[10204]: Error:[db] db_query(+370): SQLException: ERROR: insert or update on table "dbmail_messages" violates foreign key constraint "dbmail_messages_phys
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Patch to use a reliable connection algorithm
dm_db.patch (text/plain), 881 bytes, created by
David W Noon
on 2014-06-14 21:08:09 UTC
(
hide
)
Description:
Patch to use a reliable connection algorithm
Filename:
MIME Type:
Creator:
David W Noon
Created:
2014-06-14 21:08:09 UTC
Size:
881 bytes
patch
obsolete
>--- src/dm_db.c >+++ src/dm_db.c >@@ -511,16 +511,19 @@ > assert(r); > db_result_next(r); > >- // lastRowId is always zero for pgsql tables without OIDs >- // or possibly for sqlite after calling executeQuery but >- // before calling db_result_next >- >- if ((id = (uint64_t )Connection_lastRowId(c)) == 0) { // mysql >- // but if we're using 'RETURNING id' clauses on inserts >- // or we're using the sqlite backend, we can do this >- >+ if (db_params.db_driver == DM_DRIVER_POSTGRESQL) >+ { >+ id = db_result_get_u64(r, 0); >+ } >+ else >+ { >+ // lastRowId is always zero for pgsql tables without OIDs >+ // or possibly for sqlite after calling executeQuery but >+ // before calling db_result_next >+ > if ((id = (uint64_t )Connection_lastRowId(c)) == 0) // sqlite > id = db_result_get_u64(r, 0); // postgresql >+ id = (uint64_t )Connection_lastRowId(c); > } > assert(id); > return id;
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 513248
:
378898
|
378900
|
378904
|
392812
|
395404
|
395406