I want to access Oracle database from
Postgres. One way to use DBI-LINK and use plperl function in Postgres
to make connection with Oracle. Using that I am getting the following error.
Environment
Solaris 9 SPARC
PostgreSQL 8.0
DBI-LINK
Perl-5.8.5
r holder%rowtype;
BEGIN
FOR r in select departmentid, sum(salary) as totalsalary
from GetEmployees() group by departmentid
LOOP
return next r;
END LOOP;
RETURN;
END
'
LANGUAGE 'plpgsql';
-
Thanks
Dinesh Pandey
You can use Postgres 8.x, it supports 64 bit (if your OS supports 64 bit).
But you have to install it
--
./configure --enable-integer-datetimes
make
make install
--
Thanks
Dinesh Pandey
From where can I download?
Postgres 8.x + required packages and installation
instruction of Postgres for Fedora Core 2 OS.
Thanks
Dinesh Pandey
for language pltclu
-
What is the cause?
Regards
Dinesh Pandey
--
Dinesh Pandey
Sr. Software Engineer
Second Foundation (India)
Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O
I
have installed the Postgres from postgres user with pltcl option and able to
create these function with another dbUSER successfully and never get this error.
But
our client is getting this error, How to solve it now? Any Idea?
Thanks
Dinesh
Pandey
-Original
Message
Sorry I didn't get it exactly. Because the same function (send e-mail) I am
able to create at my end, but our client is not able to create it at their
end.
1. Is there some problem in installation?
Or
2. Problem with system user permission executing that database?
OR
3. Problem With Database
OR
3. Problem With Database user permission?
Only
a superuser can create a pltclu function. dbUSER must be a
PostgreSQL
superuser if it created the pltclu function. You client
must
use a PostgreSQL superuser to create a pltclu function.
What do mean with super user. The user
database.
Solution: The database must be created by
the user who is creating the pltcl function? Right
Thanks
Dinesh
Pandey
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: Friday, June 10, 2005 2:41 PM
To: [EMAIL PROTECTED]
Cc
.
And if any one is creating this function
who is not owner of database, this problem occurs.
Thanks
Dinesh
Pandey
Sorry I forgot to set LD_LIBRARY_PATH , after setting able to install.
LD_LIBRARY_PATH=/usr/local/lib
export LD_LIBRARY_PATH
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway
Sent: Wednesday, June 08, 2005 11:42 AM
I am installing postgres 8.0.1 (solaris 9 SPARC), but
while configure it is failing. (I have already installed gcc/tcl/tk and tested
a simple c program)
./configure --enable-integer-datetimes
--prefix=/usr/local/pgsql --with-tclconfig=/usr/local/lib --with-tcl
TABLE
---+---+---
Column | Type
---+---+---
scan_id | bigint
host_ip | character varying(15)
port_num | integer
plugin_id | integer
severity | character varying(50)
data | text
Indexes:
Hi,
One of the columns in primary key is of
type TEXT. I am able to insert with small data, but for around
3000 characters its failing. How to handle that?
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 3:11
PM
index row size 2728 exceeds btree
maximum, 2713 by increasing the btree size?
The big problem is I can not add any additional column in this table.
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: Thursday, June 02
Yes I am storing
some error messages in data column, and the PK columns are party
of search criteria.
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 4:44
PM
To: [EMAIL PROTECTED];
pgsql-general@postgresql.org
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
FOR EACH ROW
EXECUTE PROCEDURE myfunction();
I am getting error syntax error at or near
OF
Thanks
SELECT * FROM MY_TABLE
ORDER BY LOWER(NAME);
Thanks
Dinesh
Pandey
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Julian Legeny
Sent: Tuesday, May 10, 2005 3:12 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ORDER BY options (how
What
is the command you have used while dumping the
objects?
Thanks
Dinesh
Pandey
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vikas
Sent: Wednesday, May 11, 2005 10:00 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] database
http://www.postgresql.org/docs/8.0/static/app-pgdump.html
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vikas
Sent: Wednesday, May 11, 2005 10:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] database export
I am using Postgres. How can I send execution log into a
file.
Testdb=\i MyCreateScript.sql
Thanks
Select current_timestamp - '30 day'::interval
Select current_timestamp - '1 hour'::interval
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Craig Bryden
Sent: Tuesday, May 03, 2005 11:02 PM
To: pgsql
Subject: [GENERAL] Date
In Solaris 10 with Postgres 8.0, I am getting this error
and unable to open editor.
testdb=# \e test.sql
ttdt_open failed: TT_ERR_PROCID The
process id passed is not valid.
Thanks
In Solaris 10 with Postgres 8.0, I am getting only for EDITOR.
bash-2.05b$ echo $EDITOR
/usr/dt/bin/dtpad
bash-2.05b$ echo $VISUAL
bash-2.05b$
bash-2.05b$ echo $PSQL_EDITOR
bash-2.05b$
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
From where can I download latest Postgres source (tar
file) for Fedora Core OS?
Regards
Dinesh Pandey
. . bash-2.03# make install
Kindly let me know if you need any further clarification
or any problem occurs.
Thanks
Dinesh Pandey
From: Dinesh Pandey
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 22, 2005 11:00
AM
To: 'PostgreSQL';
'pgsql-general@postgresql.org'
Subject: How
http://www.postgresql.org/docs/8.0/interactive/kernel-resources.html#SYSVIPC
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of JM
Sent: Friday, April 22, 2005 2:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] ShmemAlloc
How to create this table (with
partition) in Postgres.
--ORACLE
CREATE TABLE A (col1 NUMBER NOT NULL,
col2 DATE NOT
NULL,
col3 VARCHAR2(500)
)
PARTITION BY RANGE (col2) (
PARTITION partition_one VALUES LESS
THAN (TO_DATE('01/04/2001', 'DD/MM/')) TABLESPACE
\df
\df functionname
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rob Stone
Sent: Thursday, April 21, 2005 9:48 AM
To: 'pgsql-general@postgresql.org'
Subject: [GENERAL] List of Functions
I have no idea if this is the correct list
How to install Postgres 8.0.1
that supports 64-bit integer/date-time.
#
./configure --prefix=/usr/local/pgsql --with-tclconfig=/usr/local/lib
--with-tcl
checking build
system type... sparc-sun-solaris2.8
checking host system
type... sparc-sun-solaris2.8
checking which
template to
What is error in this statement of pltcl function.
set var 'SENDING EMAIL TO: '||$mailto||' from: '||$mailfrom||'
with: '||$emailserver
I am getting this error:
ERROR: wrong # args: should be
set varName ?newValue?
Regards
Dinesh Pandey
How to add 1 hour in a date or time stamp?
Regards
Dinesh Pandey
--
) :='';
result
VARCHAR(10) :='Result';
BEGIN
EXECUTE(
'Select INTO vara, varb A1, A2 from '|| $1
);
RETURN result||': '|| vara ||' '|| varb;
END;
$$ LANGUAGE plpgsql;
Regards
Dinesh Pandey
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of ElayaRaja S
Sent: Tuesday, April 19, 2005 12:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Urgent
Hi,
I am using Redhat linux 9. i had configure in pg_hba.conf as
hostpostgres
after an EXCEPTION
or RAISE EXCEPTION occurs in EXCEPTION block??
Pls help me or send me some example.
Thanks
Dinesh Pandey
35 matches
Mail list logo