- String and VarBytes (bytea) fields
limit is 32kb (when not mapped as BLOB),
due to dbExpress™
limitations.
Metadata notes:
- The RECNO field for the
getTables(), getIndices() and getProcedures() are actually the OID for each corresponding tuple, and not a
sequential serie starting at 1.
- In the ISQLMetadata.GetProcedures()
interface, which is used by the TSQLConnection.GetProcedures() procedure, as of
PostgreSQL7.3 we consider functions = procedures, what
means that the functions will be listed as procedures.
- Since the function pararameters are unnamed, in ISQLMetadata.GetProcedureParams() they will appear
as "Arg1", "Arg2", etc. The output parameter will be named
"Result".