Hi - both new to the forums and new to PostgreSQL coming from a MSSQL background.
So, first - Hi!
Second. I always used stored procedures to house my business logic and plan to continue that with my PostgreSQL 9.3 installation and plpgsql functions.
So far so good but have run into an issue I hope someone can help with.
I have a function that writes information to a table then calls a second function to send an email based on this newly created row. This second is a generic function used by quite a few others. Problem is that the email function can't see data written to the tables from the first function.
I'm pretty sure that it's a transaction issue but can't seem to find a way around this. I would have thought that any functions called within other functions would be part of the same transaction and see data accordingly but this doesn't seem to be the case.
Any one have any ideas what I'm missing.
Hope I've explained this ok! Any and all help greatly appreciated.