Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNzQe-003NEx-Bs for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 19:09:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tNzQd-0017Qr-FZ for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 19:09:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNzQd-0017Q0-5V for pgsql-general@lists.postgresql.org; Wed, 18 Dec 2024 19:09:50 +0000 Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNzQa-000SF9-7T for pgsql-general@postgresql.org; Wed, 18 Dec 2024 19:09:50 +0000 Received: by mail-oi1-x236.google.com with SMTP id 5614622812f47-3eb7f3b1342so2880534b6e.1 for ; Wed, 18 Dec 2024 11:09:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734548987; x=1735153787; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=6hmzNEnwQje2c10fhpUQYSzWlZ1HMNBK54YOh0nuYQw=; b=E0UX/PxAFPyXDW+TqJnpTghFFKS5Ip3EA+T286gsglqcZU3gBnTDbR8JENELk9GHsO ck4RxMVf2Ze8vY4WaIeNKEB/aE6kw1oZwgEuzt67LWRbs8fjEZHwB7A8Yg7O9EaMr12J GGRyw2BaKhzM/Dpi07m1jkuJCYUuIIBz2Q79Q37Ulfl3nNgs8LwcQ1BE6jbEYrnEDmaD gUDYAvJB6VJmMQXpOhExkZbIJaVJhbu6y5o/UbjgHusQSqcz4Lc7OYcM0EHR5vAZJirb mSbR+EeAuo1hr74fLB0ABiJhjKfpz2byXvyT6QkQfwy2PgwOOhaOZrFiJ1VzdHiVghnn QloA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734548987; x=1735153787; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=6hmzNEnwQje2c10fhpUQYSzWlZ1HMNBK54YOh0nuYQw=; b=jXTKnK3d+K3XtJijw1K5LS1Bj8rwzZCu3PG0Y7LiDrVc+Kn+YdLuXNlYPVuGE8B/ny 2TODa9XTAX/YYW1/4deFizVG2beQIXT9hDpLqNbLSAsuDckV2RJnSsXLbbHRL4urkPoF tnoxrhcPkcf1Ow/7VxhgQb5d4g3+FF0RzRvF/i1JlZEjpUIH38WxOYmFPQDGKrCmVcb0 65LY0f4JwuSdBp/Q3iXbEbgSm7sBoZe+5daGwBL6AFB++K9fgS7xLqcBNoAOljaZ5hF2 gb6thnrvkvR/CbBUTl6VMFgFeHm5QYyXfuhLrXoHylaeYZ7+JTsgX9ujOE/U3WqetqYH xvQA== X-Gm-Message-State: AOJu0YxT+9q72IXFiop16OpSOA3++bDVPx4l3Qnhgi4kDTKzvTL6sP8U MRVL7Nsc7/yvOFjXX/Uw1NEzkGdPMsljCdIGW8zzhAWytz46rnuX8wrQUjfzoz6hSVcrQclhDzM xhSHQ6sBXxLVX1H/tOIpko2OHxpXlHw== X-Gm-Gg: ASbGncvQPcMqT4o8mCzt4rCTkZKwfvAVEjcikR3Bbkq2o7t9aR0kUGbvD4orghYgc40 SYbxRMz0nira+E+xdRDHENcXVIxhZhvuWCUyB/g== X-Google-Smtp-Source: AGHT+IE9oQxnD4ZTWB6b9GQWupPuLFAods7NsL9MKXk/ajtUjWL055VOnDLwqWDABELmTlswAQWKKseWX1mkTDi5zjU= X-Received: by 2002:a05:6808:2e4d:b0:3ea:4aad:a889 with SMTP id 5614622812f47-3eccc070e0emr2733388b6e.26.1734548986571; Wed, 18 Dec 2024 11:09:46 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:5d0f:0:b0:577:9519:f64a with HTTP; Wed, 18 Dec 2024 11:09:46 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 18 Dec 2024 12:09:46 -0700 Message-ID: Subject: Re: Cannot drop column To: Rich Shepard Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="00000000000030b43a0629902811" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000030b43a0629902811 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, December 18, 2024, Rich Shepard wrote: > On Wed, 18 Dec 2024, Rich Shepard wrote: > > Since your column name has an Upper case character, you will have to use >>> double quotes to drop it. Try alter table statustypes drop column >>> "Suspect"; >>> >> > Thanks for the lesson. >> > > But, > > bustrac=3D# alter table statustypes drop column "Suspect"; ERROR: column > "Suspect" of relation "statustypes" does not exist > bustrac=3D# > > Double quoting didn't resolve the issue. > Red Ron=E2=80=99s email=E2=80=A6 David J. --00000000000030b43a0629902811 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, December 18, 2024, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Wed, 18 Dec 2024, Rich Shepard wrote:

Since your column name has an Upper case character, you will have to use double quotes to drop it. Try alter table statustypes drop column
"Suspect";

Thanks for the lesson.

But,

bustrac=3D# alter table statustypes drop column "Suspect"; ERROR:= =C2=A0 column "Suspect" of relation "statustypes" does = not exist
bustrac=3D#

Double quoting didn't resolve the issue.

Red Ron=E2=80=99s email=E2=80=A6

David J.=C2=A0
--00000000000030b43a0629902811--