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

Re: SQL/XML publishing function experimental patch

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: nikolay(at)samokhvalov(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-patches(at)postgresql(dot)org, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: SQL/XML publishing function experimental patch
Date: 2006-08-22 03:47:25
Message-ID: 200608220347.k7M3lPs14556@momjian.us (view raw or flat)
Thread:
Lists: pgsql-patches
I am still waiting for some documentation on what XML support we have,
and what we need.  We can't decide on this patch until we have that.

---------------------------------------------------------------------------

Nikolay Samokhvalov wrote:
> I'll prepare some classification of differend kinds of XML support,
> including a brief overview for oracle, sql server and db2 (I'm a
> person who works on that SoC project)
> 
> As for Pavel's patch, I think it's pretty complete piece of several
> SQL/XML functions and could be usefull for people (e.g for me).
> 
> But it isn't fulll 'XML support' yet. On the road to XML type I see
> more grammar hacks (if standard compliance should be established) -
> for example, one of possible xml-column declarations is '...col1
> XML(SEQUENCE (UNTYPED))...', what breaks postgres' syntax for types
> descriptors, if I'm not mistaken..
> 
> Yes, standard is bloated and there is no dbms that supports part 14
> entirely (e.g., oracle doesn't accept xquery sequnces for xml type, ms
> calls its type 'xmltype' and doesn't support sql/xml functions), but
> it contains some collection of experience. Many people want to store
> xml and to work with it - so some work should take place. Another
> point: no open-source dbms has good xml support, so... Anyway, it
> would be attractive feature (speaking about marketing - look at the
> db2 v.9 'viper' description: xml, xml, xml...)
> 
> 
> On 6/15/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > > There have been inquiries about some kind of XML support every few weeks
> > > for years now.  Clearly, we need to sort out what that really means.
> >
> > Agreed.  We need a road map of some sort.
> >
> > > I'm preparing a session about that for the Toronto summit.
> >
> > Looking forward to it...
> >
> > 			regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
> >
> 
> 
> -- 
> Best regards,
> Nikolay
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-08-22 03:49:09
Subject: Re: COPY view
Previous:From: Bruce MomjianDate: 2006-08-22 03:38:25
Subject: Re: pgxml & xpath_table

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