From karebacnyc@yahoo.com Sun Dec 10 00:13:39 2006 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4AEE39FA103 for ; Sat, 9 Dec 2006 20:13:39 -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 55147-03 for ; Sat, 9 Dec 2006 20:13:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90515.mail.mud.yahoo.com (web90515.mail.mud.yahoo.com [216.252.100.182]) by postgresql.org (Postfix) with SMTP id 50EF19F9EED for ; Sat, 9 Dec 2006 20:13:32 -0400 (AST) Received: (qmail 94528 invoked by uid 60001); 10 Dec 2006 00:13:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=K3cXERwrkRaQvtmJlNYVBjJqSImKsT3gR6zKn+Cmcb2AxQaX0jAdjmck/zcRzB73d4c044IbCmtlsX9cfXU2cMFW6bR8j7D5uQKwfffuZ+qdmrqNT/7WWWQBYDc22dC80q8cK6a0g7zViv20EgWLT0nz/rG9AvmezjMLBvCJ+VA=; X-YMail-OSG: KZAQQNUVM1mBbVcvBUbOg5lleMMHVEhifwLNRHlbp8Nqj1plS2N0RR5M1LeOh1F08g-- Received: from [70.19.76.226] by web90515.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 16:13:30 PST Date: Sat, 9 Dec 2006 16:13:30 -0800 (PST) From: Philippe Salama Subject: \c bpsimple rick To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-949885259-1165709610=:92978" Content-Transfer-Encoding: 8bit Message-ID: <279843.92978.qm@web90515.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.088 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/126 X-Sequence-Number: 23918 --0-949885259-1165709610=:92978 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-949885259-1165709610=:92978 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-949885259-1165709610=:92978-- From karebacnyc@yahoo.com Sun Dec 10 00:40:59 2006 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-- From tgl@sss.pgh.pa.us Sun Dec 10 03:37:32 2006 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC0189FA182 for ; Sat, 9 Dec 2006 23:37:32 -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 84628-04 for ; Sat, 9 Dec 2006 23:37:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 38E449FA162 for ; Sat, 9 Dec 2006 23:37:29 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBA3bQ0d027891; Sat, 9 Dec 2006 22:37:27 -0500 (EST) To: Philippe Salama cc: PostgreSQL Admin Subject: Re: \c bpsimple rick In-reply-to: <279843.92978.qm@web90515.mail.mud.yahoo.com> References: <279843.92978.qm@web90515.mail.mud.yahoo.com> Comments: In-reply-to Philippe Salama message dated "Sat, 09 Dec 2006 16:13:30 -0800" Date: Sat, 09 Dec 2006 22:37:26 -0500 Message-ID: <27890.1165721846@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/130 X-Sequence-Number: 23922 Philippe Salama writes: > 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. How old is your textbook? What the # prompt actually means is that you are a "superuser", which means you can do anything at all within PostgreSQL (equivalent to root on a Unix system, and I-dunno-what on Windows). Creating databases is a lesser privilege. It used to be that creating users was only allowed to a superuser, but now we have a lesser privilege that allows non-superusers to create more (non-super) users. In any case, if you are superuser you can definitely do both of those things. If the book equates the # prompt to create-database privilege then it's flat out wrong, or at least has been for as long as I can remember. If it equates # to create-user privilege then it's only been wrong for the last release or two. regards, tom lane From karebacnyc@yahoo.com Sun Dec 10 04:06:35 2006 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8BD4C9FA1DA for ; Sun, 10 Dec 2006 00:06:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 80123-05 for ; Sun, 10 Dec 2006 00:06:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90504.mail.mud.yahoo.com (web90504.mail.mud.yahoo.com [216.252.100.171]) by postgresql.org (Postfix) with SMTP id 10F279FA18C for ; Sun, 10 Dec 2006 00:06:29 -0400 (AST) Received: (qmail 90332 invoked by uid 60001); 10 Dec 2006 04:06:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=hngtjAFowbQgCdmGBtu4sjOStXgT5PpQ6cBYrkDrC4hTR8tm2TDzXxol1+s6PD+DI1EE7c4xPjJq5eqaHa1DQxxhi9iBVcydLdhe7orZbmnoWh+9F/BMluDo7n6A3LYCOGt8PKVLEyCSMslDPaS1UpSPhfOA/mz/urnvDWs34Q4=; X-YMail-OSG: ovvJ99UVM1n3ORha3HqYlAaFeCMx2_ErBkujcuURx8phCJ22IFKvz.D2nQnrpOFyx3e0CyOwZcQzzaYQP5SxW1pcKKemOlblDlEhz5IWh9dUH5RBcA9l36d_ucYZ6s7.61XNcDGV9BUFDZc8B7qWDN.XKxXE3rVzn.Q- Received: from [70.19.76.226] by web90504.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 20:06:29 PST Date: Sat, 9 Dec 2006 20:06:29 -0800 (PST) From: Philippe Salama Subject: Re: \c bpsimple rick To: Tom Lane Cc: PostgreSQL Admin In-Reply-To: <27890.1165721846@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-950053530-1165723589=:90329" Content-Transfer-Encoding: 8bit Message-ID: <421940.90329.qm@web90504.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.041 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/132 X-Sequence-Number: 23924 --0-950053530-1165723589=:90329 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit The book has no date I can see, but I purchased it several years ago, and it speaks of PostgreSQL 8 as being new. As soon as I find the link again to subscribe to the novice forum, I shall do so, and not post in Admin. Thanks! Tom Lane wrote: Philippe Salama writes: > 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. How old is your textbook? What the # prompt actually means is that you are a "superuser", which means you can do anything at all within PostgreSQL (equivalent to root on a Unix system, and I-dunno-what on Windows). Creating databases is a lesser privilege. It used to be that creating users was only allowed to a superuser, but now we have a lesser privilege that allows non-superusers to create more (non-super) users. In any case, if you are superuser you can definitely do both of those things. If the book equates the # prompt to create-database privilege then it's flat out wrong, or at least has been for as long as I can remember. If it equates # to create-user privilege then it's only been wrong for the last release or two. regards, tom lane --------------------------------- Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. --0-950053530-1165723589=:90329 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit The book has no date I can see, but I purchased it several years ago, and it speaks of PostgreSQL 8 as being new.

As soon as I find the link again to subscribe to the novice forum, I shall do so, and not post in Admin.  Thanks!

Tom Lane <tgl@sss.pgh.pa.us> wrote:
Philippe Salama writes:
> 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.

How old is your textbook?

What the # prompt actually means is that you are a "superuser", which
means you can do anything at all within PostgreSQL (equivalent to root
on a Unix system, and I-dunno-what on Windows). Creating databases
is a lesser privilege. It used to be that creating users was only
allowed to a superuser, but now we have a lesser privilege that allows
non-superusers to create more (non-super) users. In any case, if you
are superuser you can definitely do both of those things.

If the book equates the # prompt to create-database privilege then it's
flat out wrong, or at least has been for as long as I can remember.
If it equates # to create-user privilege then it's only been wrong for
the last release or two.

regards, tom lane


Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. --0-950053530-1165723589=:90329--