On 10 Apr 2001, Konstantinos Agouros wrote:
Hi,
I have a query running for 97hours now and I am wondering if this can be made
any faster.
The Query is:
insert into dailyreport select timestamp(date
'1-8-2001'),a.category,'Observed',sum(b.count) as count from websensebycat a,
Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3
I just don't have the patience to figure out what is going wrong here.
/usr/share/ant
Ant install made a /usr/share/java withe the jar files in it.
Java is installed on the machine as /usr/java/jdk1.3
Tony Grant wrote:
Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3
I just don't have the patience to figure out what is going wrong here.
/usr/share/ant
Ant install made a /usr/share/java withe the jar files in it.
Java is installed on the machine
"Homayoun Yousefi'zadeh" [EMAIL PROTECTED] writes:
The reason I need to compile w/ Perl
support turned on is what I am reading
in the README.rserv of the ERServer
available in contrib directory.
It says that the requirements are:
- PostgreSQL = 7.0.X
A separate Makefile is required
Does 7.1 "natively" handle large objects in dumps, restores and vaccums? In
7.0.3 there was a contrib for LOs.
Thanks,
David
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Tue, 10 Apr 2001, Stan Brown wrote:
I have been suing PostgreSQL quite happily in projects for several years
now.
Now, I am thinking about actually using the computers at home for something
useful (what a concept :-)).
So, I was wandering if anyone knows wehre I could find a few
On Mon, Apr 09, 2001 at 03:33:19PM -0700, Homayoun Yousefi'zadeh wrote:
I first ran configure with the following options
./configure --with-perl --with-tcl --enable-odbc --with-java
--enable-syslog --enable-debug
and then compiled postgresql-7.1rc4 on Redhat 7.0 successfully
with
On Tue, Apr 10, 2001 at 01:42:13PM -0400, Stan Brown wrote:
I have been suing PostgreSQL quite happily in projects for
several years now.
i have the smae porbelm -- you might wnat to solw down wehn you
tyep your email msesaegs.
Suing is quite different from Using.
:)
--
americans should
First of all, since i'm new to this mailing listHi all..!!
My first question..
I have to convert an access 97 database to pgsql...are there any tools to do
this?? I checked the website but the link for the tools are not working so i
tried to export the tables from access using the ODBC
On Tue, 10 Apr 2001, mazzo wrote:
First of all, since i'm new to this mailing listHi all..!!
My first question..
I have to convert an access 97 database to pgsql...are there any tools to do
this?? I checked the website but the link for the tools are not working so i
tried to export the
David Wall writes:
Does 7.1 "natively" handle large objects in dumps, restores and vaccums? In
7.0.3 there was a contrib for LOs.
Yes.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---(end of broadcast)---
TIP 6:
Thought that I share this with the group. Thanks Marco.
The problem was gone once I created a soft link to
JAVA_HOME/lib/tools.jar in the default directory
JAVA_HOME/jre/lib/ext/. I have not set specific CLASSPATH
variable and I could understand the problem better if
I had seen the problem when
I have a table with over 1,000,000 records in it containing names and phone
numbers, and one of the indexes on the table is a unique index on the phone
number. I am trying to copy about 100,000 more records to the table from a
text file, but I get an error on copying because of duplicate phone
On Tue, Apr 10, 2001 at 09:27:50PM +0200, some SMTP stream spewed forth:
Is there a way to perform a point in time restore with postgresql ?
Nope, not yet anyway, to the best of my knowledge.
dan
/Claes
---(end of broadcast)---
TIP
On Tue, 10 Apr 2001, Cefull Lo wrote:
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
19748 is the OID of that record, and 1 means one record was inserted.
For information on OID's, look in the documentation.
--
Dominic J.
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
No, not yet. Hopefully 7.2. You can perform a pg_dump anytime, though.
Is there a way to perform a point in time restore with postgresql ?
/Claes
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian
On Tue, 10 Apr 2001, Poet/Joshua Drake wrote:
I've been experimenting a bit with Full Text Indexing in PostgreSQL. I
have found several conflicting sites various places on the net pertaining
to whether or not PostgreSQL supports FTI, and I was hoping I could find
an authoritative answer here
On Tue, 10 Apr 2001, Cefull Lo wrote:
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
It's the OID, a unique idenifier for everything in the database.
Read the Momjian book on the website -- it explains this very well.
--
Joel
On Tue, 10 Apr 2001, Joe Johnson wrote:
I have a table with over 1,000,000 records in it containing names and phone
numbers, and one of the indexes on the table is a unique index on the phone
number. I am trying to copy about 100,000 more records to the table from a
text file, but I get an
The following function doesn't work when called multiple times:
CREATE FUNCTION foo(INTEGER) RETURN BOOLEAN AS '
DECLARE
y INTEGER;
BEGIN
CREATE TEMP TABLE a (
x INTEGER
);
INSERTINTO a
VALUES(4);
SELECTINTO
The reason I need to compile w/ Perl
support turned on is what I am reading
in the README.rserv of the ERServer
available in contrib directory.
It says that the requirements are:
- PostgreSQL = 7.0.X
A separate Makefile is required for PostgreSQL 7.0.x and earlier
- Perl5 and the
I have the following table, containing about 57 Rows, but some
indexes are not used, on 7.1RC4, freshly vacuumed (analyse). It was the
same at least in 7.1RC1
CREATE TABLE access_log(
access_time timestamp NOT NULL DEFAULT NOW(),
method_num int2NOT
Furthermore, after trying to just index on a 8191-character long substring
of the resume, I run into the following:
ERROR: btree: index item size 3948 exceeds maximum 2713
The only way I could actually get the index created was to substring the
body of the resumes down to 2k. I also later
24 matches
Mail list logo