Re: ERROR CODE
От | davidb@vectormath.com |
---|---|
Тема | Re: ERROR CODE |
Дата | |
Msg-id | 008e01bfb382$ec1baba0$0602010a@bullwinkle.vectormath обсуждение исходный текст |
Ответ на | ERROR CODE (Ray Alba <ralba@dotsperinch.com>) |
Список | pgsql-general |
I think it is because you have a space between "parent" and "id" in your field named "parent id". David Boerwinkle -----Original Message----- From: Ray Alba <ralba@dotsperinch.com> To: pgsql-general@postgresql.org <pgsql-general@postgresql.org> Date: Saturday, April 29, 2000 7:17 AM Subject: [GENERAL] ERROR CODE >I am creating a new table called patienttype with categories - >infant,pediatric, adult in the doctors table > >for some reason it allows me to create a sequence but, when I create a >table that requires that sequence, I get the following. > >create table patienttype ( >id INT DEFAULT nextval ('category_seq'), >parent id INT DEFAULT '0', >type varchar(50)); > >Here is the error? What is that all about? >ERROR: Unable to locate type name 'id' in catalog > >Thanks, > >Ray > > --------------------------------- > * *** * > * Ray Alba/ dotsperinch * > * 74 Varick | 55 W 92nd St. * > * 212.966.4979 | 212.864.6456 * > * Fax.966.3866 | 212.864.4489 * > * ralba@dotsperinch.com * > * http://www.dotsperinch.com * > * http://www.dotsperinch.com * > --------------------------------- > >
В списке pgsql-general по дате отправления: