Re: Replacing uuid-ossp with uuid-freebsd

From: Jan de Visser <jan(at)de-visser(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
Subject: Re: Replacing uuid-ossp with uuid-freebsd
Date: 2015-05-25 14:31:43
Message-ID: 1436386.mQRLPreKgc@wolverine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On May 25, 2015 04:17:32 PM Piotr Gasidło wrote:
> test_uuid=# drop extension "uuid-ossp";
> ERROR: cannot drop extension uuid-ossp because other
objects depend on it
> DETAIL: default for table test column id depends on function
> uuid_generate_v4() HINT: Use DROP ... CASCADE to drop the
dependent
> objects too.

Wouldn't a simple ALTER TABLE to change/drop the default of the
id column do?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2015-05-25 14:41:05 Re: Queries for unused/useless indexes
Previous Message Adrian Klaver 2015-05-25 14:28:46 Re: Replacing uuid-ossp with uuid-freebsd