I had written a function that would recreate a static table. The function
called the "DROP TABLE" command and then proceeded to create the new table.
This used to work fine until I upgraded the database server to 8.x. Now when
I try to run the function I get the error message...
ERROR: DROP TABLE is not allowed in a non-volatile function
What can I do now? Is there a way to redefine my function so that it is a
"non-volatile" function? Tried to find more about this online with little
luck. Please any suggestions would be welcome.
Alan
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "McCormick, Bill" <BillMcCormick@Catholichealth.net>
Cc: <pgsql-novice@postgresql.org>
Sent: Tuesday, May 17, 2005 10:39 AM
Subject: Re: [NOVICE] Help: Input Error Notice
> "McCormick, Bill" <BillMcCormick@Catholichealth.net> writes:
>> Periodically, I receive messages like: psql:<stdin>:346920: ERROR:
>> dtoi: integer out of range
>
> You're trying to store a number that's too big to fit in an integer
> field. Perhaps something is wrong with the awk script that generates
> the data?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>