How can i create a vertex having more than 50 properties.

[uditsharma]

I ran the sample add vertex having 51 properties, and it failed with below error.

SELECT * FROM cypher('my_graph', $$ CREATE (:MyLabel { prop1: 'value1', prop2: 'value2', prop3: 'value3', prop4: 'value4', prop5: 'value5', prop6: 'value6', prop7: 'value7', prop8: 'value8', prop9: 'value9', prop10: 'value10', prop11: 'value11', prop12: 'value12', prop13: 'value13', prop14: 'value14', prop15: 'value15', prop16: 'value16', prop17: 'value17', prop18: 'value18', prop19: 'value19', prop20: 'value20', prop21: 'value21', prop22: 'value22', prop23: 'value23', prop24: 'value24', prop25: 'value25', prop26: 'value26', prop27: 'value27', prop28: 'value28', prop29: 'value29', prop30: 'value30', prop31: 'value31', prop32: 'value32', prop33: 'value33', prop34: 'value34', prop35: 'value35', prop36: 'value36', prop37: 'value37', prop38: 'value38', prop39: 'value39', prop40: 'value40', prop41: 'value41', prop42: 'value42', prop43: 'value43', prop44: 'value44', prop45: 'value45', prop46: 'value46', prop47: 'value47', prop48: 'value48', prop49: 'value49', prop50: 'value50', prop51: 'value51' }) $$) AS (v agtype); ERROR: cannot pass more than 100 arguments to a function

Is there a workaround this ? how can i upsert a vertex so many properties.

[jrgemignani]

@uditsharma What version of AGE are you using? What version of PostgreSQL are you using?

[uditsharma]

@jrgemignani I am using Age Extension version = 1.5.0 and my posgres version is PostgreSQL 16.3.

Btw i am running Age via Docker.

docker run \ --name age \ -p 5455:5432 \ -e POSTGRES_USER=postgresUser \ -e POSTGRES_PASSWORD=postgresPW \ -e POSTGRES_DB=postgresDB \ -d \ apache/age

[jrgemignani]

@uditsharma The latest, 1.6.0 has now been released. I did verify that this was resolved in 1.6.0. Can you try that one?

edit: Additionally, I have made sure that Dockerhub has the latest set to PG16 1.6.0, for now.