[GENERAL] CreateTable -- schema not found

2005-07-13 Thread Josef Springer
Title: Signature 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

Re: [GENERAL] CreateTable -- schema not found

2005-07-13 Thread Ropel
Title: Signature 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

Re: [GENERAL] CreateTable -- schema not found

2005-07-13 Thread Richard Huxton
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/ Are you sure pg_template_1 isn't a