Hi,
Thanks to everyone who answered my questions.. I got the problem solved.
Thanks
Ryan
> -----Original Message-----
> From: Fernando Schapachnik [mailto:fschapachnik@vianetworks.com.ar]
> Sent: Wednesday, August 15, 2001 12:28 PM
> To: Ryan C. Bonham
> Cc: pgsql-odbc@postgresql.org; pgsql-general@postgresql.org
> Subject: [ODBC] Re: [GENERAL] Updating a view
>
>
> I'm not sure about Postgres in particular, but updating a view is not
> always possible. Consider
>
> CREATE VIEW TEST AS
> SELECT sum(money) FROM table;
>
> What would it mean to update an aggregate?
>
> The propper and abstract way to do that in general is to define an
> stored procedure (they would be kind of the setters of the object)
> and a view (kind of the getters).
>
> Regards.
>
>
> En un mensaje anterior, Ryan C. Bonham escribió:
> > Hi,
> >
> > Ok i know this is something stupid, somebody mind
> explaining it to me? Also
> > sorry if this gets posted twice, i got a error back the first time..
> >
> > I have a Visual Basic Project that access a PostgreSQL
> Datbase. One Form
> > pulls information from a View in postgres. If teh user
> changes anything on
> > the form the update fails. I tried running hte dame update
> from PGAdmin and
> > it also fails with the following message. I just dont
> understand what i need
> > to create i guess.. Thanks for the help..
>
>
> Fernando P. Schapachnik
> Planificación de red y tecnología
> VIA NET.WORKS ARGENTINA S.A.
> fschapachnik@vianetworks.com.ar
> Tel.: (54-11) 4323-3381
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
