[GENERAL] Connection Oracle database from Postgres function

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 -

Re: [GENERAL] help needed for functions

ntid     LOOP     return next r;     END LOOP;     RETURN; END ' LANGUAGE 'plpgsql';   -     Thanks Dinesh Pandey From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nitin Ahire Sent: Friday, September 16, 2005 7:21 PM To: pgsql-

Re: [GENERAL] 64 bits?

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

[GENERAL] Postgres for Fedora Core 2 OS ****************

From where can I download?   “Postgres 8.x” + required packages and “installation instruction” of Postgres for Fedora Core 2 OS. Thanks Dinesh Pandey  

Re: [GENERAL] [SQL] Permission denied for language pltclu

ation of the function.   And if any one is creating this function who is not owner of database, this problem occurs.     Thanks Dinesh Pandey  

Re: [GENERAL] [SQL] Permission denied for language pltclu

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

Re: [GENERAL] [SQL] Permission denied for language pltclu

> 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

Re: [GENERAL] [SQL] Permission denied for language pltclu

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 use

Re: [GENERAL] [SQL] Permission denied for language pltclu

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

[GENERAL] Permission denied for language pltclu

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

Re: [GENERAL] Postgres 8.0.1 configure failed

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, 200

[GENERAL] Postgres 8.0.1 configure failed

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 -

Re: [GENERAL] [SQL] index row size 2728 exceeds btree maximum, 2713

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

Re: [GENERAL] index row size 2728 exceeds btree maximum, 2713

this error "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 Richa

Re: [GENERAL] [SQL] index row size 2728 exceeds btree maximum, 2713

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 it’s failing. How to handle that?   Thanks Dinesh Pandey From: Ramakrishnan Muralidharan [mailto:[EMAIL PROTECTED] Sent: Thursday, June 02, 2005 3:11

[GENERAL] index row size 2728 exceeds btree maximum, 2713

TABLE ---+---+---   Column    | Type   ---+---+---  scan_id    | bigint     host_ip    | character varying(15)  port_num | integer    plugin_id  | integer   

[GENERAL] How can I write trigger on a columns insert/update?

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  

Re: [GENERAL] database export in pgsql

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 in

Re: [GENERAL] database export in pgsql

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

Re: [GENERAL] ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)

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

[GENERAL] can I send execution log into a file.

I am using Postgres. How can I send execution log into a file.   Testdb=>\i MyCreateScript.sql   Thanks  

Re: [GENERAL] Date addition/subtraction

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 Sub

Re: [GENERAL] unable to open editor.

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 PRO

[GENERAL] unable to open editor.

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  

[GENERAL] Postgres source (tar file) for Fedora Core OS?

From where can I download latest Postgres source (tar file) for Fedora Core OS? Regards Dinesh Pandey  

[GENERAL] Table Partition

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)

Re: [GENERAL] ShmemAlloc: out of memory

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

[GENERAL] FW: How to install Postgres that supports 64-bit integer/date-time.

. 5432   .…   ….   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-g

[GENERAL] How to install Postgres that supports 64-bit integer/date-time.

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 us

Re: [GENERAL] List of Functions

\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 co

Re: [GENERAL] Urgent

all 10.10.0.76 255.255.255.0 trust 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 Redh

[GENERAL] 'Select INTO" in Execute (dynamic query )

27;;   varb    VARCHAR(10) :='';       result  VARCHAR(10) :='Result';       BEGIN        EXECUTE(   'Select INTO vara, varb A1, A2 from '|| $1       );       RETURN result||': '|| vara ||

[GENERAL] How to add 1 hour in a date or time stamp?

  How to add 1 hour in a date or time stamp? Regards Dinesh Pandey --  

[GENERAL] "pltcl" function.

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  

[GENERAL] Exception handling: Oracle's "SQLERRM" keyword option?

or code in PostgreSQL after an EXCEPTION or RAISE EXCEPTION occurs in EXCEPTION block??   Pls help me or send me some example.     Thanks Dinesh Pandey