summaryrefslogtreecommitdiff
path: root/sql/pgq/functions
AgeCommit message (Collapse)Author
2014-11-05v3.2.6martinko
2014-11-05fixed subscriber_info_watermark_name_fkey violationmartinko
2014-10-06bumping up schemata's versions in preparation for upcoming releasemartinko
2014-08-05pgq: clean up pgq.consumer when consumer is unregisteredmartinko
The goal is to leave no "garbage" that accumulates over time.
2014-04-01bumped up version to 3.2martinko
let's get trendy ... it's no good to be stuck on same minor version for so long ;-) and it actually did not make sense ... quite a few important features appeared
2014-02-20bumping up versions in preparation for upcoming releasemartinko
2013-08-18sql/pgq: fix retry-queue vs. newgrantsMarko Kreen
2012-11-29Bump pgq schema ver to 3.1.3Marko Kreen
2012-11-27pgq.unregister_consumer: don't unregister all subconsumers in subscription ↵Petr Jelinek
when subconsumer was given on input
2012-11-02Bump pgq schema version to 3.1.2Marko Kreen
2012-11-02pgq: quote internal table namesMarko Kreen
Quoting was not done previosly as the table names come not from user input but from internal tables. But understanding whether it's safe in particular setup requires extra thinking which is not good. So to remove the need for thinking, lets quote everything properly.
2012-09-19Support for extensions upgradeMarko Kreen
Needed for pgq & pgq_coop that have changed. Also move more common code to common-pgxs.mk
2012-07-19Bump schema versions.Marko Kreen
Everything is 3.1.0.0 now.
2012-07-09pgq.maint_operations: include londiste.periodic_maintenanceMarko Kreen
2012-06-15pgq.maint_rotate_tables: check txid sanity, fail if badMarko Kreen
2012-05-10pgq.version(): 3.0.0.15Marko Kreen
2012-05-10Group-access roles for SQL functions (draft)Marko Kreen
This is attempt for fine-grained access rights for all Skytools SQL schemas. As it still needs review, the rights are not activated by default, instead following sql files are generated: newgrants_<schema>.sql - applies new rights, drop old public access oldgrants_<schema>.sql - restores old rights - public execute privilege to all functions Only thing that is active by default is creation of new groups in upgrade functions. New access roles: pgq_reader Can consume queues (source-side) pgq_writer Can write into queues (source-side / dest-side) Can use pgq_node/pgq_ext schema as regular consumer (dest-side) pgq_admin Admin operations on queues, required for CascadedWorker on dest-side. Member of pgq_reader and pgq_writer. londiste_reader Member of pgq_reader, needs additional read access to tables. (source-side) londiste_writer Member of pgq_admin, needs additional write access to tables. (dest-side)
2012-05-02pgq.insert_event(): outer wrapper does not need to be secdefMarko Kreen
2012-04-18pgq.version(): 3.0.0.14Marko Kreen
2012-03-06Clean up SQL documentationMarko Kreen
By Hannu Krosing, applied with some fixing
2012-01-10pgq.version(): 3.0.0.13Marko Kreen
2012-01-10pgq.maint_operations: re-check the need for step2Marko Kreen
Previously the need for step2 was decided by need for step1. But if pgqd stops/crashed after step1 but before step2, the step2 will not be run anymore. Fix this by rechecking if no step1 was needed.
2011-12-14pgq.version(): 3.0.0.12Marko Kreen
2011-12-14pgq.register_consumer_at: if tick is given, drop open batchMarko Kreen
Old behaviour could catch (maybe) some bugs, but made life hard for consumers that know what they are doing. Basically, non-NULL tick pos is taken as "consumer knows better".
2011-12-07pgq.version(): 3.0.0.11Marko Kreen
2011-11-29pgq.register_consumer_at: fix docstringMarko Kreen
2011-11-22pgq.version(): 3.0.0.10Marko Kreen
2011-11-18pgq.unregister_consumer: do not raise errorsMarko Kreen
- be silent if consumer does not exist - if subconsumers exist, unregister those too
2011-11-15pgq.version(): 3.0.0.9Marko Kreen
2011-10-27pgq.Consumer: support .consumer_filter with lazy_fetchMarko Kreen
2011-09-08pgq.version(): 3.0.0.8Marko Kreen
2011-09-08pgq.upgrade_schema(): magic schema upgradeMarko Kreen
2011-02-16bump db verMarko Kreen
2011-02-04pgq.get_queue_info: report last tick in queueMarko Kreen
2011-01-14bump db verMarko Kreen
2011-01-14pgq.ticker(): rework the old tick sanity checkMarko Kreen
due to good-enough timing, seq and xmax may appear reversed. only error out when xmin is wrong. otherwise throw warning, to debug the issue.
2011-01-14fixed case when event id is NULL on retryAsko Tiidumaa
2011-01-10pgq.ticker: better error message when sanity check failsMarko Kreen
2010-12-14bump db verMarko Kreen
2010-12-14pgq: avoid text||int concet, it breaks if db has bandaid casts installedMarko Kreen
2010-12-13bump db verMarko Kreen
2010-12-12fix pg_autovacuum defaults in pgq.tune_storage()Martin Pihlak
Previous version used zero value for freeze_max_age, which caused autovacuum to constantly re-vacuum all of the event tables because of the wraparound threat. Set this and other values to -1 to indicate system default.
2010-12-08tick logic now respects either lag or max tick count, not just bothAsko Tiidumaa
2010-11-29set db ver for 3.0.0.3Marko Kreen
2010-11-29sql/*: Simplify queries to be able to run greenplum as leafAsko Tiidumaa
execute: Move session_replication_role setting out of db functions.
2010-11-26sql/pgq: sanity check against incorrect db stateMarko Kreen
2010-11-25pgq.version: 3.0.0.2Marko Kreen
2010-11-25pgq.drop_queue: make force drop old consumersMarko Kreen
2010-11-23pgq_node: add version() function, bump ver in pgq and londiste schemas.Marko Kreen
All code has seen various fixes, this will help detect old versions.
2010-11-09pgq.maint_rotate_tables: detect and report tick inconsistencyMarko Kreen
generated by cgit v1.2.3 (git 2.39.1) at 2025-07-19 18:36:48 +0000