Need more info on PL/pgSQL compile listing

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Need more info on PL/pgSQL compile listing
Date: 2015-11-16 23:29:56
Message-ID: CACpWLjNR-0T3w55i34eqK3z9BrVu2ojxoXPp3aUZWUFYF_M60A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am doing like:
*mydb-# \i pxportal2_mod.sql*

which gives an error like:

*CREATE FUNCTION*
*psql:pxportal2_mod.sql:309: NOTICE: type reference
tx_portal.portal_name%TYPE converted to character varying*
*psql:pxportal2_mod.sql:309: NOTICE: type reference
tx_service_catalog.service_code%TYPE converted to character varying*
*psql:pxportal2_mod.sql:309: ERROR: syntax error at or near "pxportal2"*
*LINE 61: pxportal2.dlogerror (v_program_name, v_program_loca...*
* ^*

The problem is that there are lots of directives and comments in my input
file so that neither line 309 (above) or 61 is actually meaningful.

I would simply like to echo the input lines to the output or get a more
verbose message. I spent over an hour googling this but no luck.

This is the beginning of my input file if that helps:
*-- Generated by Ora2Pg, the Oracle database Schema converter, version 16.0*
*-- Copyright 2000-2015 Gilles DAROLD. All rights reserved.*
*-- DATASOURCE: dbi:Oracle:LCD1_DEV*

*SET client_encoding TO 'UTF8';*

*\set ON_ERROR_STOP OFF*

*-- Oracle package 'PXPORTAL2' declaration, please edit to match PostgreSQL
syntax.*
*-- PostgreSQL does not recognize PACKAGES, using SCHEMA instead.*
*DROP SCHEMA IF EXISTS pxportal2 CASCADE;*
*CREATE SCHEMA pxportal2;*

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2015-11-17 00:02:30 Re: Need more info on PL/pgSQL compile listing
Previous Message david.paulo 2015-11-15 02:17:19 Re: How would I get rid of trailing blank line?