postgres 11 issue?

From: Steve Rogerson <steve(dot)pg(at)yewtc(dot)demon(dot)co(dot)uk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgres 11 issue?
Date: 2019-06-06 11:02:49
Message-ID: cbaecae6-7b87-584e-45f6-4d047b92ca2a@yewtc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-06 13:35:09 Re: postgres 11 issue?
Previous Message Alex V. 2019-06-06 10:30:00 Re: Table partition with primary key in 11.3