[BUG] PostgreSQL Import fails with Syntax Error on valid pg_dump files #852

Activity

1. 1ilit commented on Jan 28, 2026

   

   1ilit

   on Jan 28, 2026

   Member

   More actions

   can u attach the sql
2. Gautam-Bharadwaj commented on Jan 28, 2026

   

   Gautam-Bharadwaj

   on Jan 28, 2026

   Author

   More actions

   @1ilit

   Sure! Here is a minimal reproduction snippet that fails on the current version but passes with my fix. It contains standard pg_dump artefacts like SET commands and comments.

   -- Dumped by pg_dump version 14.5
   SET statement_timeout = 0;
   SET lock_timeout = 0;
   SET idle_in_transaction_session_timeout = 0;
   SET client_encoding = 'UTF8';
   SET standard_conforming_strings = on;
   SELECT pg_catalog.set_config('search_path', '', false);
   SET check_function_bodies = false;
   SET xmloption = content;
   SET client_min_messages = warning;
   SET row_security = off;
   
   -- Name: public; Type: SCHEMA; Schema: -; Owner: pg_database_owner
   
   CREATE SCHEMA public;
   
   -- Name: users; Type: TABLE; Schema: public; Owner: postgres
   
   CREATE TABLE public.users (
       id integer NOT NULL,
       username character varying(255) NOT NULL,
       email character varying(255) NOT NULL,
       created_at timestamp without time zone DEFAULT now()
   );
   
   -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
   
   CREATE SEQUENCE public.users_id_seq
       AS integer
       START WITH 1
       INCREMENT BY 1
       NO MINVALUE
       NO MAXVALUE
       CACHE 1;
   
   ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
3. Gautam-Bharadwaj commented on Jan 28, 2026

   

   Gautam-Bharadwaj

   on Jan 28, 2026

   Author

   More actions

   After the fix (How it is processed): The sanitizeSQL function added in this PR strips the noise (comments, SET, SELECT pg_catalog) internally. The parser receives this clean input, which it accepts without error:

   ---

   CREATE SCHEMA public;

   CREATE TABLE public.users (
   id integer NOT NULL,
   username character varying(255) NOT NULL,
   email character varying(255) NOT NULL,
   created_at timestamp without time zone DEFAULT now()
   );
4. Gautam-Bharadwaj commented on Apr 2, 2026

   

   Gautam-Bharadwaj

   on Apr 2, 2026

   Author

   More actions

   @1ilit Please review my pr