From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | dev(at)archonet(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: proposal for PL packages for 8.3. |
Date: | 2006-08-07 13:57:05 |
Message-ID: | BAY20-F242FF8806E5217FB8FB32AF9570@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> >> Are you saying that the package would effectively *be* a schema from
>the
> >> outside. That is, if I have package "foo" then I can't also have a
>schema
> >> "foo"?
>
> > Yes, because I don't need duplicity in function's names.
>
>What if the package needs some tables associated with it? I think you
>need to think harder about the relationship of packages and schemas.
>I don't necessarily object to merging the concepts like this, but
>the implications look a bit messy at first sight.
>
> regards, tom lane
What is problem? I can attach table or sequence. What can be problem is
visibility of nesteded objects (if can be different than functions). My
proposal is only concept, and I my first goal is find way for secure storing
session's variables and shared native functions, like my sample. I didn't
think about others objecst and it's maybe error. Or maybe I was wrong in
"package is similar to schema". I wonted say so relation between function
and package is very similar to relation between functions and schema.
Pavel Stehule
_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2006-08-07 14:11:48 | Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL |
Previous Message | Martijn van Oosterhout | 2006-08-07 13:54:44 | Re: pg_upgrade (was: 8.2 features status) |