Re: [BUGS] what are the ways to avoid --- "ERROR: EXECUTE of SELECT ... INTO is not implemented yet"

2008-05-31 Thread Shantanu
Here is my real use case 1) We have nornal SELECT ...INTO calls in the procedure calls 2) However we landed ourselves with the following problem http://www.postgresql.org/docs/faqs.FAQ.html#item4.19 4.19) Why do I get "relation with OID # does not exist" errors when accessing temporary table

Re: [BUGS] what are the ways to avoid --- "ERROR: EXECUTE of SELECT ... INTO is not implemented yet"

2008-05-31 Thread Shantanu
Here is my real use case 1) We have nornal SELECT ...INTO calls in the procedure calls 2) However we landed ourselves with the following problem http://www.postgresql.org/docs/faqs.FAQ.html#item4.19 4.19) Why do I get "relation with OID # does not exist" errors when accessing temporary table

Re: [BUGS] BUG #4216: Index scan goes wrong with crosstype comparison and between in one statement

2008-05-31 Thread Tom Lane
"Sokolov Yura aka "funny_falcon"" <[EMAIL PROTECTED]> writes: > I've created a new type - time_interval, define operators on it and > timestamp, add those operators into OPERATOR FAMILY datetime_ops USING > btree; > When I query a table using BETWEEN and equality timestamp = time_interval > (which

Re: [BUGS] problems compiling in 64 bits

2008-05-31 Thread Tom Lane
"Gerardo Antonio" <[EMAIL PROTECTED]> writes: > I am trying to compile Postgres 8.1.9 in the following Linux version: > Linux version 2.6.9-34.EL ([EMAIL PROTECTED]) (gcc version > 3.4.5 20051201 (Red Hat 3.4.5-2)) > but I get a bunch of errors saying " > i386 architecture of input file > `../.

[BUGS] BUG #4214: Bug at installaing 8.1.11

2008-05-31 Thread ROUSSEAU Jacques
The following bug has been logged online: Bug reference: 4214 Logged by: ROUSSEAU Jacques Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.11 Operating system: 2003 SERVER R2 Description:Bug at installaing 8.1.11 Details: installing log generated: === Fin de

[BUGS] BUG #4216: Index scan goes wrong with crosstype comparison and between in one statement

2008-05-31 Thread Sokolov Yura aka
The following bug has been logged online: Bug reference: 4216 Logged by: Sokolov Yura aka "funny_falcon" Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: debian etch 4r3 Description:Index scan goes wrong with crosstype comparison and betwee