Thread: relation "sql_features" does not exist
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
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/
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/
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