[DOCS] Reserved word "date" in tutorial example

doc/src/sgml/query.sgml includes a tutorial example with this definition: CREATE TABLE weather ( ... datedate ); The fact that "date" is used for both the column name and the type is highlighted by two later comments: (Yes, the column of type date is also named date. This m

[DOCS] VALUES lists aliases

Next from the stream of doc comments, someone points out that if you read http://www.postgresql.org/docs/current/static/queries-values.html a beginner may not understand just what " table alias list" means. If you start at the beginning of the chapter it makes more sense, but it isn't necessar

[DOCS] CREATE OPERATOR query

Hi, While trying to create regression tests for CREATE OPERATOR, I am able to create an operator despite not have USAGE / ALL access to the given argument type. Shouldn't the following SQL throw an error? BEGIN TRANSACTION; CREATE ROLE rol_op3; CREATE TYPE type_op3 AS ENUM ('new', 'open', 'closed

Re: [DOCS] CREATE OPERATOR query

Further, I seem to have a similar problem with the EXECUTE check requirement as well. Sample SQL given below. BEGIN TRANSACTION; CREATE ROLE rol_op3; CREATE TYPE type_op3 AS ENUM ('new', 'open', 'closed'); CREATE FUNCTION fn_op3(type_op3, type_op3) RETURNS type_op3 AS $$ SELECT NULL::type_op3;

Re: [DOCS] CREATE OPERATOR query

Robins Tharakan escribió: > Further, I seem to have a similar problem with the EXECUTE check > requirement as well. > Sample SQL given below. > > BEGIN TRANSACTION; > CREATE ROLE rol_op3; > CREATE TYPE type_op3 AS ENUM ('new', 'open', 'closed'); > CREATE FUNCTION fn_op3(type_op3, type_op3) > RETUR

Re: [DOCS] CREATE OPERATOR query

Yes, but the documentation states that EXECUTE permission for the function is required to even CREATE the operator. This what the doc says: > To be able to create an operator, you must have USAGE privilege on the argument types and the return type, as well as EXECUTE privilege on the underlying f

Re: [DOCS] CREATE OPERATOR query

Robins Tharakan escribió: > Yes, but the documentation states that EXECUTE permission for the function > is required to even CREATE the operator. What I mean is that your new role still has said permission through PUBLIC (a pseudo-role which is automatically granted to all other roles and cannot b

[DOCS] moving documentation to XML

For 9.4, I would like to tackle moving our documentation to a DocBook XML source format and tool chain. The issues surrounding that have been summarized on this wiki page: . Most of these points have become no-b