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
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-
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
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
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
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
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
"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
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
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
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
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,
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
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,
>
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:
> 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 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
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
> 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
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
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]:
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. 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:
>
> >
> >
23 matches
Mail list logo
