Am Montag, den 23.10.2006, 21:55 +0300 schrieb Mikko Partio:
> Hello,
> 
> I just recently upgraded to 1.2.0, and when I drop sets or do a 
> switchover, slonik produces strange notices about missing indices (see 
> below). I didn't see these with 1.1.5. Should I be worried (even though 
> they are just notices)?

Yes and no. Guess 1.2 would by default create these, but when upgrading,
you'll need to add these yourself. 

Andreas
> 
> MP
> 
> 
> After drop set:
> 
> <stdin>:4: NOTICE:  Consider adding partial index 
> PartInd_lit_sl_log_2-node-1 on sl_log_2
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "dropset_int" line 40 at perform
> SQL statement "SELECT  "_lit".dropSet_int( $1 )"
> PL/pgSQL function "dropset" line 26 at perform
> <stdin>:4: NOTICE:  schema: [_lit] tablename:[sl_log_2]
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "dropset_int" line 40 at perform
> SQL statement "SELECT  "_lit".dropSet_int( $1 )"
> PL/pgSQL function "dropset" line 26 at perform
> <stdin>:4: NOTICE:  index was not found - add it!
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "dropset_int" line 40 at perform
> SQL statement "SELECT  "_lit".dropSet_int( $1 )"
> PL/pgSQL function "dropset" line 26 at perform
> 
> 
> After switchover:
> 
> <stdin>:6: NOTICE:  Consider adding partial index 
> PartInd_lit_sl_log_2-node-2 on sl_log_2
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "moveset_int" line 169 at perform
> SQL statement "SELECT  "_lit".moveSet_int( $1 ,  $2 ,  $3 , 0)"
> PL/pgSQL function "moveset" line 61 at perform
> <stdin>:6: NOTICE:  schema: [_lit] tablename:[sl_log_2]
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "moveset_int" line 169 at perform
> SQL statement "SELECT  "_lit".moveSet_int( $1 ,  $2 ,  $3 , 0)"
> PL/pgSQL function "moveset" line 61 at perform
> <stdin>:6: NOTICE:  index was not found - add it!
> CONTEXT:  SQL statement "SELECT  "_lit".addPartialLogIndices()"
> PL/pgSQL function "moveset_int" line 169 at perform
> SQL statement "SELECT  "_lit".moveSet_int( $1 ,  $2 ,  $3 , 0)"
> PL/pgSQL function "moveset" line 61 at perform
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061023/7374c229/attachment.bin