Re: Repeatable crash in pg_dump (with -d2 info)

Поиск
Список
Период
Сортировка
От David Schnur
Тема Re: Repeatable crash in pg_dump (with -d2 info)
Дата
Msg-id CAANiQE=fjCFLp2DvUM9r3GVA4+khuyaQ9UFaee7HzFzEkJuYvw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Repeatable crash in pg_dump (with -d2 info)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Repeatable crash in pg_dump (with -d2 info)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Sure; the function is created programmatically as part of schema creation, by the same user who owns (almost) everything else in the database.  The definition looks like this:

        CREATE OR REPLACE FUNCTION datastore_unpack(
            data_times TIMESTAMP WITH TIME ZONE[],
            data_values DOUBLE PRECISION[],
            OUT data_time TIMESTAMP WITH TIME ZONE,
            OUT data_value DOUBLE PRECISION
        ) RETURNS SETOF RECORD AS $$
            SELECT $1[rowx] AS data_time, $2[rowx] AS data_value
            FROM generate_series(1, array_upper($1, 1)) AS rowx;
        $$ LANGUAGE SQL STABLE;

It takes two parallel arrays and unpacks them into a set of records.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Repeatable crash in pg_dump (with -d2 info)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Repeatable crash in pg_dump (with -d2 info)