Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-17 Thread Gavin Flower
On 16/07/11 05:21, Tom Lane wrote: Gavin Flower writes: On 15/07/11 11:25, Gavin Flower wrote: I think it should be possible to put a constraint on the master table to prevent rows being inserted. Of course, minutes after I sent the above - I realized these constraints are inherited, so the a

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-15 Thread Tom Lane
Gavin Flower writes: > On 15/07/11 11:25, Gavin Flower wrote: >> I think it should be possible to put a constraint on the master table >> to prevent rows being inserted. > Of course, minutes after I sent the above - I realized these constraints > are inherited, so the above is nonsense! :-( Y

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-15 Thread Gavin Flower
On 15/07/11 11:25, Gavin Flower wrote: On 15/07/11 08:00, Gavin Flower wrote: On 15/07/11 07:14, Tom Lane wrote: Alvaro Herrera writes: Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011: Using pg 9.1beta3, I was found that running a function generated an error relating t

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-15 Thread Gavin Flower
On 15/07/11 08:00, Gavin Flower wrote: On 15/07/11 07:14, Tom Lane wrote: Alvaro Herrera writes: Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011: Using pg 9.1beta3, I was found that running a function generated an error relating to escaped single quotes, yet still produ

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-14 Thread Gavin Flower
On 15/07/11 07:14, Tom Lane wrote: Alvaro Herrera writes: Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011: Using pg 9.1beta3, I was found that running a function generated an error relating to escaped single quotes, yet still produced the answer I expected! The errors a

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-14 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011: >> Using pg 9.1beta3, I was found that running a function generated an >> error relating to escaped single quotes, yet still produced the answer I >> expected! > The errors are not spurious. The fu

Re: [BUGS] Spurious errors relating to escaped single quotes

2011-07-14 Thread Alvaro Herrera
Excerpts from Gavin Flower's message of jue jul 14 07:45:00 -0400 2011: > Hi, > > Using pg 9.1beta3, I was found that running a function generated an > error relating to escaped single quotes, yet still produced the answer I > expected! The errors are not spurious. The function doesn't exist n