Procedure code generation may have issues

[adpande]

first thanks for the wonderful library. I got an issue with the code generated for a procedure.

xo generated following code for my procedure. My DB is PostgreSQL 14

Procedure

create function update_updated_at_column() returns trigger
    language plpgsql
as
$$
BEGIN
    NEW.updated_at= now();
RETURN NEW;
END;
$$;

alter function update_updated_at_column() owner to abhishek;

Generated go code:

package xodb

// Code generated by xo. DO NOT EDIT.

import (
	"context"
)

// UpdateUpdatedAtColumn calls the stored function 'public.update_updated_at_column() trigger' on db.
func UpdateUpdatedAtColumn(ctx context.Context, db DB) (Trigger, error) {
	// call public.update_updated_at_column
	const sqlstr = `SELECT * FROM public.update_updated_at_column()`
	// run
	var r0 Trigger
	logf(sqlstr)
	if err := db.QueryRowContext(ctx, sqlstr).Scan(&r0); err != nil {
		return Trigger{}, logerror(err)
	}
	return r0, nil
}

If you see the Trigger structure is not generated and the code fails to compile. I think it is a bug in code generation but can not figure out in the templates. Please help.

Thanks & Regards,
Abhi

[SC4RECOIN]

same issue for me

is there a way to disable this code generation temporarily ?