Ted Byers wrote:
>
> 2) Do I need to qualify my references to my tables in the function to
> identify the schema in which the tables exist, or will Postgres find
> the right tables with the function in its present form? If I have to
> further qualify the table references, what is the correct
> q
Please see below
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ted Byers
Sent: Wednesday, December 28, 2005 7:29 PM
To: Frank L. Parks; pgsql-general@postgresql.org
Subject: Re: [Bulk] Re: [GENERAL] Final stored procedure question, for now
anyway
- Original Message -
From: "Frank L. Parks" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 28, 2005 7:27 PM
Subject: [Bulk] Re: [GENERAL] Final stored procedure question, for now
anyway
Do you refresh you database after you add the function? It will not show
ral@postgresql.org <mailto:pgsql-general@postgresql.org>
*Sent:* Wednesday, December 28, 2005 4:16 PM
*Subject:* Re: [GENERAL] Final stored procedure question, for now
anyway
yup, just use lowercase all the time
Jonel
Rienton; pgsql-general@postgresql.orgSubject: Re: [GENERAL] Final
stored procedure question, for now anyway
Well, I just ran another test and the result indicates the
cause of the problem lies elsewhere. I replaced the original function name
with "add_entity" and the end result is
uggestions?
- Original Message -
From:
Jonel
Rienton
To: 'Ted Byers' ; pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 4:16
PM
Subject: Re: [GENERAL] Final stored
procedure question, for now anyway
yup, just use lowercase all the
ti
yup, just use lowercase all the
time
From: Ted Byers [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 28, 2005 1:45 PMTo: Jonel
Rienton; pgsql-general@postgresql.orgSubject: Re: [GENERAL] Final
stored procedure question, for now anyway
Did you find a fix for it?
- Original
Did you find a fix for it?
- Original Message -
From:
Jonel
Rienton
To: 'Ted Byers' ; pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 1:24
PM
Subject: RE: [GENERAL] Final stored
procedure question, for now anyway
it's
it's because of the mixed-case you're using in the function
name, i've had this issue last week myself and it seems to be the
culprit
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ted
ByersSent: Wednesday, December 28, 2005 11:13 AMTo:
pgsql-general@postgresql.orgSubject:
Ted Byers wrote:
> It must be stored somewhere since I get an error saying the function
> already exists if I attempt to modiy it slightly and re-run it. For
> example, I noticed I used the wrong sequence in the last INSERT
> statement. To correct that, I had to add "OR REPLACE" after "CREATE"
>
10 matches
Mail list logo