Re: [NOVICE] ERROR: expected one dependency record for TOAST table, found 0

From: Dean Montgomery <dmonty(at)sd73(dot)bc(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] ERROR: expected one dependency record for TOAST table, found 0
Date: 2017-11-20 20:12:16
Message-ID: 902315348.25959506.1511208736351.JavaMail.zimbra@zimbra.sd73.bc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Solved by dumping, dropping, then re-importing the table.

pg_dump -f v_users.sql -d fusionpbx -t v_users
DROP INDEX v_users_pkey;
DROP TABLE v_users;
cat v_users.sql | psql fusionpbx

----- Original Message -----
> I'm getting an error while trying to add a column to a table.
>
> ALTER TABLE v_users ADD COLUMN ldap_id SERIAL UNIQUE;
> ERROR: expected one dependency record for TOAST table, found 0
>
> Any ideas?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Craig H 2017-11-24 17:08:10 macOS ownership and premissions
Previous Message Stephen Frost 2017-11-20 15:34:02 Re: [ADMIN] Migration to pglister - Before