Re: pg_dump in 7.4

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg_dump in 7.4
Дата
Msg-id
17859.1037302537@sss.pgh.pa.us
Ответ на
Re: pg_dump in 7.4 (Philip Warner)
Список
Дерево обсуждения
pg_dump in 7.4 "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: pg_dump in 7.4 Rod Taylor <rbt@rbt.ca>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Rod Taylor <rbt@rbt.ca>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Rod Taylor <rbt@rbt.ca>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Rod Taylor <rbt@rbt.ca>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump in 7.4 Neil Conway <neilc@samurai.com>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump in 7.4 Neil Conway <neilc@samurai.com>
Re: pg_dump in 7.4 "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Re: pg_dump in 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump in 7.4 "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: pg_dump in 7.4 Philip Warner <pjw@rhyme.com.au>
Philip Warner  writes:
> At 12:39 AM 14/11/2002 -0500, Neil Conway wrote:
>> Perhaps when the function is defined, we run all the SQL queries in
>> the function body through the parser/analyzer/rewriter, and then
>> generate dependencies on the Query trees we get back?

> Won't work for functions that build dynamic queries.

That's irrelevant for SQL functions, though, and pg_dump does not need
to worry about dependencies inside other types of functions (since only
SQL functions' bodies are examined during CREATE FUNCTION).

Neil's solution is exactly what I was thinking we should do.  Or almost
exactly, anyway: we don't want to run the rewriter before extracting
dependencies.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Scott Shattuck
Дата:
Сообщение: Re: create or replace view
От: Stephan Szabo
Дата:
Сообщение: Re: create or replace view
FAQ