Bugzilla – Attachment 134017 Details for
Bug 108105
Multiple errors in Postgresql log when using subforms
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
DB dump
DB SQL.txt (text/plain), 5.06 KB, created by
work
on 2017-06-14 10:29:36 UTC
(
hide
)
Description:
DB dump
Filename:
MIME Type:
Creator:
work
Created:
2017-06-14 10:29:36 UTC
Size:
5.06 KB
patch
obsolete
>-- >-- PostgreSQL database dump >-- > >-- Dumped from database version 9.6.1 >-- Dumped by pg_dump version 9.6.1 > >SET statement_timeout = 0; >SET lock_timeout = 0; >SET idle_in_transaction_session_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; > >SET search_path = public, pg_catalog; > >ALTER TABLE IF EXISTS ONLY public.dossier DROP CONSTRAINT IF EXISTS dossier_id_logement_fkey; >ALTER TABLE IF EXISTS ONLY public.logement DROP CONSTRAINT IF EXISTS logement_pkey; >ALTER TABLE IF EXISTS ONLY public.dossier DROP CONSTRAINT IF EXISTS dossier_pkey; >ALTER TABLE IF EXISTS public.logement ALTER COLUMN id DROP DEFAULT; >DROP SEQUENCE IF EXISTS public.logement_id_seq; >DROP TABLE IF EXISTS public.logement; >DROP TABLE IF EXISTS public.dossier; >DROP SEQUENCE IF EXISTS public.dossier_id_seq; >DROP EXTENSION IF EXISTS plpgsql; >DROP SCHEMA IF EXISTS public; >-- >-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres >-- > >CREATE SCHEMA public; > > >ALTER SCHEMA public OWNER TO postgres; > >-- >-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres >-- > >COMMENT ON SCHEMA public IS 'standard public schema'; > > >-- >-- 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: dossier_id_seq; Type: SEQUENCE; Schema: public; Owner: olivier >-- > >CREATE SEQUENCE dossier_id_seq > START WITH 1 > INCREMENT BY 1 > NO MINVALUE > NO MAXVALUE > CACHE 1; > > >ALTER TABLE dossier_id_seq OWNER TO olivier; > >SET default_tablespace = ''; > >SET default_with_oids = false; > >-- >-- Name: dossier; Type: TABLE; Schema: public; Owner: olivier >-- > >CREATE TABLE dossier ( > id integer DEFAULT nextval('dossier_id_seq'::regclass) NOT NULL, > id_logement integer NOT NULL >) >WITH (autovacuum_enabled='on'); > > >ALTER TABLE dossier OWNER TO olivier; > >-- >-- Name: logement; Type: TABLE; Schema: public; Owner: olivier >-- > >CREATE TABLE logement ( > id integer NOT NULL >) >WITH (autovacuum_enabled='on'); > > >ALTER TABLE logement OWNER TO olivier; > >-- >-- Name: logement_id_seq; Type: SEQUENCE; Schema: public; Owner: olivier >-- > >CREATE SEQUENCE logement_id_seq > START WITH 1 > INCREMENT BY 1 > NO MINVALUE > NO MAXVALUE > CACHE 1; > > >ALTER TABLE logement_id_seq OWNER TO olivier; > >-- >-- Name: logement_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: olivier >-- > >ALTER SEQUENCE logement_id_seq OWNED BY logement.id; > > >-- >-- Name: logement id; Type: DEFAULT; Schema: public; Owner: olivier >-- > >ALTER TABLE ONLY logement ALTER COLUMN id SET DEFAULT nextval('logement_id_seq'::regclass); > > >-- >-- Data for Name: dossier; Type: TABLE DATA; Schema: public; Owner: olivier >-- > >INSERT INTO dossier (id, id_logement) VALUES (1, 2); > > >-- >-- Name: dossier_id_seq; Type: SEQUENCE SET; Schema: public; Owner: olivier >-- > >SELECT pg_catalog.setval('dossier_id_seq', 1, true); > > >-- >-- Data for Name: logement; Type: TABLE DATA; Schema: public; Owner: olivier >-- > >INSERT INTO logement (id) VALUES (2); > > >-- >-- Name: logement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: olivier >-- > >SELECT pg_catalog.setval('logement_id_seq', 2, true); > > >-- >-- Name: dossier dossier_pkey; Type: CONSTRAINT; Schema: public; Owner: olivier >-- > >ALTER TABLE ONLY dossier > ADD CONSTRAINT dossier_pkey PRIMARY KEY (id); > > >-- >-- Name: logement logement_pkey; Type: CONSTRAINT; Schema: public; Owner: olivier >-- > >ALTER TABLE ONLY logement > ADD CONSTRAINT logement_pkey PRIMARY KEY (id); > > >-- >-- Name: dossier dossier_id_logement_fkey; Type: FK CONSTRAINT; Schema: public; Owner: olivier >-- > >ALTER TABLE ONLY dossier > ADD CONSTRAINT dossier_id_logement_fkey FOREIGN KEY (id_logement) REFERENCES logement(id); > > >-- >-- Name: pg_catalog; Type: ACL; Schema: -; Owner: postgres >-- > >GRANT USAGE ON SCHEMA pg_catalog TO olivier; > > >-- >-- Name: public; Type: ACL; Schema: -; Owner: postgres >-- > >GRANT ALL ON SCHEMA public TO olivier; >GRANT USAGE ON SCHEMA public TO "Utilisateurs"; > > >-- >-- Name: dossier; Type: ACL; Schema: public; Owner: olivier >-- > >GRANT ALL ON TABLE dossier TO "Utilisateurs"; > > >-- >-- Name: logement; Type: ACL; Schema: public; Owner: olivier >-- > >REVOKE ALL ON TABLE logement FROM olivier; >GRANT ALL ON TABLE logement TO olivier WITH GRANT OPTION; >GRANT ALL ON TABLE logement TO "Utilisateurs"; > > >-- >-- Name: logement_id_seq; Type: ACL; Schema: public; Owner: olivier >-- > >REVOKE ALL ON SEQUENCE logement_id_seq FROM olivier; >GRANT ALL ON SEQUENCE logement_id_seq TO olivier WITH GRANT OPTION; >GRANT ALL ON SEQUENCE logement_id_seq TO "Utilisateurs"; > > >-- >-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: -; Owner: postgres >-- > >ALTER DEFAULT PRIVILEGES FOR ROLE postgres GRANT ALL ON TABLES TO postgres; >ALTER DEFAULT PRIVILEGES FOR ROLE postgres GRANT ALL ON TABLES TO olivier WITH GRANT OPTION; >ALTER DEFAULT PRIVILEGES FOR ROLE postgres GRANT ALL ON TABLES TO "Utilisateurs"; > > >-- >-- PostgreSQL database dump complete >-- >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=134017">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 108105
:
133651
|
134016
| 134017 |
134018
|
134019
|
134020
|
134021
|
134022
|
134023
|
134024
|
134025