[SQL] use of savepoint in containter managed transaction

HI All, I have requirement to use save point. But I am using session bean whose transaction is managed by container. While executing sql insert I got unique key constraint because of this my other command following this exception got ignored. I want to continue my transaction even after this

Re: [SQL] handling duplicate row exception

: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Filip Rembialkowski Sent: 21 September 2011 20:37 To: Amar Dhole Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] handling duplicate row exception Hi There is no IGNORE_DUP_KEY equivalent in PostgreSQL. If you

[SQL] handling duplicate row exception

Hi All, I have a requirement where my application tries to enter the duplicate row in table using batchexceute code. And batch exception is thrown we checked error code and skip it but after this exception all my next update/insert gets error out with following exception Database error. SQL

[SQL] why SELECT query needs relationname (schemaName.tableName)

Hi All, I have a query regarding database. I have database 'customer' which is having schema 'cust.' I have added my tables and data into 'cust'. But when I try to run the sql queries against this schema I need to add 'cust' as a relationName for every query. But same is not

[SQL] Help needed in skipping column for copy command

I have table created as follows CREATE TABLE D_2147483927_2147484848_TAB( CP VARCHAR(256) , CPR VARCHAR(256) , CHOUSENO VARCHAR(256) , CSTREET VARCHAR(256) , CLOCALITY VARCHAR(256) , CCITY VARCHAR(256) , CPROVINCE VARCHAR(256) , CCOUNTRY VARCHAR(256) , CZIP VARCHAR(256) , CCO

Re: [SQL] help needs in converting db2 function in postgresql.

Thanks this solves my problem.. From: filip.rembialkow...@gmail.com [mailto:filip.rembialkow...@gmail.com] On Behalf Of Filip Rembialkowski Sent: Wednesday, January 12, 2011 1:41 AM To: Amar Dhole Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] help needs

[SQL] help needs in converting db2 function in postgresql.

Hi, I need helping converting following db2 function in postgresql function. Any pointer will be great help in proceeding me ahead. CREATE FUNCTION in_liststring ( string CLOB(64K) ) RETURNS TABLE ( ordinal INTEGER, index INTEGER ) LANGUAGE SQL DETERMINISTIC NO EXTERNAL ACTION

[SQL] converting type and function in postgresql ?

Hi, I am new to postgesql. I have oracle type and function, which I needs to converting it into postgresql . I am using postgresql 9.x Type : CREATE OR REPLACE TYPE INST AS TABLE OF VARCHAR2(255) How this type can be written in postgresql ?? Oracle Function: