Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-docs-owner+M7610=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UFHzR-0004dP-Rz
	for pgsql-docs@arkaria.postgresql.org; Tue, 12 Mar 2013 05:43:10 +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+M7610=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
	id 1UFHzR-0001dk-32
	for pgsql-docs@arkaria.postgresql.org; Tue, 12 Mar 2013 05:43:09 +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 1UFHzQ-0001de-3I
	for pgsql-docs@postgresql.org; Tue, 12 Mar 2013 05:43:08 +0000
Received: from mail-wg0-f45.google.com ([74.125.82.45])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tharakan@gmail.com>) id 1UFHzL-0002jN-Qy
	for pgsql-docs@postgresql.org; Tue, 12 Mar 2013 05:43:05 +0000
Received: by mail-wg0-f45.google.com with SMTP id dq12so5893265wgb.24
	for <pgsql-docs@postgresql.org>; Mon, 11 Mar 2013 22:43:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:mime-version:from:date:message-id:subject:to
	:content-type; bh=Kfi3wJB9btCLkkKhzKwioPMs9CqYNt7hdsdfxe0aicw=;
	b=HU7ybxGmmhLLfVfAlNInLcEkdBSA6kzj1atV63eaJtWjPohIYSW5iQGD4HXOM+fXEF
	LWFagqb2nAcF4+ZcbqYyll6ief4vZCbgrEAxpyEIPeGaFVfFgR3xoghm3ZlZVMcHBITX
	Sn21TXm8HwEdnQSuLXLpeCmAxHkm4pw4NB4F+mWfhKgwVgRVPZjrb6lEe8CID9c22mGl
	uNgrXQ0y+tv90S+VbjdQTTXm5TM+D5df+O/pqSeEpZSsAclp8rbcOzOuH4MzKX5tvsCU
	Jh8Orjk9lRd1K9EZWNmBwi+jRqJhoGyuDpPqFT+TvM4cTn3yB6af1tUC+Mziy8ubs8dh
	P8nQ==
X-Received: by 10.180.183.4 with SMTP id ei4mr16787898wic.21.1363066982756;
	Mon, 11 Mar 2013 22:43:02 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.194.13.227 with HTTP; Mon, 11 Mar 2013 22:42:42 -0700 (PDT)
From: robins <tharakan@gmail.com>
Date: Tue, 12 Mar 2013 11:12:42 +0530
Message-ID: 
 <CAEP4nAxJzygfcywQDg3R=K=ZioF51xXF4v2e6A9NrWP-Un=P=Q@mail.gmail.com>
Subject: Clarify 'dependent objects' for DROP COLUMN
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=001a11c22a2e4ff85004d7b3c3d7
X-Pg-Spam-Score: -2.7 (--)
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

--001a11c22a2e4ff85004d7b3c3d7
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
p.s.: Had to re-post this. Apologies if this lands up twice in the queue.

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

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:&#39;tre=
buchet ms&#39;,sans-serif;font-size:small;color:rgb(0,0,0)"><div class=3D"g=
mail_default" style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;fon=
t-size:13px">

<font color=3D"#000000" face=3D"trebuchet ms, sans-serif">Hi,</font></div><=
div class=3D"gmail_default" style=3D"color:rgb(34,34,34);font-family:arial,=
sans-serif;font-size:13px"><font color=3D"#000000" face=3D"trebuchet ms, sa=
ns-serif"><br>

</font></div><div class=3D"gmail_default" style=3D"color:rgb(34,34,34);font=
-family:arial,sans-serif;font-size:13px"><font color=3D"#000000" face=3D"tr=
ebuchet ms, sans-serif">ALTER TABLE in=A0</font><span style=3D"font-family:=
&#39;trebuchet ms&#39;,sans-serif"><a href=3D"http://postgresql.org/docs/de=
vel/" target=3D"_blank">postgresql.org/docs/devel/</a>=A0says:</span></div>

<div class=3D"gmail_default" style=3D"color:rgb(34,34,34);font-family:arial=
,sans-serif;font-size:13px"><span style=3D"font-family:&#39;trebuchet ms&#3=
9;,sans-serif"><br></span></div><div class=3D"gmail_default" style=3D"color=
:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">

<span style=3D"font-family:&#39;trebuchet ms&#39;,sans-serif">RESTRICT: Ref=
use to drop the column or constraint if there are any dependent objects. Th=
is is the default behavior.</span><br></div><div class=3D"gmail_default" st=
yle=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">

<font color=3D"#000000" face=3D"trebuchet ms, sans-serif"><br></font></div>=
<div class=3D"gmail_default" style=3D"color:rgb(34,34,34);font-family:arial=
,sans-serif;font-size:13px"><div class=3D"gmail_default"><font color=3D"#00=
0000" face=3D"trebuchet ms, sans-serif">Could someone confirm whether &#39;=
dependent objects&#39; also includes SEQUENCES?=A0</font><span style=3D"fon=
t-family:&#39;trebuchet ms&#39;,sans-serif">i.e. if I create a sequence OWN=
ED BY tbl.col1 and then try to drop the column with RESTRICT, should it all=
ow this DROP? Currently it does, but by reading that line it seemed it shou=
ldn&#39;t.</span></div>

<div class=3D"gmail_default" style><br></div><div class=3D"gmail_default" s=
tyle>Thanks</div><div class=3D"gmail_default">--<br clear=3D"all"><div>Robi=
ns Tharakan</div><div style>p.s.: Had to re-post this. Apologies if this la=
nds up twice in the queue.</div>

</div></div></div>
</div>

--001a11c22a2e4ff85004d7b3c3d7--