pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedWrong drop procedure example
2+ messages / 2 participants
[nested] [flat]
* Wrong drop procedure example
@ 2019-08-16 11:03 PG Doc comments form <noreply@postgresql.org>
2019-08-16 13:34 ` Re: Wrong drop procedure example Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-08-16 11:03 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: norbert.burza@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-dropprocedure.html
Description:
Hi,
I noticed that drop procedure with parenthesis doesn't work (procedure name
not found), but without parenthesis it works.
Not OK: DROP PROCEDURE do_db_maintenance();
OK: DROP PROCEDURE do_db_maintenance;
Br,
Norbert
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Wrong drop procedure example
2019-08-16 11:03 Wrong drop procedure example PG Doc comments form <noreply@postgresql.org>
@ 2019-08-16 13:34 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2019-08-16 13:34 UTC (permalink / raw)
To: norbert.burza@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.org> writes:
> I noticed that drop procedure with parenthesis doesn't work (procedure name
> not found), but without parenthesis it works.
> Not OK: DROP PROCEDURE do_db_maintenance();
> OK: DROP PROCEDURE do_db_maintenance;
Works for me:
regression=# create procedure do_db_maintenance() as 'begin end' language plpgsql;
CREATE PROCEDURE
regression=# DROP PROCEDURE do_db_maintenance();
DROP PROCEDURE
This depends, of course, on how you declared the procedure (with
or without any parameters).
If we wrote the example without parens, that would just move the
set of failure conditions around, so I'm unconvinced that it'd
be an improvement.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-08-16 13:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-16 11:03 Wrong drop procedure example PG Doc comments form <noreply@postgresql.org>
2019-08-16 13:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox