Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9

From: MargaretGillon(at)chromalloy(dot)com
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Jim Nasby <decibel(at)decibel(dot)org>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Date: 2007-02-08 22:59:01
Message-ID: OF6F7E06C5.0FA84CE1-ON8825727C.007E2360-8825727C.007E3FF6@CHROMALLOY.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote on 02/08/2007 02:51:52
PM:
> > MargaretGillon(at)chromalloy(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lukas 2007-02-08 23:20:49 PgSQL dump
Previous Message Alvaro Herrera 2007-02-08 22:51:52 Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9