| From: | Ray Alba <ralba(at)dotsperinch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR CODE |
| Date: | 2000-04-29 12:12:18 |
| Message-ID: | v03007802b53081fc313a@[208.37.244.165] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)dotsperinch(dot)com *
* http://www.dotsperinch.com *
* http://www.dotsperinch.com *
---------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukasz Michalski | 2000-04-29 13:54:15 | creating temp table... |
| Previous Message | Marcel Sierra | 2000-04-29 11:32:17 | Objective : 1st. aplication with Tcl/Tk and Postgres |