Stored procedures

Found new repo release – automatically imported it

Leave a Comment / packages, PostgreSQL, Stored procedures / By

Today, while I wasn’t looking, both dev and test located and imported new package information for: FreeBSD:11:amd64 FreeBSD:11:i386 FreeBSD:12:amd64 FreeBSD:12:i386 FreeBSD:13:amd64 FreeBSD:13:i386 However, the packages table was not correctly updated. Why? Because I lost some function code I wrote. This is the code which was in use, as mentioned in Using DEFERRABLE INITIALLY DEFERRED on …

Found new repo release – automatically imported it Read More »

procedure OK under 10.6 but starts acting up under 11.1

Leave a Comment / Bug fixes, Development, Functions, PostgreSQL, Stored procedures, Trigger / By

I originally documented this so I would have a reference while tracking down the problem. I have since solved the issue and you can jump to the bottom of this post to find the solution. What I do not know is why this was not an issue under PostgreSQL 10.6 but was under PostgreSQL 11.1. …

procedure OK under 10.6 but starts acting up under 11.1 Read More »

Scroll to Top