pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  
help / color / mirror / Atom feed
From: lukaseder (@lukaseder) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #538: Why getSchemaName return empty string or exists getBaseSchemaName and getColumnName return getColumnLabel?
Date: Mon, 12 Dec 2022 14:07:34 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

> Well it can but most people don't really wan't to take the hit of doing another round trip

But the result is cached in `BaseConnection::getFieldMetadataCache`, so between the various calls to `PgResultSetMetaData`, the extra round trip is shared as good as possible. Given that a round trip is highly likely already, I think that most people will not mind?

> My admittedly fuzzy recollection here is that folks expected the schema name to be returned by the server in the results.

That would be much better, no doubt. But apparently, this information isn't already present now.

Anyway, I just wanted to add this information here, given that I had to look it up myself and that I haven't seen anyone else mention the existing cached data from other round trips.

view thread (31+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: github://pgjdbc/pgjdbc
  Cc: [email protected], [email protected]
  Subject: Re: [pgjdbc/pgjdbc] issue #538: Why getSchemaName return empty string or exists getBaseSchemaName and getColumnName return getColumnLabel?
  In-Reply-To: <<[email protected]>>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox