From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Steve Rogerson <steve(dot)pg(at)yewtc(dot)demon(dot)co(dot)uk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres 11 issue? |
Date: | 2019-06-06 13:35:09 |
Message-ID: | 676fc03d-9cf6-1eb6-4dce-9e85c8b22840@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
> sjr_local1db=> insert into user_passwords (name, "timestamp", password) values
> ('user1', my_timestamp_now(), 'dsfsdfsdf');
> INSERT 0 1
>
> sjr_local1db=> select count(*) from user_passwords ;
>
> count
> -------
> 27
> (1 row)
>
> 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.
>
> This all works fine for pg >= 9 and pg <11.
More information is needed:
1) Table definition
2) Exactly how "timestamp" is defined.
3) my_timestamp_now definition.
>
>
> Steve
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2019-06-06 13:50:37 | pg_dump include/exclude data, was: verify checksums / CREATE DATABASE |
Previous Message | Steve Rogerson | 2019-06-06 11:02:49 | postgres 11 issue? |