Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-docs-owner+M7609=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UFGj5-00070A-Gh
	for pgsql-docs@arkaria.postgresql.org; Tue, 12 Mar 2013 04:22:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-docs-owner+M7609=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UFGj5-0005zy-1A
	for pgsql-docs@arkaria.postgresql.org; Tue, 12 Mar 2013 04:22:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tharakan@gmail.com>) id 1UFGj4-0005zt-Cj
	for pgsql-docs@postgresql.org; Tue, 12 Mar 2013 04:22:10 +0000
Received: from mail-wi0-x236.google.com ([2a00:1450:400c:c05::236])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tharakan@gmail.com>) id 1UFGj1-0000eA-1w
	for pgsql-docs@postgresql.org; Tue, 12 Mar 2013 04:22:09 +0000
Received: by mail-wi0-f182.google.com with SMTP id hi18so1486852wib.3
	for <pgsql-docs@postgresql.org>; Mon, 11 Mar 2013 21:22:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:mime-version:sender:from:date:x-google-sender-auth
	:message-id:subject:to:content-type;
	bh=nsOkWhEkF7XWg2fooY2Szd5h30OPoA03RlC7l48fs+o=;
	b=QlwfWCHYotHxoq20PMw/1rh0fFBHPeKyBwDHRxsNMbj+wUFJ4upWhR3t+22kwtnIMK
	F9GXzsioo+bvMqzhQxfU63aMfkIhwXtRn9SvaBAMAQPK9kEXgVjW4gG41iWaGgidGApV
	Zirk5DvvvPe4edgL+GX7PBejRBVVSups/q0ZMFKj+dC1TXbnGkD82pzymyXXoI4vG0vz
	9gDn0DdjJnzBs08ui1s89uFRXSkId0MHNjB/G4Jrnsx2eTDLEIxWof0ZcKLphaRoEiD4
	BhYdy2hx/ocBwqPHznGhj7M9ICImF/ghcEzCgeOk/JgNsp2k8xtembOCvtLqx51mKpnd
	ZNmw==
X-Received: by 10.181.12.5 with SMTP id em5mr16728024wid.24.1363062125805;
	Mon, 11 Mar 2013 21:22:05 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.194.13.227 with HTTP; Mon, 11 Mar 2013 21:21:44 -0700 (PDT)
From: Robins <robins@pobox.com>
Date: Tue, 12 Mar 2013 09:51:44 +0530
X-Google-Sender-Auth: nRGG2LaC6iK9HJdRfFUCvCM7Tqk
Message-ID: 
 <CAEP4nAxFw=2pB-oJyWZkwo7hccggoDzooEBmv+umd1R-neyZXg@mail.gmail.com>
Subject: Clarify 'dependent objects' for DROP COLUMN
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=f46d043c7c58d0cae204d7b2a19a
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--f46d043c7c58d0cae204d7b2a19a
Content-Type: text/plain; charset=ISO-8859-1

Hi,

ALTER TABLE in postgresql.org/docs/devel/ says:

RESTRICT: Refuse to drop the column or constraint if there are any
dependent objects. This is the default behavior.

Could someone confirm whether 'dependent objects' also includes SEQUENCES? i.e.
if I create a sequence OWNED BY tbl.col1 and then try to drop the column
with RESTRICT, should it allow this DROP? Currently it does, but by reading
that line it seemed it shouldn't.

Thanks
---
Robins Tharakan

--f46d043c7c58d0cae204d7b2a19a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default"><div class=3D"gmail_default">=
<font color=3D"#000000" face=3D"trebuchet ms, sans-serif">Hi,</font></div><=
div class=3D"gmail_default"><font color=3D"#000000" face=3D"trebuchet ms, s=
ans-serif"><br>

</font></div><div class=3D"gmail_default" style><font color=3D"#000000" fac=
e=3D"trebuchet ms, sans-serif">ALTER TABLE in=A0</font><span style=3D"color=
:rgb(0,0,0);font-family:&#39;trebuchet ms&#39;,sans-serif"><a href=3D"http:=
//postgresql.org/docs/devel/">postgresql.org/docs/devel/</a> says:</span></=
div>

<div class=3D"gmail_default"><span style=3D"color:rgb(0,0,0);font-family:&#=
39;trebuchet ms&#39;,sans-serif"><br></span></div><div class=3D"gmail_defau=
lt"><span style=3D"color:rgb(0,0,0);font-family:&#39;trebuchet ms&#39;,sans=
-serif">RESTRICT: Refuse to drop the column or constraint if there are any =
dependent objects. This is the default behavior.</span><br>

</div><div class=3D"gmail_default"><font color=3D"#000000" face=3D"trebuche=
t ms, sans-serif"><br></font></div><div class=3D"gmail_default" style><div =
class=3D"gmail_default"><font color=3D"#000000" face=3D"trebuchet ms, sans-=
serif">Could someone confirm whether &#39;dependent objects&#39; also inclu=
des SEQUENCES? </font><span style=3D"color:rgb(0,0,0);font-family:&#39;treb=
uchet ms&#39;,sans-serif">i.e. if I create a sequence OWNED BY tbl.col1 and=
 then try to drop the column with RESTRICT, should it allow this DROP? Curr=
ently it does, but by reading that line it seemed it shouldn&#39;t.</span><=
/div>

<div class=3D"gmail_default"><br></div><div class=3D"gmail_default" style>T=
hanks<br clear=3D"all"><div>---<div>Robins Tharakan</div></div>
</div></div>
</div></div>

--f46d043c7c58d0cae204d7b2a19a--