X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 954949FB27B for ; Mon, 10 Jul 2006 18:57:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82805-05 for ; Mon, 10 Jul 2006 18:57:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D80A69FB286 for ; Mon, 10 Jul 2006 18:57:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from CORREOAGS03.inegi.gob.mx (unknown [200.23.9.80]) by svr4.postgresql.org (Postfix) with ESMTP id D69E95AF025 for ; Mon, 10 Jul 2006 21:57:24 +0000 (GMT) Received: from [10.22.6.71] ([10.22.6.71]) by CORREOAGS03.inegi.gob.mx with Microsoft SMTPSVC(6.0.3790.1830); Mon, 10 Jul 2006 16:55:45 -0500 Message-ID: <44B2CCDC.9060407@inegi.gob.mx> Date: Mon, 10 Jul 2006 16:55:40 -0500 From: KyLiE User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: %Alter Help Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 10 Jul 2006 21:55:45.0425 (UTC) FILETIME=[9889A010:01C6A46B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/61 X-Sequence-Number: 22307 Hi all, I have a new question, know i'm trying to alter one of my tables,but the thing is, that I need to change the range of one of my columns, I've allready try this: ALTER TABLE lugar alter column sitio varchar2(500); but it gives me a syntax error. and i don't know why. Any help I'll appreciate . Regards.