From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | ERROR: no NOT NULL constraint found to drop |
Date: | 2023-04-10 07:16:06 |
Message-ID: | CAMbWs48astPDb3K+L89wb8Yju0jM_Czm8svmU=Uzd+WM61Cr6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I run into error $subject with the query below:
# create table t1 (c int primary key null unique);
CREATE TABLE
# create table t2 (like t1);
CREATE TABLE
# alter table t2 alter c drop not null;
ERROR: no NOT NULL constraint found to drop
This starts since e056c557ae. I guess this shouldn't happen since the
comment says so.
/* this shouldn't happen */
elog(ERROR, "no NOT NULL constraint found to drop");
Thanks
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-04-10 07:55:28 | Re: ERROR: no NOT NULL constraint found to drop |
Previous Message | Tom Lane | 2023-04-07 17:36:23 | Re: Need assistance in performance tuning of a particular query |