Re: [HACKERS] Where's the docs?

2009-10-28 Thread Peter Eisentraut
On Wed, 2009-10-28 at 00:25 -0400, Tom Lane wrote: Josh Berkus j...@agliodbs.com writes: OK, this is the genuine failure; the syntax is missing for column triggers: CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE

Re: [HACKERS] Where's the docs?

2009-10-28 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Wed, 2009-10-28 at 00:25 -0400, Tom Lane wrote: Josh Berkus j...@agliodbs.com writes: OK, this is the genuine failure; the syntax is missing for column triggers: CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] {

Re: [HACKERS] Where's the docs?

2009-10-28 Thread Josh Berkus
On 10/27/09 9:25 PM, Tom Lane wrote: Josh Berkus j...@agliodbs.com writes: OK, this is the genuine failure; the syntax is missing for column triggers: CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE

[HACKERS] Where's the docs?

2009-10-27 Thread Josh Berkus
Folks, I'm looking at the developer docs on our site, and I couldn't find any docs for the following features: Column Triggers Calling Named Function parameters DEFAULT privileges ... without docs, we really can't expect people to test them. Do we have partial docs for these? Am I not looking

Re: [HACKERS] Where's the docs?

2009-10-27 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: I'm looking at the developer docs on our site, and I couldn't find any docs for the following features: Column Triggers http://developer.postgresql.org/pgdocs/postgres/sql-createtrigger.html Calling Named Function parameters

Re: [HACKERS] Where's the docs?

2009-10-27 Thread Josh Berkus
Tom, I'm looking at the developer docs on our site, and I couldn't find any docs for the following features: Column Triggers http://developer.postgresql.org/pgdocs/postgres/sql-cre atetrigger.html OK, this is the genuine failure; the syntax is missing for column triggers: CREATE

Re: [HACKERS] Where's the docs?

2009-10-27 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: OK, this is the genuine failure; the syntax is missing for column triggers: CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE function_name ( arguments ) It's embedded in