Re: relation "sql_features" does not exist - Mailing list pgsql-general

On Dec 12, 2004, at 1:56 AM, Elnaz Shafipour wrote:

> Dear Mr. Fuhr,
>
> Thank you for prompt follow up.
>
> Fitst of all, I need to remind you that presently we are working on
> Windows
> OS (Windows XP-Professional).  The errors occured when installing
> PostgreSQL
> on the above OS.
>
> Upon research I found out that I "MAY" require to install "Cygwin"
> first and
> then install PostgreSQL via its environment.  Is this correct?

It depends on which PostgreSQL installer you are using.  The only way
to run an official release of PostgreSQL under Windows, prior to
version 8, was to run it under Cygwin.  Version 8 (which is scheduled
for a stable release version within the next few days) is capable of
running natively under Windows, without the use of Cygwin.

>
> Before, getting to other details, I want to be sure which way to go.
>     a.  Can PostgreSQL be installed on Windows?  Which version of
> Windows?

Yes, under Windows NT, 2000, or XP.

>     b.  What is the deal with "Cygwin"?  Do we need it at all or not?

Cygwin is an open-source project to provide a simulated UNIX-like
environment under Windows.  For further details, see the project's web
site at http://www.cygwin.com/

>
> Awaiting your advise, I remain.
>
> Regards,
> Elnaz
>
>
> ----- Original Message -----
> From: "Michael Fuhr" <mike@fuhr.org>
> To: "Elnaz Shafipour" <shafipour.elnaz@yamazar.com>
> Cc: <pgsql-general@postgresql.org>; <tavakoli@yamazar.com>
> Sent: Sunday, December 12, 2004 12:15 AM
> Subject: Re: [GENERAL] relation "sql_features" does not exist
>
>
>> On Tue, Dec 07, 2004 at 10:42:29AM +0330, Elnaz Shafipour wrote:
>>
>>> I want to create database in postgreSQL but I get the following
>>> error:
>>> relation "sql_features" does not exist.
>>
>> How are you creating the database, and is that the operation that
>> fails or do you get the error when doing something after you've
>> created the database?  Please copy & paste the exact commands you're
>> running and the output.
>>
>> What version of the client are you running?  The startup banner
>> should say, or you can run "psql --version" (or "createdb --version"
>> if that's what you're running).
>>
>> What version of the server are you running?  You can find out by
>> executing the query "SELECT version();".
>>
>>> As I look for solving this problem I find out that I should
>>> add information_schema to the shema search path.
>>> but I don't kow how!
>>
>> Let's find out what the problem is before attempting a solution
>> that may or may not be appropriate or necessary.
>>
>> --
>> Michael Fuhr
>> http://www.fuhr.org/~mfuhr/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
>
-----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com