From: | kardash(dot)a(dot)v(at)yandex(dot)ru |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13870: couldn't restore dump with mat view |
Date: | 2016-01-15 17:55:46 |
Message-ID: | 20160115175546.2968.6033@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13870
Logged by: Arthur Kardash
Email address: kardash(dot)a(dot)v(at)yandex(dot)ru
PostgreSQL version: 9.5.0
Operating system: windows 7 x32
Description:
Try to feed sql-commands below, then do dump and you will see errors while
restore!
d:/pgsql/bin/pg_dump.exe -h 127.0.0.1 -U postgres -F c -f d:/backUp/test4
test
d:/pgsql/bin/pg_restore.exe -h 127.0.0.1 -U postgres -d t -F c
d:/backUp/test4
-----------------
SQL - commands
-----------------
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.5.0
-- Dumped by pg_dump version 9.5.0
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog;
--
-- Name: distance(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION distance(line integer) RETURNS numeric
LANGUAGE sql
AS $$
SELECT line * 4.5;
$$;
ALTER FUNCTION public.distance(line integer) OWNER TO postgres;
--
-- Name: point(integer); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION point(line integer) RETURNS numeric
LANGUAGE sql
AS $$
WITH t(line) AS (
SELECT line
FROM stend
)
SELECT distance (line) FROM t
$$;
ALTER FUNCTION public.point(line integer) OWNER TO postgres;
SET default_tablespace = '';
--
-- Name: conjunct_dynamic1; Type: MATERIALIZED VIEW; Schema: public; Owner:
postgres
--
CREATE MATERIALIZED VIEW conjunct_dynamic1 AS
SELECT point.point
FROM point(1) point(point)
WITH NO DATA;
ALTER TABLE conjunct_dynamic1 OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: stend; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE stend (
line integer
);
ALTER TABLE stend OWNER TO postgres;
--
-- Data for Name: stend; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY stend (line) FROM stdin;
\.
--
-- Name: conjunct_dynamic1; Type: MATERIALIZED VIEW DATA; Schema: public;
Owner: postgres
--
REFRESH MATERIALIZED VIEW conjunct_dynamic1;
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--
From | Date | Subject | |
---|---|---|---|
Next Message | luisandro | 2016-01-15 19:27:06 | BUG #13871: Format '%2f' invalid or incompatible with argument |
Previous Message | David G. Johnston | 2016-01-15 17:12:37 | Re: BUG #13869: Right Join query that never ends |