Re: CreateTable --> schema not found

From: Ropel <ropel(at)ropel(dot)it>
To: Josef Springer <Josef(dot)Springer(at)JOOPS(dot)COM>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CreateTable --> schema not found
Date: 2005-07-13 08:36:01
Message-ID: 42D4D271.6030707@ropel.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think it's because of uppercase letters: if you don't quote ... create
table "/OfficeTalk.absent" .... , postgresql will lowercase everything
regards

/Josef Springer wrote:

> Hi,
>
> sorry, i am a PostgesSQL beginner:
>
> * I started the pgadmin tool as superuser.
> * Created the database /OfficeTalk/
> * Created the schema /OfficeTalk/ with same permissions as the
> template /pg_template_1/
> * If i create the table /OfficeTalk.absent/ .... >>> * schema not
> found*
> * Creating the same table in schema /pg_template_1/ works fine.
>
> I could not found any solution. Can anybod help me ?
> --
>
> Best Regards,
> Josef Springer
>
> -- *the software company* --
>
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
>
> Tel. ++49(0)89 600 6920
> Fax ++49(0)89 600 69220
> mailto Josef(dot)Springer(at)joops(dot)com <mailto:Josef(dot)Springer(at)joops(dot)com>
> Website http://www.joops.com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-07-13 08:47:06 Re: illegal sort order
Previous Message Richard Huxton 2005-07-13 08:30:57 Re: CreateTable --> schema not found