On Tue, Nov 6, 2012 at 3:07 PM, Deron <fecastle@xxxxxxxxx> wrote: > We are looking at integrating a 3rd party application. They currently use > MySQL for their database solution. We are asking them to see about porting > to PostgreSQL. One of the issues they are running into is that they use > MySQL "BLACKHOLE" storage engine. > > I don't honestly know what this is used for. Of course I did know what > /dev/null was used for until I started using it. So maybe this has some > merit? Is there some sort of equivelent structure in PG? You can create a row-level BEFORE INSERT trigger on a table that does nothing but RETURN NULL. In this case all the inserts into this table will be ignored. > > http://dev.mysql.com/doc/refman/5.0/en/blackhole-storage-engine.html > > Thanks, > > Deron -- Sergey Konoplev a database and software architect http://www.linkedin.com/in/grayhemp Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +14158679984 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
