🚀 go-pugleaf

When storing a procedure in INGRES, the DBMS identifies tables with the
user prefix.  I.E.:

CREATE PROCEDURE ABC AS
BEGIN
    INSERT INTO xyz (a,b,c) VALUES (1,2,3);
END;

turns into

CREATE PROCEDURE ABC AS
BEGIN
    INSERT INTO 'my_userid'.xyz (a,b,c) VALUES (1,2,3);
END;

when it is stored in the database.  'Help procedure ABC' shows this.
I don't know why INGRES does this because procedures are not removed
when underlying tables are (as in the case of views).

What I would like is for procedure ABC to insert into the XYZ table
owned by user 'n'.  I.e., every user will have a table XYZ.

Can anyone shed some light on this?

--
David L. Tondreau, Jr. |   ars_mgr@nhqvax.hq.nasa.gov    | Don't "Just do it."
Managing Consultant    | d_tondreau@aeromail.hq.nasa.gov | Do it right.
LCT, Inc.              |        (202) 554-0115           | The first time.