Today, I tried cvs version of 6.5 and got following:

c_flats=> explain select station_id from metro_stations except select metro_id from work_flats;
ERROR:  copyObject: don't know how to copy 604
c_flats=> select station_id from metro_stations except select metro_id from work_flats;
station_id
----------
        27
        41
        60
        81
        92
       102
       133
       134
       142
       149
       150
(11 rows)

Explain fails while select works (didn't check the result though)

	Regards,

		Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Sat, 1 May 1999 20:31:55 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
6.5 cvs ERROR:  copyObject: don't know how to copy 604
Oleg Bartunov <oleg@sai.msu.su> writes:
> [ EXPLAIN fails on a SELECT ... EXCEPT ... ]

This looks to be another artifact of the fact that EXPLAIN
doesn't invoke the rewriter.

It looks to me like the rewrite-invocation section of
pg_parse_and_plan() needs to be pulled out as a subroutine
so that explain.c can invoke it.  Comments?  Where should
the new subroutine go?  (Probably not in postgres.c...)

			regards, tom lane

Sat, 01 May 1999 16:26:40 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604 

Is this a valid item?



> Oleg Bartunov <oleg@sai.msu.su> writes:
> > [ EXPLAIN fails on a SELECT ... EXCEPT ... ]
> 
> This looks to be another artifact of the fact that EXPLAIN
> doesn't invoke the rewriter.
> 
> It looks to me like the rewrite-invocation section of
> pg_parse_and_plan() needs to be pulled out as a subroutine
> so that explain.c can invoke it.  Comments?  Where should
> the new subroutine go?  (Probably not in postgres.c...)
> 
> 			regards, tom lane
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 10 May 1999 12:48:15 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Is this a valid item?

It was; but I fixed it yesterday.  At least it seems to work now.

			regards, tom lane


>> Oleg Bartunov <oleg@sai.msu.su> writes:
>>>> [ EXPLAIN fails on a SELECT ... EXCEPT ... ]
>> 
>> This looks to be another artifact of the fact that EXPLAIN
>> doesn't invoke the rewriter.
>> 
>> It looks to me like the rewrite-invocation section of
>> pg_parse_and_plan() needs to be pulled out as a subroutine
>> so that explain.c can invoke it.  Comments?  Where should
>> the new subroutine go?  (Probably not in postgres.c...)

Mon, 10 May 1999 13:24:34 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604 
On Mon, 10 May 1999, Bruce Momjian wrote:

> Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> 
> 
> Is this a valid item?

Can't check this, because of problem to compile cvs:

make[2]: Entering directory /home/postgres/cvs/pgsql/src/lextest'
flex scan.l
gcc -c lex.yy.c
lex.yy.c: In function 	nput':
lex.yy.c:1046: parse error before )'
lex.yy.c:243: warning: y_flex_realloc' declared tatic' but never defined
lex.yy.c:273: warning: y_fatal_error' declared tatic' but never defined
make[2]: *** [lextest] Error 1
make[2]: Leaving directory /home/postgres/cvs/pgsql/src/lextest'

Will test after somebody fix cvs :-) 
mira:~/cvs/pgsql/src$ flex --version
flex version 2.5.4

	Regards,

		Oleg


> 
> 
> 
> > Oleg Bartunov <oleg@sai.msu.su> writes:
> > > [ EXPLAIN fails on a SELECT ... EXCEPT ... ]
> > 
> > This looks to be another artifact of the fact that EXPLAIN
> > doesn't invoke the rewriter.
> > 
> > It looks to me like the rewrite-invocation section of
> > pg_parse_and_plan() needs to be pulled out as a subroutine
> > so that explain.c can invoke it.  Comments?  Where should
> > the new subroutine go?  (Probably not in postgres.c...)
> > 
> > 			regards, tom lane
> > 
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Mon, 10 May 1999 21:56:14 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> On Mon, 10 May 1999, Bruce Momjian wrote:
> 
> > Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> > From: Bruce Momjian <maillist@candle.pha.pa.us>
> > To: Tom Lane <tgl@sss.pgh.pa.us>
> > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> > 
> > 
> > Is this a valid item?
> 
> Can't check this, because of problem to compile cvs:
> 
> make[2]: Entering directory /home/postgres/cvs/pgsql/src/lextest'
> flex scan.l
> gcc -c lex.yy.c
> lex.yy.c: In function 	nput':
> lex.yy.c:1046: parse error before )'
> lex.yy.c:243: warning: y_flex_realloc' declared tatic' but never defined
> lex.yy.c:273: warning: y_fatal_error' declared tatic' but never defined
> make[2]: *** [lextest] Error 1
> make[2]: Leaving directory /home/postgres/cvs/pgsql/src/lextest'
> 

No one is playing with lextest, I hope.  Perhaps it is something there?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 10 May 1999 14:37:59 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
On Mon, 10 May 1999, Bruce Momjian wrote:

> Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> 
> 
> Is this a valid item?
> 

After compilation of current cvs at home I test this and it works.
But explain shows that select will not use indices, which exists !
select station_id from metro_stations except select  metro_id from work_flats;

	Oleg

> 
> 
> > Oleg Bartunov <oleg@sai.msu.su> writes:
> > > [ EXPLAIN fails on a SELECT ... EXCEPT ... ]
> > 
> > This looks to be another artifact of the fact that EXPLAIN
> > doesn't invoke the rewriter.
> > 
> > It looks to me like the rewrite-invocation section of
> > pg_parse_and_plan() needs to be pulled out as a subroutine
> > so that explain.c can invoke it.  Comments?  Where should
> > the new subroutine go?  (Probably not in postgres.c...)
> > 
> > 			regards, tom lane
> > 
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Tue, 11 May 1999 19:44:58 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> On Mon, 10 May 1999, Bruce Momjian wrote:
> 
> > Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> > From: Bruce Momjian <maillist@candle.pha.pa.us>
> > To: Tom Lane <tgl@sss.pgh.pa.us>
> > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> > 
> > 
> > Is this a valid item?
> > 
> 
> After compilation of current cvs at home I test this and it works.
> But explain shows that select will not use indices, which exists !
> select station_id from metro_stations except select  metro_id from work_flats;

Indexes aren't much use if you don't have a WHERE restriction, no?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 11 May 1999 12:04:32 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
On Tue, 11 May 1999, Bruce Momjian wrote:

> Date: Tue, 11 May 1999 12:04:32 -0400 (EDT)
> From: Bruce Momjian <maillist@candle.pha.pa.us>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> 
> > On Mon, 10 May 1999, Bruce Momjian wrote:
> > 
> > > Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> > > From: Bruce Momjian <maillist@candle.pha.pa.us>
> > > To: Tom Lane <tgl@sss.pgh.pa.us>
> > > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > > Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> > > 
> > > 
> > > Is this a valid item?
> > > 
> > 
> > After compilation of current cvs at home I test this and it works.
> > But explain shows that select will not use indices, which exists !
> > select station_id from metro_stations except select  metro_id from work_flats;
> 
> Indexes aren't much use if you don't have a WHERE restriction, no?
> 
Oh, yes. 

	Oleg

> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   maillist@candle.pha.pa.us            |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Tue, 11 May 1999 20:59:15 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604