Marko Kreen [Fri, 16 Nov 2012 13:28:45 +0000 (15:28 +0200)]
Accept 't' proargmode, use symbolic names.
Also throw error on unknown proargmode.
Fixes crash reported by Sébastien Lardière.
Marko Kreen [Wed, 31 Oct 2012 12:41:12 +0000 (14:41 +0200)]
v2.5rc1
Marko Kreen [Wed, 31 Oct 2012 13:07:00 +0000 (15:07 +0200)]
debclean target
Marko Kreen [Wed, 31 Oct 2012 12:36:06 +0000 (14:36 +0200)]
Bump ext ver to 2.5.0, add upgrade scripts
Marko Kreen [Thu, 11 Oct 2012 21:13:28 +0000 (00:13 +0300)]
Rename table alter test
Marko Kreen [Thu, 11 Oct 2012 09:06:37 +0000 (12:06 +0300)]
After sending cancel req, wait for remote error
Previously, as soon as cancel requests were send,
plproxy re-throwed the error, without waiting for
reaction from backend. Such behaviour creates
2 problems:
- If plproxy backend is closed immediately, the bouncer will
see plproxy close before cancel from backend, thus seeing
mid-tx close, thus dropping the connection.
- If new query comes in to plproxy backend, plproxy itself
will see dirty connection, closing it, thus also causing
close of server connection in bouncer.
In both cases it can cause server connection drop in pooler.
New behaviour of waiting query result should fix it.
Marko Kreen [Thu, 11 Oct 2012 12:16:58 +0000 (15:16 +0300)]
Table invalidation
On each call, recheck type relation rowstamp.
If it proves to be noticeable, we can use
syscache callback infrastructure for that,
but it will be much more complex.
Marko Kreen [Thu, 11 Oct 2012 11:45:54 +0000 (14:45 +0300)]
Support for dropped fields
Marko Kreen [Mon, 7 May 2012 14:06:11 +0000 (17:06 +0300)]
v2.4
Marko Kreen [Mon, 7 May 2012 11:02:53 +0000 (14:02 +0300)]
PGVER: add quoting
This avoids breakage if pg_config is not found
and PGVER stays empty.
Marko Kreen [Fri, 13 Apr 2012 11:42:20 +0000 (14:42 +0300)]
v2.4rc2
Marko Kreen [Fri, 13 Apr 2012 10:21:31 +0000 (13:21 +0300)]
Proper init and cleanup for ConnectionState
Otherwise there can be garbage in struct
Marko Kreen [Fri, 13 Apr 2012 10:03:01 +0000 (13:03 +0300)]
Another get_role_oid() fixup
Marko Kreen [Thu, 12 Apr 2012 11:46:12 +0000 (14:46 +0300)]
Use container_of() to get main struct from node
Direct casts hardwire the assumption that node
is always first member of struct.
Marko Kreen [Thu, 12 Apr 2012 11:33:29 +0000 (14:33 +0300)]
Provide get_role_oid() on older Postgres
Marko Kreen [Thu, 5 Apr 2012 15:24:55 +0000 (18:24 +0300)]
Fix 'make tgz'
Marko Kreen [Thu, 5 Apr 2012 14:51:06 +0000 (17:51 +0300)]
v2.4rc1
Marko Kreen [Thu, 5 Apr 2012 14:50:19 +0000 (17:50 +0300)]
config.txt: missing dot
Marko Kreen [Mon, 2 Apr 2012 10:12:11 +0000 (13:12 +0300)]
New config var: 'default_user'
This allows to fall back to old default of 'session_user'.
New default is 'current_user'.
Marko Kreen [Mon, 2 Apr 2012 10:11:03 +0000 (13:11 +0300)]
Clear old config before loading new one.
This allows falling back to defaults when
some value is dropped from config.
Marko Kreen [Thu, 29 Mar 2012 15:14:37 +0000 (18:14 +0300)]
Test SQL/MED with SECURITY DEFINER
Marko Kreen [Thu, 29 Mar 2012 15:07:01 +0000 (18:07 +0300)]
Refresh SPLIT test - order changed.
Now connections are added to active_list in order
they get tagged from hash function.
Marko Kreen [Thu, 29 Mar 2012 15:04:47 +0000 (18:04 +0300)]
Switch from session_user to current_user.
Plus minor cleanups.
Marko Kreen [Wed, 28 Mar 2012 19:12:15 +0000 (22:12 +0300)]
User mapping now almost works on sql/med too
Marko Kreen [Wed, 28 Mar 2012 19:09:17 +0000 (22:09 +0300)]
rowstamp: allow usage on zeroed stamp
Marko Kreen [Wed, 28 Mar 2012 10:47:30 +0000 (13:47 +0300)]
Per-user mapping for non-sqlmed clusters
Marko Kreen [Tue, 27 Mar 2012 15:29:33 +0000 (18:29 +0300)]
Put per-cluster connect strings into tree
Marko Kreen [Tue, 27 Mar 2012 12:09:02 +0000 (15:09 +0300)]
Convert real cluster to tree
Marko Kreen [Tue, 27 Mar 2012 11:51:33 +0000 (14:51 +0300)]
Use binary tree for fake cluster storage
- Add aatree.[ch]
- Dont run maintenance if no init is done
- Simplify header deps in Makefile
- Store fake cluster in binary tree
Marko Kreen [Tue, 27 Mar 2012 10:49:47 +0000 (13:49 +0300)]
Create separate structure for current connection
Marko Kreen [Tue, 27 Mar 2012 08:31:33 +0000 (11:31 +0300)]
Makefile cleanups
- remove plproxy.so even when building something else
- Use ctags for tags
Marko Kreen [Tue, 27 Mar 2012 08:31:22 +0000 (11:31 +0300)]
debian/rules clean: remove per-package dirs
Marko Kreen [Thu, 8 Mar 2012 22:37:21 +0000 (00:37 +0200)]
Reorganize Debian packaging
Drop yada based packaging, instead use the new pg_buildext
packaging, except include pg_buildext under debian/ so the
package builds on lenny too.
It finds any postgresql-server-dev packages and builds
against them.
Also import Peter Eisentraut's Makefile fixes from official
Debian packaging to support multi-package builds.
Now package is built for all installed server-dev versions.
Marko Kreen [Thu, 8 Mar 2012 22:02:44 +0000 (00:02 +0200)]
Makefile and tests cleanup
- Use CREATE EXTENSION in 9.1+ tests
- set verbosity to 'terse' to have less noise
- Less messy Makefile rules
Marko Kreen [Wed, 7 Mar 2012 20:49:58 +0000 (22:49 +0200)]
Update news & authors
Marko Kreen [Mon, 27 Feb 2012 00:09:22 +0000 (02:09 +0200)]
Sync with cache invalidation changes in 9.2
Marko Kreen [Tue, 6 Mar 2012 14:39:38 +0000 (16:39 +0200)]
Add printf attribute to vararg error functions
Marko Kreen [Mon, 27 Feb 2012 00:09:36 +0000 (02:09 +0200)]
Makefile cleanup
Marko Kreen [Mon, 27 Feb 2012 18:34:53 +0000 (10:34 -0800)]
Merge pull request #2 from theory/isc
ISC is not known to PGXN, so spell it out.
David E. Wheeler [Mon, 27 Feb 2012 17:49:41 +0000 (09:49 -0800)]
Only need one license field.
David E. Wheeler [Mon, 27 Feb 2012 17:41:09 +0000 (09:41 -0800)]
ISC is not known to PGXN, so spell it out.
Marko Kreen [Mon, 27 Feb 2012 00:03:14 +0000 (02:03 +0200)]
Fix metainfo
Marko Kreen [Mon, 27 Feb 2012 00:01:47 +0000 (02:01 +0200)]
plproxy.control: tag as superuser-only
As only superusers can create plproxy functions,
it does seem weird to allow regular users to install it.
Marko Kreen [Sun, 26 Feb 2012 23:55:38 +0000 (01:55 +0200)]
Fix sql file location in test/
David E. Wheeler [Sat, 25 Feb 2012 22:31:10 +0000 (14:31 -0800)]
Add support for PGXN distribution.
Mainly by adding META.json. A new `zip` target has also been added to make it simple to generate the zip file for distribution.
Note that PGXN requires x.y.z versions, so the version has been changed from 2.3 to 2.3.0.
David E. Wheeler [Sat, 25 Feb 2012 22:20:35 +0000 (14:20 -0800)]
Add .gitattributes.
So that .gitignore can be excluded from the archive. And .gitattributes itself, of course.
David E. Wheeler [Sat, 25 Feb 2012 21:43:06 +0000 (13:43 -0800)]
Add .gitignore.
David E. Wheeler [Sat, 25 Feb 2012 21:39:40 +0000 (13:39 -0800)]
Add ability to create extenion from unpackaged.
David E. Wheeler [Sat, 25 Feb 2012 21:34:01 +0000 (13:34 -0800)]
Add support for building as a 9.1 extension.
David E. Wheeler [Sat, 25 Feb 2012 21:26:14 +0000 (13:26 -0800)]
Move SQL files to sql/ subdirectory.
David E. Wheeler [Sat, 25 Feb 2012 21:03:49 +0000 (13:03 -0800)]
Move tests to test subdirectory.
David E. Wheeler [Sat, 25 Feb 2012 20:48:31 +0000 (12:48 -0800)]
Fix test failure.
Marko Kreen [Tue, 15 Nov 2011 14:28:47 +0000 (16:28 +0200)]
todo: put error-handling related items to "good to have" section
Zoltán Böszörményi [Sat, 5 Nov 2011 13:52:49 +0000 (15:52 +0200)]
Support ENUM types.
Marko Kreen [Tue, 25 Oct 2011 13:39:11 +0000 (16:39 +0300)]
v2.3
Marko Kreen [Tue, 25 Oct 2011 13:57:05 +0000 (16:57 +0300)]
Makefile cleanup
- use git-archive to generate tgz
- make clean better
Marko Kreen [Tue, 25 Oct 2011 13:43:18 +0000 (16:43 +0300)]
Add missing files for plproxy_target regtest
Martin Pihlak [Thu, 13 Oct 2011 10:23:45 +0000 (13:23 +0300)]
added deb91 target.
Marko Kreen [Wed, 12 Oct 2011 09:52:12 +0000 (12:52 +0300)]
v2.3rc2
Marko Kreen [Wed, 12 Oct 2011 09:48:56 +0000 (12:48 +0300)]
SPLIT: fix elem type info leak
Marko Kreen [Wed, 14 Sep 2011 10:03:04 +0000 (13:03 +0300)]
regtests@9.1: pg9.1 ignores --dbname in REGRESS_OPTS
Also it needs 'override' to change CONTRIB_TESTDB
Marko Kreen [Wed, 14 Sep 2011 10:01:24 +0000 (13:01 +0300)]
regtests@9.1: ignore errors around 'create language plpgsql'
As of 9.1, there is no clean way to get plpgsql into db
that works across versions.
Marko Kreen [Tue, 13 Sep 2011 13:25:40 +0000 (16:25 +0300)]
v2.3rc1
Marko Kreen [Tue, 13 Sep 2011 13:17:11 +0000 (16:17 +0300)]
doc: remove overview.txt, its unmaintained
it was copy of old wiki page
Marko Kreen [Tue, 13 Sep 2011 13:14:44 +0000 (16:14 +0300)]
doc: Use ListingBlock for code
Old style used 'literal paragraph' which was nice
in ascii but not as good in HTML.
As the HTML is preferred, optimize for that.
Marko Kreen [Tue, 13 Sep 2011 12:52:57 +0000 (15:52 +0300)]
doc: mention global options
Marko Kreen [Thu, 29 Apr 2010 10:31:23 +0000 (13:31 +0300)]
Documentation for keepalive parameters.
Marko Kreen [Wed, 28 Apr 2010 11:07:04 +0000 (14:07 +0300)]
Keepalive parameters
- keepalive_idle
- keepalive_interval
- keepalive_count
Petr Jelinek [Mon, 15 Aug 2011 09:51:09 +0000 (11:51 +0200)]
support global SQL/MED cluster options
Marko Kreen [Fri, 18 Feb 2011 15:32:28 +0000 (17:32 +0200)]
v2.2
Marko Kreen [Wed, 16 Feb 2011 14:24:46 +0000 (16:24 +0200)]
doc: fix upload link
Marko Kreen [Wed, 2 Feb 2011 12:54:08 +0000 (14:54 +0200)]
deb: v2.2rc1
Marko Kreen [Wed, 2 Feb 2011 12:46:21 +0000 (14:46 +0200)]
v2.2rc1
Marko Kreen [Wed, 2 Feb 2011 12:41:32 +0000 (14:41 +0200)]
test argument type quoting
Marko Kreen [Fri, 21 Jan 2011 14:02:28 +0000 (16:02 +0200)]
win32: poll() compat fix - w32 does not use bitmap
Marko Kreen [Fri, 21 Jan 2011 11:37:10 +0000 (13:37 +0200)]
doc: Remove obsolete target from Makefile
Marko Kreen [Thu, 20 Jan 2011 15:12:44 +0000 (17:12 +0200)]
New TARGET satement, to redirect target function.
Marko Kreen [Thu, 20 Jan 2011 15:11:24 +0000 (17:11 +0200)]
scanner: define YY_NO_INPUT to ignore unused yyinput function
Marko Kreen [Wed, 1 Dec 2010 10:23:47 +0000 (12:23 +0200)]
More portable workaround for empty FLEX/BISON
The $(or ) does not work on older gnu makes, $(if )
is more portable.
Suggested by Peter Eisentraut
Marko Kreen [Mon, 6 Sep 2010 10:49:29 +0000 (13:49 +0300)]
Make possible to disallow SELECT statement.
make NO_SELECT=1
make install
Marko Kreen [Wed, 28 Jul 2010 14:44:48 +0000 (17:44 +0300)]
Fix returning of many-column result types
Old code used FUNC_MAX_ARGS as limit for number of columns,
but composite types can be larger. Use dynamic allocation instead.
Patch by Hans-Jürgen Schönig
Marko Kreen [Wed, 28 Apr 2010 07:35:06 +0000 (10:35 +0300)]
Survive missing sqlstate field on error messages
Marko Kreen [Fri, 23 Apr 2010 15:02:18 +0000 (18:02 +0300)]
v2.1
Marko Kreen [Mon, 12 Apr 2010 13:06:14 +0000 (16:06 +0300)]
Avoid unused func warning about yy_fatal_error()
Marko Kreen [Mon, 12 Apr 2010 13:03:14 +0000 (16:03 +0300)]
Show remote database name in remote error messages.
Marko Kreen [Mon, 12 Apr 2010 14:37:47 +0000 (17:37 +0300)]
Fix hint field reference.
Marko Kreen [Tue, 23 Mar 2010 12:40:10 +0000 (14:40 +0200)]
tgz: debian/packages was renamed.
Marko Kreen [Tue, 23 Mar 2010 12:13:37 +0000 (14:13 +0200)]
Prepare for 2.1rc1
Marko Kreen [Tue, 16 Mar 2010 21:33:38 +0000 (23:33 +0200)]
Some installation notes.
Marko Kreen [Tue, 16 Mar 2010 21:05:25 +0000 (23:05 +0200)]
Allow to customize pg_config via PG_CONFIG variable.
Patch by David E. Wheeler
Marko Kreen [Tue, 16 Mar 2010 20:54:41 +0000 (22:54 +0200)]
Flex >= 2.5.35 declares it's own functions properly now, so omit our defs for it.
That also avoid the signature confict on macos 10.6 which seems to have changed
the signatures from original ones.
Marko Kreen [Tue, 16 Mar 2010 20:49:33 +0000 (22:49 +0200)]
Discard notices from sqlmed test.
DROP IF NOT EXIST can randomly show notice.
Marko Kreen [Fri, 5 Mar 2010 15:05:57 +0000 (17:05 +0200)]
deb: per-postgres version packages
make debXY will create postgresql-plproxy-X.Y package.
Marko Kreen [Mon, 11 Jan 2010 10:55:58 +0000 (12:55 +0200)]
Improved remote error and notice handling.
- Register libpq notice handler with PQsetNoticeReceiver
- Extract details from err/notice with PQresultErrorField
and pass to ereport().
- Improve state-machine in another_result().
Martin Pihlak [Thu, 12 Nov 2009 14:45:42 +0000 (16:45 +0200)]
Adds "SPLIT ALL" to specify that all array arguments
are to be split.
Marko Kreen [Mon, 11 Jan 2010 09:02:40 +0000 (11:02 +0200)]
Make regtests work across 8.2 .. 8.5
- plpgsql is installed by default on 8.5+
- EUC_JP/UTF8 problems with 8.3+
- plproxy.sql output is different in 8.4+
- bytea output is different in 8.5+
Marko Kreen [Fri, 8 Jan 2010 15:28:16 +0000 (17:28 +0200)]
Fix standard_conforming_string incompat vs. 8.5
In 8.5:
- <parser/gramparse.h> is tagged as internal header
It also defines now flex/bison symbols that conflict
with plproxy parser.
- <parser/parser.h> describes external API
As the stdstr definition was problematic on older versions anyway,
define it explicitly for those.
Martin Pihlak [Tue, 5 Jan 2010 13:06:24 +0000 (15:06 +0200)]
Enable pl/proxy clusters to be defined by SQL/MED facilities.
Provide a plproxy foreign data wrapper and a function for
validating cluster definitions. It is still possible to define
clusters using configuration functions, however SQL/MED cluster
definition takes precedence if available.
Marko Kreen [Tue, 10 Nov 2009 13:36:24 +0000 (13:36 +0000)]
doc update: add ver tags to few places
Marko Kreen [Tue, 10 Nov 2009 13:35:30 +0000 (13:35 +0000)]
tag the head as 2.1