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)
|
| Список | 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 по дате отправления: