query: INSERT INTO aggregator_feed (title, url, refresh, block, description) VALUES ('Brenda''s Blog', 'http://coffee.geek.nz/rss.xml', 900, 5, '') in /home/brenda/projects/drupal/HEAD/modules/aggregator/aggregator.module on line 371.
pg_query(): Query failed: ERROR: null value in column "image" violates not-null constraint in /home/brenda/projects/drupal/HEAD/includes/database.pgsql.inc on line 155.

schema for this column is 

      'image'       => array('type' => 'text', 'not null' => TRUE, 'size' => 'big'),

needs a default it seems.

CommentFileSizeAuthor
#4 aggregator_feed_insert-174348-4.patch858 byteschx
#1 aggregator.schema.patch1.16 KBShiny

Comments

Shiny’s picture

Shiny commented
Assigned: Unassigned » Shiny
StatusFileSize
new aggregator.schema.patch1.16 KB

patch attached.

Shiny’s picture

Shiny commented
Status: Active » Needs review
Shiny’s picture

Shiny commented
Status: Needs review » Needs work

alas, mysql doesn't support default values on text fields

chx’s picture

chx commented
Assigned: Shiny » chx
Status: Needs work » Needs review
StatusFileSize
new aggregator_feed_insert-174348-4.patch858 bytes

It's a lot simpler to fix the insert than the schema.

johnhelen’s picture

johnhelen commented

The patch is applied successfully with php 5.1.6, postgres 7.4 and drupal 6.0-dev

Shiny’s picture

Shiny commented
Status: Needs review » Reviewed & tested by the community

bug fixed for php5, pg8.2

gábor hojtsy’s picture

gábor hojtsy
he/him
Primary language Hungarian
Location Hungary
commented
Status: Reviewed & tested by the community » Fixed

Thanks, committed.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)