Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CCCBD9FA103 for ; Sat, 9 Dec 2006 20:40:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 58716-02 for ; Sat, 9 Dec 2006 20:40:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90503.mail.mud.yahoo.com (web90503.mail.mud.yahoo.com [216.252.100.170]) by postgresql.org (Postfix) with SMTP id 6F5129F9EED for ; Sat, 9 Dec 2006 20:40:50 -0400 (AST) Received: (qmail 12265 invoked by uid 60001); 10 Dec 2006 00:40:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=yHpiM29ptEOfVLXElkUILSHnaT7owIN+89u9MH5cw97XQm7nWw7+61JF/5jjRLoWn7OPmoivBEkhLVCP9zw/xPrW3XQXkDM8wYxFjAHFIyO8GqhZl6tc45rQPsv1iHvgJ3h/IvPE4Z0sZg79Aprxns8hbQ9bSFLq7hhmeeUpswE=; X-YMail-OSG: 1dhzUJYVM1mp8oGD8Xdc.7gwQILY_qO6bkqhkCccT8xHjZUs_zg1TrYTyeQewuN.VdBRJ1Y5W7sd.QaEb1_b9GHJueIdSg3DhWzv8jyIrORzMEbty2BG5SQjORyaocJ8MPTA_d7alzLgVnGIQGyRtPompa6uYX2KEE0- Received: from [70.19.76.226] by web90503.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 16:40:48 PST Date: Sat, 9 Dec 2006 16:40:48 -0800 (PST) From: Philippe Salama Subject: Re: \c bpsimple rick To: Philippe Salama , PostgreSQL Admin In-Reply-To: <279843.92978.qm@web90515.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-354427944-1165711248=:11222" Content-Transfer-Encoding: 8bit Message-ID: <461009.11222.qm@web90503.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.253 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/128 X-Sequence-Number: 23920 --0-354427944-1165711248=:11222 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I am guessing that my confusion is over something which may be a typo in the text book. I have moved along and have now make good progress in running with \i the sql scripts which may be downloaded from http://www.apress.com/book/supplementDownload.html?bID=424&sID=2569 the publisher of the book, to define tables for the exercises, and load the tables with data. So, thanks for the help here to get me started! Philippe Salama wrote: My textbook had me create a user named rick, with the power to create databases, but not the power to create new users. in the next exercise, I am in template1 as user neil, who has the prompt =# which means that neil has power to create databases. I am told to \c bpsimple rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has no power to create databases. I am confused, since clearly, I created user/role rick as someone with the power to create databases. --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited. --------------------------------- Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. --0-354427944-1165711248=:11222 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I am guessing that my confusion is over something which may be a typo in the text book.

I have moved along and have now make good progress in running with \i the sql scripts which may be downloaded from

http://www.apress.com/book/supplementDownload.html?bID=424&sID=2569

the publisher of the book,

to define tables for the exercises, and load the tables with data.

So, thanks for the help here to get me started!

Philippe Salama <karebacnyc@yahoo.com> wrote:
My textbook had me create a user named rick, with the power to create databases, but not the power to create new users.

in the next exercise, I am in template1 as user neil, who has the prompt =# which means that neil has power to create databases.  I am told to \c bpsimple rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has no power to create databases.

I am confused, since clearly, I created user/role rick as someone with the power to create databases.



Access over 1 million songs - Yahoo! Music Unlimited.


Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. --0-354427944-1165711248=:11222--