[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 enough

Re: [PATCHES] Proposed patch: synchronized_scanning GUC variable

2008-01-28 Thread Kris Jurka
maintaining table dump order is that rsyncing backups to remote locations will work better. Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

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

2007-11-29 Thread Kris Jurka
ut 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 --

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 co

[PATCHES] GSS warnings

2007-09-05 Thread Kris Jurka
85: warning: passing 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 J

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 wa

[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: /projects/c

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] 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: [pgsql-patches] uuid patch 3.0 (8.3devel)

2007-01-28 Thread Kris Jurka
patch 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_FMT

[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: src/backend/access/common/indextupl

[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: /projects/cvs

Re: [PATCHES] include compile problems

2006-07-13 Thread Kris Jurka
at 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 t

[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: contr

[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/cv

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 CVS

[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

[PATCHES] schema-qualified SET CONSTRAINTS

2006-04-10 Thread Kris Jurka
The attached patch allows SET CONSTRAINTS to take a schema qualified constraint name (myschema.t1_fk_t2) and when given a bare constraint name it uses the search_path to determine the matching constraint instead of the previous behavior of disabling all identically named constraints. Kris

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

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] 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 sugg

[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

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

2006-02-14 Thread Kris Jurka
SELECT options actually simplifies the grammar by removing the WithOidsAs production hack. Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

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

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

2006-02-14 Thread Kris Jurka
/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

[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 JurkaIndex:

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.

[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 request

[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=canary&dt=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_

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&#

Re: [PATCHES] fixing REL7_3_STABLE build issues

2005-07-16 Thread Kris Jurka
ixed without major surgery. If this was the stated policy I know more buildfarm members would run the 7.2/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

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

2005-07-16 Thread Kris Jurka
han an actual solution. > The bug 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 o

[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 obsol

Re: [PATCHES] Blob .getBytes position should start at 1

2005-05-08 Thread Kris Jurka
*position 1 > > pqsql driver assumes the position starts from 0 > Indeed. I've put a fix in 7.4, 8.0, and HEAD branches. Thanks. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please sen

Re: [PATCHES] more fixes for making contrib null safe

2005-01-28 Thread Kris Jurka
On Sat, 29 Jan 2005, Jon Jensen wrote: > On Fri, 28 Jan 2005, Kris Jurka wrote: > > > This adds the strict function attribute to the places in contrib that > > crash on null inputs. > > Doesn't C need to be quoted? A few of those looked like this: > > LANG

[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 1

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

2005-01-25 Thread Kris Jurka
meaning in the ODBC/JDBC escape 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])

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

[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/fuzzystr

Re: [PATCHES] Implementing RESET CONNECTION ...

2005-01-04 Thread Kris Jurka
level interface should desire to do statement pooling, which will have this problem. You have not stated what client interface you are targetting, but I believe anything written to a higher level than libpq will need to be aware of this. Perhaps -patches isn't the right place

Re: [PATCHES] Implementing RESET CONNECTION ...

2005-01-03 Thread Kris Jurka
e currently have has already seen and prepared the sql 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 broadca

Re: [PATCHES] Implementing RESET CONNECTION ...

2005-01-03 Thread Kris Jurka
ned for virtually each sql execution this is key to getting 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 t

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

2004-12-27 Thread Kris Jurka
proxy connection object which wraps a real 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 po

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

2004-12-25 Thread Kris Jurka
g like PREPARE 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

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

Re: [PATCHES] contrib build fixes

2004-11-04 Thread Kris Jurka
me/jurka/tmp/pg80/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.po

Re: [PATCHES] pthread.h header check

2004-11-01 Thread Kris Jurka
On Tue, 2 Nov 2004, Bruce Momjian wrote: > I think you forgot to attach the patch. > Here you go. Kris JurkaIndex: configure.in === RCS file: /projects/cvsroot/pgsql/configure.in,v retrieving revision 1.383 diff -c -r1.383 config

[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

[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] 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 re

Re: [PATCHES] psql schema permissions

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

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

2004-06-24 Thread Kris Jurka
be fully qualified in the first place. > I seem to recall that there was some reason for using "", but I don't > recall what exactly. > It seems like the only possible reasons are deliberately making it fail or just a lack of testing. There's no way it does anything

[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 qualifie

[PATCHES] EXECUTE command tag returns actual command

2004-04-18 Thread Kris Jurka
This patch makes the EXECUTE command's completion tag return the completion tag of the actual statement executed. This allows the correct update count to be returned for UPDATE/INSERT/DELETE statements. Per discussion on hackers here: http://archives.postgresql.org/pgsql-hackers/2004-03/msg0

[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: /projects/cvsroot/pgsql-server/src/interfaces

[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

[PATCHES] Dev version doesn't acknowledge cross type indexes

2004-01-09 Thread Kris Jurka
http://developer.postgresql.org/docs/postgres/datatype.html#DATATYPE-NUMERIC Section 8.1.1 has not been updated to reflect the recent addition of indexes which can be used across type definitions. Kris Jurka Index: doc/src/sgml/datatype.sgml

Re: [PATCHES] alter schema help is not available in psql

2003-11-08 Thread Kris Jurka
Repost: On Tue, 4 Nov 2003, Kris Jurka wrote: > > in psql \h alter schema does not produce the desired help because the sgml > doc has the incorrect tag so it does not get picked up by > the create_help.pl script. > > Kris Jurka > Index: doc/src/sgml/

[PATCHES] alter schema help is not available in psql

2003-11-04 Thread Kris Jurka
in psql \h alter schema does not produce the desired help because the sgml doc has the incorrect tag so it does not get picked up by the create_help.pl script. Kris Jurka Index: doc/src/sgml/ref/alter_schema.sgml === RCS file

[PATCHES] SQLState implementation for V3 Protocol

2003-09-08 Thread Kris Jurka
ws the programmer to retrieve the SQLState via the standard getSQLState call. One thing that I am concerned about is that the message fields are separated by null bytes, but what happens when we are using an encoding that allows embedded nulls? Kris Jurka ? src/interfaces/jdbc/org/postgresql/core

Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-25 Thread Kris Jurka
mmentary on the > patch about a month 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=en&lr=&ie=UTF-8&selm=28882.1057162309%40ss

Re: [JDBC] [PATCHES] IPv6 patch doesn't work fine

2003-06-29 Thread Kris Jurka
On Sat, 28 Jun 2003, Kurt Roeckx wrote: > On Thu, Jun 26, 2003 at 08:02:01AM -0400, Kris Jurka wrote: > > > > > > On Thu, 26 Jun 2003, Manuel Gil [iso-8859-1] PĂ©rez wrote: > > > > > Hi all. > > > > > > I have a Java application that it con

Re: [PATCHES] IPv6 patch doesn't work fine

2003-06-26 Thread Kris Jurka
ing a name that resolves to an IPv6 address? You're probably the first person to actually try this. I will look into this further, but it may take me a while to get IPv6 up and running on my machine. Kris Jurka ---(end of broadcast)--