aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/README.dynSQL
diff options
context:
space:
mode:
authorMichael Meskes <meskes@postgresql.org>2000-02-16 16:18:29 +0000
committerMichael Meskes <meskes@postgresql.org>2000-02-16 16:18:29 +0000
commit35ba9de276150fd3d589509a86ae651924f34cb3 (patch)
tree8d3c867e2fbb1bd7404036f7e798e9c113fa4859 /src/interfaces/ecpg/README.dynSQL
parent988d53e5ea6d87a284e8d3c81829e86b89455fa9 (diff)
downloadpostgresql-35ba9de276150fd3d589509a86ae651924f34cb3.tar.gz
postgresql-35ba9de276150fd3d589509a86ae651924f34cb3.zip
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/README.dynSQL')
-rw-r--r--src/interfaces/ecpg/README.dynSQL20
1 files changed, 20 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/README.dynSQL b/src/interfaces/ecpg/README.dynSQL
new file mode 100644
index 00000000000..fedcf80402d
--- /dev/null
+++ b/src/interfaces/ecpg/README.dynSQL
@@ -0,0 +1,20 @@
+descriptor statements have the following shortcomings
+
+- up to now the only reasonable statement is
+ FETCH ... INTO SQL DESCRIPTOR <name>
+ no input variables allowed!
+
+ Reason: to fully support dynamic SQL the frontend/backend communication
+ should change to recognize input parameters.
+ Since this is not likely to happen in the near future and you
+ can cover the same functionality with the existing infrastructure
+ I'll leave the work to someone else.
+
+- string buffer overflow does not always generate warnings
+ (beware: terminating 0 may be missing because strncpy is used)
+ :var=data sets sqlwarn accordingly (but not indicator)
+
+- char variables pointing to NULL are not allocated on demand
+
+- string truncation does not show up in indicator
+