[ADMIN] Select to other database's table

Dear Milist; Please give me some advices and help. How can i do "select" the TABLE_1 on other database DB_2, but currently i'm connecting to on DB_1.   ORACLE : Current_DB_1 #> Select * From DB_2.TABLE_1;   MS-SQL : Current_DB_1 #> Select * From DB_2..TABLE_2;   PostGre : Current_DB_1 #

[ADMIN] Select Multi Database;

Dear Milist; Please give me some advices and help. How can i do "select" the TABLE_1 on other database DB_2, but currently i'm connecting to on DB_1.   ORACLE : Current_DB_1 #> Select * From DB_2.TABLE_1;   MS-SQL : Current_DB_1 #> Select * From DB_2..TABLE_2;   PostGre : Current_DB_1 #>

Re: [ADMIN] Select Multi Database / Need More;

Thank's for Milist's advices,    Dear Oliver Elphick <[EMAIL PROTECTED]>, You Wrote ;>You cannot read from another database.  In 7.3, you can have multiple>schemas in one database and the syntax for reading a file from another>schema is: >  SELECT * FROM schema.table...

Re: [ADMIN] Select Multi Database / Cool.

Dear Milist and Dear Oliver Elphick <[EMAIL PROTECTED]>   That's Cool. There's no better answer but U. Thank you very much. I will D/L PostgreSQL 7.3   Hope you don't cloy to give me another Cools. GOD Bless You All.  

[ADMIN] Unable to automaticly load Postmaster.

Dear Milist, I've tried to upgrading my PostgreSQL to 7.3. It's Cool, especialy for the SCHEMA and I've been working on it. But one thing about "Postmaster" is keeping me in headache. Should I write "postmaster -D My_database" on every single day ? Or Every I Restart My Server, Could

[ADMIN] Do Something before Abort on Trigger ???

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

[ADMIN] Do Something before Abort on Trigger ???

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

Re: [ADMIN] Do Something before Abort on Trigger ???

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.   

[ADMIN] OOT: history of my command

Somebody know how to turn it off or clear all my script's history.   Thank's And GOD Bless You All.   Yudha Setiawan.VoIP     No.    : 01119311223344    Gatekeeper : 202.43.162.189

[ADMIN] Error Code

er is 13059. And we cannot make a different for every single errors.   Somebody please give me some explanation.           Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] Just Make Sure

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

[ADMIN] Script Trigger

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

[ADMIN] Using advance update

e's no further clearly explanation or the sample of usages. Somebody please give me ones.   Thank's and GOD Bless You.      Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] pg_proc and pg_triggers

  Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] pg_proc - pg_triggers

o tables, between pg_proc and pg_trigger to findout my trigger's script. For now we just know the trigger's function without know which trigger is using it. Somebody can help us..??? Please.   Thank's And GOD Bless You All.    Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] Spread the schema

, Was it have a same way with spread the database, or any idea to make it happend ???   Thank's A Lot and GOD Bless You.   Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] Spread the schema

, Was it have a same way with spread the database, or any idea to make it happend ???   GOD Bless You All. Yudha Setiawan.VoIP     No.    : 01119311223344

[ADMIN] Session ID

ly without knowing what's exactly process is working or which tables is busy. Any Idea about this...??   Thank's so Much and GOD Bless You All.   Yudha Setiawan.VoIP     No.    : 628899911223344

[ADMIN] OOT : Two Lonely Days

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

[ADMIN] Can not deleted all record

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

[ADMIN] Still confusing with "LISTEN,UNLISTEN,NOTIFY" Command.

OD Bless You All and Bravo PostgreSQL ------ Yudha Setiawan.

[ADMIN] LOCK has IGNORED on trigger.

  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.