pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  
help / color / mirror / Atom feed
[pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
3+ messages / 3 participants
[nested] [flat]

* [pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
@ 2025-02-11 23:39 "kevinm416 (@kevinm416)" <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: kevinm416 (@kevinm416) @ 2025-02-11 23:39 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

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"
)
```


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

* Re: [pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
@ 2025-02-12 11:07 ` "davecramer (@davecramer)" <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

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

I suggest you post this on jooq . I don't have enough information here to help you

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

* Re: [pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5
@ 2025-02-12 11:16 ` "vlsi (@vlsi)" <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: vlsi (@vlsi) @ 2025-02-12 11:16 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

It seems to be related to https://github.com/pgjdbc/pgjdbc/pull/3386/files#diff-0571f8ac3385a7f7bb34e5c77f8afd2481031150698937...

I guess it has been resolved under https://github.com/jOOQ/jOOQ/issues/17873

I do not think we could improve anything here.

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


end of thread, other threads:[~2025-02-12 11:16 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-11 23:39 [pgjdbc/pgjdbc] issue #3522: Error when bumping org.postgresql:postgresql from 42.7.4 -> 42.7.5 "kevinm416 (@kevinm416)" <[email protected]>
2025-02-12 11:07 ` "davecramer (@davecramer)" <[email protected]>
2025-02-12 11:16 ` "vlsi (@vlsi)" <[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