skytools.git
18 years agoI forgot to update format string.
Marko Kreen [Fri, 12 Oct 2007 09:54:46 +0000 (09:54 +0000)]
I forgot to update format string.

Patch by Dimitry Fontaine.

18 years agoPatch from Dimitri Fontaine:
Marko Kreen [Fri, 12 Oct 2007 09:41:15 +0000 (09:41 +0000)]
Patch from Dimitri Fontaine:

Couldn't install pgq on 8.1, the following patch seems to make it through
(PL/pgSQL for var1, var2 in construct is not yet available in 8.1, I changed
it to a record type --- hopefully I didn't break the query).

18 years agoconvert to new txid interface apperaing in 8.3
Marko Kreen [Fri, 12 Oct 2007 09:39:07 +0000 (09:39 +0000)]
convert to new txid interface apperaing in 8.3

18 years agofix nasty realloc bug introduced by recent cleanup
Marko Kreen [Fri, 28 Sep 2007 12:08:11 +0000 (12:08 +0000)]
fix nasty realloc bug introduced by recent cleanup

18 years agoinclude env
Marko Kreen [Tue, 25 Sep 2007 13:16:52 +0000 (13:16 +0000)]
include env

18 years agoclean config
Marko Kreen [Tue, 25 Sep 2007 13:16:18 +0000 (13:16 +0000)]
clean config

18 years agoshow os.spawn cmdline in error
Marko Kreen [Tue, 25 Sep 2007 13:11:40 +0000 (13:11 +0000)]
show os.spawn cmdline in error

18 years agoremove unused getopt module
Marko Kreen [Tue, 25 Sep 2007 12:45:30 +0000 (12:45 +0000)]
remove unused getopt module

18 years ago2.1.5rc2
Marko Kreen [Tue, 25 Sep 2007 12:38:22 +0000 (12:38 +0000)]
2.1.5rc2

18 years agoimport sys
Marko Kreen [Tue, 25 Sep 2007 12:38:10 +0000 (12:38 +0000)]
import sys

18 years agoremove snapshot info, "NEW" -> "-"
Marko Kreen [Tue, 25 Sep 2007 11:24:20 +0000 (11:24 +0000)]
remove snapshot info, "NEW" -> "-"

18 years agoretval for display_table
Marko Kreen [Tue, 25 Sep 2007 11:14:20 +0000 (11:14 +0000)]
retval for display_table

18 years agotxid_snapshot_out: 1 less alloc, use PG_FREE_IF_COPY
Marko Kreen [Tue, 25 Sep 2007 11:13:18 +0000 (11:13 +0000)]
txid_snapshot_out: 1 less alloc, use PG_FREE_IF_COPY

18 years agofix dumb thinko i made in quoting
Marko Kreen [Mon, 24 Sep 2007 19:16:52 +0000 (19:16 +0000)]
fix dumb thinko i made in quoting

18 years agomissing stringinfo.h include
Marko Kreen [Wed, 19 Sep 2007 08:19:37 +0000 (08:19 +0000)]
missing stringinfo.h include

18 years agomention walmgr
Marko Kreen [Tue, 18 Sep 2007 14:31:47 +0000 (14:31 +0000)]
mention walmgr

18 years ago2.1.5rc1
Marko Kreen [Tue, 18 Sep 2007 14:28:27 +0000 (14:28 +0000)]
2.1.5rc1

18 years agoSync walmgr from internal repo:
Marko Kreen [Tue, 18 Sep 2007 10:49:17 +0000 (10:49 +0000)]
Sync walmgr from internal repo:

- added "compression" option
- syncdaemon will retry on rsync errors
- syncdaemon adds -n to ssh options

By Martin Pihlak

18 years agowalmgr doc from Martin
Marko Kreen [Tue, 18 Sep 2007 10:43:00 +0000 (10:43 +0000)]
walmgr doc from Martin

18 years agodocs update
Marko Kreen [Mon, 17 Sep 2007 15:57:35 +0000 (15:57 +0000)]
docs update

18 years agoadd trigger funcs to upgrade
Marko Kreen [Mon, 17 Sep 2007 15:09:48 +0000 (15:09 +0000)]
add trigger funcs to upgrade

18 years agotrigger storage
Marko Kreen [Mon, 17 Sep 2007 14:31:45 +0000 (14:31 +0000)]
trigger storage

18 years agoAutomatic trigger handling for Londiste.
Marko Kreen [Mon, 17 Sep 2007 14:30:54 +0000 (14:30 +0000)]
Automatic trigger handling for Londiste.

By Erik Jones

18 years agointernal quoting
Marko Kreen [Mon, 17 Sep 2007 14:28:13 +0000 (14:28 +0000)]
internal quoting

18 years agostore full fkey sql in table
Marko Kreen [Mon, 17 Sep 2007 14:27:40 +0000 (14:27 +0000)]
store full fkey sql in table

18 years agosimpler get_provider_seqs() func
Marko Kreen [Mon, 17 Sep 2007 09:12:14 +0000 (09:12 +0000)]
simpler get_provider_seqs() func

18 years ago- binary search in long snapshots
Marko Kreen [Mon, 17 Sep 2007 09:09:35 +0000 (09:09 +0000)]
- binary search in long snapshots

- cleanup of text buffer handling

18 years agoclearer error message for missing psycopg
Marko Kreen [Mon, 17 Sep 2007 09:04:21 +0000 (09:04 +0000)]
clearer error message for missing psycopg

18 years agoexperimental lazy event fetching
Marko Kreen [Mon, 17 Sep 2007 09:02:51 +0000 (09:02 +0000)]
experimental lazy event fetching

18 years agoSupport both event formats, loop over list only once.
Marko Kreen [Mon, 17 Sep 2007 08:27:54 +0000 (08:27 +0000)]
Support both event formats, loop over list only once.

18 years agosupport both event format
Marko Kreen [Mon, 17 Sep 2007 08:26:10 +0000 (08:26 +0000)]
support both event format

18 years agoloop over event list only once
Marko Kreen [Sat, 15 Sep 2007 21:47:32 +0000 (21:47 +0000)]
loop over event list only once

18 years agodocument add-seq/remove-seq
Marko Kreen [Tue, 4 Sep 2007 13:24:06 +0000 (13:24 +0000)]
document add-seq/remove-seq

18 years agoupgrade scripts for 2.1.5
Marko Kreen [Tue, 4 Sep 2007 13:05:24 +0000 (13:05 +0000)]
upgrade scripts for 2.1.5

18 years agoforgot to mention hans
Marko Kreen [Tue, 4 Sep 2007 10:21:16 +0000 (10:21 +0000)]
forgot to mention hans

18 years agoupdate contributors
Marko Kreen [Thu, 30 Aug 2007 14:38:49 +0000 (14:38 +0000)]
update contributors

18 years agoconvert more docs to asciidoc
Marko Kreen [Thu, 30 Aug 2007 13:01:14 +0000 (13:01 +0000)]
convert more docs to asciidoc

18 years agoremove check command
Marko Kreen [Thu, 30 Aug 2007 12:30:25 +0000 (12:30 +0000)]
remove check command

18 years agodoc update
Marko Kreen [Thu, 30 Aug 2007 12:20:52 +0000 (12:20 +0000)]
doc update

18 years agopgqadm doc
Marko Kreen [Thu, 30 Aug 2007 12:20:37 +0000 (12:20 +0000)]
pgqadm doc

by Asko Oja

18 years agono-arg config shows conf for all queues
Marko Kreen [Thu, 30 Aug 2007 12:04:56 +0000 (12:04 +0000)]
no-arg config shows conf for all queues

18 years agofix "config" command
Marko Kreen [Thu, 30 Aug 2007 11:39:40 +0000 (11:39 +0000)]
fix "config" command

18 years agoAdd DESTDIR to man targets to make them packageable.
Marko Kreen [Thu, 30 Aug 2007 11:37:28 +0000 (11:37 +0000)]
Add DESTDIR to man targets to make them packageable.

By Dimitri Fontaine

18 years agomention the trigger purpose
Marko Kreen [Thu, 30 Aug 2007 11:35:19 +0000 (11:35 +0000)]
mention the trigger purpose

18 years agoitervalues() for completeness
Marko Kreen [Thu, 30 Aug 2007 11:29:49 +0000 (11:29 +0000)]
itervalues() for completeness

18 years agologtriga & plpython are not necessary anymore
Marko Kreen [Thu, 30 Aug 2007 11:13:45 +0000 (11:13 +0000)]
logtriga & plpython are not necessary anymore

18 years agoadd more dict() methods
Marko Kreen [Thu, 30 Aug 2007 11:12:33 +0000 (11:12 +0000)]
add more dict() methods

18 years agoadd test target
Marko Kreen [Thu, 30 Aug 2007 11:11:50 +0000 (11:11 +0000)]
add test target

18 years agoless noisy regtest
Marko Kreen [Thu, 30 Aug 2007 09:59:41 +0000 (09:59 +0000)]
less noisy regtest

18 years agodocument add-seq, remove-seq, allow --all
Marko Kreen [Thu, 23 Aug 2007 11:57:17 +0000 (11:57 +0000)]
document add-seq, remove-seq, allow --all

18 years agotypo fix
Marko Kreen [Thu, 23 Aug 2007 11:56:49 +0000 (11:56 +0000)]
typo fix

18 years agoAdd INSTALL.txt, convert rest to asciidoc
Marko Kreen [Wed, 22 Aug 2007 12:37:42 +0000 (12:37 +0000)]
Add INSTALL.txt, convert rest to asciidoc

Dimitri Fontaine & Marko Kreen

18 years agoremember paths for manpages
Marko Kreen [Wed, 22 Aug 2007 08:44:12 +0000 (08:44 +0000)]
remember paths for manpages

18 years agoadd docs
Marko Kreen [Wed, 22 Aug 2007 08:43:34 +0000 (08:43 +0000)]
add docs

18 years agosanity check
Marko Kreen [Wed, 22 Aug 2007 08:42:29 +0000 (08:42 +0000)]
sanity check

18 years agoremove some junk
Marko Kreen [Tue, 21 Aug 2007 15:27:39 +0000 (15:27 +0000)]
remove some junk

18 years agoasciidoc manpages - londiste.1, londiste.5
Marko Kreen [Tue, 21 Aug 2007 13:57:11 +0000 (13:57 +0000)]
asciidoc manpages - londiste.1, londiste.5

By Dimitri Fontaine.

18 years agoPgQ docstring fixes.
Marko Kreen [Thu, 16 Aug 2007 21:00:39 +0000 (21:00 +0000)]
PgQ docstring fixes.

By Jim Nasby.

18 years agoMinor change to collect_fkeys() in setup.py to use a list
Marko Kreen [Wed, 15 Aug 2007 14:46:01 +0000 (14:46 +0000)]
Minor change to collect_fkeys() in setup.py to use a list
comprehension when building the display field widths.

Erik Jones

18 years agoDrop fkeys also in main thread.
Marko Kreen [Tue, 14 Aug 2007 20:57:02 +0000 (20:57 +0000)]
Drop fkeys also in main thread.

By Erik Jones

18 years agoonly main thread is allowed to restore fkeys
Marko Kreen [Mon, 13 Aug 2007 21:37:23 +0000 (21:37 +0000)]
only main thread is allowed to restore fkeys

18 years agoput fkey dropping into separate function
Marko Kreen [Mon, 13 Aug 2007 21:36:47 +0000 (21:36 +0000)]
put fkey dropping into separate function

18 years agodoc update
Marko Kreen [Sun, 12 Aug 2007 12:59:08 +0000 (12:59 +0000)]
doc update

18 years agofaster copy snapshot cleanup
Marko Kreen [Sun, 12 Aug 2007 12:58:20 +0000 (12:58 +0000)]
faster copy snapshot cleanup

18 years agodoc update
Marko Kreen [Sun, 12 Aug 2007 11:37:38 +0000 (11:37 +0000)]
doc update

18 years agoSupport for automatic handling of fkeys.
Marko Kreen [Sun, 12 Aug 2007 11:36:09 +0000 (11:36 +0000)]
Support for automatic handling of fkeys.

By Eric Jones, plus some hacking by me.

18 years agoless verbose errors
Marko Kreen [Sun, 12 Aug 2007 10:59:41 +0000 (10:59 +0000)]
less verbose errors

18 years agotests/scripts: gen db also
Marko Kreen [Sun, 12 Aug 2007 10:58:31 +0000 (10:58 +0000)]
tests/scripts: gen db also

18 years agoforgot to import QuotedString from psycopg1
Marko Kreen [Sat, 11 Aug 2007 20:46:10 +0000 (20:46 +0000)]
forgot to import QuotedString from psycopg1

18 years agodocstring related cleanup
Marko Kreen [Sat, 11 Aug 2007 14:40:03 +0000 (14:40 +0000)]
docstring related cleanup

18 years agopgq: clean up table docstrings
Marko Kreen [Sat, 11 Aug 2007 14:27:16 +0000 (14:27 +0000)]
pgq: clean up table docstrings

18 years agopgq: 8.3 throws error if varname == funcname
Marko Kreen [Sat, 11 Aug 2007 14:26:34 +0000 (14:26 +0000)]
pgq: 8.3 throws error if varname == funcname

18 years agoadd lib/stringinfo.h to /triggers/
Marko Kreen [Sat, 4 Aug 2007 20:20:37 +0000 (20:20 +0000)]
add lib/stringinfo.h to /triggers/

18 years agopgq_lowlevel: missing include for StringInfo
Marko Kreen [Sat, 4 Aug 2007 20:14:22 +0000 (20:14 +0000)]
pgq_lowlevel: missing include for StringInfo

18 years agomake C modules work on 8.3
Marko Kreen [Wed, 1 Aug 2007 10:24:46 +0000 (10:24 +0000)]
make C modules work on 8.3

18 years agodont be scary
Marko Kreen [Tue, 31 Jul 2007 19:22:22 +0000 (19:22 +0000)]
dont be scary

18 years agoupdate todo
Marko Kreen [Tue, 31 Jul 2007 19:21:32 +0000 (19:21 +0000)]
update todo

18 years agodont test denytrigger
Marko Kreen [Tue, 31 Jul 2007 19:19:08 +0000 (19:19 +0000)]
dont test denytrigger

18 years agolondiste: remove unused denytrigger
Marko Kreen [Tue, 31 Jul 2007 19:18:33 +0000 (19:18 +0000)]
londiste: remove unused denytrigger

18 years agoremove a lost todo list in .py file
Marko Kreen [Tue, 31 Jul 2007 19:16:10 +0000 (19:16 +0000)]
remove a lost todo list in .py file

18 years agolondiste: new --all switch for provider/subscriber add/remove
Marko Kreen [Tue, 31 Jul 2007 19:05:07 +0000 (19:05 +0000)]
londiste: new --all switch for provider/subscriber add/remove

provider add --all adds all tables that exist in db, otherwise works on registered tables

By Hans-Juergen Schoenig, plus some cleanup from me

18 years agopgq: pgq.maint_tables_to_vacuum() includes also pgq_ext and londiste tables
Marko Kreen [Tue, 31 Jul 2007 17:53:43 +0000 (17:53 +0000)]
pgq: pgq.maint_tables_to_vacuum() includes also pgq_ext and londiste tables

18 years agoInstall .sql files separately under $prefix/share/skytools
Marko Kreen [Tue, 31 Jul 2007 17:24:22 +0000 (17:24 +0000)]
Install .sql files separately under $prefix/share/skytools
for usage for python scripts, because they may be installed
without installing postgres modules.

18 years agolondiste subscriber tables: Show the statatus of the table.
Marko Kreen [Tue, 31 Jul 2007 17:14:51 +0000 (17:14 +0000)]
londiste subscriber tables: Show the statatus of the table.

Dimitri Fontaine & Marko Kreen

18 years agolondiste remove: also survive missing trigger
Marko Kreen [Tue, 31 Jul 2007 15:36:21 +0000 (15:36 +0000)]
londiste remove: also survive missing trigger

18 years agopgq: dont allow regular users directly insert to event tables
Marko Kreen [Tue, 31 Jul 2007 15:12:58 +0000 (15:12 +0000)]
pgq: dont allow regular users directly insert to event tables

18 years agoMake "provider remove" not fail if the table does not exist.
Marko Kreen [Tue, 31 Jul 2007 14:27:18 +0000 (14:27 +0000)]
Make "provider remove" not fail if the table does not exist.

Patch by Dimitri Fontaine.

18 years agoallow everybody to SELECT pgq and londiste tables
Marko Kreen [Tue, 31 Jul 2007 09:59:20 +0000 (09:59 +0000)]
allow everybody to SELECT pgq and londiste tables

18 years agoanother todo update
Marko Kreen [Mon, 30 Jul 2007 22:58:48 +0000 (22:58 +0000)]
another todo update

18 years agolondiste: forgot to set schema for serialconsumer
Marko Kreen [Mon, 30 Jul 2007 22:43:27 +0000 (22:43 +0000)]
londiste: forgot to set schema for serialconsumer

18 years agobump version to 2.1.5
Marko Kreen [Mon, 30 Jul 2007 16:54:32 +0000 (16:54 +0000)]
bump version to 2.1.5

18 years agopgq: rewrite triggers in C, thus not depending on plpython anymore
Marko Kreen [Mon, 30 Jul 2007 12:31:24 +0000 (12:31 +0000)]
pgq: rewrite triggers in C, thus not depending on plpython anymore

18 years agopgq: more plpython code under old/
Marko Kreen [Mon, 30 Jul 2007 12:25:24 +0000 (12:25 +0000)]
pgq: more plpython code under old/

18 years agopgq: load ev_id with queue data
Marko Kreen [Mon, 30 Jul 2007 09:49:13 +0000 (09:49 +0000)]
pgq: load ev_id with queue data

18 years agoallow .copy() operation on rows
Marko Kreen [Fri, 27 Jul 2007 11:50:09 +0000 (11:50 +0000)]
allow .copy() operation on rows

18 years agowikify todo
Marko Kreen [Wed, 25 Jul 2007 21:15:45 +0000 (21:15 +0000)]
wikify todo

18 years agodoc: missed logtriga installation
Marko Kreen [Wed, 25 Jul 2007 16:33:12 +0000 (16:33 +0000)]
doc: missed logtriga installation

18 years agoUpdate docs based on feedback from Dimitri Fontaine.
Marko Kreen [Wed, 25 Jul 2007 14:21:43 +0000 (14:21 +0000)]
Update docs based on feedback from Dimitri Fontaine.

18 years agoskytools: docstring shuffle, hide/remove low-level/old stuff
Marko Kreen [Wed, 25 Jul 2007 10:14:23 +0000 (10:14 +0000)]
skytools: docstring shuffle, hide/remove low-level/old stuff

18 years agosplit identifiers on first dot only
Marko Kreen [Wed, 25 Jul 2007 09:58:26 +0000 (09:58 +0000)]
split identifiers on first dot only