Re: Schema Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Schema Problem
Date: 2007-07-02 15:12:24
Message-ID: 11781.1183389144@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> writes:
> In the script I follow following steps

> 1) create user xyz
> 2) create database xyz -O xyz
> 3) create schema xyz
> 4) {PG_PATH}/psql -d xyz -U xyz -f =
> /usr/local/pgsql/QS/QS_100_2_Create_Table.sql -q -1

Are you sure you are creating the schema in the right database? Your
problems are consistent with the theory that schema xyz isn't present.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Guy Rouillier 2007-07-02 15:38:16 Re: Replace usage of a table in query with its array values
Previous Message Michael Glaesemann 2007-07-02 13:41:59 Re: problem in plpgsql