> Oh sorry about posting in the wrong forum. You are perfectly right. How do I
> navigate to join
> the novice forum? I will bookmark the link for future reference. Thanks for
> the explanation. I
> will post all future questions in the novice forum, once I find out how to
> join.
http://w
I found the novice subscribe link
http://archives.postgresql.org/pgsql-novice/
and subscribed as Karebac at my other email.
Tomorrow morning, I will unsubscribe her, and subcribe and post only if I have
a legitimate ADMIN question, which probably wont be for a long time. Thanks!
Philippe Salama
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 <[EMAIL PROTECTED]> wrote: Philippe Salama writes:
> My t
Oh sorry about posting in the wrong forum. You are perfectly right. How do I
navigate to join the novice forum? I will bookmark the link for future
reference. Thanks for the explanation. I will post all future questions in the
novice forum, once I find out how to join.
Tom Lane <[EMAIL PRO
Philippe Salama <[EMAIL PROTECTED]> 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 databas
Philippe Salama <[EMAIL PROTECTED]> writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs
> from USER
Users are the same thing as roles, pretty much. A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call gr
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 b
Under windows pgAdmin works very well.
If you install in under Linux I recommends you phpPgAdmin that is a wphp
web application accessible from everywhere depending sour server accesses
Olivier
Shoaib Mir a écrit :
Windows installer has pgAdmin bundled in, which can serve as a very
easy to u
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 NO
The textbook wanted me to create-db -U neil bpsimple, but I accidentally
created it as postgres. I want to follow directions so future exercises will
work ok.
It has taken me a while to figure out that there are , in bin, programs such
as createdb.exe which look for parameters on command line
Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from
USER
http://www.postgresql.org/docs/8.1/interactive/sql-createrole.html
-
Want to start your own business? Learn how on Yahoo! Small Business.
See this link from PostgreSQL 8.2 official documentation.
http://www.postgresql.org/docs/8.2/interactive/app-createuser.html
It clearly describes the details and sitches of the createuser binary.
And also, I would recommend using this documentation rather than
a book which may (actually will) co
When I try clicking on the icon createuser.exe in \bin ... if I create the new
user rick, and say no to superuser, but yes to create databases, but no to
create users, then it asks me about creating new ROLES, which my textbook does
not mention
Just curious, which obviously, I may google on :
Of course now, I am in psql command line, and trying in vain to make the
examples work in "Beginning Databasses with POSTGRESQL" by Matthew and Stones.
I can type \H and see help
I can type \? and read the list that results, of commands
I see a prompt template1-#
yet when I type at that prompt
Glad to hear that it worked out good for you :-)
Thanks,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
Thanks Shoaib. You are perfectly correct! After I installed postgresql,
but without installing any odbc driver, I went to MS
Thanks Shoaib. You are perfectly correct! After I installed postgresql, but
without installing any odbc driver, I went to MS Access, and found both the
ANSI and the Unicode driver. I think I chose ANSI, ... I was able to link to
all the tables which the Celko script defined, and I was able to b
and yet, the script I ran clearly has inserts of data to the tables. And there
was no indication that something failed when I ran the script
Here is an excerpt from the script file
ALTER TABLE format.statuscodes OWNER TO postgres;
SET search_path = define, pg_catalog;
--
-- Data for Name: abs
On Sat, 2006-12-09 at 13:15 -0800, Philippe Salama wrote:
> Thanks Joshua, but that link is about as clear as mud to a beginner
> like me. And another post explains that the ODBC was already installed
> along with postgresql. All I want to do is connect with MS Access.
O.k. your question is a litt
Thanks Joshua, but that link is about as clear as mud to a beginner like me.
And another post explains that the ODBC was already installed along with
postgresql. All I want to do is connect with MS Access.
By the way. I already have PGExplorer, and right away, it connected and showed
me the Cel
But now, the admin program is showing me EVERYTHING UNDER THE SUN, except the
tables that were created by the script I ran. I need to find some other admin
program. I dont understand why this admin program is so obscure. I find
others which are quite intuitive
On Sat, 2006-12-09 at 12:48 -0800, Philippe Salama wrote:
> I just installed 8.2.1 postgresql. Now I want an odbc driver to work
> on my Dell XP with MS Access. The choices are very confusing. Please
> advise. I am not a rocket scientist. Thanks!
http://projects.commandprompt.com/public/odbcng/b
Once you have installed PostgreSQL you can now use the ANSI or Unicode ODBC
driver from the ODBC driver manager in Windows as it gets installed
automatically during installation.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wr
Use this ODBC driver to connect to PostgreSQL.
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
Windows versions already contain ODBC drivers for MS Access.
--Imad
Rocket Scientist :-)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
I just installed 8.2.1 postgresql. Now I
I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my Dell
XP with MS Access. The choices are very confusing. Please advise. I am not a
rocket scientist. Thanks!
-
Want to start your own business? Learn how on Yahoo! Small Business.
Windows installer has pgAdmin bundled in, which can serve as a very easy to
use database administration software.
Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
Thanks for install link.
Can anyone recommend a good free
Thanks for install link.
Can anyone recommend a good freeware admin program for posgresql. Thanks!
Anyone use navicat (which is not free i know). Any opinions? Thanks!
Shoaib Mir <[EMAIL PROTECTED]> wrote: You can get that from here -->
http://wwwmaster.postgresql.org/download/mirrors-ftp?file
You can get that from here -->
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip
Regards,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
I just uninstalled at home, becau
OK. I just uninstalled my old postgresql 8.0 and the odbc, and now I am
installing the 8.2.1 and will install the odbc driver, and then I shall run
your script.
Installation seems easier now than it was 2 or 3 years ago.
Thanks
Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > I was a little co
I just uninstalled at home, because what I had is old and I want the latest.
I installed at work, but I forgot the best link to install the latest
postgresql and also the odbc for windows so I can link to tables with MS Access.
Thanks!
-
Everyone is raving abou
> I was a little confused about how to reply, but now I see the yahoo option
> REPLY TO EVERYONE, so
> I shall try it right now, and see if it works, and comes back from the
> majordomo listserve.
>
> I have an older version of Postgresql 8.1 I think or 8.0. So your script did
> not work
> per
I was a little confused about how to reply, but now I see the yahoo option
REPLY TO EVERYONE, so I shall try it right now, and see if it works, and comes
back from the majordomo listserve.
I have an older version of Postgresql 8.1 I think or 8.0. So your script did
not work perfectly. I guess
--- Philippe Salama <[EMAIL PROTECTED]> wrote:
> I am new to these things. I have the command line prompt now, to postgresql
> on windows. I also
> have a free admin program. Do I simply RUN THE sql script to create the
> celko test tables.
The script that I made is from the postgresql pg_d
Em Dom, 2006-12-10 às 00:47 +0530, Rajesh Kumar Mallah escreveu:
> psql> CREATE INDEX x on test (col1);
> psql> CREATE INDEX y on test (col1);
>
> What is (are) the downsides of disallowing the
> second index. which is *exactly* same as
> previous?
What if PostgreSQL make a NOTICE about this? The
On 12/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Suppose an index get corrupted. And you need create a new index
> with exact specs and then drop the old index. Is it better to
> have a performing corrupted index or not have it at all and tempora
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Suppose an index get corrupted. And you need create a new index
> with exact specs and then drop the old index. Is it better to
> have a performing corrupted index or not have it at all and temporarily
> suffer some performance degradation ?
The
Hi,
Will it be a good feature to have pg_ctl check the syntaxes of
the config files before sending a SIGHUP to postmaster ?
Suppose a DBA does somes typos in the files, he shall be confused
not to see the changes in server even after pg_ctl reload .
Regds
mallah.
---(en
36 matches
Mail list logo
