pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSql error
5+ messages / 5 participants
[nested] [flat]
* Sql error
@ 2001-04-02 15:09 comp <virender@magnum.barc.ernet.in>
2001-04-13 03:55 ` Re: Sql error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: comp @ 2001-04-02 15:09 UTC (permalink / raw)
To: pgsql-sql
Respected Sir/Madam,
I visit your site find a lot of information. I download postgres7.0.3 latest version and install it on Redhat6.1 server. I follow all the steps in your Install file.
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=>\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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Sql error
2001-04-02 15:09 Sql error comp <virender@magnum.barc.ernet.in>
@ 2001-04-13 03:55 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2001-04-13 03:55 UTC (permalink / raw)
To: comp <virender@magnum.barc.ernet.in>; +Cc: pgsql-sql
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* SQL Error
@ 2002-10-07 23:53 Rafal Kedziorski <rafcio@polonium.de>
0 siblings, 0 replies; 5+ messages in thread
From: Rafal Kedziorski @ 2002-10-07 23:53 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: SQL Error
@ 2002-10-10 09:11 Christoph Haller <ch@rodos.fzk.de>
2002-10-10 11:23 ` Re: SQL Error Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 5+ messages in thread
From: Christoph Haller @ 2002-10-10 09:11 UTC (permalink / raw)
To: rafcio@polonium.de; +Cc: pgsql-sql
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: SQL Error
2002-10-10 09:11 Re: SQL Error Christoph Haller <ch@rodos.fzk.de>
@ 2002-10-10 11:23 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 5+ messages in thread
From: Achilleus Mantzios @ 2002-10-10 11:23 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-10-10 11:23 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-02 15:09 Sql error comp <virender@magnum.barc.ernet.in>
2001-04-13 03:55 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-10-07 23:53 SQL Error Rafal Kedziorski <rafcio@polonium.de>
2002-10-10 09:11 Re: SQL Error Christoph Haller <ch@rodos.fzk.de>
2002-10-10 11:23 ` Re: SQL Error Achilleus Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox