Re: postgres 11 issue?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Steve Rogerson <steve(dot)pg(at)yewtc(dot)demon(dot)co(dot)uk>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres 11 issue?
Date: 2019-06-06 16:06:10
Message-ID: 20190606160610.GA17846@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-Jun-06, Steve Rogerson wrote:

> On 06/06/2019 14:35, Adrian Klaver wrote:
> > On 6/6/19 4:02 AM, Steve Rogerson wrote:
> >> I've just updated my laptop to pg11 and I'm getting a problem. I'm  trying to
> >> keeps the details confidential, so somewhat vague I'm afraid.
> >>
> >> sjr_local1db=> select count(*) from user_passwords ;
> >> ERROR:  record type has not been registered

> >> The timestamp column is a "row" consisting of a timestamp and the timezone
> >> (essentially),  the my_timestamp_now  is function that returns a "timestamp"
> >> for now.

> Ok - on it's way - in the mean time - what does "record type has not been
> registered" mean?

It seems a bug to me. Can you share an anonymized/simplified definition
of that table that reproduces the problem?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2019-06-06 17:03:26 Re: Table partition with primary key in 11.3
Previous Message Dan Collens 2019-06-06 15:47:09 Question about funding development