If I'm understanding things, pg_dump will not dump casts b/c they are system
objects and belong to neither schema nor database. OK- kind of frustrating-
but OK. Is there, then, any way to easily dump all casts on a server so that
they can easily be copied and recreated in a restoration process?
Th
Hi list,
I've been doing a ton of searching on this issue, but haven't found
any information as to why I'm getting this error, and I'm convinced this
is an issue with Windows Server 2003 (or the antivirus), but thought I'd
try my luck here to see if anyone has seen this problem and knows a
Stephen Sugden wrote:
> We're trying to diagnose a system issue where we ended up with
> 100's of non-idle queries in pg_stat_activity, but the actual
> system load didn't correspond to what we should have seen with
> that query load. Is it possible that a client could cause this by
> not acknow
I've been having a difficult time finding an answer for this via google, so
please excuse me if this is the wrong list, or a stupid question...
We're trying to diagnose a system issue where we ended up with 100's of
non-idle queries in pg_stat_activity, but the actual system load didn't
correspond
hello ...
read this:
ERROR: type "number" does not exist
we don't have this type.
use numeric or whatever matches.
many thanks,
hans
On May 11, 2011, at 2:46 PM, Hsien-Wen Chu wrote:
> ERROR: type "number" does not exist
--
Cybertec Schönig & Schönig GmbH
Gröhrmü
Hi Hans
Many many thanks, I have executed the SQL, how ever, it does not work,
I don't know what's wrong
tora=# select * FROM odbclink.query(1, 'SELECT * FROM test') as
result(user_name text,score number);
ERROR: type "number" does not exist
LINE 1: ...SELECT * FROM test') as result(user_name
hello ...
in SQL this "*" has to be known at parsing time ... so, it needs the number /
type of columns before doing anything else.
as you select "some" data from oracle (the postgres parser does not look into
the oracle sql) you have to tell the system which data to expect.
it is somehow like t
hello ...
oh, it seems you did not get that one:
select * FROM odbclink.query(1, 'SELECT * FROM test') as result(user_name
text,score number);
give it a try ;).
hans
On May 11, 2011, at 12:24 PM, Hsien-Wen Chu wrote:
> Hi Hans
>
> many thanks for the answer,
>
> my table structur
Hi Hans
many thanks for the answer,
my table structure on Oracle, but I still get error as following,
Please could show me the correct SQL statement?
many many thanks
Hsien-Wen
SQL> desc test;
Name Null?Type
--
Dear All
I have a question regarding to odbc link,
I had a PostgreSQL database and an Oracle database, now I have created
a dblink to Oracle database base on odbc link.
in Oracle database, I created a user named ORATEST, and create a table
named TEST as ORATEST user.
SQL> select user_name,sco
10 matches
Mail list logo
