pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re[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>
  1999-06-08 06:31   ` Re: [INTERFACES] Re[2]: drop table  'text' Anatoly K. Lasareff <tolik@icomm.ru>
  1999-06-08 09:22   ` Re: [INTERFACES] Re[2]: drop table  'text' Herouth Maoz <herouth@oumail.openu.ac.il>
  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: [INTERFACES] Re[2]: drop table  'text'
  1999-06-07 21:13 ` Re[2]: drop table  'text' Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
@ 1999-06-08 06:31   ` Anatoly K. Lasareff <tolik@icomm.ru>
  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-07 21:13 ` Re[2]: drop table  'text' Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
@ 1999-06-08 09:22   ` Herouth Maoz <herouth@oumail.openu.ac.il>
  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

* 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


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