Thread: relation "sql_features" does not exist

relation "sql_features" does not exist

From
"Elnaz Shafipour"
Date:
Hi,
I want to create database in postgreSQL but I get the following error:
relation "sql_features" does not exist.
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!
 
Elnaz

Re: relation "sql_features" does not exist

From
Michael Fuhr
Date:
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/

Re: relation "sql_features" does not exist

From
"Elnaz Shafipour"
Date:
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?

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?
    b.  What is the deal with "Cygwin"?  Do we need it at all or not?

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/


Re: relation "sql_features" does not exist

From
"Frank D. Engel, Jr."
Date:
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