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 1tNz81-003LW7-6d for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 18:50:37 +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 1tNz80-000gHX-6X for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 18:50:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNz7z-000gHP-RI for pgsql-general@lists.postgresql.org; Wed, 18 Dec 2024 18:50:35 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNz7x-000FUC-29 for pgsql-general@postgresql.org; Wed, 18 Dec 2024 18:50:34 +0000 Received: by mail-oi1-x235.google.com with SMTP id 5614622812f47-3eb8db8ae9aso3012669b6e.1 for ; Wed, 18 Dec 2024 10:50:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734547832; x=1735152632; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Rjk58ccEzD30TIxjMZhWQYWc5WSjRK+QxuH+DtGeOUo=; b=nQ54jLvjKvXlPq+t+VkBm9VSBbY5vOawaK95yjik4eCuR7ci+AYJm8dPdx+GlHZSVL hdbu6rPvs1ngQJ3Vcu3u0H9eX5++6KsPx+lIhDktWh/+LFhaGG5KlPdNUYnq7n5El+so hdq7YI+jB+0iYqlShNtFn7sPYCYf4hgDDWCSr1Jyu7U59ywbrmGHPmodQkrJbPHlaI7Q EYm68mcDMm+I3W4BLOZxPrdGb0Gbn8qLKMaJZb4C/xFiNKJjWmZuwBeZAn0QvKSmv9bA zCrdgUNQIG3CsogyTOltIJ9qEsaK/Yq2m8DmbrIgXNOhueJfbhI2RazytLL0McpAy0SB oVXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734547832; x=1735152632; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Rjk58ccEzD30TIxjMZhWQYWc5WSjRK+QxuH+DtGeOUo=; b=DwmoHLWT5qScMGn0Yp+n4TtDobk53ztnocUd5GOgu4apIYlOB5Tc8esvGXwCPRQ5IX 7IDgq2Yuq5oR6g+aJqlZRtzRRwAmJupGWSwEQC6kNNI7CMgV2Z111HpWggbAty6hXCWq iEQww4x+4IkqKBlyG97mLcKIw5J1pgvTWefc4A0z+ySfHoEfZxIokwf5rBByp9Mi9rb5 BTJec0VlmVMOP+zE8c1is7/QghlFydwgeB+x+XnzalutkdGxYtQot3lL0TH29WzqvpTX Zk/mzEfaRy5tU+qCTZUHwkPaE/oCMLuP/yWUgxy8EWRpKZMuKE822SO82bykSYvEOCLa a8Kg== X-Gm-Message-State: AOJu0YyedHjobw5Q9jmwP2xoTwhbkdhFjtEJcTGEffHGhugYevhg6mTz J5krWSxA6EB8Judz4ripP82BLJi+PXPF2AkgjbfGH5UFehz7AWSurPofVBGZYnUrp9t8xGBXUH7 /RcvnOUgDxU/SzlZXtwXF2YLCqw3iJw== X-Gm-Gg: ASbGncs/GWddPxCaMRk2nT2pZ2LjTFsHmA/Ui/G/V+aEfYnoIe96QbkeaQ+R9EZmDOU TnQBBA0WnMvOZDH06Fas2DT08ySBz1QkbmbTDZA== X-Google-Smtp-Source: AGHT+IFboMEJeDSyUWb5fPI2Xbnfk08QdEhVFjKKcHR56dKgmXN+kFuF2wCoarpSsVA4xbOEar+FywTr+u5hnhtaMxo= X-Received: by 2002:a05:6808:2010:b0:3eb:5480:59c6 with SMTP id 5614622812f47-3eccc099684mr2079891b6e.30.1734547832313; Wed, 18 Dec 2024 10:50:32 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Wed, 18 Dec 2024 11:49:56 -0700 Message-ID: Subject: Re: Cannot drop column To: Rich Shepard Cc: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="00000000000064242606298fe3d2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000064242606298fe3d2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Dec 18, 2024 at 11:47=E2=80=AFAM Rich Shepard wrote: > I'm not seeing why postgres won't drop a table's column: > > bustrac=3D# select * from statustypes order by stat_name; > stat_name > -------------------- > Client > Lead > No further contact > Opportunity > Proposal submitted > Prospect > Qualified > Referral > Suspect > (9 rows) > > bustrac=3D# alter table statustypes drop column Suspect; > ERROR: column "suspect" of relation "statustypes" does not exist > bustrac=3D# > > What have I done incorrectly? > Failed to double-quote your column name. David J. --00000000000064242606298fe3d2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Dec 18, 2024 at 11:47=E2=80=AFAM Rich Shepard <= rshepard@appl-ecosys.com>= ; wrote:
I'm not seeing why p= ostgres won't drop a table's column:

bustrac=3D# select * from statustypes order by stat_name;
=C2=A0 =C2=A0 =C2=A0 stat_name
--------------------
=C2=A0 Client
=C2=A0 Lead
=C2=A0 No further contact
=C2=A0 Opportunity
=C2=A0 Proposal submitted
=C2=A0 Prospect
=C2=A0 Qualified
=C2=A0 Referral
=C2=A0 Suspect
(9 rows)

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

What have I done incorrectly?

Failed to d= ouble-quote your column name.

David J.

--00000000000064242606298fe3d2--