http://www.slony.info/bugzilla/show_bug.cgi?id=73

           Summary: Slony-I: old key column xxx.yyy IS NULL on UPDATE
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: blocker
          Priority: urgent
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: tbe at boreus.de
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Database statements breaks with the following error:

Slony-I: old key column product.pictureurl IS NULL on UPDATE

The columns are NO Key-Columns!

Statement: UPDATE product.product SET w3s_export_hash=:hash WHERE id=:id

Table:

                      Tabelle »product.product«
         Spalte         |             Typ             |  Attribute
------------------------+-----------------------------+--------------
 id                     | bigint                      | not null
 name                   | character varying(300)      |
 manufacturer_id        | bigint                      |
 category_id            | bigint                      |
 clickcount             | bigint                      |
 offercount             | bigint                      |
 minprice               | real                        |
 maxprice               | real                        |
 url                    | character varying(300)      |
 pictureurl             | character varying(300)      |
 search_keys            | text                        |
 description            | text                        |
 user_rating            | integer                     | default (-1)
 cb_test_result         | integer                     |
 alias_id               | bigint                      |
 complete_solution_url  | character varying(300)      |
 complete_solution_date | date                        |
 ir_url                 | character varying(300)      |
 ir_beitrags_id         | bigint                      | default 0
 w3s_export_hash        | character varying(255)      |
 lastmodification       | timestamp without time zone |
 fazit_cb               | text                        |
 fazit_cbs              | text                        |
 fazit_avf              | text                        |
 cb_grade               | real                        | default (-1)
 cbs_grade              | real                        | default (-1)
 avf_grade              | real                        | default (-1)
 testfazit_positiv      | text                        |
 testfazit_negativ      | text                        |
 testartikel_url        | character varying(255)      |
 testartikel_datum      | timestamp without time zone |
 ir_import_hash         | character varying(32)       |
Indexe:
    »pk_product« PRIMARY KEY, btree (id)
    »idx_ir_beitrags_id« btree (ir_beitrags_id)
    »idx_product_alias_id« btree (alias_id)
    »idx_product_category_id« btree (category_id)
    »idx_product_empty_complete_solution_url« btree
(complete_solution_url) WHERE complete_solution_url IS NOT NULL AND
complete_solution_url::text <> ''::text
    »idx_product_id_name« btree (id, name)
    »idx_product_id_name_ir_url« btree (id, name, ir_url)
    »idx_product_manufacturer_id« btree (manufacturer_id)
    »idx_product_product_ir_url« btree (id, name, ir_url)
    »idx_product_user_rating« btree (user_rating)
Fremdschlüssel-Constraints:
    »fk_product_manufacturer_id« FOREIGN KEY (manufacturer_id) REFERENCES
product.manufacturer(id)
    »fk_product_ref_133_category« FOREIGN KEY (category_id) REFERENCES
product.category(id) ON UPDATE SET NULL ON DELETE SET NULL
Trigger:
    _cpdb_cluster_logtrigger AFTER INSERT OR DELETE OR UPDATE ON
product.product FOR EACH ROW EXECUTE PROCEDURE
_cpdb_cluster.logtrigger('_cpdb_cluster', '19', 'k')
Abgeschaltete Trigger:
    _cpdb_cluster_denyaccess BEFORE INSERT OR DELETE OR UPDATE ON
product.product FOR EACH ROW EXECUTE PROCEDURE
_cpdb_cluster.denyaccess('_cpdb_cluster')


Versions:
postgres at cbcpdb1:~$ slon -v
slon version 2.0.0

postgres at cbcpdb1:~$ psql --version
psql (PostgreSQL) 8.3.5


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.