Re: [BUGS] Bugs in bigint indexes

2003-12-19 Thread jmm
Title: Message Try this    explain SELECT id FROM it_test WHERE id='123'; QUERY PLAN Index Scan using it_test_pkey on it_test  (cost=0.00..4.82 rows=1 width=8)   Index Cond: (id = 123

Re: [BUGS] Bug #857: [7.3] Attribute oid not found in a temporary table

2002-12-26 Thread JMM Moi-Meme Maitre du Monde
f you specify the oid column as > part of the SELECT INTO, it will take the oid from the original table > and put it in your new table. Does that help you? > > ------- > > [EMAIL PROTECTED] wrote: > > jmm ([E

Re: [BUGS] Bug #857: [7.3] Attribute oid not found in a temporary table

2002-12-26 Thread JMM Moi-Meme Maitre du Monde
Wrong ! The workaround works in 7.3 but is not backward compatible with prior 7.x.y version. I began reverting to 7.2.3 :( Anyway, I will survive ;) On Thu, Dec 26, 2002 at 09:02:08AM +0100, JMM Moi-Meme Maitre du Monde wrote: > Yes, it works. Thanks. > > I will just have to alte