Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9 - Mailing list pgsql-general

From MargaretGillon@chromalloy.com
Subject Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Date
Msg-id OF6F7E06C5.0FA84CE1-ON8825727C.007E2360-8825727C.007E3FF6@CHROMALLOY.COM
Whole thread Raw
In response to Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general

>Alvaro Herrera <alvherre@commandprompt.com> wrote on 02/08/2007 02:51:52 PM:
> > MargaretGillon@chromalloy.com wrote:
> > Using PGADMINIII I added a column of this type to my database but when I
> > try to update it I get an error.
> >
> > column:
> > ALTER TABLE datatype ADD COLUMN charflag "char"[];
>
> You added an array of "char", which is not the same.
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support

ALTER TABLE datatype ADD COLUMN charflag "char";

Got it. Thank you. Margaret Gillon.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Next
From: "Lukas"
Date:
Subject: PgSQL dump