From: | hvjunk <hvjunk(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | "alter table...if exists... add bigserial "still adds extra sequence |
Date: | 2017-09-25 07:51:49 |
Message-ID: | BCD0C88B-C3DF-4FE2-9AAF-D6439680B897@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good day,
See the sequence below, Postgresql 9.6.5 on Debian using the postgresql repository.
Question: Is this expected behaviour?
postgres(at)tracsdbhvt01:~$ cat test-serial.sql
create database test;
\c test
create table test_serial ( teststring varchar(5));
alter table test_serial add column if not exists uid BIGSERIAL;
alter table test_serial add column if not exists uid BIGSERIAL;
\d
postgres(at)tracsdbhvt01:~$ psql -p 5433 < test-serial.sql
CREATE DATABASE
You are now connected to database "test" as user "postgres".
CREATE TABLE
ALTER TABLE
NOTICE: column "uid" of relation "test_serial" already exists, skipping
ALTER TABLE
List of relations
Schema | Name | Type | Owner
--------+----------------------+----------+----------
public | test_serial | table | postgres
public | test_serial_uid_seq | sequence | postgres
public | test_serial_uid_seq1 | sequence | postgres
(3 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | hvjunk | 2017-09-25 08:34:54 | Re: "alter table...if exists... add bigserial "still adds extra sequence |
Previous Message | Tomas Vondra | 2017-09-24 17:59:05 | Re: shared_buffers smaller than max_wal_size |