The cast from int to bit that exists in pg_cast is only good for explicit casts, so would truncate user's value instead of flagging it as invalid input, and this whole discussion is about not doing that. With the DEFAULT expression specified or interpreted as a text string, we don't h...
Add an additional hstore (key/value) column containing all tags that start with the specified string, eg --hstore-column "name:" will produce an extra hstore column that contains all name:xx tags --hstore-match-only Only keep objects that have a value in one of the columns (normal ...
long time ago that this tie-breaking >> strategy was insane, and that the rule should be to prefer canonical >> names and use something else only in the case of a strictly better >> match. Tom
Secondly, I trust plpgsql mainly because it's being used by a lot of people in a lot of production systems, the same would not hold true for plpgsql2 for the first years of existence, so we who would use it in production systems must understand every single line of code changed and fe...
Thanks for looking at it! > > +static void > +ValidateAndRestoreSnapshotFile(XLogRecPtr lsn, SnapBuildOnDisk *ondisk, > + const char *path) > > This function and SnapBuildRestore() have duplicate codes. Can we have > a common function that reads the snapshot data from disk to > ...
In order to do manual conversions with proj, you need not enter the whole SRS string. Because proj already has the list of EPSG projections, you can use the option +init=epsg:index instead. The default OpenStreetmap rendering style for Mapnik assumes the default (Pseudo-Mercator) projection,...
+ * GUC check_hook for log_suppress_errcodes + */ +bool +check_log_suppress_errcodes(char **newval, void **extra, GucSource source) +{ + /* SplitIdentifierString modifies the string */ + char *new_copy = pstrdup(*newval); ...
+ fkconstraint->old_pktable_oid = InvalidOid; + fkconstraint->location = -1; + + attmap = build_attrmap_by_name(RelationGetDescr(partRel), + RelationGetDescr(rel), + false); + for (int i = 0; i < numfks; i++) + { ...
* Subroutine for cache_locale_time(). * Convert the given string from encoding "encoding" to the database @@ -829,10 +772,7 @@ cache_locale_time(void) bool strftimefail = false; int encoding; int i; - char *save_lc_time;
Please, find in attachment the same set of patch for REL_17_STABLE. Regards, >From 976fa1abff9da882ddf63636e3cb3ceec105dc57 Mon Sep 17 00:00:00 2001 From: Jehan-Guillaume de Rorthais <j...@dalibo.com> Date: Mon, 23 Sep 2024 18:50:20 +0200 Subject: [PATCH v3-17 1/4] ...