Re: [HACKERS] contrib\xml2 package's xpath_table function in PostgreSQL

2010-02-01 Thread M Z
Is there a way to fix it so that those functions are usable in 8.4 without crashing the server? Thanks, M Z On Mon, Feb 1, 2010 at 10:50 AM, Robert Haas wrote: > The functions haven't actually been removed in 8.4, in spite of the > deprecation notice. But it's very easy to u

Re: [HACKERS] contrib\xml2 package's xpath_table function in PostgreSQL

2010-02-01 Thread M Z
I am very interested in doing it. However I am new to postgresql. Could you and anyone here please give me some hint, which way I should, which part of code I should focus to fix it? Thanks, M Z On Mon, Feb 1, 2010 at 1:23 PM, Robert Haas wrote: > On Mon, Feb 1, 2010 at 1:20 PM, M Z wr

Re: [HACKERS] remove contrib/xml2

2010-02-04 Thread M Z
7;, 't', 'xpath_test', '/rowlist/row/@a|/rowlist/row/@b', 'true') as t(id int4, a text, b text); id | a | b +---+-- 1 | 1 | oops 1 | 2 | (2 rows) * For 1st test case, not sure if some paths applied to 8.3 hav

Re: [HACKERS] remove contrib/xml2

2010-02-06 Thread M Z
The thing is, why it doesn't crash on 8.3.8 but crash on 8.4.2? Any idea? A patch was applied to 8.3 but not to 8.4.2? Thanks, M Z On Fri, Feb 5, 2010 at 1:45 PM, Robert Haas wrote: > On Wed, Feb 3, 2010 at 8:49 AM, Alvaro Herrera > wrote: > > Robert Haas escribió: > >&

[HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
-avzCH --delete anoncvs.postgresql.org::pgsql-cvs $CVSROOT However, how can I checkout code from different branches (such as 8.3, 8.4)? Thank you. M Z

Re: [HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
Hi Andrew, Could you please give a little more detail how I can find different CVS branches? Thanks, M Z On Mon, Feb 8, 2010 at 10:38 PM, Andrew Dunstan wrote: > > > M Z wrote: > >> Hi, >> >> I am trying to checkout code from different branches (such as 8.3, 8.4

Re: [HACKERS] CVS checkout source code for different branches

2010-02-08 Thread M Z
nches but I don't know the their cvsroot Thanks M Z On Mon, Feb 8, 2010 at 11:04 PM, M Z wrote: > Hi Andrew, > > Could you please give a little more detail how I can find different CVS > branches? > > Thanks, > M Z > > > > On Mon, Feb 8, 2010 at 10:38 PM,

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
:pserver:anoncvs:passw...@anoncvs.postgresql.org:/REL8_3_STABLE co -P pgsql /REL8_3_STABLE: no such repository What are the correct repositories for these branch? Is there a way I can list these branch repositories and how? Many thanks, M Z On Mon, Feb 8, 2010 at 11:56 PM, Andrew Dunstan wrote: > > Th

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
Final, I tried: $ cvs -z3 -d :pserver:anoncvs:passw...@anoncvs.postgresql.org:/projects/cvsroot co -r REL8_3_STABLE -P pgsql Checked file configure.in. Around line 20, there is line: AC_INIT([PostgreSQL], [8.3.9], [pgsql-b...@postgresql.org]) Not sure that indicates version 8.3.9? But still, i

Re: [HACKERS] CVS checkout source code for different branches

2010-02-09 Thread M Z
Thanks Robert, Your reply helps a lot. Just right after sending post, I found the way to list all branches in the CVS server. Best, M Z On Tue, Feb 9, 2010 at 10:43 PM, Robert Haas wrote: > On Tue, Feb 9, 2010 at 10:35 PM, M Z wrote: > > Final, I tried: > > &

[HACKERS] Error when building postgresql with contrib functions

2010-02-15 Thread M Z
t', 'true') as t(id int4); ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown) does not exist LINE 1: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Thank you very much for your help. Best, M Z

Re: [HACKERS] remove contrib/xml2

2010-02-17 Thread M Z
server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> == Best, M Z > > > CREATE TABLE xpath_test (id integer NOT NULL, t xml); > > INSERT INTO xpath_test VAL