Re: [BUGS] Nasty tsvector can make dumps unrestorable

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stuart Bishop <stuart(at)stuartbishop(dot)net>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [BUGS] Nasty tsvector can make dumps unrestorable
Date: 2007-11-10 03:55:15
Message-ID: 200711100355.lAA3tF416292@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Andrew Dunstan wrote:
> > While the COPY will load into the table, this doesn't:
> >
> > test=> INSERT INTO Foo(bar) VALUES (E'''''x');
> > ERROR: syntax error in tsvector: "''x"
> >
> > I am confused.
> >
> >
>
>
> These two are not equivalent. What happens if you try this?
>
> INSERT INTO Foo(bar) VALUES (E'''''''x''');

test=> INSERT INTO Foo(bar) VALUES (E'''''''x''');
INSERT 0 1
test=> select * from foo;
bar
-------
'''x'
(1 row)

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

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message John 2007-11-10 10:36:41 BUG #3740: could not load library ".../pljava.dll
Previous Message Andrew Dunstan 2007-11-10 03:53:18 Re: [BUGS] Nasty tsvector can make dumps unrestorable

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-10 05:06:15 Re: [HACKERS] pg_ctl configurable timeout
Previous Message Andrew Dunstan 2007-11-10 03:53:18 Re: [BUGS] Nasty tsvector can make dumps unrestorable