Re: Drop temporary table only if it exists

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Drop temporary table only if it exists
Дата
Msg-id 3E526F86.69391A03@Yahoo.com
обсуждение исходный текст
Ответ на Drop temporary table only if it exists  (Mintoo Lall <tlqmail@yahoo.com>)
Ответы Re: Drop temporary table only if it exists  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
Mintoo Lall wrote:
> 
> Hi Everybody,
> 
> How do I drop a temporary table ( or for that matter a sequence) only
> if it exists  or create them if they donot exist ? I want to do this
> to avoid any errors

I wonder what type of application cannot remember if it created a temp
object or not during the lifetime of it's database connection.


Jan

> 
> Any help is appreciated .
> 
> Thanks,
> 
> Tarun
> 
> ----------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


В списке pgsql-sql по дате отправления:

Предыдущее
От: miquels@cistron-office.nl (Miquel van Smoorenburg)
Дата:
Сообщение: Re: convert from an integer to a date
Следующее
От: "Martin Davidsson"
Дата:
Сообщение: Rule Creates Duplicates retry