Thread: Install XML on Postgres 8.1

Hi,
I need to install XML on Postgres 8.1.
What's the simples steps that I can follow?
I found on the internet, but there are many versions, packages and ways
to install.
What's the right way to install?

Can we compare the same powerful like Oracle has on Xml?

If you could help me!!
Thanks in advance.





_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/

On 1/22/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
> Hi,
> I need to install XML on Postgres 8.1.

XML support is provided in PostgreSQL via a contrib module xml2.
look for xml related folders in contrib folder after untarring the pgsql
source. go through the README files on contrib modules to
know the features.

> What's the simples steps that I can follow?

how have you installed postgresql ?

> I found on the internet, but there are many versions, packages and ways
> to install.
> What's the right way to install?

have you installed from source or rpm ?


>
> Can we compare the same powerful like Oracle has on Xml?


what is your requirement ? postgresql xml2 module i think has xslt and xpath
support. check the README file of xml2 folder.


>
> If you could help me!!
> Thanks in advance.
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

>
> Can we compare the same powerful like Oracle has on Xml?

I don't think so that current xml2 support is according to the SQL 2003 standards and for now it is I guess just the basic one.

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

Shoaib Mir wrote:
> > Can we compare the same powerful like Oracle has on Xml?
>
> I don't think so that current xml2 support is according to the SQL
> 2003 standards and for now it is I guess just the basic one.

The functionality of the xml2 contrib module is almost completely
orthogonal to what the SQL standard says in matters of XML.  Whether
either of these are equally "powerful" as what Oracle offers, I can't
say, but since we're currently working on enhanced XML functionality in
8.3, I invite comments on that.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Peter Eisentraut wrote:
> Shoaib Mir wrote:
>>> Can we compare the same powerful like Oracle has on Xml?
>> I don't think so that current xml2 support is according to the SQL
>> 2003 standards and for now it is I guess just the basic one.
>
> The functionality of the xml2 contrib module is almost completely
> orthogonal to what the SQL standard says in matters of XML.  Whether
> either of these are equally "powerful" as what Oracle offers, I can't
> say, but since we're currently working on enhanced XML functionality in
> 8.3, I invite comments on that.

PeterE do you have a specific TODO I can line item for the pending 8.3
release?

Joshua D. Drake

>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

Joshua D. Drake wrote:
> PeterE do you have a specific TODO I can line item for the pending
> 8.3 release?

http://developer.postgresql.org/index.php/XML_Todo

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On 1/23/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
> I installed from source.
> Is there a tutorial to follow the installation?
>
> I don't need so much features using xml, but basically store, request
> and manipulate.


xml2 is just a contrib package. for installing any contrib package
go to contrib folder. read the README file for instructions.
still if you have problem come back here.
sorry i do not know of a tutorial at the moment , but its easy.

PS: please stick to the discussion on the list only.

regds
mallah.

>
> Thanks for your help.
>
>
>
>
>
> Rajesh Kumar Mallah escreveu:
> > On 1/22/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
> >> Hi,
> >> I need to install XML on Postgres 8.1.
> >
> > XML support is provided in PostgreSQL via a contrib module xml2.
> > look for xml related folders in contrib folder after untarring the pgsql
> > source. go through the README files on contrib modules to
> > know the features.
> >
> >> What's the simples steps that I can follow?
> >
> > how have you installed postgresql ?
> >
> >> I found on the internet, but there are many versions, packages and ways
> >> to install.
> >> What's the right way to install?
> >
> > have you installed from source or rpm ?
> >
> >
> >>
> >> Can we compare the same powerful like Oracle has on Xml?
> >
> >
> > what is your requirement ? postgresql xml2 module i think has xslt and
> > xpath
> > support. check the README file of xml2 folder.
> >
> >
> >>
> >> If you could help me!!
> >> Thanks in advance.
> >>
> >>
> >>
> >>
> >>
> >> _______________________________________________________
> >> Yahoo! Mail - Sempre a melhor opção para você!
> >> Experimente já e veja as novidades.
> >> http://br.yahoo.com/mailbeta/tudonovo/
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 5: don't forget to increase your free space map settings
> >>
> >
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>

On 1/22/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
> Hi,
> I need to install XML on Postgres 8.1.
> What's the simples steps that I can follow?
> I found on the internet, but there are many versions, packages and ways
> to install.
> What's the right way to install?
>
> Can we compare the same powerful like Oracle has on Xml?

Dear Alexander,

After reading the thread and related resources it looks like xml
support in pgsql may undergo major changes.

hence i suggest that you  abstract the usage of pgsql for xml . so that it
is easy for you to change your app when the xml apis to pgsql changes.
this is easily accomplised by using your own functions that wrap the call
to contrib/xml2 functions. hope you get the point.

regds
mallah.


>
> If you could help me!!
> Thanks in advance.
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Do we have XML docs indexing mechanism in the todo's for 8.3? as this is one of the problem I faced while moving the Oracle like XML functionality to PostgreSQL using xml2 contrib.

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

Shoaib Mir wrote:
> Do we have XML docs indexing mechanism in the todo's for 8.3? as this
> is one of the problem I faced while moving the Oracle like XML
> functionality to PostgreSQL using xml2 contrib.

Indexing of data types is done in terms of operator classes (or maybe
operator families in 8.3, not sure), but so far no one has proposed to
define any operators whatsoever on the XML type, so I don't see where
any indexing mechanism would come from at the moment.  What does Oracle
offer?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

The following will explain in detail how Oracle handles the XML data and also the indexing and searching mechanism for it:

http://www.oracle.com/technology/oramag/oracle/04-sep/o54xml.html

-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)