Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9A06F9FA5C8 for ; Tue, 7 Nov 2006 06:43:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 22168-10 for ; Tue, 7 Nov 2006 06:43:37 -0400 (AST) X-Greylist: delayed 00:06:39.852977 by SQLgrey- Received: from web26004.mail.ukl.yahoo.com (web26004.mail.ukl.yahoo.com [217.12.10.215]) by postgresql.org (Postfix) with SMTP id 88E449FA4CF for ; Tue, 7 Nov 2006 06:43:36 -0400 (AST) Received: (qmail 2837 invoked by uid 60001); 7 Nov 2006 10:36:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.de; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type; b=fd9GDlheJg2GvUns9wJeqGadGb8TH2XNIUauKaNZCZVjjUJvUV0WaExuaPdmpTAMiWgCP40vNkdNNZkmoySg3dWLEUaHFfR/PM74+rQe91QAQG0JDNhv9n1xEkCZf5X8hIl9gDadqJ3oMJ/G4Zc12dEaYa+fzPKejiNdJyfciXk= ; Message-ID: <20061107103654.2835.qmail@web26004.mail.ukl.yahoo.com> Received: from [143.164.102.14] by web26004.mail.ukl.yahoo.com via HTTP; Tue, 07 Nov 2006 10:36:54 GMT Date: Tue, 7 Nov 2006 10:36:54 +0000 (GMT) From: Kuckuck Kuckuck Subject: Problems changing column attribute To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1923887866-1162895814=:2369" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.202 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200611/45 X-Sequence-Number: 23572 --0-1923887866-1162895814=:2369 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi folks, I have been breaking my head over this.=0AI logg in as testuser v= ia pgadmin.=0AI create a table as user 'testuser' added some columns, one o= f them for example is name: 'testcolumn' type: varchar length: 50=0ANow I'd= like to change testcolumn's length to 60, as user 'testuser' I'm not allow= ed to change it and pgadmin tells me that I don't have the rights to chang= e relation pg_attribute.=0A=0AIf I change the length of 'testcolumn' from = an admin account it works. Now I granted all priviliges for this table to u= ser 'testuser' via the admin account, but still I cannot change the length = if I log in with 'testuser'.=0A=0AIs there any chance to grant some user (i= n my case 'testuser') the right to change attributes, without making him su= peruser?=0A=0AThanks St.=0A=0A=0A=0A=0A=0A=0A=0A=0A=09=0A=09=09=0A_________= __________________________________________________ =0ADer fr=FChe Vogel f= =E4ngt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo= .de --0-1923887866-1162895814=:2369 Content-Type: text/html; charset=ascii Content-Transfer-Encoding: quoted-printable
Hi folks, I have been breaking my head over this.
I= logg in as testuser via pgadmin.
I create a table as user 'testuser' ad= ded some columns, one of them for example is name: 'testcolumn' type: varch= ar length: 50
Now I'd like to change testcolumn's length to 60, as user = 'testuser' I'm not allowed to change it and pgadmin tells me  that I d= on't have the rights to change relation pg_attribute.

If I change th= e length of  'testcolumn' from an admin account it works. Now I grante= d all priviliges for this table to user 'testuser' via the admin account, b= ut still I cannot change the length if I log in with 'testuser'.

Is = there any chance to grant some user (in my case 'testuser') the right to ch= ange attributes, without making him superuser?

Thanks St.


=0A=09=09
Keine Lust auf Tippen? Rufen Sie Ihre Fr= eunde einfach an.
=0A Yahoo! Messenger. Jetzt installieren =0A. = =0A --0-1923887866-1162895814=:2369--