Author: dpage
Date: 2005-05-20 09:29:57 +0100 (Fri, 20 May 2005)
New Revision: 4221
Modified:
trunk/pgadmin3/src/pgAdmin3.dsp
trunk/pgadmin3/src/schema/pgFunction.cpp
Log:
Quote function name and args correctly in RE SQL, per Ivan.
Modified: trunk/pgadmin3/src/pgAdmin3.dsp
===================================================================
--- trunk/pgadmin3/src/pgAdmin3.dsp 2005-05-20 08:09:22 UTC (rev 4220)
+++ trunk/pgadmin3/src/pgAdmin3.dsp 2005-05-20 08:29:57 UTC (rev 4221)
@@ -73,7 +73,7 @@
# PROP Ignore_Export_Lib 0
# PROP Target_Dir ""
# ADD BASE CPP /nologo /MDd /W3 /GX /O2 /Ob2 /I "c:/wxWidgets-2.6/include" /I
"c:/wxWidgets-2.6/contrib/include" /I "c:/program files/postgresql/8.0/include"
/I "include/" /I "agent/include" /I "slony/include" /D "NDEBUG" /D "WIN32" /D
"_WINDOWS" /D "__WINDOWS__" /D "__WIN95__" /D "__WIN32__" /D WINVER=0x0400 /D
"STRICT" /D wxUSE_UNICODE=1 /D "_UNICODE" /D "UNICODE" /D "EMBED_XRC" /D "SSL"
/FAcs /FR /Yu"pgadmin3.h" /FD /c
-# ADD CPP /nologo /MDd /W3 /GX /O2 /Ob2 /I "c:/wxWidgets-2.6/include" /I
"c:/wxWidgets-2.6/contrib/include" /I "c:/program files/postgresql/8.0/include"
/I "include/" /I "agent/include" /I "slony/include" /D "NDEBUG" /D "WIN32" /D
"_WINDOWS" /D "__WINDOWS__" /D "__WIN95__" /D "__WIN32__" /D WINVER=0x0400 /D
"STRICT" /D wxUSE_UNICODE=1 /D "_UNICODE" /D "UNICODE" /D "EMBED_XRC" /D "SSL"
/FAcs /FR /Yu"pgamsgevent.h" /FD /c
+# ADD CPP /nologo /MDd /W3 /GX /O2 /Ob2 /I "c:/wxWidgets-2.6/include" /I
"c:/wxWidgets-2.6/contrib/include" /I "c:/program files/postgresql/8.0/include"
/I "include/" /I "agent/include" /I "slony/include" /D "NDEBUG" /D "WIN32" /D
"_WINDOWS" /D "__WINDOWS__" /D "__WIN95__" /D "__WIN32__" /D WINVER=0x0400 /D
"STRICT" /D wxUSE_UNICODE=1 /D "_UNICODE" /D "UNICODE" /D "EMBED_XRC" /D "SSL"
/FAcs /FR /Yu"pgadmin3.h" /FD /c
# ADD BASE MTL /nologo /D "_DEBUG" /mktyplib203 /o "NUL" /win32
# ADD MTL /nologo /D "_DEBUG" /mktyplib203 /o "NUL" /win32
# ADD BASE RSC /l 0x809 /i "c:/wxWidgets-2.6/include" /d "NDEBUG"
Modified: trunk/pgadmin3/src/schema/pgFunction.cpp
===================================================================
--- trunk/pgadmin3/src/schema/pgFunction.cpp 2005-05-20 08:09:22 UTC (rev
4220)
+++ trunk/pgadmin3/src/schema/pgFunction.cpp 2005-05-20 08:29:57 UTC (rev
4221)
@@ -55,7 +55,7 @@
{
wxString qtName = wxT("FUNCTION ") + GetQuotedFullIdentifier() +
wxT("(") + GetQuotedArgTypes() + wxT(")");
- sql = wxT("-- Function: ") + GetFullIdentifier() + wxT("(") +
GetArgTypeNames() + wxT(")\n\n")
+ sql = wxT("-- Function: ") + GetQuotedFullIdentifier() + wxT("(") +
GetQuotedArgTypes() + wxT(")\n\n")
+ wxT("-- DROP ") + qtName + wxT(";")
+ wxT("\n\nCREATE OR REPLACE ") + qtName
+ wxT("\n RETURNS ");
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
