Hi, Thanks to everyone who answered my questions.. I got the problem solved. Thanks Ryan > -----Original Message----- > From: Fernando Schapachnik [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 15, 2001 12:28 PM > To: Ryan C. Bonham > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > 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. > [EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
