Hello all,
I'm trying to create a schema that contains the default tables, functions, etc. of the public schema. Using pgAdmin, when I create a schema, it is blank - has no associated aggregates, tables, etc. How would I create additional schems within a database that mirror the public schema.
Hello,
Is there a way that I can specify that a request to change
to a particular table is redirected instead to a different table?
I’ve looked through rules, and as far as I can make
out, they are only useful for explicit actions. I’m looking for something
that behaves as though it
On Sat, Nov 19, 2005 at 17:06:27 +1300,
Jeremy Palmer <[EMAIL PROTECTED]> wrote:
>
> Interesting enough, on my server the "distinct on" clause that I originally
> ran takes 10% of execution time that the query you provided does.
If DISTINCT ON wasn't useful, I doubt it would have been added.
-
You can try to use this patch:
http://archives.postgresql.org/pgsql-patches/2005-09/msg00138.php
This is implementation of basic functions of SQL/XML (14th part of
SQL:2003, http://www.sqlx.org/)
I've successfully applied it to 8.1 version - no troubles.
On 11/11/05, Warren Murray <[EMAIL PROTEC
