kputnam / piggly

PL/pgSQL stored procedure code coverage tool
Other
70 stars 14 forks source link

procedure params name need to be quoted #12

Closed lcoldiron closed 13 years ago

lcoldiron commented 13 years ago

Example: CREATE OR REPLACE FUNCTION public.my_proc(OUT "timestamp" bigint) RETURNS SETOF record AS $BODY$

This function contains a param name that just so happens to also be a type. If the name is not quoted the traced procedure will not be able to be uploaded to the database. This issue would most likely occur if there is a space in the name of parameter as well.