Il 3/6/2013 11:46 PM, Andrew Dunstan ha scritto:
Excellent. Will test it out soon.
cheers
andrew
Andrew,
please find attached a full patch for cygwin relative to 9.3beta1 :
- DLLTOLL/DLLWRAP are not used anymore, replaced
by gcc also for postgres.exe (*)
- DLL versioning is added
Check failures:
- prepared_xacts is still freezing
The cygwin failure you highlighted was solved,
so it should be something else
- attached the 2 regressions diffs
tsearch ... FAILED
without_oid ... FAILED
The second one seems a new one, not sure cygwin specific
Regards
Marco
*) http://www.cygwin.com/ml/cygwin/2013-03/msg00032.html
--- origsrc/postgresql-9.3beta1/src/Makefile.global.in 2013-05-06
22:57:06.000000000 +0200
+++ src/postgresql-9.3beta1/src/Makefile.global.in 2013-06-08
15:33:28.587266200 +0200
@@ -508,6 +508,11 @@ ifeq ($(PORTNAME),win32)
LIBS += -lws2_32 -lshfolder
endif
+# missing for link on cygwin ?
+ifeq ($(PORTNAME),cygwin)
+LIBS += $(LDAP_LIBS_BE)
+endif
+
# Not really standard libc functions, used by the backend.
TAS = @TAS@
--- origsrc/postgresql-9.3beta1/src/Makefile.shlib 2013-05-06
22:57:06.000000000 +0200
+++ src/postgresql-9.3beta1/src/Makefile.shlib 2013-06-08 15:33:28.613267700
+0200
@@ -281,8 +281,9 @@ ifeq ($(PORTNAME), unixware)
endif
ifeq ($(PORTNAME), cygwin)
+ LINK.shared = $(CC) -shared
ifdef SO_MAJOR_VERSION
- shlib = cyg$(NAME)$(DLSUFFIX)
+ shlib = cyg$(NAME)-$(SO_MAJOR_VERSION)$(DLSUFFIX)
endif
haslibarule = yes
endif
@@ -371,6 +372,12 @@ else # PORTNAME == cygwin || PORTNAME ==
# If SHLIB_EXPORTS is set, the rules below will build a .def file from
# that. Else we build a temporary one here.
+ifeq ($(PORTNAME), cygwin)
+$(shlib) $(stlib): $(OBJS) | $(SHLIB_PREREQS)
+ $(CC) $(CFLAGS) -shared -o $(shlib) -Wl,--out-implib=$(stlib) $(OBJS)
$(LDFLAGS) $(LDFLAGS_SL) $(SHLIB_LINK) $(LIBS) $(LDAP_LIBS_BE)
+
+
+else
ifeq (,$(SHLIB_EXPORTS))
DLL_DEFFILE = lib$(NAME)dll.def
exports_file = $(DLL_DEFFILE)
@@ -387,6 +394,7 @@ $(shlib): $(OBJS) $(DLL_DEFFILE) | $(SHL
$(stlib): $(shlib) $(DLL_DEFFILE) | $(SHLIB_PREREQS)
$(DLLTOOL) --dllname $(shlib) $(DLLTOOL_LIBFLAGS) --def $(DLL_DEFFILE)
--output-lib $@
+endif # PORTNAME == cygwin
endif # PORTNAME == cygwin || PORTNAME == win32
--- origsrc/postgresql-9.3beta1/src/backend/Makefile 2013-05-06
22:57:06.000000000 +0200
+++ src/postgresql-9.3beta1/src/backend/Makefile 2013-06-08
15:33:28.633268800 +0200
@@ -62,18 +62,8 @@ endif
ifeq ($(PORTNAME), cygwin)
-postgres: $(OBJS) postgres.def libpostgres.a
- $(DLLTOOL) --dllname $@$(X) --output-exp [email protected] --def postgres.def
- $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX) -o $@$(X)
-Wl,--base-file,[email protected] [email protected] $(call expand_subsys,$(OBJS)) $(LIBS)
- $(DLLTOOL) --dllname $@$(X) --base-file [email protected] --output-exp [email protected]
--def postgres.def
- $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX)
-Wl,--stack,$(WIN32_STACK_RLIMIT) -o $@$(X) [email protected] $(call
expand_subsys,$(OBJS)) $(LIBS)
- rm -f [email protected] [email protected]
-
-postgres.def: $(OBJS)
- $(DLLTOOL) --export-all --output-def $@ $(call expand_subsys,$^)
-
-libpostgres.a: postgres.def
- $(DLLTOOL) --dllname postgres.exe --def postgres.def --output-lib $@
+postgres libpostgres.a: $(OBJS)
+ $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX) $(export_dynamic) $(call
expand_subsys,$^) $(LIBS) -o $@ -Wl,--stack,$(WIN32_STACK_RLIMIT)
-Wl,--export-all-symbols -Wl,--out-implib=libpostgres.a
endif # cygwin
--- origsrc/postgresql-9.3beta1/src/interfaces/libpq/Makefile 2013-05-06
22:57:06.000000000 +0200
+++ src/postgresql-9.3beta1/src/interfaces/libpq/Makefile 2013-06-08
15:33:28.654270000 +0200
@@ -45,7 +45,7 @@ OBJS += ip.o md5.o
OBJS += encnames.o wchar.o
ifeq ($(PORTNAME), cygwin)
-override shlib = cyg$(NAME)$(DLSUFFIX)
+override shlib = cyg$(NAME)-$(SO_MAJOR_VERSION)$(DLSUFFIX)
endif
ifeq ($(PORTNAME), win32)
--- origsrc/postgresql-9.3beta1/src/makefiles/Makefile.cygwin 2013-05-06
22:57:06.000000000 +0200
+++ src/postgresql-9.3beta1/src/makefiles/Makefile.cygwin 2013-06-08
16:03:24.065961700 +0200
@@ -1,6 +1,4 @@
# src/makefiles/Makefile.cygwin
-DLLTOOL= dlltool
-DLLWRAP= dllwrap
ifdef PGXS
BE_DLLLIBS= -L$(libdir) -lpostgres
else
@@ -44,6 +42,4 @@ endif
# Rule for building a shared library from a single .o file
%.dll: %.o
- $(DLLTOOL) --export-all --output-def $*.def $<
- $(DLLWRAP) -o $@ --def $*.def $< $(LDFLAGS) $(LDFLAGS_SL) $(BE_DLLLIBS)
- rm -f $*.def
+ $(CC) $(CFLAGS) -shared -o $@ $< $(LDFLAGS) $(LDFLAGS_SL)
$(BE_DLLLIBS)
***
/pub/devel/postgresql/postgresql-9.3beta1-1/src/postgresql-9.3beta1/src/test/regress/expected/tsearch.out
2013-05-06 22:57:06.000000000 +0200
---
/pub/devel/postgresql/postgresql-9.3beta1-1/build/src/test/regress/results/tsearch.out
2013-06-10 10:22:21.369652800 +0200
***************
*** 267,276 ****
SELECT * FROM ts_parse('default', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c
gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234
<i <b> wow < jqw <> qwerty');
! tokid | token
! -------+--------------------------------------
! 22 | 345
! 12 |
1 | qwe
12 | @
19 | efd.r
--- 267,277 ----
SELECT * FROM ts_parse('default', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c
gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234
<i <b> wow < jqw <> qwerty');
! tokid | token
! -------+-------------------------
! 12 | 3
! 12 | 4
! 12 | 5
1 | qwe
12 | @
19 | efd.r
***************
*** 283,335 ****
6 | aew.werc.ewr
18 | /?ad=qwe&dw
12 |
! 5 | 1aew.werc.ewr/?ad=qwe&dw
! 6 | 1aew.werc.ewr
18 | /?ad=qwe&dw
12 |
! 6 | 2aew.werc.ewr
12 |
14 | http://
! 5 | 3aew.werc.ewr/?ad=qwe&dw
! 6 | 3aew.werc.ewr
18 | /?ad=qwe&dw
12 |
14 | http://
! 6 | 4aew.werc.ewr
12 |
14 | http://
! 5 | 5aew.werc.ewr:8100/?
! 6 | 5aew.werc.ewr:8100
! 18 | /?
! 12 |
1 | ad
12 | =
1 | qwe
12 | &
1 | dw
12 |
! 5 | 6aew.werc.ewr:8100/?ad=qwe&dw
! 6 | 6aew.werc.ewr:8100
! 18 | /?ad=qwe&dw
! 12 |
! 5 | 7aew.werc.ewr:8100/?ad=qwe&dw=%20%32
! 6 | 7aew.werc.ewr:8100
! 18 | /?ad=qwe&dw=%20%32
! 12 |
! 7 | +4.0e-10
12 |
1 | qwe
12 |
1 | qwe
12 |
1 | qwqwe
12 |
! 20 | 234.435
! 12 |
! 22 | 455
! 12 |
! 20 | 5.005
! 12 |
4 | [email protected]
12 |
16 | qwe-wer
--- 284,380 ----
6 | aew.werc.ewr
18 | /?ad=qwe&dw
12 |
! 12 | 1
! 5 | aew.werc.ewr/?ad=qwe&dw
! 6 | aew.werc.ewr
18 | /?ad=qwe&dw
12 |
! 12 | 2
! 6 | aew.werc.ewr
12 |
14 | http://
! 12 | 3
! 5 | aew.werc.ewr/?ad=qwe&dw
! 6 | aew.werc.ewr
18 | /?ad=qwe&dw
12 |
14 | http://
! 12 | 4
! 6 | aew.werc.ewr
12 |
14 | http://
! 12 | 5
! 6 | aew.werc.ewr
! 12 | :
! 12 | 8
! 12 | 1
! 12 | 0
! 12 | 0
! 12 | /?
1 | ad
12 | =
1 | qwe
12 | &
1 | dw
12 |
! 12 | 6
! 6 | aew.werc.ewr
! 12 | :
! 12 | 8
! 12 | 1
! 12 | 0
! 12 | 0
! 12 | /?
! 1 | ad
! 12 | =
! 1 | qwe
! 12 | &
! 1 | dw
12 |
+ 12 | 7
+ 6 | aew.werc.ewr
+ 12 | :
+ 12 | 8
+ 12 | 1
+ 12 | 0
+ 12 | 0
+ 12 | /?
+ 1 | ad
+ 12 | =
+ 1 | qwe
+ 12 | &
+ 1 | dw
+ 12 | =%
+ 12 | 2
+ 12 | 0%
+ 12 | 3
+ 12 | 2
+ 12 | +
+ 12 | 4.
+ 12 | 0
+ 1 | e
+ 12 | -
+ 12 | 1
+ 12 | 0
1 | qwe
12 |
1 | qwe
12 |
1 | qwqwe
12 |
! 12 | 2
! 12 | 3
! 12 | 4.
! 12 | 4
! 12 | 3
! 12 | 5
! 12 | 4
! 12 | 5
! 12 | 5
! 12 | 5.
! 12 | 0
! 12 | 0
! 12 | 5
4 | [email protected]
12 |
16 | qwe-wer
***************
*** 352,373 ****
12 |
13 | <werrwe>
12 |
! 3 | ewr1
! 12 | >
! 3 | ewri2
12 |
! 13 | <a href="qwe<qwe>">
! 12 | +
|
19 | /usr/local/fff
12 |
! 19 | /awdf/dwqe/4325
! 12 |
19 | rewt/ewr
12 |
1 | wefjn
12 |
! 19 | /wqe-324/ewr
12 |
19 | gist.h
12 |
--- 397,432 ----
12 |
13 | <werrwe>
12 |
! 1 | ewr
! 12 | 1>
! 1 | ewri
! 12 | 2
! 12 | <
! 1 | a
12 |
! 1 | href
! 12 | ="
! 1 | qwe
! 13 | <qwe>
! 12 | "> +
|
19 | /usr/local/fff
12 |
! 19 | /awdf/dwqe
! 12 | /
! 12 | 4
! 12 | 3
! 12 | 2
! 12 | 5
19 | rewt/ewr
12 |
1 | wefjn
12 |
! 19 | /wqe-
! 12 | 3
! 12 | 2
! 12 | 4
! 19 | /ewr
12 |
19 | gist.h
12 |
***************
*** 377,396 ****
12 | .
1 | readline
12 |
! 20 | 4.2
! 12 |
! 20 | 4.2
! 12 | .
! 20 | 4.2
! 12 | ,
1 | readline
! 20 | -4.2
! 12 |
1 | readline
! 20 | -4.2
! 12 | .
! 22 | 234
! 12 | +
|
12 | <
1 | i
--- 436,458 ----
12 | .
1 | readline
12 |
! 12 | 4.
! 12 | 2
! 12 | 4.
! 12 | 2.
! 12 | 4.
! 12 | 2,
1 | readline
! 12 | -
! 12 | 4.
! 12 | 2
1 | readline
! 12 | -
! 12 | 4.
! 12 | 2.
! 12 | 2
! 12 | 3
! 12 | 4 +
|
12 | <
1 | i
***************
*** 404,417 ****
12 |
12 | <>
1 | qwerty
! (133 rows)
SELECT to_tsvector('english', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c
gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234
<i <b> wow < jqw <> qwerty');
!
to_tsvector
!
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! '+4.0e-10':28 '-4.2':60,62 '/?':18 '/?ad=qwe&dw':7,10,14,24
'/?ad=qwe&dw=%20%32':27 '/awdf/dwqe/4325':48 '/usr/local/fff':47
'/wqe-324/ewr':51 '1aew.werc.ewr':9 '1aew.werc.ewr/?ad=qwe&dw':8 '234':63
'234.435':32 '2aew.werc.ewr':11 '345':1 '3aew.werc.ewr':13
'3aew.werc.ewr/?ad=qwe&dw':12 '4.2':56,57,58 '455':33 '4aew.werc.ewr':15
'5.005':34 '5aew.werc.ewr:8100':17 '5aew.werc.ewr:8100/?':16
'6aew.werc.ewr:8100':23 '6aew.werc.ewr:8100/?ad=qwe&dw':22
'7aew.werc.ewr:8100':26 '7aew.werc.ewr:8100/?ad=qwe&dw=%20%32':25 'ad':19
'aew.werc.ewr':6 'aew.werc.ewr/?ad=qwe&dw':5 'asdf':39 'dw':21 'efd.r':3
'ewr1':45 'ewri2':46 'gist.c':54 'gist.h':52 'gist.h.c':53 'hjwer':44 'jf':41
'jqw':66 'qwe':2,20,29,30,37 'qwe-wer':36 'qwer':40 'qwerti':67 'qwqwe':31
'readlin':55,59,61 'rewt/ewr':49 'sdjk':42 '[email protected]':35 'wefjn':50
'wer':38 'wow':65 'www.com':4
(1 row)
SELECT length(to_tsvector('english', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
--- 466,479 ----
12 |
12 | <>
1 | qwerty
! (195 rows)
SELECT to_tsvector('english', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
/usr/local/fff /awdf/dwqe/4325 rewt/ewr wefjn /wqe-324/ewr gist.h gist.h.c
gist.c. readline 4.2 4.2. 4.2, readline-4.2 readline-4.2. 234
<i <b> wow < jqw <> qwerty');
!
to_tsvector
!
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! '/?ad=qwe&dw':6,9,13 '/awdf/dwqe':47 '/ewr':51 '/usr/local/fff':46
'/wqe-':50 'ad':16,20,24 'aew.werc.ewr':5,8,10,12,14,15,19,23
'aew.werc.ewr/?ad=qwe&dw':4,7,11 'asdf':35 'dw':18,22,26 'e':27 'efd.r':2
'ewr':41 'ewri':42 'gist.c':54 'gist.h':52 'gist.h.c':53 'hjwer':40 'href':44
'jf':37 'jqw':60 'qwe':1,17,21,25,28,29,33,45 'qwe-wer':32 'qwer':36
'qwerti':61 'qwqwe':30 'readlin':55,56,57 'rewt/ewr':48 'sdjk':38
'[email protected]':31 'wefjn':49 'wer':34 'wow':59 'www.com':3
(1 row)
SELECT length(to_tsvector('english', '345 [email protected] '' http://www.com/
http://aew.werc.ewr/?ad=qwe&dw 1aew.werc.ewr/?ad=qwe&dw 2aew.werc.ewr
http://3aew.werc.ewr/?ad=qwe&dw http://4aew.werc.ewr
http://5aew.werc.ewr:8100/? ad=qwe&dw 6aew.werc.ewr:8100/?ad=qwe&dw
7aew.werc.ewr:8100/?ad=qwe&dw=%20%32 +4.0e-10 qwe qwe qwqwe 234.435 455 5.005
[email protected] qwe-wer asdf <fr>qwer jf sdjk<we hjwer <werrwe> ewr1> ewri2 <a
href="qwe<qwe>">
***************
*** 419,425 ****
<i <b> wow < jqw <> qwerty'));
length
--------
! 53
(1 row)
-- ts_debug
--- 481,487 ----
<i <b> wow < jqw <> qwerty'));
length
--------
! 34
(1 row)
-- ts_debug
***************
*** 430,441 ****
asciiword | Word, all ASCII | abc | {english_stem} |
english_stem | {abc}
entity | XML entity | &nm1; | {} |
|
asciiword | Word, all ASCII | def | {english_stem} |
english_stem | {def}
! entity | XML entity | © | {} |
|
asciiword | Word, all ASCII | ghi | {english_stem} |
english_stem | {ghi}
! entity | XML entity | õ | {} |
|
asciiword | Word, all ASCII | jkl | {english_stem} |
english_stem | {jkl}
tag | XML tag | </myns:foo-bar_baz.blurfl> | {} |
|
! (9 rows)
-- check parsing of URLs
SELECT * from ts_debug('english',
'http://www.harewoodsolutions.co.uk/press.aspx</span>');
--- 492,508 ----
asciiword | Word, all ASCII | abc | {english_stem} |
english_stem | {abc}
entity | XML entity | &nm1; | {} |
|
asciiword | Word, all ASCII | def | {english_stem} |
english_stem | {def}
! blank | Space symbols | &# | {} |
|
! asciiword | Word, all ASCII | xa | {english_stem} |
english_stem | {xa}
! blank | Space symbols | 9; | {} |
|
asciiword | Word, all ASCII | ghi | {english_stem} |
english_stem | {ghi}
! blank | Space symbols | &# | {} |
|
! blank | Space symbols | 2 | {} |
|
! blank | Space symbols | 4 | {} |
|
! blank | Space symbols | 5; | {} |
|
asciiword | Word, all ASCII | jkl | {english_stem} |
english_stem | {jkl}
tag | XML tag | </myns:foo-bar_baz.blurfl> | {} |
|
! (14 rows)
-- check parsing of URLs
SELECT * from ts_debug('english',
'http://www.harewoodsolutions.co.uk/press.aspx</span>');
***************
*** 449,479 ****
(5 rows)
SELECT * from ts_debug('english', 'http://aew.wer0c.ewr/id?ad=qwe&dw<span>');
! alias | description | token | dictionaries |
dictionary | lexemes
!
----------+---------------+----------------------------+--------------+------------+------------------------------
! protocol | Protocol head | http:// | {} |
|
! url | URL | aew.wer0c.ewr/id?ad=qwe&dw | {simple} |
simple | {aew.wer0c.ewr/id?ad=qwe&dw}
! host | Host | aew.wer0c.ewr | {simple} |
simple | {aew.wer0c.ewr}
! url_path | URL path | /id?ad=qwe&dw | {simple} |
simple | {/id?ad=qwe&dw}
! tag | XML tag | <span> | {} |
|
! (5 rows)
SELECT * from ts_debug('english', 'http://5aew.werc.ewr:8100/?');
! alias | description | token | dictionaries | dictionary
| lexemes
!
----------+---------------+----------------------+--------------+------------+------------------------
! protocol | Protocol head | http:// | {} |
|
! url | URL | 5aew.werc.ewr:8100/? | {simple} | simple
| {5aew.werc.ewr:8100/?}
! host | Host | 5aew.werc.ewr:8100 | {simple} | simple
| {5aew.werc.ewr:8100}
! url_path | URL path | /? | {simple} | simple
| {/?}
! (4 rows)
SELECT * from ts_debug('english', '5aew.werc.ewr:8100/?xx');
! alias | description | token | dictionaries | dictionary
| lexemes
!
----------+-------------+------------------------+--------------+------------+--------------------------
! url | URL | 5aew.werc.ewr:8100/?xx | {simple} | simple
| {5aew.werc.ewr:8100/?xx}
! host | Host | 5aew.werc.ewr:8100 | {simple} | simple
| {5aew.werc.ewr:8100}
! url_path | URL path | /?xx | {simple} | simple
| {/?xx}
! (3 rows)
-- to_tsquery
SELECT to_tsquery('english', 'qwe & sKies ');
--- 516,559 ----
(5 rows)
SELECT * from ts_debug('english', 'http://aew.wer0c.ewr/id?ad=qwe&dw<span>');
! alias | description | token | dictionaries | dictionary |
lexemes
!
----------+---------------+--------------------+--------------+------------+----------------------
! protocol | Protocol head | http:// | {} | |
! host | Host | aew.wer | {simple} | simple |
{aew.wer}
! blank | Space symbols | 0 | {} | |
! url | URL | c.ewr/id?ad=qwe&dw | {simple} | simple |
{c.ewr/id?ad=qwe&dw}
! host | Host | c.ewr | {simple} | simple |
{c.ewr}
! url_path | URL path | /id?ad=qwe&dw | {simple} | simple |
{/id?ad=qwe&dw}
! tag | XML tag | <span> | {} | |
! (7 rows)
SELECT * from ts_debug('english', 'http://5aew.werc.ewr:8100/?');
! alias | description | token | dictionaries | dictionary |
lexemes
!
----------+---------------+--------------+--------------+------------+----------------
! protocol | Protocol head | http:// | {} | |
! blank | Space symbols | 5 | {} | |
! host | Host | aew.werc.ewr | {simple} | simple |
{aew.werc.ewr}
! blank | Space symbols | : | {} | |
! blank | Space symbols | 8 | {} | |
! blank | Space symbols | 1 | {} | |
! blank | Space symbols | 0 | {} | |
! blank | Space symbols | 0 | {} | |
! blank | Space symbols | /? | {} | |
! (9 rows)
SELECT * from ts_debug('english', '5aew.werc.ewr:8100/?xx');
! alias | description | token | dictionaries | dictionary |
lexemes
!
-----------+-----------------+--------------+----------------+--------------+----------------
! blank | Space symbols | 5 | {} | |
! host | Host | aew.werc.ewr | {simple} | simple |
{aew.werc.ewr}
! blank | Space symbols | : | {} | |
! blank | Space symbols | 8 | {} | |
! blank | Space symbols | 1 | {} | |
! blank | Space symbols | 0 | {} | |
! blank | Space symbols | 0 | {} | |
! blank | Space symbols | /? | {} | |
! asciiword | Word, all ASCII | xx | {english_stem} | english_stem |
{xx}
! (9 rows)
-- to_tsquery
SELECT to_tsquery('english', 'qwe & sKies ');
***************
*** 519,527 ****
(1 row)
SELECT plainto_tsquery('english', 'the and z 1))& fghj');
! plainto_tsquery
! --------------------
! 'z' & '1' & 'fghj'
(1 row)
SELECT plainto_tsquery('english', 'foo bar') && plainto_tsquery('english',
'asd');
--- 599,607 ----
(1 row)
SELECT plainto_tsquery('english', 'the and z 1))& fghj');
! plainto_tsquery
! -----------------
! 'z' & 'fghj'
(1 row)
SELECT plainto_tsquery('english', 'foo bar') && plainto_tsquery('english',
'asd');
***************
*** 1061,1067 ****
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
count
-------
! 1
(1 row)
UPDATE test_tsvector SET t = null WHERE t = '345 qwerty';
--- 1141,1147 ----
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
count
-------
! 0
(1 row)
UPDATE test_tsvector SET t = null WHERE t = '345 qwerty';
***************
*** 1075,1081 ****
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
count
-------
! 1
(1 row)
-- test finding items in GIN's pending list
--- 1155,1161 ----
SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty');
count
-------
! 0
(1 row)
-- test finding items in GIN's pending list
======================================================================
***
/pub/devel/postgresql/postgresql-9.3beta1-1/src/postgresql-9.3beta1/src/test/regress/expected/without_oid.out
2013-05-06 22:57:06.000000000 +0200
---
/pub/devel/postgresql/postgresql-9.3beta1-1/build/src/test/regress/results/without_oid.out
2013-06-10 10:22:39.130668700 +0200
***************
*** 47,52 ****
--- 47,53 ----
LINE 1: SELECT count(oid) FROM wo;
^
VACUUM ANALYZE wi;
+ WARNING: could not open statistics file "pg_stat_tmp/global.stat": Device or
resource busy
VACUUM ANALYZE wo;
SELECT min(relpages) < max(relpages), min(reltuples) - max(reltuples)
FROM pg_class
======================================================================
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
