From virender@magnum.barc.ernet.in Sun Apr  8 03:11:48 2001
Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f383Bm858470
	for <pgsql-sql@postgresql.org>; Sat, 7 Apr 2001 23:11:48 -0400 (EDT)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from mailgw.barc.ernet.in ([202.54.18.131])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f32F4IK97792
	for <pgsql-sql@postgresql.org>; Mon, 2 Apr 2001 11:04:21 -0400 (EDT)
	(envelope-from virender@magnum.barc.ernet.in)
Received: from magnum.barc.ernet.in (magnum.barc.ernet.in [192.168.1.22])
	by mailgw.barc.ernet.in (8.9.3/8.9.3) with ESMTP id UAA09003
	for <pgsql-sql@postgresql.org>; Mon, 2 Apr 2001 20:42:46 +0530 (IST)
	(envelope-from virender@magnum.barc.ernet.in)
Received: from devsys ([192.168.1.44])
	by magnum.barc.ernet.in (8.9.3/8.9.3) with SMTP id UAA02192
	for <pgsql-sql@postgresql.org>; Mon, 2 Apr 2001 20:29:43 +0530
Message-ID: <000a01c0bb86$ed9f0f50$2c01a8c0@devsys>
From: "comp" <virender@magnum.barc.ernet.in>
To: <pgsql-sql@postgresql.org>
Subject: Sql error
Date: Mon, 2 Apr 2001 20:39:34 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0007_01C0BBB5.071D4F90"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200104/106
X-Sequence-Number: 2446

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C0BBB5.071D4F90
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Respected Sir/Madam,

I visit your site find a lot of information. I download postgres7.0.3 lates=
t version and install it on Redhat6.1 server. I follow all the steps in you=
r Install file.=20

I create a database by  createdb  testdb  command.
After that I connect it by  'psql testdb'  command. It connect sucessfully.=
 but after connection when I type   testdb=3D>\df it gives this error:


" ERROR:  Function 'oid8types(oidvector)' does not exist.
  Unable to identify a function that stasfies the given  argument type You =
may need to add explocit typecast. "


Pl tell me how to solve this problem. I want to see the function available =
with the database.

Regards
virender singh
mumbai-india.




------=_NextPart_000_0007_01C0BBB5.071D4F90
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Respected Sir/Madam,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I visit your site find a lot of informatio=
n. I=20
download postgres7.0.3 latest version and install it on Redhat6.1 server. I=
=20
follow all the steps in your Install file. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I create a database by&nbsp; createdb&nbsp=
;=20
testdb&nbsp; command.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>After that I connect it by&nbsp; 'psql=20
testdb'&nbsp; command. It connect sucessfully. but after connection when I=
=20
type&nbsp;&nbsp; testdb=3D&gt;\df it gives this error:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>" ERROR:&nbsp; Function 'oid8types(oidvect=
or)' does=20
not exist.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; Unable to identify a function that =
stasfies=20
the given&nbsp; argument type </FONT><FONT face=3DArial size=3D2>You may ne=
ed to add=20
explocit typecast. "</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Pl tell me how to solve this problem. I wa=
nt to see=20
the function available with the database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>virender singh</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>mumbai-india.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0007_01C0BBB5.071D4F90--




From tgl@sss.pgh.pa.us Fri Apr  13 03:56:15 2001
Received: from sss.pgh.pa.us ([216.151.103.158])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3D3uF813667
	for <pgsql-sql@postgresql.org>; Thu, 12 Apr 2001 23:56:15 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3D3tvR02550;
	Thu, 12 Apr 2001 23:55:59 -0400 (EDT)
To: "comp" <virender@magnum.barc.ernet.in>
cc: pgsql-sql@postgresql.org
Subject: Re: Sql error 
In-reply-to: <000a01c0bb86$ed9f0f50$2c01a8c0@devsys> 
References: <000a01c0bb86$ed9f0f50$2c01a8c0@devsys>
Comments: In-reply-to "comp" <virender@magnum.barc.ernet.in>
	message dated "Mon, 02 Apr 2001 20:39:34 +0530"
Date: Thu, 12 Apr 2001 23:55:57 -0400
Message-ID: <2547.987134157@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200104/190
X-Sequence-Number: 2540

"comp" <virender@magnum.barc.ernet.in> writes:
>  but after connection when I type   testdb=3D>\df it gives this error:

> " ERROR:  Function 'oid8types(oidvector)' does not exist.

Use the version of psql that came with 7.0.3, not some older version.

			regards, tom lane



From rafcio@polonium.de Mon Oct  7 23:56:41 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7F8D847602A
	for <pgsql-sql@postgresql.org>; Mon,  7 Oct 2002 19:56:41 -0400 (EDT)
Received: from trill.maridan.net (unknown [217.6.52.210])
	by postgresql.org (Postfix) with ESMTP id 6C291475F2C
	for <pgsql-sql@postgresql.org>; Mon,  7 Oct 2002 19:56:39 -0400 (EDT)
Received: from rafcio.polonium.de (130-149-145-117.dialup.cs.tu-berlin.de
	[130.149.145.117])
	by trill.maridan.net (8.9.3/8.9.3) with ESMTP id BAA29397
	for <pgsql-sql@postgresql.org>; Tue, 8 Oct 2002 01:56:41 +0200
Message-Id: <5.1.0.14.0.20021008013840.01f5be78@mail.polonium.de>
X-Sender: rafcio@mail.polonium.de
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Tue, 08 Oct 2002 01:53:54 +0200
To: pgsql-sql@postgresql.org
From: Rafal Kedziorski <rafcio@polonium.de>
Subject: SQL Error
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/96
X-Sequence-Number: 9814

Hallo,

I have following table:

CREATE TABLE "scheduler_action" (
   "scheduler_action_id"  numeric(30) NOT NULL,
   "action_type"          numeric(4) NOT NULL,
   "priority"             numeric(4) NOT NULL,
   "referenced_id"        numeric(30) NOT NULL,
   "invocation_date"      numeric(30) NOT NULL,
   "is_done"              numeric(1) NOT NULL,
   PRIMARY KEY ("scheduler_action_id")
);

My quety look so:

select t0_o.scheduler_action_id from scheduler_action t0_o where 
t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921

And I get following error:

ERROR:  Unable to identify an operator '<=' for types 'numeric' and 'double 
precision'
         You will have to retype this query using an explicit cast

But if my query looks like:

select t0_o.scheduler_action_id from scheduler_action t0_o where 
t0_o.is_done = 0 and t0_o.invocation_date <= '1034033214921'

"invocation_date" is numeric with p=30 and s=0.


Best Regards,
Rafal




From ch@rodos.fzk.de Thu Oct  10 09:11:05 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 84EE047602A
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 05:11:05 -0400 (EDT)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id 4B6AA475EB2
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 05:11:02 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Thu Oct 10 11:11:02 2002 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id LAA05186; Thu, 10 Oct 2002 11:11:01 +0200 (METDST)
Message-ID: <3DA54424.B48015F8@rodos.fzk.de>
Date: Thu, 10 Oct 2002 11:11:00 +0200
From: Christoph Haller <ch@rodos.fzk.de>
X-Mailer: Mozilla 4.06 [en] (X11; I; HP-UX B.10.20 9000/780)
MIME-Version: 1.0
To: rafcio@polonium.de
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL Error
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/131
X-Sequence-Number: 9848

> CREATE TABLE "scheduler_action" (
>    "scheduler_action_id"  numeric(30) NOT NULL,
>    "action_type"          numeric(4) NOT NULL,
>    "priority"             numeric(4) NOT NULL,
>    "referenced_id"        numeric(30) NOT NULL,
>    "invocation_date"      numeric(30) NOT NULL,
>    "is_done"              numeric(1) NOT NULL,
>    PRIMARY KEY ("scheduler_action_id")
> );
>
> My quety look so:
>
> select t0_o.scheduler_action_id from scheduler_action t0_o where
> t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921
>
> And I get following error:
>
> ERROR:  Unable to identify an operator '<=' for types 'numeric' and
'double
> precision'
>          You will have to retype this query using an explicit cast
>
> But if my query looks like:
>
> select t0_o.scheduler_action_id from scheduler_action t0_o where
> t0_o.is_done = 0 and t0_o.invocation_date <= '1034033214921'
>
> "invocation_date" is numeric with p=30 and s=0.
>
I've got the same error message on
select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.2.1 on hppa-hp-hpux10.20, compiled by GCC 2.95.2

but
select t0_o.scheduler_action_id from scheduler_action t0_o where
template1-# t0_o.is_done = 0 and t0_o.invocation_date <=
1034033214921::numeric ;
did work;
I cannot see why this is necessary, and I cannot understand why nobody
else
replied to both of your requests.

Regards, Christoph




From achill@matrix.gatewaynet.com Thu Oct  10 11:12:13 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3ADE2475AE4
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 07:12:13 -0400 (EDT)
Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP id 1628B4762C4
	for <pgsql-sql@postgresql.org>; Thu, 10 Oct 2002 07:12:10 -0400 (EDT)
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g9ABNNk28153;
	Thu, 10 Oct 2002 14:23:23 +0300
Date: Thu, 10 Oct 2002 14:23:23 +0300 (EEST)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: rafcio@polonium.de, <pgsql-sql@postgresql.org>
Subject: Re: SQL Error
In-Reply-To: <3DA54424.B48015F8@rodos.fzk.de>
Message-ID: <Pine.LNX.4.44.0210101421420.28144-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/132
X-Sequence-Number: 9849


select t0_o.scheduler_action_id from scheduler_action t0_o where
t0_o.is_done = 0 and t0_o.invocation_date <= 1034033214921::numeric;

seems to work in

 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96

The reason that this query worked in hpux without the explicit
casting is maybe hpux runs on a 64-bit architecture processor

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr