Opened 6 years ago
Closed 6 years ago
#2005 closed enhancement (fixed)
Petascope should get oid returned from INSERT query
| Reported by: | Dimitar Misev | Owned by: | Bang Pham Huu |
|---|---|---|---|
| Priority: | minor | Milestone: | 9.8 |
| Component: | petascope | Version: | 9.7 |
| Keywords: | Cc: | ||
| Complexity: | Medium |
Description
Right now petascope sends two queries like this:
INSERT INTO S2_32634_10m_L1C_test VALUES <[0:0,0:0,0:0] {0us,0us,0us,0us}> TILING ALIGNED [0:0, 0:2999, 0:2999] TILE SIZE 72000000
SELECT oid(S2_32634_10m_L1C_test) FROM S2_32634_10m_L1C_test
The second SELECT is always executed. However, INSERT already returns the oid of the inserted array. So this return value can be used, instead of sending a second query.
Change History (2)
comment:1 by , 6 years ago
| Type: | defect → enhancement |
|---|
comment:2 by , 6 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
