\d+ table_name results in column c.relhasoids does not exist

[paulm17]

Running 0.2.13.

In psql, when I do \d+ [table_name]. I get the following:

column c.relhasoids does not exist

Running psql version:

paul@Pauls-MBP-2 ~ % psql --version
psql (PostgreSQL) 16.2

[yacineb]

@paulm17 have you tried with psql v16.4 ?

[paulm17]

@yacineb That's oddly specific. I'm using brew and I can't install another version except 17.2.

It's the same error with 17.2 as well.

[pmp-p]

please, what socket gateway are you using, and full "psql" command line used to connect ?

[paulm17]

@pmp-p

what socket gateway are you using

Do you mean this?:

I had pg-lite running via node:cluster.

It was something like this (I'm pulling from an old comment, as I've now changed the config - see below).

import { join } from 'path';
import { createServer, LogLevel } from '@acme/pglite-server';
import { PGlite } from '@electric-sql/pglite';
import pg from 'pg';

(async () => {
  try {
    const db = new PGlite({ dataDir: join(import.meta.dirname, 'pglite-data') });
    await db.waitReady;

    // @ts-expect-error
    const pgServer = createServer(db);

    pgServer.listen(5432, async () => {
      const client = new pg.Client({
        host: 'localhost',
        port: 5432,
        database: 'postgres',
        user: 'postgres',
      });
      await client.connect();
    });
  } catch (err) {
    console.error('Server error:', err);
  }
})();

and full "psql" command line used to connect ?

psql -U postgres -h 127.0.0.1

Fyi, I've now moved to leinelissen/embedded-postgres as pglite was causing downstream issues wrt commonjs/esm.

I'll keep this issue open.