pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

[pgjdbc/pgjdbc] issue #3723: `connection.setSchema("invalid_schema")` should throws IllegalArgumentException
2+ messages / 2 participants
[nested] [flat]

* [pgjdbc/pgjdbc] issue #3723: `connection.setSchema("invalid_schema")` should throws IllegalArgumentException
@ 2025-07-09 02:12  "quaff (@quaff)" <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: quaff (@quaff) @ 2025-07-09 02:12 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

Currently, `connection.setSchema("invalid_schema")` is silently ignored, later `connection.getSchema()` returns `null`, I think it's inconsistent here.

See https://github.com/brettwooldridge/HikariCP/issues/2323 for more background.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [pgjdbc/pgjdbc] issue #3723: `connection.setSchema("invalid_schema")` should throws IllegalArgumentException
@ 2025-07-09 11:48  "davecramer (@davecramer)" <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: davecramer (@davecramer) @ 2025-07-09 11:48 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

Well, postgres does not throw an error if you execute set `search_path='invalid_schema'` and subsequent calls to `current_schema()` return null as per current_schema () → name

Returns the name of the schema that is first in the search path (or a null value if the search path is empty). This is the schema that will be used for any tables or other named objects that are created without specifying a target schema. 

See https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-SESSION

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-07-09 11:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-09 02:12 [pgjdbc/pgjdbc] issue #3723: `connection.setSchema("invalid_schema")` should throws IllegalArgumentException "quaff (@quaff)" <[email protected]>
2025-07-09 11:48 Re: [pgjdbc/pgjdbc] issue #3723: `connection.setSchema("invalid_schema")` should throws IllegalArgumentException "davecramer (@davecramer)" <[email protected]>

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