From: | svn(at)pgadmin(dot)org |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | SVN Commit by dpage: r4903 - in trunk/pgadmin3: . src/schema |
Date: | 2006-01-17 12:43:11 |
Message-ID: | 200601171243.k0HChB2B025954@developer.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Author: dpage
Date: 2006-01-17 12:43:10 +0000 (Tue, 17 Jan 2006)
New Revision: 4903
Modified:
trunk/pgadmin3/CHANGELOG.txt
trunk/pgadmin3/src/schema/pgFunction.cpp
Log:
Display the defintion of set returning procedures correctly.
Modified: trunk/pgadmin3/CHANGELOG.txt
===================================================================
--- trunk/pgadmin3/CHANGELOG.txt 2006-01-17 11:30:01 UTC (rev 4902)
+++ trunk/pgadmin3/CHANGELOG.txt 2006-01-17 12:43:10 UTC (rev 4903)
@@ -18,6 +18,7 @@
</ul>
<br>
<ul>
+ <LI>2006-01-17 DP 1.4.2 Display the defintion of set returning procedures correctly.
<li>2006-01-17 DP 1.4.2 Fix drop procedure by including IN/OUT parameter flags in the name.
<li>2006-01-13 DP 1.4.2 Fix role SQL - correctly define CREATEROLE/NOCREATEROLE per Andrus.
<li>2006-01-11 DP Allow result copy quoting configuration to be set explicitly rather than using the result export settings [Magnus Hagander]
Modified: trunk/pgadmin3/src/schema/pgFunction.cpp
===================================================================
--- trunk/pgadmin3/src/schema/pgFunction.cpp 2006-01-17 11:30:01 UTC (rev 4902)
+++ trunk/pgadmin3/src/schema/pgFunction.cpp 2006-01-17 12:43:10 UTC (rev 4903)
@@ -74,8 +74,13 @@
sql += wxT("\n RETURNS ");
if (GetReturnAsSet())
sql += wxT("SETOF ");
- sql +=GetQuotedReturnType();
+ sql += GetQuotedReturnType();
}
+ else if (GetReturnAsSet())
+ {
+ sql += wxT("\n RETURNS SETOF ");
+ sql += GetQuotedReturnType();
+ }
sql += wxT(" AS\n");
@@ -155,8 +160,15 @@
sql = wxT("-- Procedure: ") + GetQuotedFullIdentifier() + wxT("\n\n")
+ wxT("-- DROP PROCEDURE") + GetQuotedFullIdentifier() + wxT(";")
- + wxT("\n\nCREATE OR REPLACE ") + qtName
- + wxT(" AS\n")
+ + wxT("\n\nCREATE OR REPLACE ") + qtName;
+
+ if (GetReturnAsSet())
+ {
+ sql += wxT("\n RETURNS SETOF ");
+ sql +=GetQuotedReturnType();
+ }
+
+ sql += wxT(" AS\n")
+ qtStringDollar(GetSource())
+ wxT(";\n");
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2006-01-17 12:44:12 | SVN Commit by dpage: r4904 - in trunk/pgadmin3: . src/dlg |
Previous Message | svn | 2006-01-17 11:30:01 | SVN Commit by dpage: r4902 - in trunk/pgadmin3: . src/schema |