At 07:56 28/03/01 -0500, chris markiewicz wrote:
>Hello.
>
>I am occasionally (seemingly randomly) seeing the following error when I try
>to load a large object.
>
>FastPath call returned ERROR: lo_close: invalid large obj descriptor (0)
You must setAutoCommit(false) before using any large objec
At 09:43 16/03/01 -0500, Raymond Chui wrote:
Delayed as I only read General once in a while - jdbc mails should go to
the jdbc list.
>I have PostgreSQL jdbc7.0-1.2.jar JDBC drive.
>
>I found out if a column of a table is Timestamp data type
>
>Properties p = new Properties();
>p.put("PGTZ", "GM
Which version of the driver are you using?
There's a problem with DatabaseMetadata.getTables(). As I'm rewriting all
the queries in that class on Saturday, this should dissapear in 7.1.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: [EMAIL PROT
On 18 Oct 2000, Gunnar R|nning wrote:
> Peter Mount <[EMAIL PROTECTED]> writes:
>
>
> > > couldn't produce a full patch using cvs diff -c this time since I have
> > > created new files and anonymous cvs usage doesn't allow you to
> > > adds.
On Mon, 16 Oct 2000, Bruce Momjian wrote:
> Peter, where are we on this?
Did it some time ago. I've just retrieved the email from my laptop
and checked it against cvs, and it's in there.
Peter
> [ Charset ISO-8859-1 unsupported, converting... ]
> > Ok, I've added it to the list of things to ch
On Tue, 17 Oct 2000, Rick Roberts wrote:
> What's the trick to getting it to compile?
> I'm on Linux 6.2, using JDBC2.
It depends on the version of the driver.
In most 6.5 & 7.0 you type:
make jdbc2
In 7.1, you have 3 options. The easiest is:
make
while:
make jdbc2
On Mon, 16 Oct 2000, Bruce Momjian wrote:
> I think the problem is using kaffe. I downloaded the jdbc binary from
> Peter's web site at:
>
> http://www.retep.org.uk
>
> and that worked with kaffe. Seems kaffe can not handle dependencies
> properly.
Yes, kaffe cannot handle compiling tw
On Thu, 12 Oct 2000, Bruce Momjian wrote:
> > Could you please put the ISBN on the web page:
> > http://www.postgresql.org/docs/awbook.html
> > I know I can get it from Amazon or whatever, but it would save people the
> > extra trip.
>
> Done.
>
> ISBN 0-201-70331-9
>
> >
> > Anyway,
On Wed, 11 Oct 2000, Robert D. Nelson wrote:
> >> Heaven help you if you order it from Amazon with a real email address.
> >>
> >> After about a year and a half of trying to get them to stop spamming
> >me, I
> >> simply gave up and dropped the email account.
> >
> >I've always used a disposa
On Tue, 10 Oct 2000, Marc SCHAEFER wrote:
>- ability to have databases bigger than the host's maximum file size
This has been in there since the old postgres days (although we did find
it have a problem with Linux and files exactly 2Gig). PostgreSQL now
splits tables at the 1Gb level, so tab
On Tue, 10 Oct 2000, Keith L. Musser wrote:
> jdbc7.0-1.2.jar 1.89 ms5.0 ms 3.9 ms
> postgresql.jar (191450 bytes)1.36 ms3.1 ms 3.2 ms
> postgresql.jar (204223 bytes)1.78 ms3.9 ms 4.1 ms
>
> In Test #2 w/ GC, I purposefully ran System.gc() every 1
On Tue, 3 Oct 2000, Keith L. Musser wrote:
> Where can I get the source for the JDBC driver?
It's part of the main source tree (src/interfaces/jdbc).
>
> -Original Message-
> From: Peter Mount <[EMAIL PROTECTED]>
> To: Gunnar R|nning <[EMAIL PROTECTED]>
On 2 Oct 2000, Gunnar R|nning wrote:
> Peter Mount <[EMAIL PROTECTED]> writes:
>
> > I'm now off work for the next two weeks (off sick that is), so I'll have
> > some more time now to get the driver up to date. I'm finishing off the
> > outstand
On 2 Oct 2000, Gunnar R|nning wrote:
> Peter Mount <[EMAIL PROTECTED]> writes:
>
> >
> > For JDBC2, I'm planning (may get done for 7.1) an alternate ResultSet
> > class that uses cursors. This would speed things up as the entire
> > resultset isn
On 2 Oct 2000, Gunnar R|nning wrote:
> Peter Mount <[EMAIL PROTECTED]> writes:
>
> > Our concurrency is done by locking against the pg_Stream object. As there
> > is only one per connection this works (as it prevents the network protocol
> > from getting messed
On 28 Sep 2000, Gunnar R|nning wrote:
> Tim Kientzle <[EMAIL PROTECTED]> writes:
>
> > > I'm finding that ... my CPU spends about 60% of the time in JDBC, and about
> > > 40% of the time in the postmaster backend.
> > > (Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/
> >
On Fri, 15 Sep 2000, Andreas Tille wrote:
> On Thu, 14 Sep 2000, chris markiewicz wrote:
>
> > could this be a servlet/thread issue? i cannot tell from the code snippet,
> Solved. I really stupidly forgot an rs.next() :-(((.
>
> > but remember that variables in a servlet with class scope are
A few months ago I posted to either the hackers or interfaces list
instructions on how to get MSSQL7 to talk to PostgreSQL (using the ODBC
driver) and to use the DTS (Data Transform Services) to transfer data
between them.
It should be on the archives or in the docs.
Peter
On Sat, 9 Sep 2000, R
Due to me moving home and my day job taking
precedence, I've not had chance to do anything since 7.0, so there is no
difference between 7.0, and 7.0.2.
I'm working though the backlog of patches & bug
fixes at the moment. I had hoped to have something online last night, but I'm
still havin
Not directly (by methods), but you can use them as you would elsewhere.
Issue the relevent sql to declare the cursors, and fetch the results using
Statement.
Peter
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
Post
Ah servlets. The CLASSPATH variable doesn't work with them. Copy the .jar
file into the JDK's lib/jre/ext directory, and it should then work.
Peter
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: htt
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
- Original Message -
From: "Jackson Ching" <[EMAIL PROTECTED]
getTimestamp() has always given us some problems. As you compiled from
source, try getting the current cvs repository. There's a couple of bug
fixes, including the current getTimestamp() fix.
Peter
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.rete
andle the sql &
blobs separately but still have everything backed up.
PS: Backups is formost on my mind at the moment - had an NT one blow up in
my face on Monday and it wasn't nice :-(
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not
ng file).
http://www.goice.co.jp/member/mo/formats/tar.html has a nice brief
description of the header.
As for a C api with a compatible licence, if needs must I'll write one to
your spec (maidast should be back online in a couple of days, so I'll be
back in business development wise
As usual when replying from here, replies prefixed with PM:
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-Original Message-
From: Lamar Owen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000
On Tue, 18 Apr 2000, Lincoln Yeoh wrote:
> At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
> >On Mon, 17 Apr 2000, Adam Ruth wrote:
> >
> >> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
> >> > 6.5.3 tables are stored as s
On Tue, 8 Feb 2000, Brian Piatkus wrote:
> I am constructing a large ( by some standards) database where the largest table
> threatens to be about 6-10 Gb on a Linux system. I understand that postgresql
> splits the tables into manageable chunks & I have no problem with that as a
> workround for
On Mon, 24 Jan 2000, Ron King wrote:
> Hello Everyone,
>
> I want to build a prototype system under 32-bit Linux using
> a table that would be about 20GB with PostgreSQL. I looked
> through the archives and saw talk about a patch for PostgreSQL
> to fix a bug with tables > 2Gb. If the system wor
On Fri, 15 Oct 1999, soundar rajan wrote:
> Hi,
>
> I'm using postgresql under Linux with jdk1.2. When I
> try to 'make' under /src/interfaces/jdbc to get the
> jdbc driver, I get the java.version to be 1.0b4. But,
> this output doesn't generate any driver, or in fact
> the postgresql.jar file
On Tue, 12 Oct 1999, Yin-So Chen wrote:
[snip]
>
> I don't know how SP is implemented since none of the commercial RDBMS
> publishes their sources, but they've all claimed that SP saves parsing
> time and saves query plan time (it's generated once and stored). Need
> some database experts to ve
On Mon, 27 Sep 1999, David Warnock wrote:
> Bruce,
>
> As I am not going to be able to help on the coding I won't try to
> comment on it's dificulty.
>
> But I will ask what realistic expectations are for the current NT port
> using cgywin. My current concern is that the installation is very
>
On Wed, 15 Sep 1999, Robert Wagner wrote:
> Hello all,
>
> Ran into this while regression testing my app.
>
> Does anybody know if this is a physical limitation of postgress, or is this
> a parameter to the database that I can change? Kinda limits the database's
> usefulness in the real world.
On Tue, 31 Aug 1999, you wrote:
> what bugtrackign system? if you are referring to keystone, we trashed it
> over a month ago...
It's still on the web site (at least at midday UK time it was).
> On Tue, 31 Aug 1999, Michael Simms wrote:
>
> > Hi
> >
> > I was wondering what the situation is w
On Mon, 16 Aug 1999, Martin Weinberg wrote:
> Currently, pgsql 6.5.x breaks up the files containing
> tables into roughly 1 GB chunks. My question is: will
> pgsql do the same for the files containing the indices?
It should do, as it's the StorageManager that does the splitting, and
tables/ind
On Sat, 7 Aug 1999 [EMAIL PROTECTED] wrote:
> Does anyone know of a source for some sample code for using jdbc or an
> online tutorial?
There's an entire directory of examples included with the source code.
Peter
--
Peter T Mount [EMAIL PROTECTED]
Main Homepage: http://www.retep.o
Because most of my own code is Astronomical based, any of my time code
treats the skipped days in 1582 as invalid.
However, I think we should be careful with postgres, as anyone who is
storing dates for historical purposes, may be recording the dates for a
region who didn't change on that date (i
On Mon, 22 Jun 1998, Brian wrote:
> I am trying to convert a table into PostgresSQL from MySQL, and had a few
> questions:
[snip]
> 2. Does postgres support anything even like a "blob" data type?
yes and no. I posted an experimental blob type (actually its lo) just over
a week ago, and it shou
On Tue, 2 Jun 1998, Peter Cordone wrote:
> I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> find a graphical tool that I can use to do my database table design, in
> XWindows or one that I can run in Microsoft Windows NT over my network.
>
> Can anyone suggest anything?
That sounds like a good idea.
How about having them stored in a new system table (say pg_errormsg) which
contains each possible error in all the supported languages. That way, you
can have multiple language support when users from different countries use
the same server?
I have done (in other pr
k
On Sun, 17 May 1998, Ricardo Romero wrote:
> Hi.
>
> postgreSQL instaled since 15/may/98 on FreeBSD 2.2.5
>
> # su - pgsql
> $ postmaster -S
try:
$ postmaster -S -i
> $ createdb mydb
instead of createdb, try:
$ psql template1
...
template1> create database mydb;
> Connection to databas
41 matches
Mail list logo
