pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddrop table in pgsql
3+ messages / 2 participants
[nested] [flat]
* drop table in pgsql
@ 1999-01-05 21:20 Pawel Pierscionek <pawel@astercity.net>
1999-01-06 10:19 ` Re: [SQL] drop table in pgsql Jan Wieck <jwieck@debis.com>
0 siblings, 1 reply; 3+ messages in thread
From: Pawel Pierscionek @ 1999-01-05 21:20 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] drop table in pgsql
1999-01-05 21:20 drop table in pgsql Pawel Pierscionek <pawel@astercity.net>
@ 1999-01-06 10:19 ` Jan Wieck <jwieck@debis.com>
1999-01-06 14:43 ` Re: [SQL] drop table in pgsql Pawel Pierscionek <pawel@astercity.net>
0 siblings, 1 reply; 3+ messages in thread
From: jwieck@debis.com @ 1999-01-06 10:19 UTC (permalink / raw)
To: pawel@astercity.net; +Cc: pgsql-sql
>
> 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.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] drop table in pgsql
1999-01-05 21:20 drop table in pgsql Pawel Pierscionek <pawel@astercity.net>
1999-01-06 10:19 ` Re: [SQL] drop table in pgsql Jan Wieck <jwieck@debis.com>
@ 1999-01-06 14:43 ` Pawel Pierscionek <pawel@astercity.net>
0 siblings, 0 replies; 3+ messages in thread
From: Pawel Pierscionek @ 1999-01-06 14:43 UTC (permalink / raw)
To: Jan Wieck <jwieck@debis.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-01-06 14:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-05 21:20 drop table in pgsql Pawel Pierscionek <pawel@astercity.net>
1999-01-06 10:19 ` Jan Wieck <jwieck@debis.com>
1999-01-06 14:43 ` Pawel Pierscionek <pawel@astercity.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox