Skip site navigation (1) Skip section navigation (2)

RE: [ODBC] Re: Updating a view

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: Fernando Schapachnik <fschapachnik(at)vianetworks(dot)com(dot)ar>
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: RE: [ODBC] Re: Updating a view
Date: 2001-08-20 20:02:55
Message-ID: 19AB8F9FA07FB0409732402B4817D75A038A82@FILESERVER.SRF.srfarms.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Hi,

Thanks to everyone who answered my questions.. I got the problem solved.


Thanks

Ryan
> -----Original Message-----
> From: Fernando Schapachnik [mailto:fschapachnik(at)vianetworks(dot)com(dot)ar]
> Sent: Wednesday, August 15, 2001 12:28 PM
> To: Ryan C. Bonham
> Cc: pgsql-odbc(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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(at)vianetworks(dot)com(dot)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
> 

pgsql-odbc by date

Next:From: Tom LaneDate: 2001-08-20 20:54:05
Subject: Re: Float Percision with MS Access 97
Previous:From: Michael CalabreseDate: 2001-08-20 16:05:55
Subject: Float Percision with MS Access 97

pgsql-general by date

Next:From: David FordDate: 2001-08-20 20:13:36
Subject: Re: Finding database names for overnight vacuum
Previous:From: wsheldahDate: 2001-08-20 19:37:21
Subject: Re: nextval, sequences and sequencenames

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group