From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Zahir Lalani <ZahirLalani(at)oliver(dot)agency>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Possible corrupt index? |
Date: | 2019-04-16 17:08:04 |
Message-ID: | ea6a2955-f207-161f-42d9-e7f13aba8d31@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/16/19 10:02 AM, Zahir Lalani wrote:
> Hi All
>
> New on this list!
>
> We have an existing postgres deployment which is showing some odd
> behaviour on Live. We use Navicat to manage it, and when we open a
What does Live refer to?
> specific table via navicat on live, it says we don’t have a primary
> index – although the design view does show it. We have auto deployment
> scripts between environments, and none of the other environments show
> this. Doing a structure dump shows that there is indeed a primary index:
>
> CREATE TABLE "public"."briefs_master" (
>
> "id" int4 NOT NULL DEFAULT nextval('briefs_master_id_seq'::regclass),
>
> …..
>
> "ext_system_ref" varchar(255) COLLATE "pg_catalog"."default"
>
> …..
>
> ALTER TABLE "public"."briefs_master" ADD CONSTRAINT "briefs_master_pkey"
> PRIMARY KEY ("id");
>
> However, we are seeing very strange behaviour on live. We can search via
> the ID field just fine. Searching on ext_system_ref returns no records.
>
> If I manually add data to the ext field, it then queries correctly. But
> as other records are added to the table, this field data disappears on
> the row I manually edited.
>
> We have run a reindex on the specific index as well as table. We have
> run a vacuum on the table. Nothing seems to resolve and we are quite
> confused as to what the issue could be. Any help and guidance would be
> most appreciated
>
> Regards
>
> Zahir
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Zahir Lalani | 2019-04-16 17:16:02 | RE: Possible corrupt index? |
Previous Message | Michael Lewis | 2019-04-16 17:05:51 | Re: Possible corrupt index? |