Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-25 Thread Kris Jurka
ago. Unfortunately I didn't keep a copy, and I'm not having any luck finding that message in the archives right now. Sumit, did you keep a copy? http://groups.google.com/groups?hl=enlr=ie=UTF-8selm=28882.1057162309%40sss.pgh.pa.us Kris Jurka ---(end of broadcast

[PATCHES] contrib/ltree Readme operator name

2004-01-25 Thread Kris Jurka
contrib/ltree's readme has = instead of = as the operator name for greater than or equal to. Kris Jurka Index: contrib/ltree/README.ltree === RCS file: /projects/cvsroot/pgsql-server/contrib/ltree/README.ltree,v retrieving revision

[PATCHES] compiling with ssl without thread safety still broken

2004-03-26 Thread Kris Jurka
Compiling with ssl without thread safety still broken. pq_initssllib is being incorrectly guarded by ENABLE_THREAD_SAFETY. Kris JurkaIndex: src/interfaces/libpq/fe-secure.c === RCS file:

[PATCHES] pg_dump --clean w/ = 7.2 server

2004-06-24 Thread Kris Jurka
When running pg_dump --clean against a server that doesn't have schemas the namespace is blank and ends up producing a dump full off things like: DROP TABLE .tab; The attached patch only includes a schema if one exists. There are numerous comments about the DROPs needing to be fully qualified

Re: [PATCHES] pg_dump --clean w/ = 7.2 server

2004-06-24 Thread Kris Jurka
possible reasons are deliberately making it fail or just a lack of testing. There's no way it does anything useful. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [PATCHES] psql schema permissions

2004-06-30 Thread Kris Jurka
in that area. Kris Jurka ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[PATCHES] Code/comment cleanups now that odbc is gone.

2004-09-24 Thread Kris Jurka
Here ae some code/comment cleanups now that the odbc interface is no longer part of the main distribution. Kris JurkaIndex: src/backend/libpq/md5.c === RCS file: /projects/cvsroot/pgsql-server/src/backend/libpq/md5.c,v retrieving

[PATCHES] dblink crash fix

2004-10-27 Thread Kris Jurka
This makes dblink pass its installcheck test on platforms where snprintf(data, len, %s, NULL) crash. The code was trying to find a connection by name when it already had an unnamed connection and did not have a name to search with. Kris JurkaIndex: contrib/dblink/dblink.c

[PATCHES] pthread.h header check

2004-11-01 Thread Kris Jurka
configure checks for the presense of pthread.h before adjusting CFLAGS to include PTHREAD_CFLAGS. This patch just moves the check down so CFLAGS are set usefully. Kris Jurka ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [PATCHES] contrib build fixes

2004-11-04 Thread Kris Jurka
/doc/postgresql/contrib ../../config/install-sh: ./README.mysql does not exist. renaming README to README.mysql fixes this. Kris Jurka ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [PATCHES] [BUGS] solaris non gcc compiler debug options

2004-11-28 Thread Kris Jurka
On Sat, 27 Nov 2004, Bruce Momjian wrote: Kris Jurka wrote: Compiling on solaris with a non gcc compiler does not correctly enable debugging when --enable-debug is specified. src/template/solaris is specifying CFLAGS=-O -v and -O overrides the -g that --enable-debug adds

Re: [PATCHES] Allow pooled connections to list all prepared queries

2004-12-25 Thread Kris Jurka
OR REPLACE would be more useful. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list

Re: [PATCHES] Allow pooled connections to list all prepared queries

2004-12-27 Thread Kris Jurka
connection. So each new connection from the pool gets a new proxy object, but the real underlying connection stays the same. So the real connection will know what it has or has not prepared. So I don't see why, simply because it's in a pool, that it forgets what's been prepared. Kris Jurka

Re: [PATCHES] Implementing RESET CONNECTION ...

2005-01-03 Thread Kris Jurka
the performance boost from prepared statements. We don't want to have to reprepare on each connection and we don't want them to disappear from underneath us, because the prepared statements are generated transparently by the JDBC driver, not directly by a user statement. Kris Jurka

Re: [PATCHES] Implementing RESET CONNECTION ...

2005-01-03 Thread Kris Jurka
string we are looking for. If we add the RESET you've implemented then it will never have a pre-prepared statement for us to use, so we'll have to create a new one every time. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through

[PATCHES] add soundex difference function to contrib/fuzzystrmatch

2005-01-24 Thread Kris Jurka
The attached patch implements the soundex difference function which compares two strings' soundex values for similarity. http://databases.about.com/od/development/l/aasoundex.htm Kris Jurka? contrib/fuzzystrmatch/.deps ? contrib/fuzzystrmatch/fuzzystrmatch.sql ? contrib/fuzzystrmatch

Re: [PATCHES] add soundex difference function to contrib/fuzzystrmatch

2005-01-24 Thread Kris Jurka
On Tue, 25 Jan 2005, Neil Conway wrote: On Tue, 2005-01-25 at 01:13 -0500, Kris Jurka wrote: The attached patch implements the soundex difference function which compares two strings' soundex values for similarity. *** 19,24 --- 19,28 AS 'MODULE_PATHNAME', 'soundex

Re: [PATCHES] add soundex difference function to contrib/fuzzystrmatch

2005-01-25 Thread Kris Jurka
sequence {fn difference('a','b') } Kris Jurka ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[PATCHES] more fixes for making contrib null safe

2005-01-28 Thread Kris Jurka
This adds the strict function attribute to the places in contrib that crash on null inputs. Kris JurkaIndex: contrib/chkpass/chkpass.sql.in === RCS file: /projects/cvsroot/pgsql/contrib/chkpass/chkpass.sql.in,v retrieving revision

[PATCHES] pgcrypto warnings for Sun's cc

2005-07-12 Thread Kris Jurka
This patch removes a couple of warnings Sun's cc reports in contrib/pgcrypto. cc -Xa -v -g -KPIC -I. -I../../src/include -I/usr/local/include -c -o sha2.o sha2.c sha2.c, line 173: warning: storage class after type is obsolescent sha2.c, line 193: warning: storage class after type is

Re: [PATCHES] [HACKERS] 4 pgcrypto regressions failures - 1 unsolved

2005-07-16 Thread Kris Jurka
as I see it is that gcc is choosing to link libz.a rather than libz.so --- why is that happening? The link line says -L/usr/local/lib -lz and libz.a is in /usr/local/lib while libz.so is in /usr/lib. Kris Jurka ---(end of broadcast)--- TIP 5: don't

Re: [PATCHES] fixing REL7_3_STABLE build issues

2005-07-16 Thread Kris Jurka
/3 branches to help enforce it. Also getting the regression tests to pass on even older versions(=7.1) seems like a waste of time, but ensuring that they at least compile and start to allow data extraction may not be, as a recent -general thread has shown. Kris Jurka

Re: [PATCHES] [HACKERS] 4 pgcrypto regressions failures - 1 unsolved

2005-07-16 Thread Kris Jurka
On Sat, 16 Jul 2005, Tom Lane wrote: Kris Jurka [EMAIL PROTECTED] writes: The link line says -L/usr/local/lib -lz and libz.a is in /usr/local/lib while libz.so is in /usr/lib. Well, that is a flat-out configuration error on the local sysadmin's part. I can't think of any good

[PATCHES] 7.3 pg_dump pt_BR translation msgfmt failure

2005-07-18 Thread Kris Jurka
The attached patch fixes this buildfarm failure: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=canarydt=2005-07-18%2015:30:01 Kris Jurka Index: src/bin/pg_dump/po/pt_BR.po === RCS file: /projects/cvsroot/pgsql/src/bin/pg_dump

[PATCHES] high values for client_min_messages

2005-09-27 Thread Kris Jurka
The patch updates the documentation to reflect the fact that higher values of client_min_messages (fatal + panic) are valid and also fixes a slight issue with how psql tried to display error messages that aren't sent to the client. We often tell people to ignore errors in response to

Re: [PATCHES] [BUGS] date overflows

2005-12-05 Thread Kris Jurka
On Sat, 3 Dec 2005, Michael Fuhr wrote: On Sat, Dec 03, 2005 at 07:53:23PM -0500, Kris Jurka wrote: I'm seeing some date input overflows here. Yep, I noticed this a few days ago while looking at another problem. I probably should have started a new thread. This seems to fix it. Kris

[PATCHES] parallel builds with dependencies

2006-02-10 Thread Kris Jurka
When performing a parallel build (make -j N) with ./configure --enable-depend it often tries to create the .deps directory twice and bails out when it already exists due to a race condition of if doesn't exist, then create. This patch prevents mkdir from returning an error. Kris

[PATCHES] add additional options to CREATE TABLE ... AS

2006-02-14 Thread Kris Jurka
with/without oids is now available for the EXECUTE variant. Currently you still cannot specify inheritance attributes with these commands, but this seems like a more complicated task. Kris Jurka? GNUmakefile ? config.log ? config.status ? log ? contrib/spi/.deps ? src/Makefile.global ? src/backend

Re: [PATCHES] add additional options to CREATE TABLE ... AS

2006-02-14 Thread Kris Jurka
On Tue, 14 Feb 2006, Kris Jurka wrote: This patch adds most of the options available for regular CREATE TABLE syntax to the CREATE TABLE x AS SELECT ... and AS EXECUTE ... Here's the doc changes for this. Kris JurkaIndex: doc/src/sgml/ref/create_table_as.sgml

[PATCHES] constant too large in port/gettimeofday

2006-02-15 Thread Kris Jurka
This patch fixes this warning. gettimeofday.c:35: warning: integer constant is too large for long type Kris Jurka Index: src/port/gettimeofday.c === RCS file: /projects/cvsroot/pgsql/src/port/gettimeofday.c,v retrieving

Re: [PATCHES] win codepages 1253, 1254, 1255, 1257 and cleanup

2006-02-20 Thread Kris Jurka
On Sat, 18 Feb 2006, Peter Eisentraut wrote: Kris Jurka wrote: The attached patch adds support for windows codepages 1253, 1254, 1255, and 1257 and cleans up a bunch of the support utilities. I've applied this patch but left out the changes to the Japanese encoding maps, as you suggested

Re: [PATCHES] constant too large in port/gettimeofday

2006-03-03 Thread Kris Jurka
On Fri, 3 Mar 2006, Bruce Momjian wrote: I am a little worried that some of our platforms do not support LL designations, so I applied it only to CVS HEAD. Yes, this one is probably better. Kris Jurka? src/port/.deps ? src/port/pg_config_paths.h Index: src/port/gettimeofday.c

Re: [PATCHES] [PERFORM] WAL logging of SELECT ... INTO command

2006-03-24 Thread Kris Jurka
On Fri, 24 Mar 2006, Jim C. Nasby wrote: On Wed, Mar 22, 2006 at 02:37:28PM -0500, Kris Jurka wrote: On Wed, 22 Mar 2006, Jim C. Nasby wrote: Ok, I saw disk activity on the base directory and assumed it was pg_xlog stuff. Turns out that both SELECT INTO and CREATE TABLE AS ignore

[PATCHES] pg_dump insert transactions

2006-04-12 Thread Kris Jurka
). Kris Jurka ? src/bin/pg_dump/.deps ? src/bin/pg_dump/pg_dump ? src/bin/pg_dump/pg_dumpall ? src/bin/pg_dump/pg_restore Index: doc/src/sgml/ref/pg_dump.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v

Re: [PATCHES] [BUGS] BUG #2401: spinlocks not available on amd64

2006-04-27 Thread Kris Jurka
Bruce Momjian wrote: Great, changes attached and applied. I removed the solaris_i386 and solaris_x86_64.s files and made just one solaris_x86.s. I updated the build system to use the new file, updated the macros, and added some documentation on the approach. Thanks. Would you test current

[PATCHES] 7.3 contrib/ltree compile

2006-07-13 Thread Kris Jurka
A recent backpatch to 7.3's contrib/ltree got mixed up, putting code in the wrong place. This moves it to the right place which allows it to compile. Kris Jurka Index: contrib/ltree/_ltree_gist.c === RCS file: /projects/cvsroot

[PATCHES] include compile problems

2006-07-13 Thread Kris Jurka
The attached patch makes the tree build for me again after the recent include changes. This patch still violates the postgres.h before all system headers rule and I'm still not sure what changed that broke everything, but if people need to get work done this may help. Kris JurkaIndex:

Re: [PATCHES] include compile problems

2006-07-13 Thread Kris Jurka
platform are you using? I tested on Solaris 9 with Sun compiler and Debian unstable with gcc-4.1.1. Debian only failed on contrib while Solaris failed on both core and contrib. Kris Jurka ---(end of broadcast)--- TIP 5: don't forget

[PATCHES] build with different options than Bruce

2006-07-14 Thread Kris Jurka
When building with --enable-cassert, without --enable-thread-safety, or when the OS supports USE_WIDE_UPPER_LOWER we need some more include files. Kris JurkaIndex: src/backend/storage/buffer/buf_table.c === RCS file:

[PATCHES] toast index entries again

2006-07-14 Thread Kris Jurka
The inclusion of access/tuptoaster.h in access/common/indextuple.c brought in the define of TOAST_INDEX_HACK which compresses large index entries. When this was removed the entries were no longer compressed which caused btree_gist to fail. Kris JurkaIndex:

Re: [pgsql-patches] uuid patch 3.0 (8.3devel)

2007-01-28 Thread Kris Jurka
tomorrow. We need some more work on the uuid feature (e.g. generator functions and documentation), but that can be done shortly. This fails on Solaris 9 buildfarm members kudu and dragonfly because they do not support the hh scanf modifier using in UUID_FMTx. Kris Jurka

[PATCHES] lo_truncate

2007-02-22 Thread Kris Jurka
The attached patch implements lo_truncate for truncating large objects to a given length. This is required for implementing Blob.truncate in the JDBC driver[1] and rounds out filesystem like functionality for large objects. Kris Jurka [1] http://java.sun.com/javase/6/docs/api/java/sql

Re: [PATCHES] lo_truncate

2007-02-28 Thread Kris Jurka
On Wed, 28 Feb 2007, Bruce Momjian wrote: Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. Here's a patch that works with

[PATCHES] Remove warning about const qualifier

2007-04-16 Thread Kris Jurka
The attached patch removes this warning: encnames.c:511: warning: passing argument 1 of 'clean_encoding_name' discards qualifiers from pointer target type Kris JurkaIndex: src/backend/utils/mb/encnames.c === RCS file:

Re: [PATCHES] Remove warning about const qualifier

2007-04-16 Thread Kris Jurka
On Mon, 16 Apr 2007, Tom Lane wrote: Kris Jurka [EMAIL PROTECTED] writes: The attached patch removes this warning: encnames.c:511: warning: passing argument 1 of 'clean_encoding_name' discards qualifiers from pointer target type Applied, but I've not seen that warning myself ... what

[PATCHES] GSS warnings

2007-09-05 Thread Kris Jurka
argument 2 of 'gss_release_cred' from incompatible pointer type Parts of the GSS API want the object while others want pointers to the object and it looks like this code got it backwards. I haven't tested these changes, but they look right to me. Kris Jurka? src/backend/libpq/.deps Index

Re: [PATCHES] GSS warnings

2007-09-05 Thread Kris Jurka
On Wed, 5 Sep 2007, Tom Lane wrote: Kris Jurka [EMAIL PROTECTED] writes: Parts of the GSS API want the object while others want pointers to the object and it looks like this code got it backwards. I haven't tested these changes, but they look right to me. Wouldn't the code fail entirely

Re: [PATCHES] Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

2007-11-29 Thread Kris Jurka
, but it wasn't built shared, so I can't test plperl. I ran the test case Greg posted to the perl bug tracker and it doesn't fail, so unless you're concerned that your change will break 5.6, then it doesn't look like 5.6 needs a fix. Kris Jurka ---(end of broadcast

[PATCHES] tsvector prints pointer difference as int

2008-03-09 Thread Kris Jurka
The tsvector code is printing a pointer difference as an integer, generating the following warning: tsvector.c: In function 'tsvectorin': tsvector.c:225: warning: format '%d' expects type 'int', but argument 2 has type 'long int' I was thinking the %td specifier wasn't well supported