On 09/20/2011 04:06 PM, Marc Fromm wrote:
My postgres version is 8.1. Last I heard RETURNING id started in 8.2.
I'd advise upgrading. 8.1 is no-longer supported (end-of-life was last November) and 8.2 has an end-of-life date in just a couple months. You'll get security and bug fixes, performance benefits and, of course, those cool new features you need. :)
(No security fixes is often the issue that gets management attention if necessary.)
Is not my semicolon before the select statement make it two sequential staements?
I don’t get an sql error when it is executed.
Well, it is technically legal (and why SQL injection can work). Looks like you are using PHP and PHP says that if you bundle statements together they will be executed as a transaction.
Perhaps it's personal preference, but combining statements like that is difficult to read and I suspect will make bugs hard to find. And although I can't find it documented, it appears that the return value is only from the final statement. I shy away from undocumented behaviour and I'd rather be able to check the result of each statement.
I did learn from another reply that my select statement was wrong. I needed to SELECT currval('jobs_id_seq') not the field name, which I was doing.
Yes, this is probably the real root of your problem. I did not notice that since I didn't have the table definition in front of me.
Cheers,
Steve