pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe[2]: drop table 'text'
5+ messages / 3 participants
[nested] [flat]
* Re[2]: drop table 'text'
@ 1999-06-07 21:11 Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
2 siblings, 0 replies; 5+ messages in thread
From: Piotr Stelmaszyk @ 1999-06-07 21:11 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Herouth Maoz <herouth@oumail.openu.ac.il>
Monday, June 07, 1999, 6:23:56 PM, you wrote:
HM> DROP TABLE 'my_table',
HM> but
HM> DROP TABLE my_table.
thank You
i _do_ understand problem now, but i still don't know the sollution.
How can I drop table which name is evaluated from variable and text?
(in plpgsql of course)
/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re[2]: drop table 'text'
@ 1999-06-07 21:13 Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
2 siblings, 2 replies; 5+ messages in thread
From: Piotr Stelmaszyk @ 1999-06-07 21:13 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: herouth@oumail.openu.ac.il
Monday, June 07, 1999, 6:23:56 PM, you wrote:
HM> DROP TABLE 'my_table',
HM> but
HM> DROP TABLE my_table.
thank You
i _do_ understand problem now, but i still don't know the sollution.
How can I drop table which name is evaluated from variable and text?
(in plpgsql of course)
/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re[2]: drop table 'text'
@ 1999-06-07 21:15 Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
2 siblings, 0 replies; 5+ messages in thread
From: Piotr Stelmaszyk @ 1999-06-07 21:15 UTC (permalink / raw)
To: pgsql-interfaces
Monday, June 07, 1999, 6:23:56 PM, you wrote:
HM> DROP TABLE 'my_table',
HM> but
HM> DROP TABLE my_table.
thank You
i _do_ understand problem now, but i still don't know the sollution.
How can I drop table which name is evaluated from variable and text?
(in plpgsql of course)
ps. sorry for previous "subjectless" email
/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Re[2]: drop table 'text'
@ 1999-06-08 06:31 Anatoly K. Lasareff <tolik@icomm.ru>
parent: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
1 sibling, 0 replies; 5+ messages in thread
From: tolik@icomm.ru @ 1999-06-08 06:31 UTC (permalink / raw)
To: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>; +Cc: pgsql-interfaces; herouth@oumail.openu.ac.il
>>>>> "PS" == Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl> writes:
PS> Monday, June 07, 1999, 6:23:56 PM, you wrote:
HM> DROP TABLE 'my_table',
HM> but
HM> DROP TABLE my_table.
PS> thank You
PS> i _do_ understand problem now, but i still don't know the sollution.
PS> How can I drop table which name is evaluated from variable and text?
PS> (in plpgsql of course)
I think there is no solution this problem in 'plpgsql'
--
Anatoly K. Lasareff Email: tolik@icomm.ru
Senior programmer
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Re[2]: drop table 'text'
@ 1999-06-08 09:22 Herouth Maoz <herouth@oumail.openu.ac.il>
parent: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
1 sibling, 0 replies; 5+ messages in thread
From: Herouth Maoz @ 1999-06-08 09:22 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: pgsql-interfaces
At 09:31 +0300 on 08/06/1999, Anatoly K. Lasareff wrote:
> PS> Monday, June 07, 1999, 6:23:56 PM, you wrote:
> HM> DROP TABLE 'my_table',
> HM> but
> HM> DROP TABLE my_table.
> PS> thank You
> PS> i _do_ understand problem now, but i still don't know the sollution.
> PS> How can I drop table which name is evaluated from variable and text?
> PS> (in plpgsql of course)
>
> I think there is no solution this problem in 'plpgsql'
Neither do I. I think you will have to write in C or in pl/pgtcl. Either
that, or have a big conditional that maps all possible combinations.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-06-08 09:22 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-07 21:11 ` Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
1999-06-07 21:13 ` Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
1999-06-08 06:31 ` Anatoly K. Lasareff <tolik@icomm.ru>
1999-06-08 09:22 ` Herouth Maoz <herouth@oumail.openu.ac.il>
1999-06-07 21:15 ` Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
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