On Tue, 15 Nov 2011 18:48:00 -0700
J.V. jvsr...@gmail.com wrote:
the drop function works when running from a pgAdmin III Sql window
but when I try to do from the command line and script it:
psql -h $PGHOST -p $PGPORT -d $PGDATABASE -U $PGUSER -c
*drop function *
the above fails.
Ivan Sergio Borgonovo, 16.11.2011 01:01:
test=# begin;
create or replace function process_table (
action TEXT, v_table_name varchar(100)
) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
return true;
END;
$$ LANGUAGE plpgsql;
drop function process_table (
action TEXT,
On Wed, 16 Nov 2011 09:17:45 +0100
Thomas Kellerer spam_ea...@gmx.net wrote:
Ivan Sergio Borgonovo, 16.11.2011 01:01:
test=# begin;
create or replace function process_table (
action TEXT, v_table_name varchar(100)
) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
return
How do I drop a function that was created like so:
create or replace function process_table (action TEXT, v_table_name
varchar(100)) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
...
END;
$$ LANGUAGE plpgsql;
---
I have tried various ways, but it always fails.
J.V.
--
Sent via pgsql-general
On 11/16/2011 07:38 AM, J.V. wrote:
How do I drop a function that was created like so:
create or replace function process_table (action TEXT, v_table_name
varchar(100)) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
...
END;
$$ LANGUAGE plpgsql;
---
I have tried various ways, but it always fails.
DROP FUNCTION process_table;
should work.
On Tue, Nov 15, 2011 at 11:38 PM, J.V. jvsr...@gmail.com wrote:
How do I drop a function that was created like so:
create or replace function process_table (action TEXT, v_table_name
varchar(100)) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
...
On Tuesday, November 15, 2011 3:56:32 pm Rebecca Clarke wrote:
DROP FUNCTION process_table;
should work.
Actually no, for the following reason:(
http://www.postgresql.org/docs/9.0/interactive/sql-dropfunction.html
DROP FUNCTION removes the definition of an existing function. To execute
On Tue, 15 Nov 2011 16:38:20 -0700
J.V. jvsr...@gmail.com wrote:
How do I drop a function that was created like so:
create or replace function process_table (action TEXT,
v_table_name varchar(100)) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
...
END;
$$ LANGUAGE plpgsql;
---
I
this did not work.
On 11/15/2011 4:56 PM, Craig Ringer wrote:
On 11/16/2011 07:38 AM, J.V. wrote:
How do I drop a function that was created like so:
create or replace function process_table (action TEXT, v_table_name
varchar(100)) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
...
END;
$$ LANGUAGE
this does not work.
On 11/15/2011 4:56 PM, Rebecca Clarke wrote:
DROP FUNCTION process_table;
should work.
On Tue, Nov 15, 2011 at 11:38 PM, J.V. jvsr...@gmail.com
mailto:jvsr...@gmail.com wrote:
How do I drop a function that was created like so:
create or replace function
the drop function works when running from a pgAdmin III Sql window
but when I try to do from the command line and script it:
psql -h $PGHOST -p $PGPORT -d $PGDATABASE -U $PGUSER -c *drop
function *
the above fails.
It does however work with functions with no params or a single param.
On Nov 15, 2011, at 20:24, J.V. jvsr...@gmail.com wrote:
this did not work.
On 11/15/2011 4:56 PM, Craig Ringer wrote:
On 11/16/2011 07:38 AM, J.V. wrote:
How do I drop a function that was created like so:
create or replace function process_table (action TEXT, v_table_name
varchar(100))
On Tue, Nov 15, 2011 at 6:48 PM, J.V. jvsr...@gmail.com wrote:
the drop function works when running from a pgAdmin III Sql window
but when I try to do from the command line and script it:
psql -h $PGHOST -p $PGPORT -d $PGDATABASE -U $PGUSER -c drop function
the above fails.
On 11/15/11 5:48 PM, J.V. wrote:
the drop function works when running from a pgAdmin III Sql window
but when I try to do from the command line and script it:
psql -h $PGHOST -p $PGPORT -d $PGDATABASE -U $PGUSER -c *drop
function *
the above fails.
can you please give the complete
14 matches
Mail list logo