Thanks Tom!
Thanks for confirming, so I know I'm not going crazy :)
FWIW, it works on 10.3 to 10.8 (I think) and looks like a regression.
psql (10.3 (Debian 10.3-2))
Type "help" for help.
test=# create table users(id serial primary key, name varchar(255), email
varchar(255), age int);
CREATE TABLE
Time: 26.
e text;
ERROR: relation "users_name_idx" already exists
test=# select version();
version
---
PostgreSQL 11.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 8.3.0)
8.3.0, 64-bit
(1 row)
Not sure what's goin
Hi,
I'm encountering an issue altering multiple column types in a single ALTER
TABLE
psql (12beta2, server 11.4)
Type "help" for help.
test=# create table users(id serial primary key, name varchar(255),
age int, email varchar(255));
CREATE TABLEtest=# create index users_name_idx on users(name);
C
;::timestamp with time zone at time
zone 'Australia/Melbourne';
timezone
-
2017-12-01 11:00:00
Cheers
On 4 December 2017 at 13:59, Bharanee Rathna wrote:
> Sorry I didn't mean for it to come out as a complaint, just that I am
> confused since
Sorry I didn't mean for it to come out as a complaint, just that I am
confused since the result of the SQL query was not what I expected. I
expected +11:00 to be 11 hours east of UTC which wasn't the case.
On 4 December 2017 at 13:55, Tom Lane wrote:
> Bharanee Rathna wr
Hi,
the documentation around how numeric offsets are parsed from strings is a
bit confusing, are they supposed to be treated as ISO8601 or POSIX ?
e.g.
select '2017-12-01 11:00:00 +11:00'::timestamp with time zone at time zone
'+11:00';
timezone
-
2017-11-30 13:00:0
