Re: [HACKERS] XML ouput for psql

2003-03-05 Thread Alan Gutierrez
ocument and keep track of placeholder values used by the client program to represent SERIAL values in database. What I've got is a system where I post an XML document to a URL and it gets mapped out to my normalized PostgreSQL schema. -- Alan Gutierrez - [EMAIL PROTECTED] http:

Re: [HACKERS] XML ouput for psql

2003-03-05 Thread Alan Gutierrez
pdate statements for every type of element in an XML document. Alan Gutierrez 1234565789 If I feed this document to a database I want it to absorb the document, inserting if doesn't already exists, updating it if it does. There is no way to test for the existstence of a record in

Re: [HACKERS] XML ouput for psql

2003-03-05 Thread Alan Gutierrez
es, I just tweak the config file and it will generated the inserts, updates, and deletes by comparing the XML document with the tables to which the XML elements are mapped. I've been able to handle tree structures tolerably well. I am currently rewriting the code in C++ from Perl. -- Alan

Re: [HACKERS] XML ouput for psql

2003-03-04 Thread Alan Gutierrez
e code could generate a document, but it is so easy to do using Perl and cgi, I've not bothered. It has some constraints, but it is a very useful utility. I've been able to abosorb XML documents into my PostgreSQL db just by tweeking the configuration file. Currently, I am porting it to

Re: Windows Build System was: [HACKERS] Win32 port patches

2003-01-28 Thread Alan Gutierrez
include VC6 projects. The projects are kept in their own directory apart from source code. You might want to download the Xerces and Xalan source and look at how they structured their envrionment. I *does* make it easier for Windows developers to work with VC6 projects. Alan Gutierrez - [EMAIL PR