Questions tagged [postgresql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Problem with entry relations in using craft + postgres

I have a custom module saving entries into the system and those entries contains several category relationships. I have done the same previously with MySql and never had problems. I am currently ...
2
votes
1answer
98 views

Is there a way to convert a Craft MySQL database to PostgreSQL?

I have an existing Craft installation using MySQL and I've only recently realized the error of my ways and would like to convert the database to PostgreSQL. Is this possible?
0
votes
0answers
61 views

SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535

{% set entryIds = craft.entries ({ section: 'locations' }).ids() %} {% set cities = craft.categories ({ descendantOf: category, ...
3
votes
2answers
77 views

Migrate Craft CMS installation from PgSQL to MySQL - any hints?

We need to migrate a Craft installation with a pgsql dump to MySQL. Any hints on the procedure? Thanks, Matthias
0
votes
0answers
103 views

Custom Elements + Joins

I'm having a bit of trouble wrapping my head around an SQL issue with a custom Element. One column in my Element's table—for the case of this question, let's call it myplugin_things—has a foreign key ...
1
vote
2answers
201 views

How do you deploy Craft 3 on Heroku with Postgres?

I'm relatively new to Craft 3, and am able to run Craft locally with a Postgres db and Valet as my server. When I try to deploy to Heroku, I run into issues with (I think) Postgres. Background I ...
1
vote
1answer
300 views

Integrity constraint violation - Not null violation

Looking for some help here - I'm working on a site that is using a PostgreSQL db and am running into an issue. When saving a large Matrix field with multiple block types I was receiving the following ...
1
vote
1answer
333 views

Install Failed - Numerous Errors when running with pgsql

Getting Numerous errors when trying to test a staging environment with Craft 3.1. States Install Failed - Check Logs which I have and I'm seeing the following logs being given. I don't understand what'...
1
vote
1answer
50 views

SQL Error (Feed Me) when matching entries

I'm currently getting the following error when matching on an entry field. Offers Test: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown LINE 3: WHERE "id" ...
2
votes
1answer
1k views

Craft 3 : What are the advantages to use PostgreSQL and when should I use it instead of MySQL?

Craft 3 now supports PostgreSQL. I know this a very general question, but: I have absolutely no experience with PostgreSQL I don't know when should I use it instead of MySQL To quote Bob Olde ...