~~
Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
/usr/local/perlapache/lib/perl/Banner.pm line 71, GEN1 line 7.
~~
It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record simultaneously.
On Mon, 20 Jan 2003, Tom Lane wrote:
Bhuvan A [EMAIL PROTECTED] writes:
Error:...deadlock detected...
... You can overcome this by locking the table in share row
exclusive mode also...
...use shorter transactions (one per page, not one per several pages).
Hmm... with his query:
are there any tools for postgres that would assist a dba in the
monitoring of a postgres database?
for example, send alerts when data files are filling up, send alerts if
the database goes down, etc.
---(end of broadcast)---
TIP 1: subscribe and
Dear Sir,
I'm a graduate student studying computer science in the Univ. of Edinburgh.
After I donwload the 'PostgreSQL 7.3.1', I run the command /configure in its
directory on my computer as root. However, the result is :bad interpreter: no
such file or directory. My OS is redhat 7.3 and gmake
~~
Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
/usr/local/perlapache/lib/perl/Banner.pm line 71, GEN1 line 7.
~~
It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record
Tom Lane [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
codeWarrior [EMAIL PROTECTED] writes:
I noticed that the server generated logfile gets real big real fast --
(15
queries and it's already at 1.5MB) -- Is there a switch / option to
recycle
the server
On Thu, 16 Jan 2003, Tim Lynch wrote:
First, sorry for the OT, flame me off-list!
I'm a sysadmin being impressed into dba service. i've been getting along
pretty well writing queries and making reports, but i've got some questions.
suggestions for a good list/forum for help?
from two
Dear Sir,
I have downloaded fallowing files from http://www.postgresql.org
1. mx-2.0.1-1.i386.rpm
2. postgresql-odbc-7.1.2-5PGDG.i386.rpm
3. postgresql-7.1.2-5PGDG.i386.rpm
4. postgresql-perl-7.1.2-5PGDG.i386.rpm
5. postgresql-contrib-7.1.2-5PGDG.i386.rpm
6.
Hi:
I need to register all the operations (INSERT/UPDATE/DELETE) that users
does.
Something like an log file for the backbone (like a /var/log/messages,
where all done is registered).
Can any help me?
Thanks.
--
SAMTEK, Consultores Informática y Telecomunicaciones
Calificado como Agente
On Wed, 15 Jan 2003, Yudha Setiawan wrote:
Somebody gimme your hand plz.
Using my previous Database I used to be like that;
ALTER TRIGGER tr_T_DtlPO ON dbo.T_DtlPO FOR UPDATE AS
bla..bla..bla...
IF @OldQty @NewQty BEGIN
ROLLBACK
INSERT INTO
I'm going to CC this to the -general list as well, it's possible that -admin
isn't the right list for this thread.
You can not rollback or commit within a function. That would require nested
transactions which aren't implemented yet. Obviously that precludes use of your
'begin work' in your
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root# chown
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root#
Hello all,
I am new to postgreSQL. I have installed postgreSQL 7.1.3-2 on Linux 7.2.
If I login as root (administrator) and change user as postgres I can create
database on /usr/local/pgsql/data which I created and changed its owner as
postgres.
root# mkdir usr/local/pgsql/data
root# chown
Hi Zhiqiang,
You might take a look at the following link:
http://www.tek-tips.com/viewthread.cfm?SQID=449717SPID=699page=1
After you have postgres user properly setup, you can use pgaccess to
configure other users.
LelandJ
- Original Message -
From: Zhiqiang Feng [EMAIL PROTECTED]
First of all your su postgres problem. You will note, that the first time
you executed su postgres you were root (and thus didn't need a password), the
second time you were a non-root user, zf2linux, and thus you DO need a
password.
The second problem is who postgreSQL thinks you are. What
Hi,
Writing a web-based application using PostgreSQL as the back-end
database. The master create functions look something like this:
1. Accept ID from user.
2. Verify that ID doesn't exist in database. Start transaction.
Create blank record with ID as key.
3. Accept remaining data for record
17 matches
Mail list logo