jiaqizho commented on PR #1044:
URL: https://github.com/apache/cloudberry/pull/1044#issuecomment-2800549130
>
> So, this already fixed? Ok. Locally I removed std::move - and it compiles
ok.
>
> Next step, i get errors:
>
> ```
>
> reshke@yezzey-cbdb-bench:~/cloudberry$ createdb
> psql
> reshke@yezzey-cbdb-bench:~/cloudberry$ psql
> psql (14.4, server 14.4)
> Type "help" for help.
>
> reshke=# set allow_system_table_mods to true;
> SET
> reshke=# \i
/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:3:
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named
'relid' as the Apache Cloudberry data distribution key for this table.
> HINT: The 'DISTRIBUTED BY' clause determines the distribution of data.
Make sure column(s) chosen are the optimal data distribution key to minimize
skew.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:3:
ERROR: relation "pg_pax_tables" already exists
> DELETE 0
> UPDATE 1
> UPDATE 0
> UPDATE 10
> UPDATE 1
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:15:
ERROR: relation "pg_pax_tables_relid_index" already exists
> UPDATE 1
> UPDATE 1
> UPDATE 1
> UPDATE 1
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:27:
ERROR: duplicate key value violates unique constraint "pg_proc_oid_index"
> DETAIL: Key (oid)=(7600) already exists.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:28:
ERROR: duplicate key value violates unique constraint "pg_am_name_index"
> DETAIL: Key (amname)=(pax) already exists.
> COMMENT
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:30:
ERROR: duplicate key value violates unique constraint "pg_proc_oid_index"
> DETAIL: Key (oid)=(7601) already exists.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:31:
ERROR: duplicate key value violates unique constraint "pg_proc_oid_index"
> DETAIL: Key (oid)=(7602) already exists.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:32:
ERROR: duplicate key value violates unique constraint "pg_type_oid_index"
> DETAIL: Key (oid)=(7603) already exists.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:34:
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named
'objid' as the Apache Cloudberry data distribution key for this table.
> HINT: The 'DISTRIBUTED BY' clause determines the distribution of data.
Make sure column(s) chosen are the optimal data distribution key to minimize
skew.
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:34:
ERROR: relation "pg_pax_fastsequence" already exists
> psql:/usr/local/cbdb/share/postgresql/cdb_init.d/pax-cdbinit--1.0.sql:35:
ERROR: relation "pg_pax_fastsequence_objid_idx" already exists
> UPDATE 0
> UPDATE 1
> UPDATE 0
> UPDATE 1
> UPDATE 10
> UPDATE 1
> UPDATE 1
> UPDATE 1
> UPDATE 1
> reshke=# select ^C
> reshke=# select * from pg_proc where oid = 7600;
> oid | proname | pronamespace | proowner | prolang | procost
| prorows | provariadic | prosupport | prokind | prosecdef | proleakproof |
proisstrict | proretset | provolatile | proparallel |
> pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes |
proargmodes | proargnames | proargdefaults | protrftypes | prosrc
| probin | prosqlbody | proconfig | proacl | pr
> odataaccess | proexeclocation
>
------+---------------------+--------------+----------+---------+---------+---------+-------------+------------+---------+-----------+--------------+-------------+-----------+-------------+-------------+-
>
---------+-----------------+------------+-------------+----------------+-------------+-------------+----------------+-------------+---------------------+-------------+------------+-----------+--------+---
> ------------+-----------------
> 7600 | pax_tableam_handler | 11 | 10 | 13 | 1
| 0 | 0 | - | f | f | f | t
| f | s | u |
> 1 | 0 | 269 | 2281 | |
| | | | pax_tableam_handler |
$libdir/pax | | | | n
> | a
> (1 row)
> ```
>
> But creating/inserting into pax table works after this, so maybe this
errors do not change much.
not finished yet, It is still under discussion. If you are interested, you
can submit the PR after the current PR merge (after pax merge). :)
You don't need exec the `pax-cdbinit--1.0.sql`, the sql script will be exec
if pax enabled. So u can direct use the PAX as table access method.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@cloudberry.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cloudberry.apache.org
For additional commands, e-mail: commits-h...@cloudberry.apache.org
