[SQL] Mutex via database

Hi folks, i've a dozen of servers processing jobs from a database. Some servers may only run exactly once, otherwise I'll get jobs done twice. Is there any way for implementing an kind of mutex within the database, which is automatically released if the holding process/connection dies ? t

Re: [SQL] Mutex via database

Hi, Enrico, Enrico Weigelt wrote: > i've a dozen of servers processing jobs from a database. > Some servers may only run exactly once, otherwise I'll get jobs > done twice. > > Is there any way for implementing an kind of mutex within the > database, which is automatically released if the hol

[SQL] all server processes terminated; reinitializing

Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2. Esta é a messagem gravada no meu "serverlog": WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because

Re: [SQL] all server processes terminated; reinitializing

Hallo, 2000 Informatica, 2000 Informatica wrote: > Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2. > > Esta é a messagem gravada no meu "serverlog": > > WARNING: terminating connection because of crash of another server process > > DETAIL: The postmaster has commanded this server p

Re: [SQL] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style

On May 2, 2005, at 6:09 PM, Markus Schaber wrote: 1) is it possible to know Pg backend uptime with SQL queries? Or must I look at postmaster.pid file? or even something else? In contrib, there's a function caled backend_pid() defined in misc_utils.sql, it may be helpful for you. markus I wro

[SQL] HELP: aggregating insert rule for multirow inserts.

I'm having a problem with the use of the NEW rowset, in a rule intended to aggregate across inserts. I've never really grokked how NEW and OLD really work, syntactically, other than that they seem to be implicit in every top-level FROM clause, and any mention elsewhere gets an error: '42P01: re

[SQL] accessing multiple database

hi all, im finding some ideas, method, advice, n etc on accessing multiple database.The system that i'm currently develop is real time update and the data reside on few different db at different db site. Tq in advance. Tq ---(end of broadcast)--

Re: [despammed] [SQL] accessing multiple database

am 05.05.2005, um 10:47:12 +0800 mailte mohammad izwan ibrahim folgendes: > hi all, > > im finding some ideas, method, advice, n etc on accessing multiple > database.The system that i'm currently develop is real time update and > the data reside on few different db at different db site. Tq in > a