Manuel wrote:
>
> Hi.
>
> I've serious problems with the speed of my database.
> If I execute any query like this;
>
[big ugly query :]
Yes I'd say so, that's a rather horrendous query. You're a better computer
than I if you can make heads or tails of it :). So I ran it through an SQL
tidier and
Peter T. Brown writes:
>
> I want to add replication capabilities to my postgresql installation. Can
> anyone recommend a good way (open source or otherwise) to do so?
>
[snip]
Check the contrib/rserv/ directory in the PostgreSQL source.
Also check http://techdocs.postgresql.org/oresources.php#
Brian McCane wrote:
> How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
SELECT t.oid, t.*
FROM pg_trigger t, pg_clas
Chris Pesko writes:
> Can I put transactions and cursors into functions? As soon as I
> put BEGIN;
> and COMMIT; wrapping an insert statement within a function, I get
> errors. Do these programs need to reside outside of the database?
Pg doesn't supported nested transactions or save points (yet
On Fri, 2003-07-18 at 13:26, Naomi Walker wrote:
> I noticed in some (older) documentation that views were read-only? Is this
> still the case?
Yes, views are read-only unless you define rules for how they can be
inserted/updated/deleted from.
See these for how to create those rules:
http://dev
