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
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 |