Обсуждение: Double Quotes

Поиск
Список
Период
Сортировка

Double Quotes

От
"Jason Best"
Дата:

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

 

Re: Double Quotes

От
Dave Page
Дата:
Jason Best wrote:
> 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:

What version of pgAdmin? It works for me on 1.8.0 beta 5.

Regards, Dave

Re: Double Quotes

От
"Jason Best"
Дата:
1.6.3

Regards,
Jason Aaron Best
Lead Development Engineer
602.393.8987 [M]
212.202.4288 [F]
866.297.2841 [TF]


-----Original Message-----
From: Dave Page [mailto:dpage@postgresql.org]
Sent: Saturday, September 15, 2007 1:48 AM
To: Jason Best
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Double Quotes

Jason Best wrote:
> 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:

What version of pgAdmin? It works for me on 1.8.0 beta 5.

Regards, Dave

Re: Double Quotes

От
Dave Page
Дата:
Jason Best wrote:
> 1.6.3

Yeah, that code has changed a lot since then. Can you try 1.8b5 please?

Thanks, Dave.

Re: Double Quotes

От
"Jason Best"
Дата:
It seems to be fixed in 1.8b5. Thanks.

Regards,
Jason Aaron Best
Lead Development Engineer
602.393.8987 [M]
212.202.4288 [F]
866.297.2841 [TF]


-----Original Message-----
From: Dave Page [mailto:dpage@postgresql.org]
Sent: Monday, September 17, 2007 12:42 PM
To: Jason Best
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Double Quotes

Jason Best wrote:
> 1.6.3

Yeah, that code has changed a lot since then. Can you try 1.8b5 please?

Thanks, Dave.

Re: Double Quotes

От
Dave Page
Дата:
Jason Best wrote:
> It seems to be fixed in 1.8b5. Thanks.

Great, thanks for testing.

Regards, Dave.