Re: [BUGS] Nasty tsvector can make dumps unrestorable - Mailing list 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 1test=> select * from foo;  bar------- '''x'(1 row)

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +