Hello > > My experience in this is just from 8.0 so I don't know if anything has > changed. In general, if tables are created or deleted within the > function then you want to use execute, as well as if the tables are > recreated in the course of a normal workflow. For example, if you have a > table that you regenerate once a day (by drop and create) you will not > want to reference that table in a view or function. this bug is solved in 8.3 regards Pavel Stehule > > Obviously if you want to run dynamic code you also need to use execute. > > Sim > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkmqnSkACgkQjDX6szCBa+o77gCgjB7W+4tIYZVPtEvaF1Uj3QBC > fPcAoOubAAC9dr5opTRyFsyUfLq6ojQF > =q5NU > -----END PGP SIGNATURE----- > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
