From 3d772413a194c5b33d4202285d46b285920c475b Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Wed, 7 Dec 2011 19:08:06 +0100
Subject: modified sql statements to work with postgresql

---
 sql/server_insert.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'sql/server_insert.sql')

diff --git a/sql/server_insert.sql b/sql/server_insert.sql
index f63da57..d17703b 100644
--- a/sql/server_insert.sql
+++ b/sql/server_insert.sql
@@ -1,4 +1,6 @@
 INSERT INTO servers 
 ( server_autostart, server_port, server_machine_id) 
 VALUES
-( :server_autostart:, :server_port:, :server_machine_id:);
+( :server_autostart:, :server_port:, :server_machine_id:) 
+RETURNING 
+server_id as last_inserted_id;
-- 
cgit v1.2.3

