This fixes some text as well as enforces the use of "drop table cascade"
since we moved from an implicate to explicate implementation.

Please find attached the func.py patch.

Sorry these are not all one single patch.  I really hadn't planned on
doing all this...especially not tonight. ;)

Greg Copeland
07 Aug 2002 22:50:03 -0500
Greg Copeland <greg@CopelandConsulting.Net>
Another python patch -- minor

Your patch has been added to the PostgreSQL unapplied patches list at:

	http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Greg Copeland wrote:

Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
> This fixes some text as well as enforces the use of "drop table cascade"
> since we moved from an implicate to explicate implementation.
> 
> Please find attached the func.py patch.
> 
> Sorry these are not all one single patch.  I really hadn't planned on
> doing all this...especially not tonight. ;)
> 
> Greg Copeland
> 
> 
> 

[ text/x-patch is unsupported, treating like TEXT/PLAIN ]

> Index: func.py
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/src/interfaces/python/tutorial/func.py,v
> retrieving revision 1.5
> diff -u -r1.5 func.py
> --- func.py	2000/10/02 03:46:24	1.5
> +++ func.py	2002/08/08 03:47:04
> @@ -9,7 +9,7 @@
>  This module is designed for being imported from python prompt
>  
>  In order to run the samples included here, first create a connection
> -using :                        cnx = advanced.DB(...)
> +using :                        cnx = func.DB(...)
>  
>  The "..." should be replaced with whatever arguments you need to open an
>  existing database.  Usually all you need is the name of the database and,
> @@ -189,13 +189,13 @@
>  	print "DROP FUNCTION add_em(int4, int4)"
>  	print "DROP FUNCTION one()"
>  	print
> -	print "DROP TABLE EMP"
> +	print "DROP TABLE EMP CASCADE"
>  	pgcnx.query("DROP FUNCTION clean_EMP()")
>  	pgcnx.query("DROP FUNCTION high_pay()")
>  	pgcnx.query("DROP FUNCTION new_emp()")
>  	pgcnx.query("DROP FUNCTION add_em(int4, int4)")
>  	pgcnx.query("DROP FUNCTION one()")
> -	pgcnx.query("DROP TABLE EMP")
> +	pgcnx.query("DROP TABLE EMP CASCADE")
>  
>  # main demo function
>  def demo(pgcnx):
-- End of PGP section, PGP failed!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sun, 11 Aug 2002 01:14:48 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Another python patch -- minor

Patch applied.  Thanks.

---------------------------------------------------------------------------



Greg Copeland wrote:

Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
> This fixes some text as well as enforces the use of "drop table cascade"
> since we moved from an implicate to explicate implementation.
> 
> Please find attached the func.py patch.
> 
> Sorry these are not all one single patch.  I really hadn't planned on
> doing all this...especially not tonight. ;)
> 
> Greg Copeland
> 
> 
> 

[ text/x-patch is unsupported, treating like TEXT/PLAIN ]

> Index: func.py
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/src/interfaces/python/tutorial/func.py,v
> retrieving revision 1.5
> diff -u -r1.5 func.py
> --- func.py	2000/10/02 03:46:24	1.5
> +++ func.py	2002/08/08 03:47:04
> @@ -9,7 +9,7 @@
>  This module is designed for being imported from python prompt
>  
>  In order to run the samples included here, first create a connection
> -using :                        cnx = advanced.DB(...)
> +using :                        cnx = func.DB(...)
>  
>  The "..." should be replaced with whatever arguments you need to open an
>  existing database.  Usually all you need is the name of the database and,
> @@ -189,13 +189,13 @@
>  	print "DROP FUNCTION add_em(int4, int4)"
>  	print "DROP FUNCTION one()"
>  	print
> -	print "DROP TABLE EMP"
> +	print "DROP TABLE EMP CASCADE"
>  	pgcnx.query("DROP FUNCTION clean_EMP()")
>  	pgcnx.query("DROP FUNCTION high_pay()")
>  	pgcnx.query("DROP FUNCTION new_emp()")
>  	pgcnx.query("DROP FUNCTION add_em(int4, int4)")
>  	pgcnx.query("DROP FUNCTION one()")
> -	pgcnx.query("DROP TABLE EMP")
> +	pgcnx.query("DROP TABLE EMP CASCADE")
>  
>  # main demo function
>  def demo(pgcnx):
-- End of PGP section, PGP failed!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Wed, 14 Aug 2002 23:33:46 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Another python patch -- minor