Re: [DOCS] CREATE OPERATOR query

2013-05-22 Thread Robins Tharakan
Makes perfect sense. Thanks and appreciate a prompt response. Would update the tests accordingly. -- Robins Tharakan On 22 May 2013 09:03, Alvaro Herrera wrote: > Robins Tharakan escribió: > > Yes, but the documentation states that EXECUTE permission for the > function > > i

Re: [DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
ing function. If a commutator or negator operator is specified, you must own these operators. Am I missing something obvious here? -- Robins Tharakan On 22 May 2013 07:12, Alvaro Herrera wrote: > Robins Tharakan escribió: > > Further, I seem to have a similar problem with the E

Re: [DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
S $$ SELECT NULL::type_op3; $$ LANGUAGE sql IMMUTABLE; REVOKE EXECUTE ON FUNCTION fn_op3(type_op3, type_op3) FROM rol_op3; SET ROLE rol_op3; CREATE OPERATOR #*# ( leftarg = type_op3, rightarg = type_op3, procedure = fn_op3 ); RESET ROLE; ROLLBACK; Thanks. -- Robins Tharakan On 22 M

[DOCS] CREATE OPERATOR query

2013-05-21 Thread Robins Tharakan
hese operators. Any pointers would be helpful. Thanks -- Robins Tharakan

Re: [DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-13 Thread robins
.f1; CREATE SEQUENCE postgres=# ALTER TABLE serialTest3 DROP COLUMN f1 RESTRICT; ALTER TABLE postgres=# I was working on some regression tests and then just wanted to be sure that this (Q2 in particular) was perfectly legal, before adding checks for them. Thanks again. -- Robins Tharakan

[DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-11 Thread robins
l.col1 and then try to drop the column with RESTRICT, should it allow this DROP? Currently it does, but by reading that line it seemed it shouldn't. Thanks -- Robins Tharakan p.s.: Had to re-post this. Apologies if this lands up twice in the queue.

[DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-11 Thread Robins
l.col1 and then try to drop the column with RESTRICT, should it allow this DROP? Currently it does, but by reading that line it seemed it shouldn't. Thanks --- Robins Tharakan