1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
/******************************************************************************
* $Id: ogrpgutility.cpp 22919 2011-08-10 18:12:05Z rouault $
*
* Project: OpenGIS Simple Features Reference Implementation
* Purpose: Utility methods
* Author: Even Rouault, <even dot rouault at mines dash paris dot org>
*
******************************************************************************
* Copyright (c) 2009, Even Rouault
*
* Permission is hereby granted, free of charge, to any person obtaining a
* copy of this software and associated documentation files (the "Software"),
* to deal in the Software without restriction, including without limitation
* the rights to use, copy, modify, merge, publish, distribute, sublicense,
* and/or sell copies of the Software, and to permit persons to whom the
* Software is furnished to do so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included
* in all copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS
* OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
* THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
* FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
* DEALINGS IN THE SOFTWARE.
****************************************************************************/
#include "ogr_pg.h"
#include "cpl_conv.h"
CPL_CVSID("$Id: ogrpgutility.cpp 22919 2011-08-10 18:12:05Z rouault $");
/************************************************************************/
/* OGRPG_PQexec() */
/************************************************************************/
PGresult *OGRPG_PQexec(PGconn *conn, const char *query, int bMultipleCommandAllowed)
{
PGresult* hResult;
#if defined(PG_PRE74)
/* PQexecParams introduced in PG >= 7.4 */
hResult = PQexec(conn, query);
#else
if (bMultipleCommandAllowed)
hResult = PQexec(conn, query);
else
hResult = PQexecParams(conn, query, 0, NULL, NULL, NULL, NULL, 0);
#endif
#ifdef DEBUG
const char* pszRetCode = "UNKNOWN";
char szNTuples[32];
szNTuples[0] = '\0';
if (hResult)
{
switch(PQresultStatus(hResult))
{
case PGRES_TUPLES_OK:
pszRetCode = "PGRES_TUPLES_OK";
sprintf(szNTuples, ", ntuples = %d", PQntuples(hResult));
break;
case PGRES_COMMAND_OK:
pszRetCode = "PGRES_COMMAND_OK";
break;
case PGRES_NONFATAL_ERROR:
pszRetCode = "PGRES_NONFATAL_ERROR";
break;
case PGRES_FATAL_ERROR:
pszRetCode = "PGRES_FATAL_ERROR";
break;
default: break;
}
}
if (bMultipleCommandAllowed)
CPLDebug("PG", "PQexec(%s) = %s%s", query, pszRetCode, szNTuples);
else
CPLDebug("PG", "PQexecParams(%s) = %s%s", query, pszRetCode, szNTuples);
/* -------------------------------------------------------------------- */
/* Generate an error report if an error occured. */
/* -------------------------------------------------------------------- */
if ( !hResult || (PQresultStatus(hResult) == PGRES_NONFATAL_ERROR ||
PQresultStatus(hResult) == PGRES_FATAL_ERROR ) )
{
CPLDebug( "PG", "%s", PQerrorMessage( conn ) );
}
#endif
return hResult;
}
|
