Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 275:e92d5944fe4b
Enabled the artifact database to retrieve requests to change the name of a specific collection.
artifacts/trunk@2074 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 08 Jun 2011 07:36:43 +0000 |
| parents | 92166f7c3842 |
| children | 942a54670a72 |
comparison
equal
deleted
inserted
replaced
| 274:92166f7c3842 | 275:e92d5944fe4b |
|---|---|
| 98 AND CURRENT_TIMESTAMP - c.last_access > (c.ttl || ' milliseconds')::interval \ | 98 AND CURRENT_TIMESTAMP - c.last_access > (c.ttl || ' milliseconds')::interval \ |
| 99 AND a.id NOT IN ($LOCKED_IDS$) | 99 AND a.id NOT IN ($LOCKED_IDS$) |
| 100 | 100 |
| 101 collections.update.ttl=UPDATE collections SET ttl = ? WHERE gid = ?::uuid | 101 collections.update.ttl=UPDATE collections SET ttl = ? WHERE gid = ?::uuid |
| 102 | 102 |
| 103 collections.update.name=UPDATE collections SET name = ? WHERE gid = ?::uuid | |
| 104 | |
| 103 collections.touch.by.gid =\ | 105 collections.touch.by.gid =\ |
| 104 UPDATE collections SET last_access = CURRENT_TIMESTAMP \ | 106 UPDATE collections SET last_access = CURRENT_TIMESTAMP \ |
| 105 WHERE gid = ?::uuid | 107 WHERE gid = ?::uuid |
| 106 | 108 |
| 107 collections.touch.by.id =\ | 109 collections.touch.by.id =\ |