Hi all, First, I must apologize for my long absence from the project. I hope to start paying more attention again.
Looking at tdf#153431, "PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13" <https://bugs.documentfoundation.org/show_bug.cgi?id=153431>, I have managed to confuse myself in many ways. Can somebody help me out? One confusion comes from function pq_sdbc_driver::ResultSet::guessDataType() defined in connectivity/source/drivers/postgresql/pq_resultset.cxx. The function examines the values in a column and guesses the data type. But I thought Postgresql is a "real" database system, one with real metadata. Why is it ever necessary to examine table contents to determine the datatype of a column? ( When executing the STR (comment 22 in the bug report), there is a call to this function with an empty result set, and the function returns 4=INTEGER for column the_memo, which STR (10) defined as Memo [ text ]. ) Thank you for your guidance. Terry.
