Thanks. I have access to the Statement object that issued the original
query. I used the latest JDBC driver for PostgreSQl7.3 and JDK1.4 and I
used threads to achieve it. Thanks once again.
prahalad
On Thu, 11 Dec 2003, Kris Jurka wrote:
>
>
> On Tue, 9 Dec 2003, H A Prahalad wrote:
>
> >
> >
Hello All,
I am having the following problem in PostgreSQL build
process. If anyone came across this, pls give me a
solution to solve this.
I followed the steps below given at the build time.
1) postgresql-7.3.5 source files are downloaded from
postgresql.org
2) Issued the commands from that loc
Thanks Tom. That got rid of the 'ar' error, but here's the new one that
subsequently occurs :
-
/var/tmp/ccECcaaa.s:2139:Parameter error: r0 not allowed for parameter 2
(code as 0 not r0)
make[4]: *** [xlog.o] Error 1
make[3]: *** [transam-recursive] Error 2
make[2]:
On Tue, 9 Dec 2003, H A Prahalad wrote:
>
> Hello,
> I want to know whether PostgreSQL support cancel() [cancel
> JDBCStatement]. I want to abort a long running query issued/executed by a
> java application using JDBC driver to connect to the database. Thanks.
>
The JDBC driver does suppo
> Ok, I see what you're trying to do. In looking at this it occurs to me
that one
> of the way to aid in this effort is through more tech documents. For
instance,
> I have asked before what is the recommended procedure or stategy for
recovering
> a database that has "crashed". Something like th
I've recompiled without the patch and all is fine now. I'm sorry for
waisting your time...
On Thu, 11 Dec 2003, Tom Lane wrote:
> Andrei Ivanov <[EMAIL PROTECTED]> writes:
> > It's an almost clean build (it has
> > http://gppl.terminal.ru/hier-Pg7.4-0.3.tar.gz in it)...
>
> That's your prob
On Thu, 2003-12-11 at 20:14, Michael . wrote:
> I had an error before involving a temporary table, and
> that has been taken care of...
> The last message I wrote where it seemed to have
> needed it after I added it was because of different
> \connects. Could someone please help me with this
> nex
Andrei Ivanov <[EMAIL PROTECTED]> writes:
> It's an almost clean build (it has
> http://gppl.terminal.ru/hier-Pg7.4-0.3.tar.gz in it)...
That's your problem, then; it makes incompatible changes in stored
rules. The patch should have included a catversion.h change to force
you to initdb after app
On a more serious note though I stopped doing comparisons between postgres
and mysql a long time ago. As soon as I realized that it didn't have unions
(yes I know that it does now) I never took it seriously again. But I have
noticed some very good things about firebird. Namely:
tested, solid, n
Andrei Ivanov <[EMAIL PROTECTED]> writes:
> On Thu, 11 Dec 2003, Tom Lane wrote:
>> Andrei Ivanov <[EMAIL PROTECTED]> writes:
>>> template1=# select usename from pg_user;
>>> ERROR: did not find '}' at end of input node
>>
>> There's something wrong with the ON SELECT rule for the pg_user view,
>
Hi,
I think it is time to create a pgsql-humour list where such mails can be directed..
No point wasting energy answering such questions especially when they do not
appear sincere..
Thomas Zehetbauer wrote:
Why do I have to use FOUR queries to accomplish the same result I can
get from MySQL with
John Gibson <[EMAIL PROTECTED]> writes:
> Unfortunately, I am stuck on how to get all three into the monitor table
> with the same timestamp.
Do all the work in a single SERIALIZABLE transaction. That gives you a
static, consistent view of the database for as long as you need.
Hi John,
John Gibson schrieb:
Hi, all.
I have a table which is continually updated with the latest totals. I
would like to take snapshots of some of the data in that table and store
it in a second table to run statistics on it later. What might some
ways of doing this be?
Illustrative (I ho
Hi All,
I have a very weird problem which is occurring with a VB.Net app and
PostgreSQL 7.3.1. There is a form that has a standard .Net datagrid on it
that contains some data from a table in PostgreSQL.
Now, the datagrid has functionality to allow the developer to
programmatically determine what
On Thursday 11 December 2003 12:42 am, John Gibson wrote:
> Hi, all.
>
> I have a table which is continually updated with the latest totals. I
> would like to take snapshots of some of the data in that table and store
> it in a second table to run statistics on it later. What might some
> ways of
"Michael ." <[EMAIL PROTECTED]> writes:
> [ SQL function that references a TEMP table ]
> How do I get these functions to import correctly if it
> fails due to this "current_transaction" table not
> being found?
I don't think there is any good solution in 7.3, because it will insist
on trying to
Before I begin, I think that most of us agree on the following points:
1: The PostgreSQL project is not in a position at the moment to bless
any attempt to create an official curriculum or certification.
2: The idea of patterning PostgreSQL certifications on Microsoft exams
is patently offensiv
I am curious if tablespaces are going to be seriously targeted for the next version.
It really opens up new levels of scalability and is a killer feature from an
administration perspective.
Thanks,
Brian
---(end of broadcast)---
TIP 9: the
This happend again, but now, postgresql tells me where it happens:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: select (select usename from pg_user where
usesysid = datdba) as dba, pg_encoding_to_char(enc
Mike,
You could take a look at:
http://www.oscommerce.com/
While it is not written for postgres but for mySql, it has all data base
access abstracted to a single include file, so it (potentially) could be
easy to adapt to postgres.
It is also not a finished project, but I think it's good enough al
Oliver Elphick wrote:
On Wed, 2003-12-10 at 23:01, Jean-Max Reymond wrote:
I stop the postmaster (/usr/local/pgsql/bin/pg_ctl stop) and restart the
postmaster (/usr/local/pgsql/bin/pg_ctl -D /home/local/BasePostgres/ -l
logfile -o -i start).
I have tried with and without blanks near = (
da
Hi, all.
I have a table which is continually updated with the latest totals. I
would like to take snapshots of some of the data in that table and store
it in a second table to run statistics on it later. What might some
ways of doing this be?
Illustrative (I hope) example using fruit-qty-on-
C G wrote:
Dear All,
I wonder if anyone can advise me with this problem.
1. A user logs into the database (through web, webservice, some other
piece of software) - connect(user="joe",passwd="blogs")
2. We generate a random session key which will expire in 1 hour. Put
this in table (user, SessK
23 matches
Mail list logo