Patch applied. Thanks.
---
Joe Conway wrote:
> Stephen Robert Norris wrote:
> > Well, no. What it says is that certain values must be escaped (but
> > doesn't say which ones). Then it says there are alternate escape
> > se
I've moved all data to a new location using pg_dum/pg_restore,
Things seems to be working properly so far, data seems to be where it
should be and complete, I did the initdb once again using es_MX as
locale.
This was the first time I face such a problem with this Solaris
installation after 14 mon
IPC, 'interrupt procedure call'?
scott.marlowe wrote:
On Thu, 17 Jul 2003, Markus Heinz wrote:
Hello,
i'm evaluating Postgresql on win32 (winnt, win2k). I'm using a small java benchmark
from FirstSQL (see attachments).
I've ran the benchmark on three pc's
1) Pentium III 750 MHz Winnt
"Terence Chang" <[EMAIL PROTECTED]> writes:
> IC.. However, my application is critical. So is it possible to backup those
> 20 user's transactions from log? Oracle and MS SQL can recover to the
> failure point. Does PostgreSQL support that also? I mean recover from a
> transaction log and where is
IC.. However, my application is critical. So is it possible to backup those
20 user's transactions from log? Oracle and MS SQL can recover to the
failure point. Does PostgreSQL support that also? I mean recover from a
transaction log and where is the transaction log?
Thanks!
- Original Messag
What you don't get is a look at the maximum number of records when T is full and T1 is half full. How will you pull out half of the records in T1 and half of the records in T?
Shridhar Daithankar wrote:
On 16 Jul 2003 at 19:09, Kirill Ponazdyr wrote:
It is for a advanced syslog server product we
On Thu, 17 Jul 2003, Markus Heinz wrote:
> Hello,
>
> i'm evaluating Postgresql on win32 (winnt, win2k). I'm using a small java benchmark
> from FirstSQL (see attachments).
> I've ran the benchmark on three pc's
> 1) Pentium III 750 MHz Winnt Sp6a, 372 MB PC100 RAM, IBM 26GB HD 7200RPM
>
The short answer is - there is no way you can do it.
Different connections in postgres (and in every other DB engine I heard
of) can never share the same transaction.
As far as I can see, the only way to do what you want is to rethink your
architechture so that the clients never talk directly to
On 17 Jul 2003 at 16:47, Daniel Schuchardt wrote:
> 1.Client starts Transaction and does some changes.
> 2.Now the client notices that very huge operations are nescesarry and
> starts a procedure @ App-Server
> 3.App-Server reads the database and makes changes. Problem : the changes
> the client do
On Wed, 16 Jul 2003, Terence Chang wrote:
> Great! That is easier than Oracle! Now! I have no excuse not to use
> PostgreSQL. :-)
>
> I got one more question! Is there a way that I can shut down only one
> database for "Cold Backup" while other database are running like Oracle
> does?
There's re
Hi Jason,
Thats not what I mean. Both, the Client and the App-Server connects to
the same Postgres-Database. The problem a procedure like this:
1.Client starts Transaction and does some changes.
2.Now the client notices that very huge operations are nescesarry and
starts a procedure @ App-Server
Tom Lane schrieb:
Thomas Kellerer <[EMAIL PROTECTED]> writes:
But isn't that exactly the problem? Once the sequence wraps around how do I
know that id=1 is actually later then id=2 without a date column?
If you use an int8 sequence column, I doubt you need to worry about
wraparound. A date col
On Fri, Jul 18, 2003 at 03:40:25AM +0800, jerome wrote:
> im creating a page that will be queried from time to time... to output the
> results in a fast manner the easiest way is to return cached results... i was
> thinking if postgres can do this... otherwise hope the webserver (aol) can
> help
Hi Daniel,
Maybe make procedural wrappers around all events undertaken and simulate it?
ie:
1. Client connects to MS SQL Server (Application Server) and PG Server
2. SQL Server connects to PG Server aswell
3. Client begins new record process
4. New record process starts by putting PG into serial
Hello,
i'm evaluating Postgresql on win32 (winnt, win2k). I'm using a small java benchmark
from FirstSQL (see attachments).
I've ran the benchmark on three pc's
1) Pentium III 750 MHz Winnt Sp6a, 372 MB PC100 RAM, IBM 26GB HD 7200RPM
2) Pentium 4 1.4GHz Win2k SP4, 256MB RRAM, WD 2
> Searchable for what? A regexp? I'll bet you my lunch, a simple grep on a
> text file will be quicker :-)
> And you don't need to vacuum it, and/or concern yourslef with writing
> triggers ...
Well, simple Grep might find you a single occurance of the event, but as
soon as you try to correlate ma
Title: Nachricht
Hi @
all,
Our software
consists of a Client-Side App and a Application Server. Every client
owns a direct connection to the PSql-Server and for every Client the
Application-Server also creates a connection to the PSql-Server. The problem is
that it is nescesary that the C
im creating a page that will be queried from time to time... to output the
results in a fast manner the easiest way is to return cached results... i was
thinking if postgres can do this... otherwise hope the webserver (aol) can
help me..
TIA
On Thursday 17 July 2003 19:01, you wrote:
> On 18
On 18 Jul 2003 at 2:52, jerome wrote:
> is postgres capable of throwing cached results... or the right question is.. does
> postgres
> cache query results?
>
> if yes.. to both... can someone point me to a documentation that tacle this
Postgresql does not cache results. It caches data. It c
is postgres capable of throwing cached results... or the right question is.. does
postgres
cache query results?
if yes.. to both... can someone point me to a documentation that tacle this
TIA
---(end of broadcast)---
TIP 6: Have you searched o
Jim Crate <[EMAIL PROTECTED]> writes:
> on 7/15/03, Florian Weimer <[EMAIL PROTECTED]> wrote:
>
>>If I switched from signed integers to unsigned integers (and from INET
>>to "real" IPv4 addresses, consisting of the relevant 32 bits only) I
>>think I could save about 25% of my table size.
>
> Why d
That's ok I found the problem :
BEGIN WORK
ERROR: Cannot insert a duplicate key into unique index cde_lig_pkey
ERROR: current transaction is aborted, queries ignored until end of
transaction block
BEGIN WORK
I forgot a ROLLBACK...
cia
Annabelle
Annabelle Desbois wrote:
Hello,
"ERROR: cu
Hello,
"ERROR: current transaction is aborted, queries ignored until end of
transaction block"
This error occurs after a ROLLBACK in a PHP script.
All the next queries fail, so what's wrong ?
Why the ROLLBACK isn't the end of a transaction block ?
Apache 1.3.26
PHP 4.3.0
PostgreSQL 7.3.1
Thx fo
On Wednesday 16 Jul 2003 8:04 pm, Joe Maldonado wrote:
> Here it is...
> things to note:
> This table contains 1 record allways.
> The record is updated once per second.
> Every 167 seconds a vacuum analyze is run on the table
> After some time it hangs in the analyze and bl
24 matches
Mail list logo
