Tabish Sarwar tabish.sarwar
Mon Sep 13 12:16:08 PDT 2004
I tried configuring the slony pereojct but the problem is in the time
stamp please help me how should i resolve this .
Here is what comes on console when i ran the configuration script as
listed on the site.

NOTICE:  type "_proto.xxid" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type _proto.xxid is only a shell
NOTICE:  type "_proto.xxid_snapshot" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type _proto.xxid_snapshot is only a shell
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_node-pkey" for table "sl_node"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_set-pkey" for table "sl_set"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_setsync-pkey" for table "sl_setsync"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_table-pkey" for table "sl_table"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"sl_table_tab_reloid_key" for table "sl_table"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_trigger-pkey" for table "sl_trigger"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_sequence-pkey" for table "sl_sequence"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"sl_sequence_seq_reloid_key" for table "sl_sequence"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_path-pkey" for table "sl_path"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_listen-pkey" for table "sl_listen"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_subscribe-pkey" for table "sl_subscribe"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_event-pkey" for table "sl_event"
NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index
"history__Slony-I_proto_rowID_key" for table "history"
CONTEXT:  PL/pgSQL function "determineattkindserial" line 52 at
execute statement
NOTICE:  type "_proto.xxid" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type _proto.xxid is only a shell
NOTICE:  type "_proto.xxid_snapshot" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type _proto.xxid_snapshot is only a shell
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_node-pkey" for table "sl_node"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_set-pkey" for table "sl_set"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_setsync-pkey" for table "sl_setsync"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_table-pkey" for table "sl_table"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"sl_table_tab_reloid_key" for table "sl_table"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_trigger-pkey" for table "sl_trigger"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_sequence-pkey" for table "sl_sequence"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"sl_sequence_seq_reloid_key" for table "sl_sequence"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_path-pkey" for table "sl_path"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_listen-pkey" for table "sl_listen"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_subscribe-pkey" for table "sl_subscribe"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"sl_event-pkey" for table "sl_event"
ERROR:  invalid input syntax for type timestamp: "Mon Aug 15
15:05:17.023748 2005 PKST"
CONTEXT:  PL/pgSQL function "enablenode_int" line 32 at SQL statement


Any help will be highly appreciated!

Regards,
tabish


More information about the Slony1-general mailing list