[GENERAL] Re: InputStream as parameter not supported

ve autocommit turned off? I appearantly have to send both a "COMMIT" statement to the back end and then execute the Connection's commit() method to get the transactions committed. Why is that? Thanks, -- --------

[GENERAL] InputStream as parameter not supported

the 7.1 JDBC driver that would occassionally produce the "InputStream as parameter not supported" error? Thanks -- -------- Travis Bauer | CS Grad Student | I

[GENERAL] Re: PL/Perl Question

ommands are included. -- -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer Hitesh Patel ([EMAIL PROTECTED]) wrote: > I need to be able to execute SQL

[GENERAL] Re: plperl and sqrt.

akefile.PL script which would allow people to customize the operation mask that plperl.so uses. I have to use the :base_math mask because I need sqrt. When plperl is re-enabled in the configure script, it should be added there too. -- ---- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

[GENERAL] plperl and sqrt.

code which calls sqrt. Can someone tell me how to get around this? Thanks, -- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL] [HACKERS] pg_connect error

When you compiles php, did you ./configure with --with-pgsql? If you did not compile php explicitly telling it to includ pgsql support, it probably didn't. Travis Brian Edginton ([EMAIL PROTECTED]) wrote: > > > I'm trying to use the php/postgresql interface via my apache server. > When I tr

Re: [GENERAL] web programming

I'm using postgres through JDBC as the backend for my research so I have a great interest in having a better driver. I'll pitch in. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.ed

Re: [GENERAL] Re: R: PostgreSQL book

I'll second Bookpool for computer books. I've used them a couple of times and they are good. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer --

Re: [GENERAL] Lock problem on Solaris

Tom, Thanks. Running ipcclean fixed it right away. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Mon, 9 Oct 2000, Tom Lane wrote: > Tra

[GENERAL] Lock problem on Solaris

hanks, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL] Command names

;s web site for people who wanted it. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Thu, 28 Sep 2000, Keith L. Musser wrote: > I know all of you

[GENERAL] Change to DatabaseMetaData.java for the jdbc2 driver (fwd)

I sent this to PATCHES last week, but it did not show up on the list. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer -- Forwarded message

Re: [GENERAL] Error with tcp/ip networking

nd why they didn't show up in ps or ps -a. Thanks,. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Thu, 31 Aug 2000, Tom Lane wrote: > > Well, the /tmp files are for non-

[GENERAL] Cursors and JDBC

Does the JDBC driver support the user of cursors in postgresql 7.0.2? Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

[GENERAL] cron jobs not requiring password

I have a postgresql 7.0.2 server running on a linux box. I have a number of views that I have converted to tables in order to improve performance. I need these tables to be deleted and re-created daily and using a script through cron would work beautifully. Is it possible to require all used to

[GENERAL] Help on analyzing performance problem.

I have a problem with a _very_ slow query. I'm not sure how to understand the explain output. Can anyone tell from the following where I might look for a bottleneck in the system? Thank, Travis psql:test.sql:1: NOTICE: QUERY PLAN: Nested Loop (cost=3.03..240.90 rows=4 width=124) -> Neste

Re: [GENERAL] sql question

Thanks, Now that you mention it, I even remember reading it in the book! Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Wed, 12 Jul 2000, Ross

Re: [GENERAL] Slashdot discussion

. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Tue, 11 Jul 2000, Peter Eisentraut wrote: > > Is anyone else noticing this: Everytime this sort of thing come

Re: [GENERAL] [NOVICE] newbie problem on creating table

. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Mon, 10 Jul 2000, Thomas Krebs wrote: > > >I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. > > I did that just 2 weeks ago. >

Re: [GENERAL] view permissions problem - featuer or bug?

select statement), you get a permission denied error. The workaround I did was to create a bunch of extra subview which user1 has access to. This works, but seems like the above scenerio shouldn't be causes the permission violation. -----

[GENERAL] view permissions problem - featuer or bug?

ermissions. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

[GENERAL] Hiding table structure

. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

[GENERAL] sql select challenge

k you, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL] Precision of calculated numeric fields

. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Tue, 6 Jun 2000, Tom Lane wrote: > > Sounds like the jdbc driver also gets confused when it sees typmod -1 > for a numeric field. >

[GENERAL] Precision of calculated numeric fields

driver takes _forever_ to retrieve these fields into big decimal. 3. I really don't want to reconfigure my database to use floating points :) Thanks, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL]

Ooops. I have to withdraw that comment. I spent hours the other day beating my head against the wall over this. I was sure that it didn't work . . . Sorry, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~tr

Re: [GENERAL] 7.0 installation problem, help please :-(

code? Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Tue, 23 May 2000, Chris Chan wrote: > > I'm pgsql newbie. I try to install the pgsql 7.0 on my Solaris 8 x86 server > but fail. The fol

Re: [GENERAL] RPM troubleshoot

rks much better. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer > Original Message > Date: Fri, 19 May 2000 23:19:25 PDT > From: "santosh behera" <[EMAIL PROTECTED]> &

[GENERAL] Error in manual

ction can be quite frustrating. -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

[GENERAL] getting libperl.so

configured properly on my machine. I'm using Mandrake 7.0, and the only copy of libperl.so that I can find is in: /usr/lib/apache (thanks to the mod-perl rpm). How do I get libperl.so so I can compile plperl? Thanks, -------- Travis

[GENERAL] array data types and performance

itten in C++. If there a performance cost to using routines in shared libraries? -------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL] Problems compiling version 7

I have tr version 1.22 (GNU texutils). It is located in /usr/bin, and is found by my login shell (cshrc). How could I check the locale setting? Thanks, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer

Re: [GENERAL] problem with nested views

Thank you, I think that is what it is. I noticed that when the view fails, it the values that are incorrect are sums of what should appear in multiple records. Is there any obvious way around this problem? Thanks, Travis Bauer

Re: [GENERAL] problem with nested views

help me a lot. If this doesn't work, my Java application has to do a lot more work. I'm trying to pass off these calculations to the database. -------- Travis Bauer | CS Grad Student | IU |www.cs.

[GENERAL] problem with nested views

, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer