[Pgpool-general] replicate_def_pgbench.sql

[Addison Pan]

update:

1. modified the replicate_def_pgbench.sql so that replicate_def becomes dist_def

result of replicate_def_pgbench.sql run:

ERROR: column "col_name" is of type text but expression is of type text[]

did a check of the pgpool_catalog.dist_def and saw that there was data put in:

 bench_parallel | public      | branches  
 bench_parallel | public      | tellers    

question:

1. so does that mean the insert worked from the replicate_def_pgbench.sql ?

2. I tested out data from the tutorial page

http://pgpool.projects.postgresql.org/tutorial-en.html

and completed going through the tutorial.  And did a check via the shell script shown at the end of the tutorial page, it all seemed well.  So what affect did the error in the replicate_def_pgbench.sql statement have?

Thanks

Addison Pan <addisonp at yahoo.com> wrote: When i do the command

psql -f replicate_def_pgbench.sql -p 5432 pgpool 

I get the following errors

psql:/usr/share/postgresql-pgpool-II/replicate_def_pgbench.sql:7 ERROR: relation "pgpool_catalog.replicate_def" does not exist
psql:/usr/share/postgresql-pgpool-II/replicate_def_pgbench.sql:15: ERROR: column "col_name" is of type text but expression is of type text[]

here's a copy of the script that I'm using (I believe it matches up to the tutorial page on pgpool)

INSERT INTO pgpool_catalog.replicate_def VALUES (
    'bench_parallel',
    'public',
    'branches',
    ARRAY['bid', 'bbalance', 'filler'],
    ARRAY['integer', 'integer', 'character(88)']
);

INSERT INTO pgpool_catalog.dist_def VALUES (
    'bench_parallel',
    'public',
    'tellers',
    ARRAY['tid',  'bid', 'tbalance', 'filler'],
    ARRAY['integer', 'integer', 'integer', 'character(84)']
);

-Addison
        

---------------------------------
Looking for last minute shopping deals?   Find them fast with Yahoo! Search._______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general


       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080326/635324a4/attachment.html