[BUGS] BUG #6621: Constant Segmentation Faults in the Postmaster

2012-04-27 Thread kris
The following bug has been logged on the website: Bug reference: 6621 Logged by: Kris Bushover Email address: k...@spiceworks.com PostgreSQL version: 9.1.3 Operating system: Red Hat Enterprise Linux Server release 6.2 (Santi Description: We have been getting constant

Re: [BUGS] BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work

2008-10-17 Thread Kris Jurka
the cursor you must not have autocommit on. Since the JDBC driver uses protocol level cursors (portals), it doesn't even have the option of specifying WITH HOLD. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http:

Re: [BUGS] Deadlock condition in driver

2008-10-18 Thread Kris Jurka
On Wed, 21 May 2008, Kris Jurka wrote: On Wed, 21 May 2008, Daniel Migowski wrote: I came across a deadlock condition in the JDBC driver that rises when very large queries, containing thousends of statements are send to the server with statement.execute(). We already consider this case

Re: [BUGS] BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

2008-10-21 Thread Kris Jurka
ot;? If you still believe it's a driver problem, please post a complete test case that shows the exact create table command and java code calling getPrimaryKeys. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4586: Supporting of Binary instead Bytea for Primary Keys

2008-12-17 Thread Kris Jurka
://archives.postgresql.org/pgsql-jdbc/2008-09/msg00102.php Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4586: Supporting of Binary instead Bytea for Primary Keys

2008-12-17 Thread Kris Jurka
) at psqluuidtest.Main.main(Main..java:25) Surely you want to persist a TestTable1 instance, not the uuid itself. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

2008-12-31 Thread Kris Jurka
test case I'd be happy to look at it, but there's not much else I can do. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4598: flaw in hashCode() method implementation of Connection class in postgresql-8.3-604.jdbc3.jar

2009-01-06 Thread Kris Jurka
' hashCode method doesn't work after the connection is closed failing with a NullPointerException] Fixed in CVS. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4617: JDBC Drivers 8.2/8.3 return no ResultSet

2009-01-16 Thread Kris Jurka
, and won't just give you the final select result. For multi-command statements you should use Statement.execute() and then getResultSet or getUpdateCount until getMoreResults is false. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4638: Bug with Geometry in Array

2009-03-02 Thread Kris Jurka
eplacement. I use postgis_1.3.5.jar with postgresql-8.3-603.jdbc3.jar Right, postgis.jar is just an addon, and it's really a bug in the main JDBC driver. I have put in a fix for this bug into the JDBC driver for the next release. I've put up a copy of it here, and it should fix things for

Re: [BUGS] BUG #4891: postgresql-8.3-604.jdbc4.jar - failed to load manifest

2009-06-28 Thread Kris Jurka
following command: java -jar postgresql-8.3-604.jdbc4.jar Failed to load Main-Class manifest attribute from postgresql-8.3-604.jdbc4.jar I'm not sure why you'd expect that command to do something. The JDBC driver is a library, not an application. Kris Jurka -- Sent via pgsql-bugs ma

Re: [JDBC] [BUGS] BUG #5058: [jdbc] Silent failure with executeUpdate()

2009-09-26 Thread Kris Jurka
whole thing as you are expecting. I intend to change the driver to error out in this case. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5177: Concurrency problem in AbstractJdbc23PooledConnection

2009-11-18 Thread Kris Jurka
http://pgfoundry.org/tracker/?group_id=1000224 Kris Jurkaimport java.sql.*; import javax.sql.XAConnection; import org.postgresql.xa.PGXADataSource; public class XaCloseTest { public static void main(String args[]) throws Exception { PGXADataSource ds

Re: [BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Kris Jurka
t projects in the entire postgresql ecosystem deserve special mention on the bug reporting page. Surely there must be at least one ODBC person subscribed to -bugs. What about just asking them to be more responsive even if they don't have a solution? Kris Jurka -- Sent via pgsql-bugs mail

Re: [BUGS] BUG #5197: JDBC: selecting oid results in Exception

2009-11-20 Thread Kris Jurka
ng the negative values. Unfortunately that's failing and it's not what the user wants for this case. I imagine the user really wants to get a Long back from this. I'm going on vacation next week, but when I return, I'll make that happen. Kris Jurka -- Sent via

Re: [BUGS] BUG #5099: When MetaData is acquired, it becomes an SQL error.

2009-12-07 Thread Kris Jurka
formation from the query to the provided parameters. Its goal was just to overwrite parameters without a type (unknown), but it was actually overwriting all types which could change the query's desired behavior. In this case a safeguard to prevent that change was throwing the exception no

Re: [BUGS] BUG #5269: postgres backend terminates with SIGSEGV

2010-01-12 Thread Kris Jurka
On Tue, 12 Jan 2010, Tom Lane wrote: preparing something as trivial as a ROLLBACK is pretty silly so nobody does it. Actually the JDBC driver has been preparing BEGIN, COMMIT, and ROLLBACK since the 8.0 release. http://archives.postgresql.org/pgsql-jdbc/2006-10/msg00149.php Kris Jurka

Re: [BUGS] Possible bug with BYTEA and JDBC

2010-02-14 Thread Kris Jurka
. You've got a couple of options: 1) Change the bytea format back to the 8.4 supported format. Set bytea_output = escape in your postgresql.conf. 2) Build the JDBC driver from CVS which does support the new format. 3) Use an 8.4 server. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql

Re: [BUGS] helo

2010-02-22 Thread Kris Jurka
once rather than a half dozen times. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] psql core dump

2001-10-16 Thread Kris Houghton
nitialize () at readline.c:649 #7 0x2a954 in readline (prompt=0x5b700 "demodb=# ") at readline.c:342 #8 0x191e0 in gets_interactive () #9 0x1a110 in MainLoop () #10 0x1d22c in main () /pgsql/bin/postmaster: dumpstatus: (gdb) quit $ Kris Houghton Sun Microsystems Inc. Phone: 303-272-71

Re: [BUGS] BUG #2084: Add WIN1253 to CLIENT_ENCODING encodings

2006-06-14 Thread Kris Jurka
On Wed, 14 Jun 2006, Bruce Momjian wrote: Added to TODO list. Already done. http://archives.postgresql.org/pgsql-committers/2006-02/msg00299.php Kris Jurka ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [BUGS] Fwd: [JDBC] Diffrence between 8.0.3 and 8.1.3

2006-07-05 Thread Kris Jurka
r them: In 8.0 "SELECT ' '::varchar(3) FROM tab" retained the typmod value specified in the query, but in 8.1 it is lost and -1 is used instead. Kris Jurka ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner wil

Re: [BUGS] BUG #2514: (jdbc driver) Multiple inlined statements with

2006-07-06 Thread Kris Jurka
jar file here if you need a fix before the next official releases. http://www.ejurka.com/pgsql/jars/gr/ Kris Jurka ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData.

2006-08-04 Thread Kris Jurka
of"getColumnName()"return the column'lable,but the method of"getColumnName()" return the real column'name. please show why?thanks. My project has been used Oracle and Mysql.It's my first to use PostgreSQL. Please see the thread "Wrong column names in

Re: [BUGS] The column index is out of range in PostgreSQL + resolve

2006-08-04 Thread Kris Jurka
ution, but rather the fetching of results from the ResultSet. I imagine you are using one of the ResultSet.getXXX() methods using an improper column index. Kris Jurka ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #2593: Improper implimentation of SQLException

2006-08-29 Thread Kris Jurka
returned as the vendor error code. Perhaps the problem is that this page is referring to error codes when a more careful reading shows that it is really talking about sql state values? http://www.postgresql.org/docs/current/static/errcodes-appendix.html Kris Jurka

Re: [BUGS] BUG #2628: jdbc2

2006-09-26 Thread Kris Jurka
JDBC2 spec, but was added in JDBC3. So you'll need to download the JDBC3 version. Kris Jurka ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [BUGS] BUG #2636: JDBC error behaviour incorrect

2006-09-26 Thread Kris Jurka
On Mon, 18 Sep 2006, Kiren Pillay wrote: The following bug has been logged online: Bug reference: 2636 PostgreSQL version: 8.1.4 Operating system: Windows Description:JDBC error behaviour incorrect Details: try { DBActions db=DBActio

Re: [BUGS] JDBC driver bug PreparedStatement.setNull(int,Types.BOOLEAN)

2006-11-10 Thread Kris Jurka
org.postgresql.jdbc3.AbstractJdbc3Statement#setNull to see how this is handled. I don't believe there's any problem with it. Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[BUGS] multiple SRFs in SELECT clause.

2006-11-27 Thread Kris Jurka
eries(1,2) b; a | b ---+--- 1 | 1 1 | 2 2 | 1 2 | 2 3 | 1 3 | 2 4 | 1 4 | 2 (8 rows) Tested on 8.1.3 and CVS HEAD. Kris Jurka ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[BUGS] BUG #2806: uninstall procedures

2006-12-05 Thread kris langenback
The following bug has been logged online: Bug reference: 2806 Logged by: kris langenback Email address: [EMAIL PROTECTED] PostgreSQL version: unknown Operating system: windows xp Description:uninstall procedures Details: How do I uninstall and completely remove

Re: [BUGS] BUG #2856: Jdbc 4 connector running on JDK 1.6 should

2007-01-04 Thread Kris Jurka
s working to the JVM there just wouldn't be a way to get at it on the database side. Kris Jurka ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #2856: Jdbc 4 connector running on JDK 1.6 should

2007-01-05 Thread Kris Jurka
but I don't think that's appropriate behavior for all users. Kris Jurka ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [BUGS] BUG #3106: A problem with escaping table name pattern for DatabaseMetaData.getColumns()

2007-03-06 Thread Kris Jurka
see also for getSearchStringEscape implies to me that our implementation is wrong and it shouldn't return the doubled version and anyone interpolating text into a query must escape it appropriately including the search string escape. I'll put a fix for this into the next releas

[BUGS] setseed accepts bad seeds

2007-04-11 Thread Kris Jurka
lue which isn't going to produce a good random number stream. Kris Jurka ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] setseed accepts bad seeds

2007-04-11 Thread Kris Jurka
On Wed, 11 Apr 2007, Tom Lane wrote: Kris Jurka <[EMAIL PROTECTED]> writes: Why doesn't setseed complain when given a seed value outside of its expected range? Why should it complain? The use of the value is totally unspecified anyway. Because the user is likely using it

Re: [BUGS] setseed accepts bad seeds

2007-04-11 Thread Kris Jurka
t the mapping is one-to-one, so any user assumptions about what a specific seed value might "mean" seem broken regardless. Then please consider this patch which checks the range and maps the provided value to the entire seed space. Kris JurkaIndex:

Re: [BUGS] BUG #3278: PSQLException when using setBinaryStream via JDBC

2007-05-14 Thread Kris Jurka
is implmented. So you'll need to cast the last parameter to an integer to make it work with the current driver. Kris Jurka ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index sc

Re: [BUGS] BUG #3480: JDBC driver: getIndexInfo() returns quotes around quoted column names

2007-07-23 Thread Kris Jurka
, unlike the getColumns() method. To reproduce run the following statement in a database named "test" and the "public" schema: Fixed in CVS for 8.1, 8.2, and HEAD. Thanks for the test case. Kris Jurka ---(end of broadcast)--

Re: [BUGS] BUG #3544: SQLException from JDBC driver

2007-08-17 Thread Kris Jurka
aused by a permission denied error because you are running the tomcat server with a security policy. The driver should be placed in $CATALINA_HOME/common/lib instead of a war file. Kris Jurka ---(end of broadcast)--- TIP 7: You can help suppor

Re: [BUGS] JDBC-Interface - Behaviour on Update, Insert or Delete returning ResultSets - Inconsistency to Console & ODBC

2007-08-18 Thread Kris Jurka
y and then loop retrieving any number of results that are returned. The extended query protocol is designed around single query gives a single result, so it isn't really prepared to handle the update count and results at the same time. Kris Jurka ---(end of broadcas

Re: [BUGS] BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement

2007-08-30 Thread Kris Jurka
ql-committers/2007-03/msg00097.php Kris Jurka ---(end of broadcast)--- TIP 1: 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 cleanly

Re: [BUGS] BUG #3675: Crash on xpath function with 2 parameters

2007-10-13 Thread Kris Jurka
('/my:a/text()', 'http://example.com";>test'); This patch avoids the double free of xpathcomp and fixes things for me. Kris JurkaIndex: src/backend/utils/adt/xml.c === RCS file: /projects/cvsroot/pgsql/s

Re: [BUGS] creating a table with a serial column sets currval

2007-10-18 Thread Kris Jurka
On Thu, 18 Oct 2007, Kris Jurka wrote: jurka=# create table t (c serial); NOTICE: CREATE TABLE will create implicit sequence "t_c_seq" for serial column "t.c" CREATE TABLE jurka=# select currval('t_c_seq'); currval - 1 (1 row) I would expect

[BUGS] creating a table with a serial column sets currval

2007-10-18 Thread Kris Jurka
so: jurka=# create sequence myseq; CREATE SEQUENCE jurka=# select currval('myseq'); ERROR: currval of sequence "myseq" is not yet defined in this session Kris Jurka ---(end of broadcast)--- TIP 7: You can help support the

Re: [BUGS] creating a table with a serial column sets currval

2007-10-18 Thread Kris Jurka
xt nextval call. jurka=# create sequence s; CREATE SEQUENCE jurka=# select nextval('s'); nextval - 1 (1 row) jurka=# select setval('s',5, false); setval 5 (1 row) jurka=# select currval('s'); currval - 5 (1 row) Should retu

Re: [BUGS] BUG #3722: PSQLWarning missing call to super in CTOR

2007-11-06 Thread Kris Jurka
ror = err; } Why is this necessary? Since PSQLWarning overrides both getMessage and toString, why is the super call needed? Kris Jurka ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #3751: Conversion error using PreparedStatement.setObject()

2007-11-15 Thread Kris Jurka
urning b as Types.BIT would be a mistake. Driving this decision solely on the length attribute is not good because the server will not give you the length information in certain circumstances and all you'll have is the raw "bit" type name. This is why we've cho

Re: [BUGS] BUG #3751: Conversion error using PreparedStatement.setObject()

2007-11-15 Thread Kris Jurka
7;t get that far. Other notes: In PG the bit type is really for multiple bits, not a single bit. Consider SELECT 77::bit(8) results in "01001101". It's more likely that you want to use boolean as the type instead although it doesn't have any casts that will help you out

Re: [BUGS] BUG #3751: Conversion error using PreparedStatement.setObject()

2007-11-15 Thread Kris Jurka
; end;' language 'plpgsql' ; Kris Jurka Lance J. Andersen wrote: Sorry Bad, Cut and paste. This test is a strip down of much larger test. The reason the metadata is there as this gets run from a framework which exercises JDBC drivers from all of the major vendors which is als

Re: [BUGS] BUG #3751: Conversion error using PreparedStatement.setObject()

2007-11-18 Thread Kris Jurka
it; SELECT '1'::bit(1) UNION ALL SELECT '11'::bit(2); CREATE TABLE bittable (a bit(1), b bit(2)); SELECT COALESCE(a, b) FROM bittable; CREATE TABLE bittable2 (a "bit"); SELECT a FROM bittable2; None of these ResultSets will contain length informa

Re: [BUGS] BUG #3800: Java/Postgres PreparedStatement returns stale data

2007-12-05 Thread Kris Jurka
can adjust this by the prepareThreshold URL parameter. You can disable plan reuse by adding prepareThreshold=0. Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Kris Jurka
1638400. I don't know which is correct. You need to consider the units. guc.c is in "number of pages", while postgresql.conf is in kB. Since the page size is 8192, these are equivalent. Kris Jurka ---(end of broadcast)---

Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Kris Jurka
On Wed, 5 Dec 2007, Reece Hart wrote: On Wed, 2007-12-05 at 23:20 -0500, Kris Jurka wrote: You need to consider the units. guc.c is in "number of pages", while postgresql.conf is in kB. Since the page size is 8192, these are equivalent. I did consider that, but I'm not ce

Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-06 Thread Kris Jurka
e true default (2). Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-01-23 Thread Kris Jurka
ot;,...) to imply that you wanted a case sensitive match. Even odder would it be to do a search for a schema with a quote in it's name using SQL identifier rules in Java code. Kris Jurka ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] BUG #3897: plJava dll still doesn't load

2008-01-24 Thread Kris Jurka
On Wed, 23 Jan 2008, David Gradwell wrote: Bug reference: 3897 PostgreSQL version: 8.3rc2 Operating system: Windows Server 2003 Description:plJava dll still doesn't load Details: I've successfully installed plJava on postgres 8.2.6 using Kris Jurka's

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-01 Thread Kris Jurka
g the other metadata calls appropriately. Kris Jurka ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-12 Thread Kris Jurka
ess with the case of the object although it can be a pain to type if you writing a lot of queries by hand. Kris Jurka ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Kris Jurka
7;a', 5) || 'b'); This only works because it gets toasted before being put in the index. Since you've selected something real compressible, you can fit 50k chars into it. Kris Jurka ---(end of broadcast)--- TIP 1: if posting/

Re: [BUGS] setseed accepts bad seeds

2008-03-09 Thread Kris Jurka
On Mon, 10 Mar 2008, Tom Lane wrote: I'd be inclined to leave the mapping alone and just insert a warning (or hard error) for inputs outside the range -1 to 1. Here's a patch that errors out for out of range values. Kris JurkaIndex: doc/src/sgml

Re: [BUGS] BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver

2008-04-22 Thread Kris Jurka
accept the value and do nothing. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver

2008-04-24 Thread Kris Jurka
network connection dropping that statement_timeout can't do. In many cases statement_timeout is an adequate substitute for setQueryTimeout, but not in the general case that the JDBC driver must implement. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Deadlock condition in driver

2008-05-21 Thread Kris Jurka
into an internal size that we expect is safe from deadlock. It looks like we should be doing the same for these one query batches. I'm not sure how tough that will be, but I'll take a look. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make chang

Re: [BUGS] Deadlock condition in driver

2008-05-21 Thread Kris Jurka
call into multiple batches is that in autocommit mode you would get one transaction per batch instead of the previous behavior of one transaction for the whole execute call. Kris Jurka On Thu, 22 May 2008, Richard Evans wrote: We hit this problem and modified the driver to use non-blocking IO

[BUGS] No dependency between fkey constraint and unique index

2002-09-12 Thread Kris Jurka
(a); On a somewhat related note... CREATE UNIQUE INDEX does not add an entry to pg_constraint. Is this because unique constraints are different from unique indexes in that the index can be functional and/or partial? Would it be possible to add an entry to pg_constraint in the simple case?

Re: [BUGS] Bug #794: JDBC 7.3 PreparedStatement.setNull(..)

2002-10-08 Thread Kris Jurka
I cannot reproduce this bug on CVS tip, nor the 7.3b1 driver you mention. I know about a month ago there was a problem with batched prepared statements, but that does not seem to be the case here. Could you send a complete example or at least some context as to what comrad.database.sql.DatabaseA

Re: [BUGS] bug in create table with serial

2002-10-16 Thread Kris Jurka
doesn't seem very exciting to me ... > Unless of course the column's data type was int8. Kris Jurka ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] GEQO Triggers Server Crash

2002-12-05 Thread Kris Jurka
The following script crashes 7.4devel. SET geqo_threshold=2; CREATE TABLE t1 (a int primary key); CREATE TABLE t2 (a int); SELECT * FROM t1,t2 WHERE t1.a=t2.a; #0 0x0811001c in best_inner_indexscan (root=, rel=, outer_relids=, jointype=) at indxpath.c:1421 1421if (samese

[BUGS] Explain analyze gives bogus varno for dblink views

2002-12-05 Thread Kris Jurka
Using the old < 7.3 version of dblink on 7.4devel gives a "get_names_for_var: bogus varno 5" error. Install the deprecated version of dblink by following the directions in the dblink.sql file to comment / uncomment various parts of the script. DROP TABLE t1; CREATE TABLE t1 (a int); DROP TABLE t

Re: [BUGS] Explain analyze gives bogus varno for dblink views

2002-12-05 Thread Kris Jurka
This behavior is present in 7.3 as well. On Thu, 5 Dec 2002, Kris Jurka wrote: > Using the old < 7.3 version of dblink on 7.4devel gives a > "get_names_for_var: bogus varno 5" error. > > Install the deprecated version of dblink by following the directions in > th

Re: [BUGS] Troubles with JDBC method DataBaseMetaData.getTables()

2003-02-06 Thread Kris Jurka
find your suggestion has been implemented. Kris Jurka ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] select where id=random()*something returns two results

2003-09-18 Thread Kris Jurka
wrong. Most of the time, > I actually get 0 results. The problem is that random() is evaluated on each line giving a different result. Kris Jurka ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [BUGS] Bug #886: jdbc "update row" can mess up other columns

2003-11-03 Thread Kris Jurka
Half of this bug was fixed at some point, but an exception is still thrown when calling rs.afterLast() and then rs.previous(). Attached is a regression test addition and the appropriate fix. Sorry for the extreme delay in response and thanks for the thorough report. Kris Jurka On Fri, 24 Jan

Re: [BUGS] JDBC getImortedKeys() getExportedKeys() incorrect ON

2003-11-03 Thread Kris Jurka
this. Additionally the on delete rule would not return importedKeyRestrict because of a missing if statement. Also an addition to the test suite is attached. Kris Jurka Index: src/interfaces/jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java ===

Re: [BUGS] 7.5devel - duplicate error message

2003-11-16 Thread Kris Jurka
hould only be one error. Is there any chance you started the postmaster in the background and then started psql on the same terminal so you get one error reported to the server and one to the client? Kris Jurka ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] Build problems for PostgreSQL v7.4 on FreeBSD v4.1

2003-11-18 Thread Kris Jurka
. Not that a one liner needs one, but less work for the committers as well as getting it to the JDBC list. Kris Jurka ? src/interfaces/jdbc/blob_testoutput ? src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetMetaDataTest.java Index: src/interfaces/jdbc/org/postgr

pgsql-bugs@postgresql.org

2003-12-08 Thread Kris Jurka
1Resu > ltSet.java:102) > at This problem was fixed nearly three months ago in a patch from Kim Ho, but unfortunately the builds on jdbc.postgresql.org have not been updated in some time. This fix is in the 7.4 and HEAD cvs branches, but a source build is t

Re: [BUGS] java.lang.NullPointerException - at

2003-12-09 Thread Kris Jurka
> >>>>> at > >>>>> com.mphasis.give.common.utilities.DatabaseUtil.getConnection(DatabaseUtil.java:46) > >>>>> at com.mphasis.give.payment.CartDAO.addToCart(CartDAO.java:161)>>>>> > > >>>>>We are usi

Re: [BUGS] BUG #1005: JDBC cancelRowUpdates() sets column values to

2003-12-11 Thread Kris Jurka
ategorie 1 > > > Output after Update > > Kunde null > PLZ/Ort 6 null > Straße null > Kategorie 0 > Here's a patch to fix this. Kris Jurka ? src/interfaces/jdbc/org/postgresql/copy ? src/interfaces/jdbc/org/postgresql/jdbc2/.AbstractJdbc2ResultSet.java.swp ? src/i

Re: [BUGS] Jdbc connection pooling and PG 7.4 consistently fails

2003-12-19 Thread Kris Jurka
e /usr/share/pgsql/devpgjdbc3.jar? The RPMs do not have the correct jar file. Try one of those available from http://jdbc.postgresql.org/download.html Kris Jurka ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] Jdbc connection pooling and PG 7.4 consistently fails

2003-12-19 Thread Kris Jurka
On Fri, 19 Dec 2003, Lamar Owen wrote: > On Friday 19 December 2003 01:27 pm, Kris Jurka wrote: > > The RPMs do not have the correct jar file. Try one of those available > > from http://jdbc.postgresql.org/download.html > > At the time I put the RPMs together there were

Re: [BUGS] Jdbc connection pooling and PG 7.4 consistently fails

2003-12-19 Thread Kris Jurka
. Just putting it in a standard location (Debian uses /usr/share/java for all jars) is fine so other people/packages can adjust their classpath to use it or symlink it to another location. Kris Jurka ---(end of broadcast)--- TIP 5: Have you checke

Re: [BUGS] BUG #1026: org.apache.commons.dbcp.DbcpException: The

2003-12-23 Thread Kris Jurka
that comes up with anything interesting? (Enable log_statement in postgresql.conf and restart the server making sure the output is going somewhere other than /dev/null) What do you get from the results of the following queries when run in psql? SELECT version(); SELECT pg_encoding_to_char(1); SELECT ge

Re: [BUGS] jdbc1.AbstractJdbc1Statement.setBinaryStream bug and

2004-01-09 Thread Kris Jurka
length argument is just for informational purposes and should not be used to limit the amount of data actually read from the stream. Kris Jurka ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [BUGS] JDBC driver doesn't handle NaN values

2004-01-09 Thread Kris Jurka
oblem with positive and negative infinity, but there are some more problems as evidenced by the attached test case. Double.MIN_VALUE will cause underflow. Double.MAX_VALUE goes in alright, but comes out as POSITIVE_INFINITY when trying Float.MAX_VALUE and MIN_VALUE on a real or float4 field they ove

Re: [BUGS] jdbc1.AbstractJdbc1Statement.setBinaryStream bug and

2004-01-09 Thread Kris Jurka
On Fri, 9 Jan 2004, Martin Holz wrote: > On Friday 09 January 2004 09:46, Kris Jurka wrote: > > > The odd thing about the javadocs is that they say "The data will be > > read from the stream as needed until end-of-file is reached." The > > length parameter&#x

[BUGS] Assertion failure in current cvs

2004-01-12 Thread Kris Jurka
When the JDBC driver tries to query the information schema running against cvs head, it gets an assertion failure. The query in question is the ugly: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname LIKE 'pg\\_%' OR n.nspname = 'information_schema' WH

[BUGS] COPY allows parameters which corrupt output

2004-01-12 Thread Kris Jurka
en be read as a special character. It also allows DELIMITER and NULL to overlap. No character in the NULL specification should be the DELIMITER. Kris Jurka DROP TABLE copytest; CREATE TABLE copytest (a text, b text); INSERT INTO copytest VALUES ('t,n,g','a'); INSERT INTO c

Re: [BUGS] Assertion failure in current cvs

2004-01-12 Thread Kris Jurka
On Mon, 12 Jan 2004, Neil Conway wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > Kris Jurka <[EMAIL PROTECTED]> writes: > >> When the JDBC driver tries to query the information schema running against > >> cvs head, it gets an assertion failure. >

Re: [BUGS] jdbc1.AbstractJdbc1Statement.setBinaryStream bug and

2004-01-15 Thread Kris Jurka
ituation where the Stream was longer than the given length. Kris Jurka ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #1048: error connection to dbms from java app server

2004-01-15 Thread Kris Jurka
class involved which does not exist in either the 7.3 or 7.4 drivers. You may have an old version somewhere in your classpath. Kris Jurka ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] ResultSet.getFetchSize()

2004-01-15 Thread Kris Jurka
where it is? Kris Jurka ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] jdbc1.AbstractJdbc1Statement.setBinaryStream bug and

2004-01-16 Thread Kris Jurka
On 16 Jan 2004, Martin Holz wrote: > Kris Jurka <[EMAIL PROTECTED]> writes: > > > On Wed, 7 Jan 2004, Martin Holz wrote: > > > > > Hello, > > > > > > org.postgresql.jdbc1.AbstractJdbc1Statement.setBinaryStream() > > > in postgresql 7.4

Re: [BUGS] BUG #1065: JDBC DataSource Serializability

2004-01-26 Thread Kris Jurka
t and readObject. This problem also occurs in SimpleDataSource. I've attached the patch I've applied to the gborg cvs repository. Thanks for the report. Kris Jurka ? doc ? mine.pdf ? mybuild.xml Index: org/postgresql/jdbc2/optional/BaseDataSource.java =

Re: [BUGS] Why not (OID) in JDeveloper10g?

2004-01-30 Thread Kris Jurka
cle's product supports postgresql. If it is supposed to support pg, then the place to file the bug report would be oracle, not here. Because it uses JDBC you can probably get a connection to any database, but that doesn't mean it will actually work. Kris Jurka ---(e

Re: [BUGS] createdb fails

2004-02-03 Thread Kris Jurka
> /var/log/pgsqld.log -o -i > > > > /usr/local/pgsql/bin/createdb management <-- fails here > > /usr/local/pgsql/bin/createdb test <-- fails here > > > > > > Any help on what's causing this behavior and how to fix is appreciated. > > > > -Allen > > > > > > > > +=

Re: [BUGS] createdb fails

2004-02-03 Thread Kris Jurka
l is failing with the error that there is an open connection to template1. In your case I wonder if even though the "createdb management" client has exited allowing the code to proceed to "createdb test" call, the backend associated with this connection may not hav

Re: [BUGS] BUG #1073: JDBC "time with time zone"

2004-02-06 Thread Kris Jurka
imetz. The fix for this is a little complicated as the date/time/timestamp parsing is kind of messy, but I will try to have a patch for this sometime this weekend. Kris Jurka ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] BUG #1119: DatabaseMetaData.getTables() returns not a

2004-03-28 Thread Kris Jurka
's name ie MYTABLE won't match mytable. Another thing to try would be to put just "%" as the table name and see what happens. Kris Jurka ---(end of broadcast)--- TIP 8: explain analyze is your friend

  1   2   3   >