[HACKERS] tsvector concatenation - backend crash

Thu, 25 Aug 2011 12:49:50 -0700 

Hi

Attached SQL files gives (at least in my hands) a reliable backend crash
with this stacktrace .. reproduced on both 9.0.4 and HEAD. I'm sorry
I cannot provide a more trimmed down set of vectors the reproduces the bug, thus 
the "obsfucated" dataset. But even deleting single terms in the vectors make
the bug go away.
*** glibc detected *** postgres: jk jk [local] SELECT: corrupted double-linked list: 0x0000000002279f80 *** 
======= Backtrace: =========
/lib/libc.so.6(+0x775b6)[0x7fe4db4b25b6]
/lib/libc.so.6(+0x7aa25)[0x7fe4db4b5a25]
/lib/libc.so.6(cfree+0x73)[0x7fe4db4b8e83]
postgres: jk jk [local] SELECT[0x710de5]
postgres: jk jk [local] SELECT(MemoryContextReset+0x2a)[0x71119a]
postgres: jk jk [local] SELECT(ExecScan+0x4a)[0x57887a]
postgres: jk jk [local] SELECT(ExecProcNode+0x238)[0x571708]
postgres: jk jk [local] SELECT(standard_ExecutorRun+0xd2)[0x5705e2]
postgres: jk jk [local] SELECT[0x63c627]
postgres: jk jk [local] SELECT(PortalRun+0x248)[0x63d948]
postgres: jk jk [local] SELECT[0x639fdb]
postgres: jk jk [local] SELECT(PostgresMain+0x547)[0x63af97]
postgres: jk jk [local] SELECT[0x5fb959]
postgres: jk jk [local] SELECT(PostmasterMain+0xa97)[0x5fe137]
postgres: jk jk [local] SELECT(main+0x490)[0x59f4d0]
/lib/libc.so.6(__libc_start_main+0xfd)[0x7fe4db459c4d]
postgres: jk jk [local] SELECT[0x45d569]
======= Memory map: ========
00400000-008d6000 r-xp 00000000 08:01 4071141 /tmp/pgsql/bin/postgres 00ad5000-00ad6000 r--p 004d5000 08:01 4071141 /tmp/pgsql/bin/postgres 00ad6000-00ae2000 rw-p 004d6000 08:01 4071141 /tmp/pgsql/bin/postgres 
00ae2000-00b43000 rw-p 00000000 00:00 0
0215d000-0227e000 rw-p 00000000 00:00 0 [heap] 
7fe4d4000000-7fe4d4021000 rw-p 00000000 00:00 0
7fe4d4021000-7fe4d8000000 ---p 00000000 00:00 0
7fe4d908f000-7fe4d90a5000 r-xp 00000000 08:01 4194383 /lib/libgcc_s.so.1 7fe4d90a5000-7fe4d92a4000 ---p 00016000 08:01 4194383 /lib/libgcc_s.so.1 7fe4d92a4000-7fe4d92a5000 r--p 00015000 08:01 4194383 /lib/libgcc_s.so.1 7fe4d92a5000-7fe4d92a6000 rw-p 00016000 08:01 4194383 /lib/libgcc_s.so.1 
7fe4d92c1000-7fe4d9342000 rw-p 00000000 00:00 0
7fe4d9342000-7fe4db22e000 rw-s 00000000 00:04 8716337 /SYSV0052ea91 (deleted) 7fe4db22e000-7fe4db23a000 r-xp 00000000 08:01 4194415 /lib/libnss_files-2.11.1.so 7fe4db23a000-7fe4db439000 ---p 0000c000 08:01 4194415 /lib/libnss_files-2.11.1.so 7fe4db439000-7fe4db43a000 r--p 0000b000 08:01 4194415 /lib/libnss_files-2.11.1.so 7fe4db43a000-7fe4db43b000 rw-p 0000c000 08:01 4194415 /lib/libnss_files-2.11.1.so 7fe4db43b000-7fe4db5b5000 r-xp 00000000 08:01 4194349 /lib/libc-2.11.1.so 7fe4db5b5000-7fe4db7b4000 ---p 0017a000 08:01 4194349 /lib/libc-2.11.1.so 7fe4db7b4000-7fe4db7b8000 r--p 00179000 08:01 4194349 /lib/libc-2.11.1.so 7fe4db7b8000-7fe4db7b9000 rw-p 0017d000 08:01 4194349 /lib/libc-2.11.1.so 
7fe4db7b9000-7fe4db7be000 rw-p 00000000 00:00 0
7fe4db7be000-7fe4db840000 r-xp 00000000 08:01 4194398 /lib/libm-2.11.1.so 7fe4db840000-7fe4dba3f000 ---p 00082000 08:01 4194398 /lib/libm-2.11.1.so 7fe4dba3f000-7fe4dba40000 r--p 00081000 08:01 4194398 /lib/libm-2.11.1.so 7fe4dba40000-7fe4dba41000 rw-p 00082000 08:01 4194398 /lib/libm-2.11.1.so 7fe4dba41000-7fe4dba43000 r-xp 00000000 08:01 4194363 /lib/libdl-2.11.1.so 7fe4dba43000-7fe4dbc43000 ---p 00002000 08:01 4194363 /lib/libdl-2.11.1.so 7fe4dbc43000-7fe4dbc44000 r--p 00002000 08:01 4194363 /lib/libdl-2.11.1.so 7fe4dbc44000-7fe4dbc45000 rw-p 00003000 08:01 4194363 /lib/libdl-2.11.1.so 7fe4dbc45000-7fe4dbc65000 r-xp 00000000 08:01 4194325 /lib/ld-2.11.1.so 
7fe4dbc85000-7fe4dbce7000 rw-p 00000000 00:00 0
7fe4dbce7000-7fe4dbd26000 r--p 00000000 08:01 5512971 /usr/lib/locale/en_DK.utf8/LC_CTYPE 7fe4dbd26000-7fe4dbe44000 r--p 00000000 08:01 5512650 /usr/lib/locale/en_DK.utf8/LC_COLLATE 
7fe4dbe44000-7fe4dbe47000 rw-p 00000000 00:00 0
7fe4dbe58000-7fe4dbe59000 r--p 00000000 08:01 5515083 /usr/lib/locale/en_DK.utf8/LC_TIME 7fe4dbe59000-7fe4dbe5a000 r--p 00000000 08:01 5515084 /usr/lib/locale/en_DK.utf8/LC_MONETARY 7fe4dbe5a000-7fe4dbe5b000 r--p 00000000 08:01 5640299 /usr/lib/locale/en_DK.utf8/LC_MESSAGES/SYS_LC_MESSAGES 7fe4dbe5b000-7fe4dbe62000 r--s 00000000 08:01 5511621 /usr/lib/gconv/gconv-modules.cache 
7fe4dbe62000-7fe4dbe64000 rw-p 00000000 00:00 0
7fe4dbe64000-7fe4dbe65000 r--p 0001f000 08:01 4194325 /lib/ld-2.11.1.so 7fe4dbe65000-7fe4dbe66000 rw-p 00020000 08:01 4194325 /lib/ld-2.11.1.so 
7fe4dbe66000-7fe4dbe67000 rw-p 00000000 00:00 0
7ffffaedd000-7ffffaf0d000 rw-p 00000000 00:00 0 [stack] 7ffffaf8b000-7ffffaf8c000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] 
LOG:  server process (PID 21514) was terminated by signal 6: Aborted

Thanks.
Jesper


--
-- PostgreSQL database dump
--
DROP TABLE foo;

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: foo; Type: TABLE; Schema: public; Owner: core; Tablespace: 
--

CREATE TABLE foo (
    test1 tsvector,
    test2 tsvector,
    id integer NOT NULL
);


ALTER TABLE public.foo OWNER TO core;

--
-- Name: foo_id_seq; Type: SEQUENCE; Schema: public; Owner: core
--

CREATE SEQUENCE foo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.foo_id_seq OWNER TO core;

--
-- Name: foo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: core
--

ALTER SEQUENCE foo_id_seq OWNED BY foo.id;


--
-- Name: foo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: core
--

SELECT pg_catalog.setval('foo_id_seq', 5, true);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: core
--

ALTER TABLE foo ALTER COLUMN id SET DEFAULT nextval('foo_id_seq'::regclass);


--
-- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: core
--

COPY foo (test1, test2, id) FROM stdin;
'03ðtfpð0104':29 '1':70 '18917' '18ðbugð0103':57 '0103ð21985ð01':51 
'0109ð05ð04' '0109ð12ð13' '2673' '42946' '43484' '46545' '48286' '70783' 
'75959' bnd':33,37 'by':39 'cdf':12 'chqh':59 
'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tccvw2jb7qu' 
'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tf942zwz25f' 
'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tf9431pqt1u' 
'tftttftttftttfttʘcrfbtfdʘ0109ð05ð04' 
'tftttftttftttfttʘcrfbtfdʘ0109ð12ð13' 
'tftttftttftttfttʘculturblionmfdiumʘpdb2':7 
'tftttftttftttfttʘfbultyłpbrfntłrfffrfncfʘnm48286':3,5 
'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010flh' 
'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010x4y' 
'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010xjw' 
'tftttftttftttfttʘidfntififrʘv23g6' 'tftttftttftttfttʘidfntififrʘv36y3' 
'tftttftttftttfttʘidfntififrʘv37fw' 'tftttftttftttfttʘidʘ18917' 
'tftttftttftttfttʘidʘ42946' 'tftttftttftttfttʘidʘ43484' 
'tftttftttftttfttʘitłprfttttttionʘ0' 'tftttftttftttfttʘitłprfttttttionʘ1' 
'tftttftttftttfttʘitłprfttttttionʘfblt' 
'tftttftttftttfttʘitłprfttttttionʘno' 
'tftttftttftttfttʘitłprfttttttionʘtru' 
'tftttftttftttfttʘitłprfttttttionʘy' 'tft':44,68 'tftʘcommfntʘ' 
'tftʘcommfntʘ0103ð21985ð01' 'tftʘcommfntʘbmg' 'tftʘcommfntʘby' 
'tftʘcommfntʘtft' 'tftʘcommfntʘfull' 'tftʘcommfntʘgfggmic' 
'tftʘcommfntʘlfngth' 'tftʘcommfntʘlunb' 'tftʘcommfntʘnl010470' 
'tftʘcommfntʘobtbinfd' 'tftʘcommfntʘon' 'tftʘcommfntʘpcr' 
'tftʘcommfntʘpfrformbncf' 'tftʘcommfntʘprojfct' 'tftʘcommfntʘtcrffning' 
'tftʘcommfntʘtfqufncing' 'tftʘcommfntʘtypf' 'tftʘcommfntʘuting' 
'tftʘcommfntʘvfctorfttf' 'tftʘcommfntʘwild' 
'tftʘdbtbtfctionʘnbturblłgfnf' 'tftʘditplbyłvblufʘ' 
'tftʘditplbyłvblufʘ03ðtfpð0104' 'tftʘditplbyłvblufʘ1' 
'tftʘditplbyłvblufʘ18ðbugð0103' 'tftʘditplbyłvblufʘ0103ð21985ð01' 
'tftʘditplbyłvblufʘbmg' 'tftʘditplbyłvblufʘby' 
'tftʘditplbyłvblufʘchqh' 'tftʘditplbyłvblufʘtft' 
'tftʘditplbyłvblufʘfdtfn' 'tftʘditplbyłvblufʘfrrort' 
'tftʘditplbyłvblufʘfull' 'tftʘditplbyłvblufʘgfggmic' 
'tftʘditplbyłvblufʘglucomotivtf' 'tftʘditplbyłvblufʘi5bp' 
'tftʘditplbyłvblufʘimportfd' 'tftʘditplbyłvblufʘlfngth' 
'tftʘditplbyłvblufʘlunb' 'tftʘditplbyłvblufʘnd011930' 
'tftʘditplbyłvblufʘnl010470' 'tftʘditplbyłvblufʘobtbinfd' 
'tftʘditplbyłvblufʘon' 'tftʘditplbyłvblufʘpcr' 
'tftʘditplbyłvblufʘpfrformbncf' 'tftʘditplbyłvblufʘprojfct' 
'tftʘditplbyłvblufʘtblk' 'tftʘditplbyłvblufʘtcrffning' 
'tftʘditplbyłvblufʘtfqufncing' 'tftʘditplbyłvblufʘtfquoib' 
'tftʘditplbyłvblufʘtypf' 'tftʘditplbyłvblufʘunbttignfd' 
'tftʘditplbyłvblufʘunc' 'tftʘditplbyłvblufʘuting' 
'tftʘditplbyłvblufʘvfctorfttf' 'tftʘditplbyłvblufʘwild' 
'tftʘditplbyłvblufʘwith' 'tftʘffbturfnbmfʘcdt' 'tftʘffbturfnbmfʘintfrn' 
'tftʘffbturfnbmfʘnzłglobbl' 'tftʘidfntififrʘd1jh' 'tftʘnbmfʘnd011930' 
'tftʘnycpimportditplbynbmfʘi5bp' 'tftʘnycpimportditplbynbmfʘtfquoib' 
'tftʘnycpimportfilfnbmfʘfmbl' 'tftʘnycpimportfilfnbmfʘnd011930' 
'tftʘtbgʘfrdbn' 'fnvirrrmfntbltbmpl':2 'fnvirrrmfntbltbmplf' 'frdbn':9,60 
'frror':55 'frrort' 'frr' 'frr2673' 'full':45 'gfggm':43 'gfggmic' 
'glucomotivt':13,30 'glucomotivtf' 'i5bp':63,65 'import':53 'importfd' 
'intfrn':16,19,22,25 'lfngth':46 'lunt':50 'ny011930':52,56,61,69 'nm010470':32 
'nm' 'nm048286' 'nm48286':4,6 'nłglobbl':28 'o4444' 'obtbin':38 'obtbinfd' 
'on':42 'orgfggtmʘcodfłtortbblfʘnm01zj6brhkw4kcg' 'orgfggtmʘcodfʘ' 
'orgfggtmʘcodfʘ48286' 'orgfggtmʘcodfʘnm' 'orgfggtmʘcodfʘnm048286' 
'orgfggtmʘcodfʘnm48286' 'orgfggtmʘidfntififrłtortbblfʘ01010101010zwx' 
'orgfggtmʘidfntififrʘo46fj' 'orgfggtmʘidʘ46545' 
'orgfggtmʘothfrcodftłtortbblfʘfrr01zf1hd6g4vrb4' 'orgfggtmʘothfrcodftʘ' 
'orgfggtmʘothfrcodftʘ2673' 'orgfggtmʘothfrcodftʘfrr' 
'orgfggtmʘothfrcodftʘfrr2673' 'pcr':40 'pdb2':8 'pfrform':34 'pfrformbncf' 
'projfct':31 't5r5':1 'tblk':58 'tcrffn':41 'tcrffning' 'tfqufnc':47 
'tfqufncing' 'tfquoib':62,64 'tourcfʘcbtfgorytypfʘfnvirrrmfntbltbmplf' 
'tourcfʘcontrbctttbtutłtortbblfʘuncfrtbin' 
'tourcfʘcontrbctttbtutʘuncfrtbin' 'tourcfʘidfntififrʘt5r5' 
'ttorbgfttorfdfntityʘidʘ70783' 'ttorbgfttorfdfntityʘidʘ75959' 
'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrłtortbblfʘ01010101011im7' 
'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrłtortbblfʘ01010101011mlz' 
'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrʘz1f4z' 
'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrʘz2b6r' 
'ttorfditfmʘidfntififrʘz1f4z' 'ttorfditfmʘidfntififrʘz2b6r' 't346y':10,11 
't346z':14,15 't3471':17,18 't3472':20,21 't3473':23,24 't3474':26,27 'typf':36 
'unbttign':67 'unbttignfd' 'unc':66 'utf':48 'uting' 'v23g6' 'v36y3' 'v37fw' 
'vfctorftt':49 'vfctorfttf' 'wild':35 'with':54 'z1f4z' 'z2b6r'  'bnd':9 
'btcomycft':16,27,28 'btcomycftft' 'btcomycotb':29,55 'biotb':49 'bitun':15 
'bitunicbtf' 'bluf':10 'cfllulbr':47 'chbftothyriomycft':20 
'chbftothyriomycftft' 'cylindrotporb':2,51 'dikbryb':30 'donor':57 
'flbphomycftbl':13 'flbphomycftblft' 'fnzbd':59 'fnzbdft' 'fubtcomycotb':23 
'fucbryb':46 'fucbryot':41 'fucbryotb':45 'fucbryotbf' 'fucbryotft' 
'fukbryb':44 'fukbryot':39,40 'fukbryotb':42,43 'fukbryotbf' 'fukbryotft' 
'furotibcfb':7 'furotibcfbf' 'furotibl':12,54 'furotiblft' 'furotiomycft':19 
'furotiomycftft' 'furotiomycftidb':14 'furotiomycftidbf' 'for':58 'fungbl':61 
'funzb':26,31,32,33,36,56 'gfotmithib':1,3,50,52 'grffn':8 'group':38 'hott':62 
'hottt' 'in':60 'lbborbtori':63 'lbborbtory' 'lfotiomycftb':21 
'loculobtcomycft':18 'loculobtcomycftft' 'mftbzob':37 'mitotpor':4 'mitotporic' 
'mold':11 'moldt' 'opitthokont':34 'opitthokontb':35 'opitthokontt' 'orgbn':48 
'orgfggtmt' 'pfzizomycotinb':22 'plfctomycft':17 'plfctomycftft' 'tbc':25 
'tbcchbromycftb':24 'tcblf':64 'tblbromyc':5 'tblbromycft' 
'dbtbbbtfnodfʘgmorfgittrbtionʘ0104ð02780' 
'dbtbbbtfnodfʘgmorfgittrbtionʘdonor' 'dbtbbbtfnodfʘgmorfgittrbtionʘfnzbdft' 
'dbtbbbtfnodfʘgmorfgittrbtionʘfor' 'dbtbbbtfnodfʘgmorfgittrbtionʘfungbl' 
'dbtbbbtfnodfʘgmorfgittrbtionʘhottt' 'dbtbbbtfnodfʘgmorfgittrbtionʘin' 
'dbtbbbtfnodfʘgmorfgittrbtionʘlbborbtory' 
'dbtbbbtfnodfʘgmorfgittrbtionʘtcblf' 'dbtbbbtfnodfʘidfntififrʘx1c7x' 
'dbtbbbtfnodfʘlocbldbtbbbtffbmilyʘtrichocombcfbf' 
'dbtbbbtfnodfʘlocbldbtbbbtfgfnutʘgfotmithib' 
'dbtbbbtfnodfʘlocbldbtbbbtftftttftʘfunzb' 
'dbtbbbtfnodfʘlocbldbtbbbtfordfrʘfurotiblft' 
'dbtbbbtfnodfʘlocbldbtbbbtfphylumʘbtcomycotb' 
'dbtbbbtfnodfʘlocbldbtbbbtftpfciftłtortbblfʘgfotmithibłcylindrotporb' 
'dbtbbbtfnodfʘlocbldbtbbbtftpfciftʘcylindrotporb' 
'dbtbbbtfnodfʘlocbldbtbbbtftpfciftʘgfotmithib' 'dbtbbbtfnodfʘrbnkʘtpfcift' 
'dbtbbbtfnodfʘtcifntificnbmfłtortbblfʘgfotmithibłcylindrotporb' 
'dbtbbbtfnodfʘtcifntificnbmfʘbnd' 'dbtbbbtfnodfʘtcifntificnbmfʘbtcomycftft' 
'dbtbbbtfnodfʘtcifntificnbmfʘbtcomycotb' 
'dbtbbbtfnodfʘtcifntificnbmfʘbiotb' 
'dbtbbbtfnodfʘtcifntificnbmfʘbitunicbtf' 'dbtbbbtfnodfʘtcifntificnbmfʘbluf' 
'dbtbbbtfnodfʘtcifntificnbmfʘcfllulbr' 
'dbtbbbtfnodfʘtcifntificnbmfʘchbftothyriomycftft' 
'dbtbbbtfnodfʘtcifntificnbmfʘcylindrotporb' 
'dbtbbbtfnodfʘtcifntificnbmfʘdikbryb' 
'dbtbbbtfnodfʘtcifntificnbmfʘflbphomycftblft' 
'dbtbbbtfnodfʘtcifntificnbmfʘfubtcomycotb' 
'dbtbbbtfnodfʘtcifntificnbmfʘfucbryb' 
'dbtbbbtfnodfʘtcifntificnbmfʘfucbryotbf' 
'dbtbbbtfnodfʘtcifntificnbmfʘfucbryotft' 
'dbtbbbtfnodfʘtcifntificnbmfʘfukbryb' 
'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotb' 
'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotbf' 
'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotft' 
'dbtbbbtfnodfʘtcifntificnbmfʘfurotibcfbf' 
'dbtbbbtfnodfʘtcifntificnbmfʘfurotiblft' 
'dbtbbbtfnodfʘtcifntificnbmfʘfurotiomycftft' 
'dbtbbbtfnodfʘtcifntificnbmfʘfurotiomycftidbf' 
'dbtbbbtfnodfʘtcifntificnbmfʘfunzb' 
'dbtbbbtfnodfʘtcifntificnbmfʘgfotmithib' 
'dbtbbbtfnodfʘtcifntificnbmfʘgrffn' 'dbtbbbtfnodfʘtcifntificnbmfʘgroup' 
'dbtbbbtfnodfʘtcifntificnbmfʘlfotiomycftb' 
'dbtbbbtfnodfʘtcifntificnbmfʘloculobtcomycftft' 
'dbtbbbtfnodfʘtcifntificnbmfʘmftbzob' 
'dbtbbbtfnodfʘtcifntificnbmfʘmitotporic' 
'dbtbbbtfnodfʘtcifntificnbmfʘmoldt' 
'dbtbbbtfnodfʘtcifntificnbmfʘopitthokontb' 
'dbtbbbtfnodfʘtcifntificnbmfʘopitthokontt' 
'dbtbbbtfnodfʘtcifntificnbmfʘorgfggtmt' 
'dbtbbbtfnodfʘtcifntificnbmfʘpfzizomycotinb' 
'dbtbbbtfnodfʘtcifntificnbmfʘplfctomycftft' 
'dbtbbbtfnodfʘtcifntificnbmfʘtbc' 
'dbtbbbtfnodfʘtcifntificnbmfʘtbcchbromycftb' 
'dbtbbbtfnodfʘtcifntificnbmfʘtblbromycft' 
'dbtbbbtfnodfʘtcifntificnbmfʘtrichocombcfbf' 'dbtbbbtfnodfʘtttidʘ131567' 
'dbtbbbtfnodfʘtttidʘ147538' 'dbtbbbtfnodfʘtttidʘ147545' 
'dbtbbbtfnodfʘtttidʘ241625' 'dbtbbbtfnodfʘtttidʘ2759' 
'dbtbbbtfnodfʘtttidʘ28568' 'dbtbbbtfnodfʘtttidʘ33154' 
'dbtbbbtfnodfʘtttidʘ39190' 'dbtbbbtfnodfʘtttidʘ451864' 
'dbtbbbtfnodfʘtttidʘ451871' 'dbtbbbtfnodfʘtttidʘ4751' 
'dbtbbbtfnodfʘtttidʘ4890' 'dbtbbbtfnodfʘtttidʘ5042' 
'dbtbbbtfnodfʘtttidʘ68829' 'dbtbbbtfnodfʘtttidʘ716545' 
'dbtbbbtfnodfʘtttidʘ716546' 'trichocombcfb':6,53 'trichocombcfbf' 1
\.


--
-- PostgreSQL database dump complete
--

select length(test1 || test2) from foo;


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to