On 2/7/07, Andrew Dunstan <andrew@dunslane.net> wrote:
> Nikolay Samokhvalov wrote:
> >
> > I still do not understand why is it so needed.
> > Your argument is "some apps aren't able to call functions as
> > schemaname.functionname(arg1, arg2, ..)", right?
>
> wrong.
>
> >
> > I still think that separate namespaces for extensions is a good idea
> > while adjusting search_path is not. I've explained my POV in details
> > several messages ago in this thread...
>
>
> The difference between us is that I am less inclined to be prescriptive
> about such matters than you are. I think that as namespace use expands
> we should also probably provide better support for adding things to the
> search path (or indeed taking things away). If you don't want to use it
> then don't, but I don't see why you are so insistent on denying such
> facilities to others.

ok, looks like I've misunderstood your mesages. Sorry for that. Surely
additional capabilities for manipulation with search_path cannot
hinder anybody.

--
Best regards,
Nikolay

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

"Nikolay Samokhvalov" <samokhvalov@gmail.com> writes:
> We cannot use schema name as prefix for operator calling

You can, but it's kind of ugly:

regression=# SELECT 2 OPERATOR(pg_catalog.+) 2;
?column?
----------
4
(1 row)


regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Jim Nasby wrote:

> In addition to Martijn's tsearch case, there's also PostGIS. And I
> believe this is a pretty big pain for them.

Hear hear! It would be nice to dump from an old PostgreSQL/PostGIS
combination and restore to a new version combination, without taking all
the function definitions along for a ride in the dump process. What we
really want is just the data.

--

Paul Ramsey
Refractions Research
http://www.refractions.net
pramsey@refractions.net
Phone: 250-383-3022
Cell: 250-885-0632

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Are we doing this?

---------------------------------------------------------------------------

Joshua D. Drake wrote:
> Hello,
>
> With all the recent discussion on contrib modules etc.. I would like to
> offer the following suggestion. I am willing to do a good portion of the
> work myself and I can get it done before feature freeze. I will need
> help with the global make file stuff however so that is one dependency.
>
> Add directory /modules
> Modules are compiled and installed by default but not enabled.
> Modules in 8.3 currently are:
> pgrowlocks
> pg_freespacemap (to be renameed pgfreespacemap to be consistent)
> pgstattuple
> pgcrypto
> xml2
> pgbuffercache
> initagg
>
> Requirements for /modules
> Must go through normal vetting process on -hackers
> Must include patches to core documentation in Docbook
> Must include test cases? I don't recall if we have regress for all
> contrib stuff.
>
> Keep directory contrib
> Contrib is not compiled or installed by default
> Contrib in 8.3 would be:
> start-scripts
> pgbench (which I think really should be a foundry project)
> vacuumlo (is this even required anymore?)
> adminpack
> btree_gist
> etc...
> Requirements for /contrib
> Must go through normal vetting process on -hackers
> Must includes README
> Must include test cases? Same questions for modules
>
>
> Thoughts, flames?
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org