Lists: | pgsql-hackers |
---|
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Where's the docs? |
Date: | 2009-10-28 03:35:54 |
Message-ID: | 4AE7BC1A.8050004@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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 in the right place?
--Josh Berkus
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 03:40:57 |
Message-ID: | 27830.1256701257@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Josh Berkus <josh(at)agliodbs(dot)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
http://developer.postgresql.org/pgdocs/postgres/sql-syntax-calling-funcs.html
> DEFAULT privileges
http://developer.postgresql.org/pgdocs/postgres/sql-alterdefaultprivileges.html
regards, tom lane
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 04:15:19 |
Message-ID: | 4AE7C557.9010708@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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 TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }
ON table [ FOR [ EACH ] { ROW | STATEMENT } ]
EXECUTE PROCEDURE function_name ( arguments )
Does a doc patch already exist for this, or do I need to write one?
>> Calling Named Function parameters
>
> http://developer.postgresql.org/pgdocs/postgres/sql-syntax-calling-funcs.html
>
>> DEFAULT privileges
>
> http://developer.postgresql.org/pgdocs/postgres/sql-alterdefaultprivileges.html
Thanks for these, I wasn't finding them. Problem of no search on the
developer docs ...
--Josh Berkus
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 04:25:38 |
Message-ID: | 29117.1256703938@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Josh Berkus <josh(at)agliodbs(dot)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 "event", which isn't spelled out here.
regards, tom lane
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 06:33:07 |
Message-ID: | 1256711587.993.0.camel@fsopti579.F-Secure.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Wed, 2009-10-28 at 00:25 -0400, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)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 "event", which isn't spelled out here.
I know this is a bit suboptimal, but I couldn't think of a better way
without cluttering up to many things.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 13:43:48 |
Message-ID: | 5764.1256737428@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On Wed, 2009-10-28 at 00:25 -0400, Tom Lane wrote:
>> Josh Berkus <josh(at)agliodbs(dot)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 "event", which isn't spelled out here.
> I know this is a bit suboptimal, but I couldn't think of a better way
> without cluttering up to many things.
Expanding "event" in-place definitely wouldn't be very readable. The
only alternative that seems sane is to do something like what we do
in SELECT:
CREATE TRIGGER ...
where "event" is:
INSERT | UPDATE [ ( column [,...] ) ] | DELETE | TRUNCATE
I am not convinced that it's worth it, but maybe. Certainly the current
psql "\h CREATE TRIGGER" display is not helpful at reminding you where
to put the column names.
regards, tom lane
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Where's the docs? |
Date: | 2009-10-28 16:50:09 |
Message-ID: | 4AE87641.1000900@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 10/27/09 9:25 PM, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)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 "event", which isn't spelled out here.
>
Yeah, I couldn't figure it out from the docs, which means that other
people won't be able to. Doc patch coming if I ever finish this server
migration.
--Josh Berkus