From sivannarayanreddy@subexworld.com Wed Feb 16 08:52:42 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id F3FB41337B99 for ; Wed, 16 Feb 2011 04:52:42 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 47427-01 for ; Wed, 16 Feb 2011 08:52:35 +0000 (UTC) X-Greylist: delayed 00:10:58.369416 by SQLgrey-1.7.6 Received: from cx296.800onemail.com (CX296.800onemail.com [209.171.54.154]) by mail.postgresql.org (Postfix) with ESMTP id B4B901337B79 for ; Wed, 16 Feb 2011 04:52:34 -0400 (AST) Received: from EX13-N05.exchserver.com ([10.7.5.66]) by cx296.800onemail.com (8.13.8/8.13.8) with ESMTP id p1G8fJlI025007 for ; Wed, 16 Feb 2011 03:41:19 -0500 Received: from EX60.exchserver.com (10.7.5.154) by EX13-N05.exchserver.com (10.7.40.162) with Microsoft SMTP Server id 8.3.106.1; Wed, 16 Feb 2011 03:41:19 -0500 Received: from [127.0.0.1] ([164.164.82.29]) by EX60.exchserver.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 16 Feb 2011 03:41:17 -0500 Message-ID: <4D5B8E0E.5040101@subexworld.com> Date: Wed, 16 Feb 2011 14:12:54 +0530 From: Sivannarayanreddy Reply-To: sivannarayanreddy@subexworld.com Organization: Subex Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: Subject: PL/SQL block error Content-Type: multipart/alternative; boundary="------------050006030008050609080607" X-OriginalArrivalTime: 16 Feb 2011 08:41:18.0143 (UTC) FILETIME=[476F1CF0:01CBCDB5] X-Crx-NoRoute: SMTP reroute not required X-CRXEFW-Info: Please contact Ceryx for more information X-CRXEFW-Virus: Clean X-CRXEFW-From: sivannarayanreddy@subexworld.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201102/71 X-Sequence-Number: 35147 --------------050006030008050609080607 Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit Hello, I am very new to the postgres sql, i am trying to execute below pl/sql block in postgres but i am getting error *'ERROR: syntax error at or near "integer" '*, Could some one help me in this regard declare v_count integer; begin select count(1) into v_count from pg_index inx where inx.indexrelid in (select oid from pg_class where relname='action_pk' and relowner in (select oid from pg_authid where rolname='postgres_ref')) and inx.indrelid in (select oid from pg_class where relname='action' and relowner in (select oid from pg_authid where rolname='postgres_ref')); if v_count = 0 then execute immediate 'create unique index action_pk on action(acn_id)'; end if; end *Sivannarayanareddy Nusum****| **System Analyst(Moneta GDO)* Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, Bangalore -- 560037, India. *Phone:*+91 80 6696 3371; *Mobile:*+91 9902065831*Fax:*+91 80 6696 3333; *Email:*sivannarayanreddy@subexworld.com ; *URL:*www.subexworld.com /Disclaimer: This e-mail is bound by the terms and conditions described at //http://www.subexworld.com/mail-disclaimer.html/ --------------050006030008050609080607 Content-Type: multipart/related; boundary="------------030701000807040607030406" --------------030701000807040607030406 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Hello,
I am very new to the postgres sql, i am trying to execute below pl/sql block in postgres but i am getting error 'ERROR: syntax error at or near "integer" ', Could some one help me in this regard

declare
v_count integer;
begin
select count(1) into v_count from pg_index inx where inx.indexrelid in
(select oid from pg_class where relname='action_pk' and relowner in
(select oid from pg_authid where rolname='postgres_ref'))
and inx.indrelid in
(select oid from pg_class where relname='action' and relowner in
(select oid from pg_authid where rolname='postgres_ref'));

if v_count = 0 then
execute immediate 'create unique index action_pk
on action(acn_id)';
end if;
end

Sivannarayanareddy Nusum | System Analyst(Moneta GDO)

Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, Bangalore – 560037, India.
Phone: +91 80 6696 3371; Mobile: +91 9902065831 Fax: +91 80 6696 3333;

Email: sivannarayanreddy@subexworld.com; URL: www.subexworld.com

Disclaimer: This e-mail is bound by the terms and conditions described at http://www.subexworld.com/mail-disclaimer.html

--------------030701000807040607030406 Content-Type: image/gif; name="graphics1" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="graphics1" R0lGODlhvgBHAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5 LjAXAAAAC21zT1BNU09GRklDRTkuMEI8pPUALAAAAAC+AEcAh4ODg4uLi6KiotqpvP/BCf/T U50aUPfs8P/IJe7Z4cuGosyJpfnw9P7yy/De5q9GcZwZTzY2Np4dU/71254eU3x8fLFKdf7c d7Kystmmu2tra8nJyXV1df/ABfz8/Pz5+v/nnL5pjJUJQ6s9ar1miu3t7f/CDFtbW//RTPv1 +P/hiP/78ZqamsZ7mv7uuuHh4f/pqP78/dGVrsTExPny9f/DEqmpqdHR0f/77SwsLPHx8fXp 7uG6yvLh6KEmWKAgVb29vf/01UxMTNra2urO2VRUVKYyYv/MNM+QquXl5dyuwblehLm5ufXn 7f/NO7ZVfc2NqOnK196yxOK+zK1BbqUvX5oVTJsWTf/FG56ent3d3f++AJ4fWrtghv+/ApkS SuTAz7RReZGRkbhagdfX1/r6+vr09/T09P37/Ojo6JsYTvz6+6g2ZRkZGfj4+Pb29uTB0N+0 xezU3v/9+dCQq6QtXpaWlv/5566urp4eUsmBn8HBwf/abKIoWs3NzUJCQiEhIdSbspkUS9Wd tJwcUsR1lmRkZOXE0fPk6ufJ1f/rsMFxkqAkV5gQSJ8iVqMqXNCTtJ0cUMBukKQsXrlcgv7X Yba2ttahtuvS3NejuKo4Z6YrS5wXTwgICPHg56AgVv/+++vQ2/7AA+3W4MN1lfTl654iVZwc WrNRebBIcqQqXfry9tOYsOC3yJoSS+zT3ch+nP+9AMV4l/7YZtCSrJ8iVP/fgrNOd92ww5kV TJ0dUr9sjv7337hZgObG1JcOR5gSSdSbs/+/A/ry9fjv85gRSZ8eVOS/z50bUZsaULVTe5kT S50fVKQrXZ8hVf7////+/////p8gVaYuX/7+/58fVP7+/p4hVf/+/p8hVP7//p4gVPz4+Z4g Vf79/frz9p8iVcJzk6YtX+/b47xROuWVHeSXIZ0gVf/1stF4OfPk79+2x5kXWLdXf//vwP/M Abldib9ukf/71f76++ymL54hVOKZQ//HAJkVTf2+AP/LEf/HCNuswNurv6AhVv///wj/AP8J HEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmyJEhtJlNO/CADChI6MOlA yRRDpc1/KG/qVMhA2q9iQIGKGMFtp8cY1IwqZUhjmgRn/qL6M5Dqw1KJ2KbIUCBLEoklS5T1 WtJlESwoYKxeXUqjylOpUx+ovWotWrR/dxN6oiCir9+/In4JjvRggYO1Rtu+lWpA7tW8Dg88 obKkkB4kmDErWHRrkg9CgtnE8Yb4pmKojB0jnuMwRtGEaA4k4KGHTTFkFsCUVnkabuO5SkFd OHKBF0FoAyFHbBJuWaMRxAQi3y2yd2rgRoMQELYFwYUg/54J/7SrPOKaXcuWFZIObTp1j9aj /l7boMYWAgS21LjgAsezZ9hcNI8sySCjxEDuvcdRfHFhtxM27lSChTD4eUEAAjD8lxEJjRhx QHgkIVeeaW6hJp9qB4n3TIIWtQciQrzwYV8HBNBYQAMF2SVRP1fgk4GCITE4H3UT2OLEdiYI YwIf4I03IkOJOLIMCQGG9IEDYPCTQSsOOJiSkCgO1MMhUmQgBRHfbIRGKVGsk8EAPLxyAGkF geICCjSaIEoNs9xRkSePQGBEmh8NwwoVfVRjgBoU9PGAHuMcN9AaSrw5wKUDZKDEGgvJkQmm l25Zk0BgztXEJb304QwyakTiCBskZP+QgkVEQGFBH45IoAajPjSjDCujCCSeQNjYUoMXJhAQ ixMTjDesQ000Y8AjTXyUwQhXQEBBNT/8UA0FBiwzzQLV/lPlPzT4YAUE7LIriA80LASFCO2y CwwVr6Fbom8PoPHPGrTUYQUneVQjTbfVSGCFIBbw4G9EDpCwzTIQGFMNt94ao6sgjFCCiUEN FJCknhgK+yRCDvSBTDOldMSAJJxA4MzMcEkTlQRXGLFAQTSII0G3QBMyTbwKIVHMwUBDgKKQ FqQQTCoQRGIzXDW3moovDA17zBiPXEEB1VQ7Iw0FV/RBSRwEiecOCqLg1wEKzUIUBSMrt7wR N100Ik02M5v/GNUPUK1qhQIENSUB1bpMw8BCRvs9pL6LRYVbC8uo4QzfYEsljTPb5DKJbgxF 8cgXeUhFc9j+0MyMIBBIIZA22iAHDQhYdGBCd4pAJAUykbDMkQLL/JD58NVYAcVrhlMtwdCM f+H40vtq/ogz1QxvvQE/rINXQS7+A4e0mV/Ttz/ig42MD7ggCKI7WNxHowoLdU+LIHnUEZ1G ozByuPVgO3JFHZ4glVOUx7yiOY9fc2GQI6QxNf6BDRzIYATWnvUP5HhjAXQbntiMsS3MgY0Q eYDFw/LyDF6oAAv4EUUl/HQygTCACsiAQBg8sJEMWCFzOLMC9qiGDFUcYiDJg8vy/4iWECQc 8DpAjF5UnHGNT9RMV5xQgwSqB7aZWeEW+ZLOPxKhBmT47W/hggAjEpULTlDRdM7QxRV+iBxr COsfisDP7ZzQJINoKBOCcMYyYLG9jOgBGGG7wjR2IYkHqMGMqTMAOH4IxAEKsYBFPOKJEqhE 1KAGGcswABso0YUxaEICgtDFEk/nDEHI4CC7sAIpxdZFKuihH0QYxxRYsQRGWOFrcPEfCQZy LoHAoH0m8AIC/ISQNaRCDdK4wo9aCBFsLEENNdNFCA7zD25kQhkSoAAywMEKnjlSKkNs3vMo GTmqqWEEsojD/dA1BVlUwXKpc2JUdNGHYBEkA5E448woQP8IC/AjiwOJQhcYYYDT+eMHBrhE QhqAAgIEswBxMwgrkCkBAKrpFgaAS6Psxksl5KEPcDBIEMEJSYQYcZxJLKdUrmABRCTEAe1Q pd+cYYUx0OkfKUOGVD6RDWboIhCjShtBEsGGgpooEj6IFEKiUQn9iAIL7jCIAz7jD0GEoyNL 4ITppBGJfhwECTwYyLNGerOSflWSDUrpFx1hhQdwVDrPgAwDnnAFgzqDAoyw5z8WsAy/SWMZ ejgINSj4DyL4oHRwWcbODBKNweIABfkwQQewYByCBMMKDFRDWFlkEVgIIpcSeAQSXNoQsvoj nAZEKamUKDxkjCABDSkFGwgxU0H/0EIgZqBCQeFCiCoE0CGLuALVDEAFIh5kDhcwQZJQUNl/ YIINXoQAFjdyFyXscIn+0EUupqGH3yrEtKiNpGohZyKxGeBA0EjKQoAHtlzsQiChcAQz4NIN NQwCIgnwgTFM1w1OHGghF9hCMBEAHk+wQWbMQEZYN4KccejPdKZwxA90IYg6ZOCmBwGvWQ1y UgSqFS7MYARsqaFehYTCH/vFrhra4UYeSIAZJpKGI9rRhRrb+MY4rnEzzpg6VywWIQGaQwEE 7IUjTAAegnDEqvDFEfFYQxJ6m2nqIiFDtCFEw8Y963gZFAlNzIqwCImBBTKKXapYZQAQ2Bxc nGEATrj5/81wjnMUZUw1K6yHIY8VhQneYY9TzBccXwgBSL7RAghsY3jduIIB2mHlCjZyfyTN MofR+jgGWUESDxGPAr6gvBHMSgbLcKCorceJXWZtBSi4hzk2sT8J9CEUIpFFMeYLtmv4I5lq WMTi3INlcXp4teUsBhQekpRMCFeIVYiX0UbNbHNSgrMGwcYz5EGPTZzictIQxGKhfRHkEOMJ u6pi4KrRCEEXzmcElHRBOoxEYPutGLd1CHL6cd2yKpvTzc43BJQR1IS4UR0jMEA29gaBEXzI XCHhBg8oAYxIOEPJX0ToLswwEG6MwIsanUS5iliM5+WLQcD4sUMGcUNkK7sYYP/bhgR0IYGW u/zlMI95y60Qhn4nhAEWOLY/KOADIoxEQ/9IgQLqIAgKeBAu5P7xBx5ggAbu3HcKgQLK4aKG J9zU0vGIiB7wDU5NUJwWrqCaNPowjSpM4+xoT7va1372PizB5pL6BwPG8FmpsIMcIBgPSJ5B Dfd4Qg/++AIh+keISfRAIDG4BQRsLRUKPMK7CGmBIMoXlSt0oXCVbMzDHEIJaMIFGUy+LNWu EAIz0OD0qE+96lefejMkBcwDmfsyGH9aQpRDHzjSBjMtAuZj7KKoflOybQdCgivIMyrG8IEc FiKJKzjdCovAfDk/CvmFJKAPuFzivmtiXeFJxbWLIwn/N0jgPEekzhhcSMc+OuAEFtqkCajQ +RKtYOp/UI72/mCGNECHEDSM2W9fMGwftkTboAYDkBwLAQuAtGaXJhBRAmOaY0oQAXQMkV7i UQq9oHNiwwmQgA7KFQt88CIqkQBVoFNSkQ0r5kb/AGqpozmccIB2JB7j4AMUYCI/oAaZIH1+ JV1FwW0Vp1tgUwyE8w+IgH3llQyaEH4dMR2IkArL0EDOoAZUYBWzYCEIsAIhMQCnhBCDwAne 5w/ZsH0CEQdNt2ZXUH9C9Q+wgFmAExXVwAxYM4Cmgw8tgGEIsQBq8IVR4VMh9Q8eoAzyd2tq 4FUO0SUQ8QG9AAxqdjNXoFD//+AODiUMtsARkCEDPgABlOBzFdQ961Bv/iCG/7ADRiBKWxUJ sjAX7oEEF8NDI6CE5AU20gABvfBWIogJXTBFYUN/N3UIFEBrSyQBk3A8OdJH//AKJNAHFtAC SiWCBsEDFmCCqZMr4PAjAgEKfGAhJpA7jnYR0SAeMhBK5+AKRiAFGLYDFgABpnMNajAGJSYJ eYRGq/MEr0AQKUAHVwBpUrEMLUCMDKI5X5AKU8ApBBEDUvAIguB0N+MIH0MQ6LFmabQMYbCM BfENUPAIy0AByVAMRqAAvzVYBjEIOFMzzKAGwYCAOIAAHSAKV/gMOYERieBTM+MIMRQGlzAK 43AMt/8gf5cjCO81EFNgAPrkD0r2P+FABzLQAjC0DV/0CVbgVZDRj0t0DRCgC6mwAHFwCOsA BWGQB7QFNp/wBXxUEA5Qgmi0QDnTAlLQA6d3AIcgAxaQC7rQN+AQCa4wDYEwKwaBC63iNz9Q DLJgRyBgO16gAhRoEa2gCdAYFdJwSD7QB9JAZmhkBTk4EN5QCHX1RadlBV+wDIKAcWs2FZqw A9v4iqYDDjUDAVZwOBJAMTzWgs5whnhZEHqplF8ESoSgCmYnDv6wLkJpOv4ADoLwAOUyHQkQ Ag+GRsswBq44EKBQCRSCBRFlEaWgCkmWOZ9gDBZTRVJIKI62A1UQCdmQb1L/UQ0vOJqkGRUD h5nSsIoaFAnMECwUZEEkAAyHljnSoDEt15pL9AO60oeOlgBG8AXZ9wnXUAuC0A7LSRAu4FBe AAKwZx4KgA/Zx2w402j/oF6k8AsQmG/S0AjRZ54MYgrGkAzi+YkQUJLM6JFz1wgTKp7hQjjP QgRUUFdUYwptJZoJcQco5AUF8KASsQCcgI8tmDm5IgFIgBClQAIGIKQOVDwhkKDnuXOakJMp NmpqwAbUaEexpweOgI7i+QOcYARbKB7fQAt9YDnjAxVXwAawthAqoCQm4AIbMQiM4HypY1Dx BBUGYDwLkQHVoAb1wETjM0p9kwxXUAgCKVJVEJfj/wMBFvANCqALBgBxtbY5eXAv1KQQ08ED bFB0fIOnaDQzhPAFDyCR46AMxUAIpkmogpAKh8cQoOAEHcB+rOGjDaFeofAExSAIS3ox3vIt yHAFgsAGMLgQA2AEgqBousAM+reezCABBnAFjaAJhFhihcMIxXAFVrCtVvALI1ATU8AGjXAF yFAwF8NBrPIFPqAAH1KYBkFiArEDCuAD2YoMEmAx3HIxeUBlVlAMbCADq0AQ/TANV0B5oxSc tHgQOgICyEIAcqp7GcENrEACFlAHjKAoxiANzTAC7YAEONoQO8AKXUAFRsAI0iAByCANjDAN qdAFCkBa5jkQKUAKIbALNv9rsySgAA8zDgowsn1wWhIwdiPwBIWgie4qWARBBApAAlRQBT8r ARBQDWPEBqgQAlAAs0RICl0EDngqDVZABQvpECtwBB0gDAUACsSYEWtwAKFwDErAA3BQCrEp EdxAA3IAB1KgBGBABDvgJRfBDZ5wCK2wDnAwDilghxXBDQyQAFg5AFOQCJ7wDTYXA6xQB4gE F+KTbSRwcBABA7ZTA+Cxe0AyuhUxHdyAHokZlczACaSQqBBxkrOaO6J7EbbaENMxHbXLe2+0 iR8BDbAXBcqgBtWAmf6ADMXQBdYKEdGAAtwBP7NLutDLEHkxCl3gD1pFpAZQB4MApQ9hCxZy BFj/GL034QFlUBIosQYy0Ay3lDkzowZ1oIkW0QDK1QGKkLviaxBAAAQVIQAc0BBnkAUAIAYv MBBDEAAVgAc0JBAbAAAawAIJjBfe0ALFEAnkg5nMkAvNYGU+2BBzQLZbwAf2WxLlSxAeQCcq SBAnrAMFUb43cAMD4QGu6wFvYBB+IAY0FAAn4IcrXBBDAAhMgAF/4MIscAKWMAMAIAQqzL9A cAN+8MBbpAtfM6jgxAwL8Krc+A8qQCPDtBRuwAFDfAID/A82UARFsAf/sAEBcMYAcMZi8A/e UAF/wAFu8A9DvMZAsAFnHAAaUARaIBCWIAQnoAF4PBAa0AYnUAJ28Adw/6y//6AFJyAETEAQ QxABAhEBTLAGOeAHA/EHM+ANOUAGCDEAnFCfo5Q6wSqAGzEBNVAj2mgUbmDIabDH/wAEOXAD GAAIaaAFOSDGOeAGAtDGNmAHb6ABGPAPRQDG/2AHNvAPWfAHL2AHGvAPblDGaZADyzwQNnAC SeABdtAGN8ACOVAGbiAEGEAGOZAEA6HLAgAAhlAGL5ADMywQB/zOZ4AQGaAGpHxr/tANgtAM 1BjCHOzBF7AUZ5ADePwCgOABGlABAiEELPAPf7AHY4wHAjAExgwAGFABy2wIliAQLIAHzPzQ GyAE//ACafwPhnDNAsEE0fwPOPwPOtAGZzADOf+AAUBsxgKhBYBQAUWQBSWdA/UsEByAAfSM EGBACA3kCDKpBiSwfJQoEBcQC7FQAASdAzPwDzeQA9agAS39B8ssBkUQACNdAeV7AjZQAmdA GoYQyXQM0gJgB2dM0mnQv/9g1gRhCS390iUACGewAedcAmWQqJP8D3tdAh7wB2380wMsBIxs ECnwAHW3QFagCvcVErxQALNQRzvhBoDwBxggBGuc1SzAAX9Qz1rQCWucAzn8DxhgCEDABCVQ 18X8D2KwzCzQxjPwB9bgAUXAAQIACCA9EBsQAfp7xITdCYAtBBqQvydszm/gycs8A4AQADYQ AWv8DzPg0HuAAa77D3KyMALAsAzZ2gWwRRJHaxNnEAEG/NAC4QccAACx/Q/WYAcWbQNs/Q8C UAEAkAasbdH/4AegfAN4nAQ24EZJEABZwNgEUQYGfMYg/QZiUM9nYMACcMIlwALliweMTAYA UAGzvdIcUAEsgGHicQCBoAcKgAu9NBLPGxIF7cIl4QEsYAcAIMdAog0AbREtDhIeMAMqbBJ+ EAAs8OP3W+RGfuRI7hAnnORMXhpL3uRQHuVS/h4BAQA7 --------------030701000807040607030406-- --------------050006030008050609080607-- From pavel.stehule@gmail.com Wed Feb 16 09:08:14 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 921751337BC3 for ; Wed, 16 Feb 2011 05:08:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 09510-01 for ; Wed, 16 Feb 2011 09:08:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id E8BDB1337BC4 for ; Wed, 16 Feb 2011 05:08:05 -0400 (AST) Received: by iwn9 with SMTP id 9so1089249iwn.19 for ; Wed, 16 Feb 2011 01:08:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type; bh=cWFjIa0sT1YNA+hSFTF7OWa293Kv3WMO3EIuE+e6bKU=; b=LC5u0/vFEOd/aSvWAqnB/jDOfdVudDxCqF6QKAWIxogVcVjuJvEv0uaDcWutENvcBk OS8ODP7RoZxs6+1TwU49g6QSM6CYdeECjbPr3gEyvT5gc8iMC416qH/RYyCtZj+0VBLU UzZsySRUICzH/Lrkje07o/RC2nqUhdiBAynJw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=o6uSRyG12Zr2BfjmDkpAFPHT5QzRFYr0CSbTtbNzIUCAPvza4mtoyNY7k8hQD1375t sovg/fF9W7vPPnC2EE/yYGlaDL7BdiYa/2TmjoH1X9EWFLHvKwqEjZYk7x7R/SwL52ij dFctbL4Qckhf9q3LjYncFUMT8t97R4mZBPYe0= Received: by 10.42.229.73 with SMTP id jh9mr492739icb.6.1297847285682; Wed, 16 Feb 2011 01:08:05 -0800 (PST) MIME-Version: 1.0 Received: by 10.42.163.6 with HTTP; Wed, 16 Feb 2011 01:07:25 -0800 (PST) In-Reply-To: <4D5B8E0E.5040101@subexworld.com> References: <4D5B8E0E.5040101@subexworld.com> From: Pavel Stehule Date: Wed, 16 Feb 2011 10:07:25 +0100 Message-ID: Subject: Re: PL/SQL block error To: sivannarayanreddy@subexworld.com Cc: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=20cf3054a0696f93cc049c629e27 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.588 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201102/72 X-Sequence-Number: 35148 --20cf3054a0696f93cc049c629e27 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello you should to wrap code to function or inline function everywhere. psql doesn't support PL/SQL and doesn't support inlined PL/SQL blocks. Regards Pavel Stehule 2011/2/16 Sivannarayanreddy > Hello, > I am very new to the postgres sql, i am trying to execute below pl/sql > block in postgres but i am getting error *'ERROR: syntax error at or nea= r > "integer" '*, Could some one help me in this regard > > declare > v_count integer; > begin > select count(1) into v_count from pg_index inx where inx.indexrelid i= n > (select oid from pg_class where relname=3D'action_pk' and relowner in > (select oid from pg_authid where rolname=3D'postgres_ref')) > and inx.indrelid in > (select oid from pg_class where relname=3D'action' and relowner in > (select oid from pg_authid where rolname=3D'postgres_ref')); > > if v_count =3D 0 then > execute immediate 'create unique index action_pk > on action(acn_id)'; > end if; > end > > > > *Sivannarayanareddy Nusum** **| **System Analyst(Moneta GDO)* > > Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, > Bangalore =E2=80=93 560037, India. > *Phone:* +91 80 6696 3371; *Mobile:* +91 9902065831 *Fax:* +91 80 6696 > 3333; > > *Email:* sivannarayanreddy@subexworld.com ; * > URL:* www.subexworld.com > > > > *Disclaimer: This e-mail is bound by the terms and conditions described a= t > **http://www.subexworld.com/mail-disclaimer.html* > --20cf3054a0696f93cc049c629e27 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello

you should to wrap code to function or inline function everywh= ere.

psql doesn't support PL/SQL and doesn't support inlined= PL/SQL blocks.

Regards

Pavel Stehule

2011/2/16 Sivannarayanreddy <sivannarayanreddy@subexworld.com><= br>

=20 =20 =20
Hello,
I am very new to the postgres sql, i am trying to execute below pl/sql block in postgres but i am getting error 'ERROR:=C2=A0 sy= ntax error at or near "integer" ', Could some one help m= e in this regard

declare
v_count integer;
begin
select=C2=A0 count(1) into v_count=C2=A0 from=C2=A0 pg_index inx where= =C2=A0 inx.indexrelid in
=C2=A0(select oid from pg_class where relname=3D'action_pk' and= relowner in
=C2=A0(select oid from pg_authid where rolname=3D'postgres_ref'= ))
=C2=A0and inx.indrelid in
=C2=A0(select oid from pg_class where relname=3D'action' and re= lowner in
=C2=A0(select oid from pg_authid where rolname=3D'postgres_ref'= ));

if v_count =3D 0 then=C2=A0
execute immediate 'create unique index action_pk=C2=A0=C2=A0=C2=A0 =
on action(acn_id)';=C2=A0
end if;
end

=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Sivannarayanareddy Nusum <= /font>= | System Analyst(Moneta GDO)

Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, Bangalore =E2=80=93 560037, India.
Phone: +91 80 6696 3371; Mobile: +91 9902065831=C2=A0= Fax: +91 80 6696 3333;

Email:<= /font> =C2=A0sivannarayanreddy@subexworld.com; URL: =C2=A0www.subexworld.com

=C2=A0

Disclaimer: This e-mail is bound by the terms and conditions described at http://www.subexworld.com/mail-disclaime= r.html

--20cf3054a0696f93cc049c629e27--