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:
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).
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,
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
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