[SQL] unsubscribe

unsubscribe

[SQL] 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: [SQL] Table Constraint CHECK(SELECT()) alternative?

You can create a function and call it from a trigger on that column insert event Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert D. Kennedy Sent: Sunday, September 04, 2005 12:20 AM To: pgsql-sql@postgresql.org Cc: [EMAIL

Re: [SQL] SQLException - SET AUTOCOMMIT TO OFF is no longer supported

After using correct version of JDBC driver I am able to start JBOSS server.   Thanks Dinesh Pandey   I have created datasource but getting this error on JBOSS startup.   Using: PostgreSQL 8.0 JBOSS: JBOSS-3.2.6   16:09:37,093 WARN  [TransactionImpl] XAException: tx

[SQL] SQLException - SET AUTOCOMMIT TO OFF is no longer supported

org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:654)     at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)       at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:649)   Thanks Dinesh Pandey  

Re: [SQL] How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?

Title: Re: [SQL] How to connect ORACLE database from Postgres function using plpgsql/pltclu? Thanks Sean, It great help from you.   Thanks Dinesh Pandey From: Sean Davis [mailto:[EMAIL PROTECTED] Sent: Monday, August 01, 2005 4:47 PM To: [EMAIL PROTECTED] Cc: PostgreSQL Subject

[SQL] How to connect ORACLE database from Postgres function using plpgsql/pltclu?

Is there any way to connect ORACLE database from Postgres function using plpgsql/pltclu?   Thanks Dinesh Pandey  

[SQL] 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  

[SQL] How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format

How to store and retrieve data with special characters (\n, \r, \f, \t) in the same format, because while storing \f treats data in strange way.   Example: ‘This is sample data \n \root\files.txt, \root\text.txt’   Sol: One way replaces \ with \\   Thanks Dinesh

[SQL] Create connection with Oracle database from Postgres plpgsql function

How can we create connection with Oracle database from Postgres plpgsql function and execute some oracle stored procedure? Thanks Dinesh    

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: [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: [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: [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

[SQL] 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: [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: [SQL] [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: [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

[SQL] 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   

[SQL] Postgres 8.0.1 on Solaris 10 Sparc: library -lgcc_s: not found

ror 2 make[2]: Leaving directory `/export/home/softwares/postgresql-8.0.1/src/backend/utils/mb/conversion_procs' make[1]: *** [all] Error 2 make[1]: Leaving directory `/export/home/softwares/postgresql-8.0.1/src' make: *** [all] Error 2   Regards Dinesh Pandey --  

[SQL] 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

[SQL] 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

[SQL] '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 ||

Re: [SQL] user connection over tcp

all 10.1.11.54 255.255.255.0 trust Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Davis Sent: Monday, April 18, 2005 7:13 PM To: Frank Habermann; pgsql-sql@postgresql.org Subject: Re: [SQL] user connection

[SQL] 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 --  

[SQL] "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  

Re: [SQL] Error handling in pltcl

I have attached below an e-mail program. I want to log messages into a table from a function written in 'plpgsql' whenever any exception occurs (like unable to connect/invalid email etc..) Pls update the code attached below Thanks Dinesh Pandey CREATE

[SQL] Error handling in pltcl

Hi,   Can any one tell me how to handle error in PL/TCL language.   On Error/Exception, In the exception block I want to call a FUNCTION (written in PL/pgSQL).   ThanksDinesh Pandey  

Re: [SQL] send mail from Postgres using PLTCLU language.

After using puts $mySock "rcpt cc: [EMAIL PROTECTED]" I am able to send mail as Cc: also. Thanks Dinesh Pandey   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dinesh PandeySent: Friday, April 15, 2005 6:18 PMTo: 'PostgreSQL'Subject: [SQL] send mail

[SQL] send mail from Postgres using PLTCLU language.

How to send mail from Postgres using PLTCLU language.   I am able to send mail, but I want to know how to add "Cc" option also. (Program attached below)   How to add "Cc"  (Right now containd "From", "To", "Subject" and "Message"). ---

[SQL] EXCEPTION handling in PL/pgSQL.

ostgres as it is available in ORACLE.   RegardsDinesh Pandey------Dinesh Pandey Sr. Software Engineer  

Re: [SQL] Prepared query ?

ter Valley', 't', 200.00); Thanks Dinesh Pandey -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 8:29 PM To: [EMAIL PROTECTED] Cc: 'PostgreSQL' Subject: Re: [SQL] Prepared query ? Dinesh Pandey wrote: > How can I &

Re: [SQL] Prepared query ?

I am using PL/pgSQL.   Thanks Dinesh Pandey From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Bax Sent: Thursday, April 14, 2005 8:24 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Prepared query ?   At 10:28 AM 4/14/05, Dinesh Pandey wrote

Re: [SQL] dynamic 'INSERT' query?

v_sentryid, v_nodeid; END LOOP; How to convert this into Postgres? Thanks Dinesh Pandey ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[SQL] Prepared query ?

How can I Write a prepared query and Set values at run time and Execute that query for different values.   LOOP ….. ….. sql := INSERT INTO MYTABLE VALUES(?, ?); …… --EXECUTE (sql); END LOOP;   Regards Dinesh Pandey

Re: [SQL] dynamic 'INSERT' query?

FOR _record IN SELECT A1, A2 FROM A LOOP --[Dinesh Pandey] -- Sorry I didn't get this part. _sql := "INSERT INTO B VALUES ( '*" || _record.A1 || "'** , '" || _record.A2 || "' ***)"; EXECUTE (_sql); END LOOP; Dinesh Pandey wrote: &

[SQL] dynamic 'INSERT' query?

END LOOP;   = I can do this as (but I need another way instead of using || operator).   _sql := 'INSERT INTO B VALUES (‘ || _record.A1 || ’,’ || _record.A2 || ’)’; =====   Regard

Re: [SQL] max question

Try "select oid,* from ccontinue where citkey ='04-0594703' group by oid,citkey,contby,contdate,abcontinue,ccdate having contdate= max(contdate)" Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. R. Van Hook Sen

Re: [SQL] ignore single character in SELECT query?

Use select replace(quote_literal('don\'t'), '\'', ''); Or select replace(quote_ident(myColumnName, '\'', ''); Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behal

[SQL] How to Port Oracle's user defined "Package" into Postgres 8.0.1.

Title: How to Port Oracle's user defined "Package" into Postgres 8.0.1. Hi folks, Can any one give me an idea about: How to Port Oracle's user defined "Package" into Postgres 8.0.1. If possible pls attache sample code. Thanks Dinesh Pandey

Re: [SQL] Table PARTITION

Yes, I will do in this way Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Enrico Weigelt Sent: Friday, April 08, 2005 7:18 AM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Table PARTITION * Richard Huxton wrote: > S

Re: [SQL] Table PARTITION

Hi Richard, I am using postgres 8.0.1. It allows us to create TABLESPACE but I don't know how to create PARTITION in postgres. Can you pls tell me little more. Thanks Dinesh Pandey -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005

[SQL] Table PARTITION

_date) (PARTITION invoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001', 'DD/MM/')) TABLESPACE users Regards Dinesh Pandey ---------- Dinesh Pandey  Sr. Software Engineer Second Foundation (India) Pvt. Ltd.

Re: [SQL] ar: Command not found.

Title: ar: Command not found. In Solaris "ar" command is in "/usr/ccs/bin" directory.   Thanks Dinesh Pandey   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dinesh PandeySent: Thursday, April 07, 2005 10:21 AMTo: 'PostgreSQL'Subject: [SQL]

[SQL] ar: Command not found.

Error 2 make[1]: Leaving directory `/export/home/psingh/postgre/postgresql-8.0.1/src' make: *** [install] Error 2 Which package need to be installed? Regards Dinesh Pandey ---------- Dinesh Pandey  Sr. Softw

FW: [SQL] createlang 'pltclu' with postgreSQL.

ot;: No such file or directory createlang: language installation failed: ERROR: could not access file "$libdir/pltcl": No such file or directory Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dinesh Pandey Sent: Wednes

Re: [SQL] createlang 'pltclu' with postgreSQL.

1. I installed with compiled package using "pkgadd -d postgresql-8.0.1-sol9-sparc-local" 2. I haven't used --with-tcl? Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Wednesday, April 06, 2005 9:1

Re: [SQL] createlang 'pltclu' with postgreSQL.

PandeyCc: 'PostgreSQL'Subject: Re: [SQL] createlang 'pltclu' with postgreSQL.On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote:>> I have already installed Postgres 8.0.1.How did you install PostgreSQL?  Did you build it from source?> $ createlang pltclu te

[SQL] createlang 'pltclu' with postgreSQL.

;tk-8.4.9-sol9-sparc-local.gz" and "tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command. Any othe configuration required Regards Dinesh Pandey

[SQL] CURSOR EXAMPLE - ORACLE TO POSTGRES CONVERSION

end loop; close cur1; return alert_mesg; END; $$ LANGUAGE plpgsql ------ Dinesh Pandey  Sr. Software Engineer

Re: [SQL] Migrated Oracle database to PostgreSQL ??

Yes, but after creating some function, we can get sql error messages. But I not comfortable that much in that. For Procedures and Packages we can use Functions Any other option in pl/PGSQL Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[SQL] Migrated Oracle database to PostgreSQL ??

 Hi there, Has anyone migrated Oracle database to PostgreSQL? If yes, could you please help me -    1. How to migrate Procedures and Packages from Oracle to PostgreSQL     2. How to find error messages in PostgreSQL thrown from an Exception (as we can get messages in Oracle with "SQLE

Re: [SQL] Speed up slow select - was gone blind

Try with creating INDEX on the used tables...It will make your search query faster. Thanks Dinesh Pandey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Stainburn Sent: Friday, April 01, 2005 6:03 PM To: pgsql-sql@postgresql.org Subject: [SQL

Re: [SQL] gone blind - can't see syntax error

Try this FROM requests r left outer join users sm on sm.u_id = r.r_salesman left outer join users u on r.r_u_id = u.u_id left outer join request_types t on r.r_t_id = t.t_id left outer join request_states s on r.r_s_id = s.s_id left outer join dealerships d on r.r_d_id = d.d_id left outer join de

[SQL] Help - Oracle 9i to PostgreSQL SQL conversion

L after an EXCEPTION or RAISE EXCEPTION occurs in EXCEPTION block??   Pls help me or send me some example.   Fuction attached below   Thanks Dinesh Pandey        CREATE OR REPLACE FUNCTION DOES_NODE_HAVE_RULE (IN_SENTRYID_ID IN NUMBER ,IN_NODE_ID IN NUMBER ,IN_DEVICEID IN NUMBER ,IN