RE: [ODBC] Re: [GENERAL] Updating a view
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])
[GENERAL] ERROR: relation_info: Relation 41069 not found
Hi, Ok i am lost.. I added a filed to a table, now when i try to do a select on that table, or open a view based on that table i get teh following message. I get the following message in both phpPGAdmin and PGAdmin 12 and my VB program. Can someone tell me what i did... Thanks.. PostgreSQL said: ERROR: relation_info: Relation 41069 not found Ryan ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Updating a view
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.. Ryan *** * pgAdmin v7.1.0: Error - 2001-07-19 11:31:42 *** Error Details * Error Number: -2147217842 Error Description: Operation was canceled. Error Source: Microsoft OLE DB Provider for ODBC Drivers Subroutine of Function: frmODBCLogon, cmdOK_Click System Details ** Operating System: Windows NT v5.0 Build 2195 Additional Info: Service Pack 2 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
RE: [GENERAL] THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEEEASE
If you already have the information on the labels, all you need is to set the font on the text box to a "Bar Code Font". If you dont have a barcode font, try "elfring soft fonts" http://64.21.138.30/. Hope that helps.. If you have any question email me directly and i wil see if i can help. -Original Message-From: Kapil Tilwani [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 18, 2001 10:28 AMTo: [EMAIL PROTECTED]Subject: [GENERAL] THIS IS NOT RELATED TO THE RDBMS BUT PLEASE Hi, This is Kapil Tilwani again with another irrelevant ridiculous question but, I am coming back over here only after I did not find a solutino myself... Could anyone just tell me some place where I could find some source which I can incorporate in my VB Code to print bar-code labels. Actually, there is one query which filters out the records and arranges the data that is to be printed on a label... however, I dont know how to convert the value of my ItemID... On the label, there are some other values also which are required to be printed in ASCII format] Thanx a lot in anticipation Kapil
[GENERAL] MS SQL 7.0 to PostgreSQL 7.1
Hi, I am looking at PostgreSQL as an alternative to Microsoft SQL. I have a database I would like to move to PostgreSQL to test how long it will take to move files, how to best change our software to access Postgre, etc.. I have PostgreSQL setup on a Test machine running Redhat 7.1. I have Postgre successfully installed and I also have phpPgadmin installed and configured. I have created a database, and a table, just trying to get use to Postgre. My question is what is the best way to import my data from MS SQL. I installed the ODBC Drivers and tried exporting using the MS import/export tool.. It successfully creates the tables, but fails to import any data, with a error stating that the relationship doesn't exist. So there goes the easy route and MS POS tool.. What's the correct way of doing this?? Thanks in advance Ryan C. Bonham ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster