Re: [SQL] drop table in pgsql

On Wed, 6 Jan 1999, Jan Wieck wrote:

> >
> > Hi,
> >
> > How do I drop a table under plpgsql ?
> > When I invoke a function which contains eg: DROP TABLE TMP a get a
> > backend crash no matter if this table exists or not.
> >
> > I can always do it the hard way and put DROP ... in an SQL function
> > and then invoke DROP indirectly but do I have to ?
> >
> > Please help me
> > Pawel Pierscionek
>
> Huh - intersting. Not that I think it's good to change the
> database schema from inside of functions, but if SQL
> functions can do it, PL/pgSQL should too. Will take a look at
> it.
>
I don't like changing db shema that way too, but there is no support for
temporary tables and I have to use drop before I go with select sth into
temp_db.

Pawel Pierscionek