pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed
From: kevinm416 (@kevinm416) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
Date: Tue, 11 Feb 2025 23:39:47 +0000
Message-ID: <[email protected]> (raw)

Bumping `org.postgresql:postgresql` from 42.7.4 -> 42.7.5 causes this error for me, while I keep the `jooq` dependency constant. I'm not sure what's going on here, or what `key_seq` is.

```
17:35:40 SEVERE Error while generating table public.app_user
java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Field (key_seq) is not contained in Row (
  "PKTABLE_CAT",
  "pg_namespace"."PKTABLE_SCHEM",
  "pg_class"."PKTABLE_NAME",
  "pg_attribute"."PKCOLUMN_NAME",
  "FKTABLE_CAT",
  "pg_namespace"."FKTABLE_SCHEM",
  "pg_class"."FKTABLE_NAME",
  "pg_attribute"."FKCOLUMN_NAME",
  "KEY_SEQ",
  "UPDATE_RULE",
  "DELETE_RULE",
  "pg_constraint"."FK_NAME",
  "pg_class"."PK_NAME",
  "DEFERRABILITY"
)
        at org.jooq.meta.AbstractDatabase.onError(AbstractDatabase.java:3806)
        at org.jooq.meta.AbstractDatabase.getRelations(AbstractDatabase.java:2801)
        at org.jooq.meta.DefaultColumnDefinition.getPrimaryKey(DefaultColumnDefinition.java:154)
        at org.jooq.meta.AbstractTableDefinition.getPrimaryKey(AbstractTableDefinition.java:108)
        at org.jooq.codegen.JavaGenerator.generateTable(JavaGenerator.java:6006)
        at org.jooq.codegen.JavaGenerator.generateTables(JavaGenerator.java:5985)
        at org.jooq.codegen.JavaGenerator.generate(JavaGenerator.java:654)
        at org.jooq.codegen.JavaGenerator.generate(JavaGenerator.java:609)
        at org.jooq.codegen.JavaGenerator.generate0(JavaGenerator.java:521)
        at org.jooq.codegen.AbstractGenerator.generate(AbstractGenerator.java:191)
        at org.jooq.codegen.JavaGenerator.generate(JavaGenerator.java:222)
        at org.jooq.codegen.GenerationTool.run0(GenerationTool.java:957)
        at org.jooq.codegen.GenerationTool.run(GenerationTool.java:240)
        at org.jooq.codegen.GenerationTool.generate(GenerationTool.java:235)
        at org.jooq.codegen.GenerationTool.main(GenerationTool.java:207)
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: Field (key_seq) is not contained in Row (
  "PKTABLE_CAT",
  "pg_namespace"."PKTABLE_SCHEM",
  "pg_class"."PKTABLE_NAME",
  "pg_attribute"."PKCOLUMN_NAME",
  "FKTABLE_CAT",
  "pg_namespace"."FKTABLE_SCHEM",
  "pg_class"."FKTABLE_NAME",
  "pg_attribute"."FKCOLUMN_NAME",
  "KEY_SEQ",
  "UPDATE_RULE",
  "DELETE_RULE",
  "pg_constraint"."FK_NAME",
  "pg_class"."PK_NAME",
  "DEFERRABILITY"
)
```


view thread (3+ 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 #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
  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