0 4 12
But when i put the "Insert into Table_A" command
on
the other trigger's table. That's LOCK is
ignored.
Somebody help me please...
GOD Bless You All and Bravo Postgre
---
Yudha Setiawan.
OD Bless You All and Bravo
PostgreSQL
------
Yudha Setiawan.
Dear expert;
I've tried to update my record on stock's
table.
but i failed "ERROR: Query was
cancelled."
was show up. But when i update on partial
`till
all my record is changed, its work.
Anyway that's table have no rule,trigger and
relation
with the other table. I've been thinking we m
I've been two days with no
information,ask,
question or etc from this milist.
So, What's Up..?, Did the Admin kicked me out ??,
What did I Do..???
Anybody Know what's exactly going on out
there..??
Please...,
GOD Bless You All.
Yudha Setiawan.VoIP
No. :
628899911223344
Dear
Milist,
1.
I Used 2b using
"alter system kill session
'n1,n2'";
on oracle, to kill specified session.
Than how do i done this on postgres
or there's another solution.
And How do i know the user is
connected.
2.
Sometimes the process is feel so
slowly without knowing what's
exact
I've reads from other milist(Mr.Aris
Wendy),
And he was asking about How to Configuring
the PostgreSQL and spread the database to
different hardisk. And I thought he has
succesfully spread the database to
another
physical disk.
And I wonder Now. Could I spread the
Schema to ??, Was i
I've reads from other milist(Mr.Aris
Wendy),
And he was asking about How to Configuring
the PostgreSQL and spread the database to
different hardisk. And I thought he has
succesfully spread the database to
another
physical disk.
And I wonder Now. Could I spread the
Schema to ??, Was it
Dear Master,
As Developer we've been developing a simple
tools
for PostgreSQL under Windows,
Just helping on Daily operation for our "IT-Operation Dept.". Someday I'll
share that's tools for milist, i promise. But know we need to know how
could we connecting two tables, between pg_proc an
Yudha Setiawan.VoIP
No. :
01119311223344
Dear Milist,
Somebody please give me more
explanation about
using "Update" syntax with cursor. I've
seen this
on manual of postgre(sql-update.html). Here
it is
the example;
UPDATE table SET column
= expression [,
...] WHERE CURRENT OF
cursor
But there's no
further clear
Dear Master;
How do i find the script of
trigger's Description Like
"Create Trigger tr_bi_podtl Before Insert On d_temporary.t_podtl For Each Row Execute Procedure fn_tr_bi_podtl();"
Yudha Setiawan.VoIP
No. :
01119311223344
Dear Master;
So There's no way to put the Begin Work,
Commit Work or Rollback inside Trigger's Function...
Some Explanation will be better
:b
GOD Bless You All.
Yudha Setiawan.VoIP
No. :
01119311223344
Dear Milist;
My Application is Developed by Delphi
with Ms-SQL Server as a previous Database
and we are using ODBC/BDE (Borland
Database Engine)
for Database connection. And We've been
porting
the database to PostgreSQL. So far so
Good.
And now our problem is How do we get
The Error
After I type "Psql -Uroot DBase" and
get connecting to Postgre User Interface, Every I pressed the Up_Arrow or Down_Arrow, The history of my Script will
Show-Up. Sometimes it's pretty helpfull but
Sometimes it's being a "pinprick".
Anybody
offence as I am.. Somebody know how to
turn it o
Thank's so much to all of you guys. You
have
giving me completely explainations
about the
transactional on Postgre-SQL especially
to
Nigel J. Andrews <[EMAIL PROTECTED]>
and
Ross J. Reedstrom <[EMAIL PROTECTED]>.
GOD Bless U All.
Yudha
Setiawan.VoIP;
No. :
01119311223344
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 T_My_ListError(fc_code,fv_descript)
VALUES('12345','No
Somebody Help Me.
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 T_My_ListError(fc_code,fv_descript)
VALUES('12345','No Authori
17 matches
Mail list logo
