Comments (7)
We cut the values for a while now: #26755
The field calendarobjects_props.value
has been created as varchar(255) since the start.
Does pqsql do not enforce a limit?
from server.
As much as I like the idea of only supporting one database, it's not planned, and we deal with the challenges as best as possible (e.g. chunking for in clauses with more than 1000 values).
Moreover, there are many aspects to consider. For example, our database layer also does not support vendor-specific queries: doctrine/dbal#2972.
We have a limit schema and code-wise, and there are no rows in your table with value > 255.
What are we supposed to do?
from server.
Does pqsql do not enforce a limit?
Not sure how I would go about determining that, since....
select * from oc_calendarobjects_props where length(value) > 255;
Returns zero rows.
But obviously it seems to still get dumped when using pg_dump
becuase the pg_restore
fails.
So maybe the enforcement is silent ? The pg docs are silent on the subject.
from server.
What PostgreSQL version(s) are involved here?
If you do an SQL style dump (i.e. w/o using the -Fc
parameter), what does that row's value column actually look like?
The restore shouldn't exceed the length since the dump presumably shouldn't either.
You should not be using varchar with Postgresql, ESPECIALLY varchar(255) !! It is well documented to just use text:
That same reference also states when one might want to use it. It's not a black and white matter. Also, keep in mind we support multiple databases so there are other factors.
from server.
What PostgreSQL version(s) are involved here?
Export from 14, import to 16
That same reference also states when one might want to use it.
It also shows that if you still want a limit, using a check constraint on text
is the way to go.
keep in mind we support multiple databases
I don't buy that argument.
People who think "generic" or "portable" schemas exist and don't make use of database specific features usually end up being the same people who complain the database is "slow" and then go introducing an over-complicated caching layer in-between because that's what they think they need. Its demonstrated time after time.
Make use of the features the developers of databases have made available for you. Whether it be database-specific indexes or anything else. This is perhaps particularly the case with postgres that has a great deal of features that people have put a great deal of time and effort into designing and refining to make postgres one of the best open-source databases out there.
A database is not a generic term for a dumb black-box.
from server.
That's all great, but since things are already <255 you have a mystery here at either the source or the receiving end.
Did you try looking at the data itself or doing an SQL style dump as I suggested?
Export from 14, import to 16
What versions, precisely?
This may need to be reported to PostgreSQL (depending) or it may already be addressed.
from server.
This issue has been automatically marked as stale because it has not had recent activity and seems to be missing some essential information. It will be closed if no further activity occurs. Thank you for your contributions.
from server.
Related Issues (20)
- [Bug]: Nextcloud only downloads .php.html files HOT 4
- [Bug]: Move files in the browser doesn't work
- [Bug]: iphone display error - empty content HOT 1
- i18n: Source strings are not understandable for translators and need improvements HOT 1
- When changing file extension ask for confirmation
- [Bug]: Talk Stun Server do not generate any request to connect HOT 1
- [Bug]: Unable to delete a file whose name begins with an emoji in a renamed directory
- Mail Server Account Creation/Deletion Support
- [Bug]: "X minutes ago" should switch to "An hour ago" a lot earlier HOT 3
- Restrict file extension / mime type for file drop share
- [Bug]: Dashboard with default background shows low resolution logo as full size background HOT 14
- [Bug]: Increased space between apps and name when hovering the apps menu HOT 3
- [Bug]: files_external:scan not work if mountpoint have $user in the path
- Expensive share queries called multiple times
- [Bug]: Appstore: Exception array_map(): Argument #2 ($array) must be of type array, null given
- [UnifiedSearch] Allow to optionally disable available SearchProviders and/or set custom prefix-trigger
- [Bug]: Deletion of user does not request password and fails silently
- [App Files] Guest user sees himself with superadmin's mail address in the share menu for a Group Folder
- [App Files] Rights display for a Group Folder sync issue when changing the permissions' rules
- [Bug]: sqlite3 configured to only use mmap, no fallback to regular IO
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from server.