1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
index f166976..75a51e2 100644
--- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
+++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
@@ -412,15 +412,15 @@ namespace OpenSim.Data.PGSQL
            query = @"WITH upsert AS (
                        UPDATE userpicks SET
                            pickuuid = :PickId, creatoruuid = :CreatorId, toppick = :TopPick, parceluuid = :ParcelId,
-                            name = :Name, description = :Desc, snapshotuuid = :SnapshotId, ""user"" = :User, 
+                            name = :Name, description = :Desc, snapshotuuid = :SnapshotId, ""user"" = :User,
-                            originalname = :Original, simname = :SimName, posglobal = :GlobalPos, 
+                            originalname = :Original, simname = :SimName, posglobal = :GlobalPos,
-                            sortorder = :SortOrder, enabled = :Enabled 
+                            sortorder = :SortOrder, enabled = :Enabled
-                        RETURNING * ) 
+                        RETURNING * )
                      INSERT INTO userpicks (pickuuid,creatoruuid,toppick,parceluuid,name,description,
-                            snapshotuuid,""user"",originalname,simname,posglobal,sortorder,enabled) 
+                            snapshotuuid,""user"",originalname,simname,posglobal,sortorder,enabled)
                      SELECT
                            :PickId,:CreatorId,:TopPick,:ParcelId,:Name,:Desc,:SnapshotId,:User,
-                            :Original,:SimName,:GlobalPos,:SortOrder,:Enabled 
+                            :Original,:SimName,:GlobalPos,:SortOrder,:Enabled
                      WHERE NOT EXISTS (
                        SELECT * FROM upsert )";

diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs index f166976..75a51e2 100644 --- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs +++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
@@ -412,15 +412,15 @@ namespace OpenSim.Data.PGSQL
412	query = @"WITH upsert AS (	412	query = @"WITH upsert AS (
413	UPDATE userpicks SET	413	UPDATE userpicks SET
414	pickuuid = :PickId, creatoruuid = :CreatorId, toppick = :TopPick, parceluuid = :ParcelId,	414	pickuuid = :PickId, creatoruuid = :CreatorId, toppick = :TopPick, parceluuid = :ParcelId,
415	name = :Name, description = :Desc, snapshotuuid = :SnapshotId, ""user"" = :User,	415	name = :Name, description = :Desc, snapshotuuid = :SnapshotId, ""user"" = :User,
416	originalname = :Original, simname = :SimName, posglobal = :GlobalPos,	416	originalname = :Original, simname = :SimName, posglobal = :GlobalPos,
417	sortorder = :SortOrder, enabled = :Enabled	417	sortorder = :SortOrder, enabled = :Enabled
418	RETURNING * )	418	RETURNING * )
419	INSERT INTO userpicks (pickuuid,creatoruuid,toppick,parceluuid,name,description,	419	INSERT INTO userpicks (pickuuid,creatoruuid,toppick,parceluuid,name,description,
420	snapshotuuid,""user"",originalname,simname,posglobal,sortorder,enabled)	420	snapshotuuid,""user"",originalname,simname,posglobal,sortorder,enabled)
421	SELECT	421	SELECT
422	:PickId,:CreatorId,:TopPick,:ParcelId,:Name,:Desc,:SnapshotId,:User,	422	:PickId,:CreatorId,:TopPick,:ParcelId,:Name,:Desc,:SnapshotId,:User,
423	:Original,:SimName,:GlobalPos,:SortOrder,:Enabled	423	:Original,:SimName,:GlobalPos,:SortOrder,:Enabled
424	WHERE NOT EXISTS (	424	WHERE NOT EXISTS (
425	SELECT * FROM upsert )";	425	SELECT * FROM upsert )";
426		426