Mercurial > dive4elements > framework
changeset 216:2d90d5cfe8f9
Added a cast to uuid in collections.select.by.gid
artifacts/trunk@1555 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 24 Mar 2011 15:29:41 +0000 |
| parents | a9c8fa38ba03 |
| children | 87a7773030b5 |
| files | ChangeLog artifact-database/src/main/resources/sql/org-postgresql-driver.properties |
| diffstat | 2 files changed, 6 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/ChangeLog Thu Mar 24 11:28:26 2011 +0000 +++ b/ChangeLog Thu Mar 24 15:29:41 2011 +0000 @@ -1,3 +1,8 @@ +2011-03-24 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * artifact-database/src/main/resources/sql/org-postgresql-driver.properties: + Added a cast to uuid in collections.select.by.gid + 2011-03-24 Ingo Weinzierl <ingo@intevation.de> * artifact-database/src/main/resources/sql/org-h2-driver.properties,
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Thu Mar 24 11:28:26 2011 +0000 +++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Thu Mar 24 15:29:41 2011 +0000 @@ -121,7 +121,7 @@ collections.select.by.gid= \ SELECT id, name, owner_id, creation, last_access, attribute \ - FROM collections WHERE gid = ? + FROM collections WHERE gid = ?::uuid users.collections=SELECT collection_id, gid, name FROM collections WHERE owner_id = ? users.collection.ids=SELECT collection_id FROM collections WHERE owner_id = ?