I tried switching over to using Feedmanager and have discovered that it simply doesn't work with PostgreSQL as the backend. As noted elsewhere, the update for exiting aggregator feeds doesn't work and you have to delete and recreate them. But before that, there are problems with the tables not being modified correctly. And once I did the alter table commands by hand, and recreated a couple of my feeds, I tried to update them. Then I discovered some gratuitous renaming for the sequence on the table from aggregator_iid_seq to feedparser_iid_seq so I created that sequence. The I found the syntax for actually inserting rows into the database is clearly standard adn fails with postgres, too. I believe all databases support the standard insert syntax, so I really don't know why it is using
insert into aggregator_node set iid =1, nid = 133, fid = ...
which is more like standard update syntax. It should just say
insert into aggregator_node (iid, nid, fid, ...) values (1, 133, 24, ...)
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | feedparser.patch | 4.77 KB | rbroberts |
Comments
Comment #1
rbroberts commentedPatch attached for feedmanager.install, feedaggregator_node.install, and feedaggregator_node.module. The former two are not properly tested since I had already made the fixes by hand.