Re: [GENERAL] Errors in other languages

2001-02-22 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Luis Magaña writes: > > > It is possible to display error messages from PostgreSQL in other > languages rather than English ? > > No The JDBC driver does return it's own error messages in French, Dutch and Italian if the VM is in one of those lo

Re: [GENERAL] jdbc connection pool settings

2001-02-13 Thread Peter T Mount
Quoting Culley Harrelson <[EMAIL PROTECTED]>: > I'm in the process of implementing connection pooling > and the setup I'm using (http://www.javaexchange.com - > really slick!) has settings for min # connections and > max # connection. Any suggestions on where I should > set these values? min=2,

Re: [GENERAL] How to make PostgreSQL JDBC drive get PGTZ?

2001-02-13 Thread Peter T Mount
Quoting Raymond Chui <[EMAIL PROTECTED]>: > > My system time zone (TZ) is set to US Eastern Standard Time is -5 hours > of > GMT time > > I set > export PGTZ=GMT > then go to psql do > > insert into a_table (a_column) values ('2001-02-08 18:30:00+00'); > select a_column from a_table; > > will

Re: [GENERAL] Auto-timestamp generator (attached)

2001-02-08 Thread Peter T Mount
Quoting Einar Karttunen <[EMAIL PROTECTED]>: > I think that modules like this could be included in the distribution or > archieved at the ftp. They'd make it easier for people new to sql to > start using postgresql. Also there would be no performance loss in > the backend code, as these "modules"

Re: [GENERAL] JDBC & geo objects

2001-02-01 Thread Peter T Mount
Quoting elein <[EMAIL PROTECTED]>: Redirecting to the jdbc list... > > I'm a Java novice and I would like to be able to > use JDBC to get Points and Paths into a Java > program as native Java objects. Note that the > binary form of Paths is more than a simple array. > > I know how to do thi

Re: [GENERAL] jdbc, use of nested ResultSet loops.(longish, interesting I hope)

2001-01-30 Thread Peter T Mount
Quoting "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > A few days ago I posted a query regarding a problem I had with errors I > was > incurring doing some nested queries with the jdbc driver. (having > recently > done a re-install my email history is in limbo for the moment) > > Found some of my

Re: [JDBC] [GENERAL] JDBC: java.lang.ArrayIndexOutOfBoundsException: 256

2001-01-25 Thread Peter T Mount
Quoting Mirko Zeibig <[EMAIL PROTECTED]>: Redirecting to the jdbc only list as that's where all jdbc emails should now go. > Hello, > my system: > RedHat 7.0 > postgresql 7.1 (CVS) > IBMJava2-SDK-1.3-1.1 > > After having set JAVA_HOME "ant" is working like a charm, now it will > build > postgre

Re: [GENERAL] Connection pooling

2001-01-25 Thread Peter T Mount
Quoting Guillaume Lémery <[EMAIL PROTECTED]>: > Hi, > > my database has to handle quickly several number of queries per second > from numerous clients. > Because of the waste of time for connection/disconnection, Im' looking > for a connection pooling tool. > > Where can I find a such tool or

Re: [GENERAL] Why does the JDBC driver not support prepareCall?

2001-01-19 Thread Peter T Mount
Quoting "Brett W. McCoy" <[EMAIL PROTECTED]>: > On Fri, 19 Jan 2001, mg wrote: > > > I have troubles with jsp-based websites that have been generated by > > Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the > > problem lies in the JDBC driver not supporting prepareCall > (prepar

Re: [GENERAL] Unanswered questions about Postgre

2000-12-12 Thread Peter T Mount
Quoting Tom Lane <[EMAIL PROTECTED]>: > The JDBC support for over-the-wire access to large objects used to > have some bugs, but AFAIK those are cleaned up in current sources > (right Peter?) Yes except for DatabaseMetaData.getTables() but thats not directly to do with large objects. As long a

Re: [GENERAL] Large files on linux

2000-12-12 Thread Peter T Mount
Quoting Fernan Aguero <[EMAIL PROTECTED]>: > Dear all: > > I am having trouble with large files on a Linux box (RH 6.2). I know > there > is a limit of 2 GB on the file size, but do not know if this is kernel > related, filesystem related or both. IIRC Partly Kernel, Partly FileSystem. For la

[GENERAL] Re: PostgreSQL Install

1999-06-03 Thread Peter T Mount
lem might be and how to solve it? Do you know anyone who > can help me to solve this problem ? > > I appreciate your help. > Sincerely > George Titan > -- Peter T Mount [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq:

Re: [GENERAL] Tree structure

1999-02-26 Thread Peter T Mount
ptr --- 1 - 2 - 3 -- 4 5 - 6 - 7 (7 rows) Turning off headings and alignment: test=> \a turned off field alignment test=> \t turned off output headings and row count test=> select textcat(text_substr('----- '::text,10-pointer,pointer+1)

Re: [GENERAL] GIS/GPS Experiences with pgsql?

1999-02-19 Thread Peter T Mount
On Thu, 18 Feb 1999, Gregory Maxwell wrote: > On Wed, 17 Feb 1999, Peter T Mount wrote: > > [snip] > > If the TIGER/Line data is raster, and each feature (polygon, line, > > circle, etc) doesn't exceed the block size, then postgresql should be able > > to han

Re: [GENERAL] GIS/GPS Experiences with pgsql?

1999-02-17 Thread Peter T Mount
:-) If the TIGER/Line data is raster, and each feature (polygon, line, circle, etc) doesn't exceed the block size, then postgresql should be able to handle it. I have in the works some Java code to draw the geometric types, and some GPS code as well, but it's mainly aimed at the Astrono

[GENERAL] Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.

1999-02-08 Thread Peter T Mount
> where my_db is substituted for my database name: > > host my_db 0.0.0.0 0.0.0.0 ident sameuser > > I'm still getting the same 'User authentication failed' messages. Same thing > from JDBC. Do I need access to the 'template1' table also? no. Is the machine

Re: [GENERAL] Callable Statement in JDBC

1999-01-08 Thread Peter T Mount
knows if 6.4 support callable statement? Nope. CallableStatement is still unsupported, mainly because I haven't been able to figure out how CallableStatement works. -- Peter T Mount [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq: http://www.retep.org.uk/

Re: [GENERAL] Backup of large object

1998-12-28 Thread Peter T Mount
eplacing the old oid with the newly created one. My backup and restore scripts call some Java code to handle the large objects, as it's easy to save each large object directly into a compressed Zip file, with it's OID as the filename. -- Peter T Mount [EMAIL PROTECTED] Mai

Re: [GENERAL] PostgreSQL and WWW

1998-11-30 Thread Peter T Mount
t good for applets. For applets, it would be better to have your own protocol to a servlet, then jdbc to the database. -- Peter T Mount [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres Java PDF Generator: http://www.retep.org.uk/pdf

[GENERAL] Re: [INTERFACES] pb compiling JDBC interface

1998-07-09 Thread Peter T Mount
* > *http://www.mygale.org/05/ironmask * > ********* > -- Peter T Mount [EMAIL PROTECTED] or [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk Someday I may rebuild this signature completely ;-) Work Homepage: http://www.maidstone.gov.uk Work EMail: [EMAIL PROTECTED]