Re: [GENERAL] PostgreSQL and XML

2005-03-03 Thread John Gray
On Thu, 03 Mar 2005 07:59:14 +, Mario Splivalo wrote: > Can I use XPath queries in any form to retrive data from XML documents and > 'transfer' them to table-like sets? > Basically, yes - if you look at the README for contrib/xml2 in the PostgreSQL source distribution (v8.0.1) there is an exa

Re: [GENERAL] Connecting to Postgres from LAN

2005-05-30 Thread John Gray
s covered by that line, so the pattern does not match. Regards John Gray ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] PostgreSQL and XML support

2005-09-09 Thread John Gray
>if I missed something). Are they alive and functionable? > 2. Contribution made by John Gray (xml and xml2). This is a tool that uses >'shredding' for storing XML in relational tables (another words, it >decomposes XML document into nodes and places these nodes int

Re: [GENERAL] XML inserts and updates in postgreSQL 8

2005-10-13 Thread John Gray
On Thu, 13 Oct 2005 10:00:31 -0700, firechaser wrote: > Hello all, > [example snipped] > > I've got this working in sql server 2005 beta which implements a > sub-set of XQuery on a native xml data type column, but I would prefer > to use postgreSQL if at all possible. > Although there is suppo

Re: [GENERAL] can't start postgresql

2006-11-14 Thread John Gray
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote: >> I'd think starting a standalone backend and issuing a "reindex database" >> should be enough to get him started. Now, the problem is figuring _how_ >> the index got in that state; or even _what_ index is the problematic >> one. (I th

Re: [GENERAL] xpath_list() question for contrib/xml2

2005-01-25 Thread John Gray
On Mon, 24 Jan 2005 16:53:47 -0800, Ron Mayer wrote: > Short summary: > >I want something like xpath_list() that returns an array >(instead of a delimited, concatenated string) when multiple >nodes exist in an XML file. It feels to me like that'd >be a better (cleaner) API. > Y

Re: [GENERAL] OpenOffice 2 and Postgresql 8.1 How to?

2005-12-12 Thread John Gray
On Mon, 12 Dec 2005 21:34:42 +0100, Tino Wildenhain wrote: > Am Montag, den 12.12.2005, 15:26 -0500 schrieb Matthew T. O'Connor: >> Jerry LeVan wrote: >> > Are there any (detailed) instructions available on how to connect >> > OpenOffice 2 and Postgresql 8.1. >> > >> > I have the jdbc driver(s) fr

Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-13 Thread John Gray
Robert, Others have covered some of your topics. On Thu, 12 Jan 2006 20:51:44 -0800, rlee0001 wrote: > 7. > An XML field type and associated XPath/DOM functions. Other exotic > field types like Image might be nice for some people as well. But XML > would be awesome. > The contrib module xml2 (

Re: [GENERAL] xml_valid function

2006-01-27 Thread John Gray
On Wed, 25 Jan 2006 17:11:04 -0800, George Pavlov wrote: > Not sure what the correct forum for pgxml/xml2 questions is. I was > wondering what is the definition of "valid" that the xml_valid(text) > function that is part of that module uses? It seems different from the > W3C definition of "valid"

Re: [GENERAL] xml_valid function

2006-01-27 Thread John Gray
On Fri, 2006-01-27 at 12:32 -0800, Roger Hand wrote: > John Gray wrote on > Friday, January 27, 2006 12:24 PM > > On Wed, 25 Jan 2006 17:11:04 -0800, George Pavlov wrote: > > > >> Not sure what the correct forum for pgxml/xml2 questions is. I was > >> wonder

Re: [GENERAL] XML Support

2006-05-26 Thread John Gray
On Fri, 26 May 2006 13:25:34 +0200, Thomas Kellerer wrote: > Hello, > > I'm trying to use XML with PG, and I a descriptioin of the XML support for > PostgreSQL at http://www.throwingbeans.org/postgresql_and_xml_updated.html > > As I could not find the mentioned package in my Windows installation

Re: [GENERAL] pgxml & xpath_table

2006-06-09 Thread John Gray
Hi, On Fri, 09 Jun 2006 08:43:51 +0200, Philippe Lang wrote: > I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure > if what I found with pgxml is a feature of a bug: > [snip] > I get: > > > iddoc_num line_numval1val2val3 > 1

Re: [GENERAL] pgxml & xpath_table

2006-06-10 Thread John Gray
On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote: > John Gray <[EMAIL PROTECTED]> writes: > > This is the reason why xpath_table allows you to specify an > > identifying field (usually a primary key but doesn't have to be)- the > > solution to your question is

Re: [GENERAL] XPath and XML support

2006-08-29 Thread John Gray
On Thu, 24 Aug 2006 13:56:12 -0700, Frank Cohen wrote: > Thanks Nikolay: Seeing as xml2 hasn't been ported to Windows yet > makes me wonder if this is going to be the best way to use XML in > PostgreSQL in the long-term? Is there anything else on the boards? - > Frank > There's a lot of sco

Re: [GENERAL] ORM, XPath, and pgxml_dom segfaulting

2004-01-21 Thread John Gray
On Tue, 20 Jan 2004 01:07:00 +, Simen Brekken wrote: > Hi, > > I'm currently running 7.3.4 on Debian/testing, I've been trying to get > pgxml_dom working but after doing some normal tests I find that it > segfaults the postmaster whenever it hits an error, is this because > the contrib modul

Re: [GENERAL] Changing xml in a database

2003-11-11 Thread John Gray
On Tue, 11 Nov 2003 11:02:51 +, C G wrote: > Dear All, > > I have installed the contrib xml package and have it working, but I would > like some advice on the best way to use it. In particular, how should I > alter xml files? For instance, if I have: > There's no way at present. The suppo

Re: [GENERAL] uploading files

2003-11-19 Thread John Gray
the header info from them, EXTERNAL is a good bet (and depending on the image format, the compression might not compress them very much anyway). Finally, note that the substr optimisation for text only really buys you anything if the character-set is single-byte. Hope this helps John Gray (impl

Re: [GENERAL] Installation problem

2000-10-10 Thread John Gray
at 6.2 RPM version of 7.0) This is handled by the config.guess script; you could try looking in there and picking something that matches BUT if config.guess can't tell your system type then maybe you have some inconsistency in the configuration... I'm not an expert on autoconf host strin