Double Quotes

Поиск
Список
Период
Сортировка
От Jason Best
Тема Double Quotes
Дата
Msg-id 3525FBCA1E76744385FA9B247B14A8D9B7C889@34093-EVS1C2.exchange.rackspace.com
обсуждение исходный текст
Ответы Re: Double Quotes  (Dave Page <dpage@postgresql.org>)
Список pgadmin-support

Hi,

                I think I have come across a bug. I am trying to create a new stored proc using plperl. I have an IN variable declared as a table called XmlData. The SQL being generated is wrong:

 

CREATE FUNCTION test.testsub2(IN xml test.""XmlData"", OUT id integer) AS

'return $_[0]->{id};'

LANGUAGE 'plperl' VOLATILE;

ALTER FUNCTION test.testsub2(IN test.""XmlData"", OUT integer) OWNER TO postgres;

GRANT EXECUTE ON FUNCTION test.testsub2(IN test.""XmlData"", OUT integer) TO public;

 

 

You can see it clearly is double quoting the table name. The UI form element is single quoting it. I tried to correct this be removing the quotes in the UI (add param screen), but it won’t let me add test.XmlData without the quotes. Am I doing something wrong or is this a bug? The exact error pgAdmin gives when I click OK is –

 

 An error has occurred:

 

ERROR: zero-length delimited identifier or near “”””

LINE 1: CREATE FUNCTION test.testsub2(IN test test.””XmlData””) RETU…

 

Regards,

Jason Aaron Best
Lead Development Engineer
602.393.8987 [M]

212.202.4288 [F]

866.297.2841 [TF]

http://www.mission3.com/images/Mission3LogoFinalColor.png

 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Erwin Brandstetter
Дата:
Сообщение: Re: pgAdmin III v1.8.0 Beta 5 released
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Export the explain diagram?