aboutsummaryrefslogtreecommitdiff
path: root/src/datastore/plugin_datastore_postgres.c
Commit message (Collapse)AuthorAge
* postgres: drop use of 'WITH OIDS'Daniel Golle2020-10-05
| | | | | | | | | | | | | | | | | | | | | | PostgreSQL since version 12 no longer supports 'WITH OIDS': Previously, a normally-invisible oid column could be specified during table creation using WITH OIDS; that ability has been removed. Columns can still be explicitly declared as type oid. Operations on tables that have columns created using WITH OIDS will need adjustment. The system catalogs that previously had hidden oid columns now have ordinary oid columns. Hence, SELECT * will now output those columns, whereas previously they would be displayed only if selected explicitly. Drop 'WITH OIDS' as it was stated even on tables for plugins which didn't make any use of the then exposed 'oid' column. In the case of datacache and datastore the 'oid' column is used, so replace the 'WITH OIDS' statement with an explicit 'oid' column having 'OID' type and a corresponding sequence. No measures are taken to still work with PostgreSQL before version 12. Users should update PostgreSQL to version 12 or newer. Signed-off-by: Daniel Golle <daniel@makrotopia.org>
* modify GNUNET_PQ_connect_with_cfg to enable flexible loading of .sql filesChristian Grothoff2020-01-24
|
* tighten formatting rulesChristian Grothoff2019-10-31
|
* libgnunetpq API change to fix #5733Christian Grothoff2019-10-11
|
* global reindent, now with uncrustify hook enabledChristian Grothoff2019-10-05
|
* uncrustify as demanded.ng02019-09-08
|
* fix possibility of NULL result for empty databaseChristian Grothoff2019-02-19
|
* src: for every AGPL3.0 file, add SPDX identifier.ng02019-01-14
|
* paragraph for gnunet devs that don't know how to use the webpsyc://loupsycedyglgamf.onion/~lynX2018-06-07
|
* glitch in the license text detected by hyazinthe, thank you!psyc://loupsycedyglgamf.onion/~lynX2018-06-07
|
* better indentation, nicer formatting of SQLChristian Grothoff2018-06-06
|
* first batch of license fixes (boring)psyc://loupsycedyglgamf.onion/~lynX2018-06-05
|
* rename GNUNET_PQ_QueryStatus to GNUNET_DB_QueryStatusChristian Grothoff2017-06-11
|
* finish datastore pq refactoringChristian Grothoff2017-06-04
|
* more pq workChristian Grothoff2017-06-03
|
* adding more good helpers to libgnunetpqChristian Grothoff2017-06-01
|
* [datastore] Create remove plugin API callDavid Barksdale2017-04-16
| | | | | | The only use of vhash in the get_key call was for removing, split that out into its own function. This simplifies the get_key call and removes the need for some indexes, speeding up insertion into the database.
* [datastore] Combine put and update plugin APIsDavid Barksdale2017-04-16
| | | | This resolves issue #4965.
* [datastore] Return and update replicationDavid Barksdale2017-03-22
| | | | | | This fixes a couple FIXMEs in the datastore code. The replication value is now returned from the datastore and the update function can increase the replication.
* [datastore] Fix #3743David Barksdale2017-03-19
| | | | | | | | | | | | | | | | | | | | This change adds support for key == NULL to the datastore plugins and replaces the offset argument with a next_uid and random arguments to increase performance in the key == NULL case. With the offset argument a datastore plugin would have to count all matching keys before fetching the key at the right offset, which would iterate over the entire database in the case of key == NULL. The offset argument was used in two ways: to iterate over a set of matching values and to start iteration at a random matching value. The new API seperates these into two arguments: if random is true it will return a random matching value, otherwise next_uid can be set to uid + 1 to return the next matching value. The random argument was not added to get_zero_anonymity. This function is used to periodically insert zero anonymity values into the DHT. I don't think it's necessary to randomize this.
* we use CREATE INDEX IF NOT EXITS, this requires postgres>=9.6, bump ↵Christian Grothoff2017-03-09
| | | | dependency requirements
* Restrict update to positive priority deltasDavid Barksdale2017-02-20
| | | | | This is only ever called with positive values and the mysql and postgres plugins were not handling negative values correctly anyway.
* datastore: postgres: use IF NOT EXISTS to avoid error messagesDaniel Golle2016-10-13
|
* -avoid calling memcpy() with NULL argument, even if len is 0Christian Grothoff2016-07-08
|
* -bugfix, adding comments, fixing indentChristian Grothoff2016-03-14
|
* make some more use of libgnunetpqChristian Grothoff2016-02-06
|
* -fix (C) noticesChristian Grothoff2016-01-19
|
* fix #3869: outdated FSF addressChristian Grothoff2015-06-30
|
* Convert datastore plugin API to asynchronousDavid Barksdale2015-03-21
|
* -bringing copyright tags up to FSF standardChristian Grothoff2015-02-07
|
* Workaround emscripten bug in returning int64_tDavid Barksdale2015-01-06
| | | | | Emscripten can't return a 64-bit integer from dynamically loaded code.
* Include libpq-fe.h instead of postgres/libpq-fe.h.Sree Harsha Totakura2014-08-08
| | | | | Also add a macro for checking libpq from Autoconf macro archives.
* -doxygenChristian Grothoff2014-06-08
|
* malloc -> newLRN2013-12-19
|
* -remove trailing whitespaceChristian Grothoff2013-10-06
|
* changing time measurement from milliseconds to microsecondsChristian Grothoff2013-08-11
|
* -consistently use struct GNUNET_HashCodeChristian Grothoff2012-06-12
|
* -fixChristian Grothoff2012-04-02
|
* -removing legacy #ifdefsChristian Grothoff2012-04-01
|
* -doxygenChristian Grothoff2012-03-23
|
* -check return codeChristian Grothoff2012-03-23
|
* adding libgnunetpostgres for shared postgres functionality between postgres ↵Christian Grothoff2012-03-22
| | | | datastore/datacache backends
* -docsChristian Grothoff2012-03-22
|
* -implementing get_keys for postgresChristian Grothoff2011-12-17
|
* LRN: Use GNUNET_EXTRA_LOGGING to manage compile-time logging callsChristian Grothoff2011-10-04
| | | | | | (#1805).
* doxygenChristian Grothoff2011-09-02
|
* run indent twice, it alternates between two 'canonical' forms, also run ↵Christian Grothoff2011-08-29
| | | | whitespace remover
* indentationChristian Grothoff2011-08-15
|
* indentationChristian Grothoff2011-08-15
|
* use postgres PRNG also on insertionChristian Grothoff2011-08-02
|
generated by cgit v1.2.3 (git 2.39.1) at 2024-05-13 23:06:51 +0000