Re: [GENERAL] psql doesn't pass on exported shell environment functions

2017-07-07 Thread Tom Lane
o break. It would be interesting to capture the output of "env" in the sub-shell to see which environment variables and functions are getting through. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change

Re: [GENERAL] Modified rows are not marked as dead and as such vacuum is unable to clean them up

2017-07-06 Thread Tom Lane
data is not marked as dead after updates, Have you checked for uncommitted prepared transactions? If "select * from pg_prepared_xacts" finds anything, that's probably your problem. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [GENERAL] CREATE AGGREGATE on jsonb concat

2017-07-06 Thread Tom Lane
> same thing? It just feels like such an obvious feature. Doesn't jsonb_agg() do exactly that? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

2017-07-05 Thread Tom Lane
r...@bb-c.de (Rainer J.H. Brandt) writes: > Tom Lane writes: >> The whole thing's odd though --- certainly many people are building >> PG successfully on macOS. There's got to be something unusual about >> Rainer's build environment, but what? > I thought so, too, bu

Re: [GENERAL] building extension with large string inserts

2017-07-05 Thread Tom van Tilburg
You are right! I totally forgot about this dollar quoting :) Typically one of those things you will only remember the hard way ;-) Thanks a lot, Tom On Wed, Jul 5, 2017 at 5:08 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Tom van Tilburg <tom.van.tilb...@gmail.com> writes

Re: [GENERAL] building extension with large string inserts

2017-07-05 Thread Tom Lane
Tom van Tilburg <tom.van.tilb...@gmail.com> writes: > I think I misunderstand. How would that help my insert statement? > You would get INSERT INTO mytable VALUES ($ javascript with a lot of > unescaped characters like /n " // etc. $); Sure, but in a dollar-quoted literal you

Re: [GENERAL] building extension with large string inserts

2017-07-05 Thread Tom van Tilburg
I think I misunderstand. How would that help my insert statement? You would get INSERT INTO mytable VALUES ($ javascript with a lot of unescaped characters like /n " // etc. $); and: Am I correct that INSERTS are the way to go in extensions? Best, Tom vT. On Wed, Jul 5, 2017 at 4:57 PM

Re: [GENERAL] building extension with large string inserts

2017-07-05 Thread Tom Lane
Tom van Tilburg <tom.van.tilb...@gmail.com> writes: > I am trying to build an extension where there is the need to insert large > strings consisting of javascript code. > ... > What would be a proper way to get this code into a table via an extension? > I've been working

[GENERAL] building extension with large string inserts

2017-07-05 Thread Tom van Tilburg
for the extension's sql file but it seems a tedious job to escape the code myself. Best, Tom

Re: [GENERAL] Imperative Query Languages

2017-07-05 Thread Tom Lane
op and maintain. People were more excited about spending human effort to save machine cycles forty years ago than they are today. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

2017-07-04 Thread Tom Lane
build environment, but what? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

2017-07-04 Thread Tom Lane
error, > and everything works fine. Unfortunately, I need the 64-bit version. This makes little sense to me. 64-bit builds have been the default on macOS for some time. It's possible that by overriding LDFLAGS you're removing linker switches that need to be there ...

Re: [GENERAL] Invalid field size

2017-07-04 Thread Tom Lane
"Daniel Verite" <dan...@manitou-mail.org> writes: > Tom Lane wrote: >> If it is a newline-conversion problem, compressed pg_dump archives would >> be just as subject to corruption as your binary COPY file is. > It's mentioned in [1] that the signatu

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size

2017-07-04 Thread Tom Lane
e careful about how you do the cross-machine file transfers. I suspect what is really happening is you're not always doing that the same way, and that some of the methods allow a newline conversion to happen to the file while others don't. regards, tom lane -- Sent

Re: [GENERAL] Invalid field size

2017-07-04 Thread Tom Lane
Moreno Andreo <moreno.and...@evolu-s.it> writes: > Il 04/07/2017 16:51, Tom Lane ha scritto: >> Pushing binary data around on Windows is always a hazardous proposition. > So what you are saying is "in the last 5 years you've been extremely > lucky?" :-) Yup, pa

Re: [GENERAL] Invalid field size

2017-07-04 Thread Tom Lane
length words used in binary-COPY format to contain such bytes. You might be better off using plain text COPY format; it can withstand this sort of thing much better. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Text search dictionary vs. the C locale

2017-07-02 Thread Tom Lane
ike it'd often be useful to load dictionary files that don't match the database's prevailing locale. Do we really need the t_isalpha tests, or would it be good enough to assume that anything that isn't t_isspace is part of a word? regards, tom lane -- Sent via pgsql-g

Re: [GENERAL] 9.6 parameters messing up my 9.2 pg_dump/pg_restore

2017-06-28 Thread Tom Lane
at would allow the restore to ignore the new parameters and move on. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] LEFT JOIN, entry can not be referenced

2017-06-26 Thread Tom Lane
hat first ON clause can only refer to "u" and "d", because only those two tables are in-scope for it. There are other RDBMSes (mumble ... ancient mysql versions ... mumble) that give the commas a different syntactic priority and would allow that ON clause to reference "wl"

Re: [GENERAL] Config for fast huge cascaded updates

2017-06-26 Thread Tom Lane
dvance, it's worth considering. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] When inserting from a SELECT with an ORDER BY, are the inserts (and associated triggers) applied in order?

2017-06-26 Thread Tom Lane
t the moment. > It looks like inserts aren't applied in order, and I'm wondering if this is > something I should expect. Hard to comment on that without seeing your test case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

2017-06-22 Thread Tom Lane
at file, and it wasn't the postmaster. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] SPI_execute_plan and vardata

2017-06-22 Thread Tom Lane
tice would be Values[1] = CStringGetTextDatum(char-*-ptr); regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 10beta1 role

2017-06-22 Thread Tom Lane
er than your OS name. Nobody's particularly felt the need though, since the log message is harmless. [ pokes at it a bit... ] Actually, you don't need a -U switch, because setting PGUSER in pg_ctl's environment works. regards, tom lane -- Sent via pgsql-general mailing

Re: [GENERAL] Table Updatable By Trigger Only

2017-06-20 Thread Tom Lane
ole that has permissions to change table B. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED

2017-06-19 Thread Tom Lane
ue? https://wiki.postgresql.org/wiki/Guide_to_reporting_problems regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] inheritence children with integer columns of differing width

2017-06-19 Thread Tom Lane
hat's the point of letting the child column type be different? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Connection options

2017-06-15 Thread Tom Lane
The point of the libpq "options" argument is that you can pass server settings using that same switch syntax, for settings you'd be allowed to change at runtime. This is obsolete legacy stuff; all of the available options can be set with SET commands, and that's the preferred way to do

Re: [GENERAL] Freeing memory in native extension in case of error

2017-06-15 Thread Tom Lane
you're trying to cache data across rows, or in even longer-lived ways, that you really need to be careful. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Tom Lane
lts might be inconsistent. Either one will add some complexity to your application code. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-13 Thread Tom Lane
t doesn't offer much to go on in terms of being able to make a more reproducible case. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: type " " does not exist

2017-06-12 Thread Tom Lane
me non-breaking spaces, or other weird stuff that didn't show up in your email? I find it a bit fishy that it looks like there's two spaces after "resigned at the score" in your function text, but only one in the error message. regards, tom lane -- Sent via p

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-12 Thread Tom Lane
a tablespace? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-12 Thread Tom Lane
k that Harry is testing against a master/slave setup not just a standalone server. Maybe that's not as irrelevant as it should be. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection

2017-06-11 Thread Tom Lane
e is okay. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-11 Thread Tom Lane
Do you know which binary mime types they won't reject? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection

2017-06-11 Thread Tom Lane
out how to explain that part; I suspected a cause of this form but couldn't make that theory match the 9-iterations observation. (I still can't.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Removing null bytes from a json column

2017-06-11 Thread Tom Lane
ion=# select '{"z":"\u0001"}'::json::text ~ '\\u'; ?column? -- f (1 row) It's true that we won't let you cast such a value to JSONB or do any exciting JSON-ish manipulations on it, but I'm not seeing an error in cast-to-text. regards, tom

Re: [GENERAL] Deadlock with single update statement?

2017-06-10 Thread Tom Lane
Rob Nikander <rob.nikan...@gmail.com> writes: >> On Jun 10, 2017, at 10:34 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> […] but it'd be better to adjust the query to ensure a deterministic >> update order. > Thank you for the answer. Since `update` has no `order by

Re: [GENERAL] Deadlock with single update statement?

2017-06-10 Thread Tom Lane
point, producing a different row locking order. If it's (B) you could ameliorate the problem by disabling syncscan, but it'd be better to adjust the query to ensure a deterministic update order. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Performance issue with Pointcloud extension

2017-06-09 Thread Tom Lane
-enable-cassert. The memory clobber stuff that's enabled by the latter is very good at turning coding errors into reproducible, debuggable crashes ;-) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-09 Thread Tom Lane
e do not hijack an existing thread to ask an unrelated question. Start a new thread (ie "compose" don't "reply") and use an appropriate subject line. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-08 Thread Tom Lane
ion that I'm not duplicating. Can you explain what sort of platform you're testing on, and what nondefault configuration settings you're using? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] Performance issue with Pointcloud extension

2017-06-08 Thread Tom Lane
s would be easier to credit if there are hooks both extensions try to get into. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_catalog tables don't have constraints?

2017-06-07 Thread Tom Lane
tions; but we don't really. You can do that, if you're a superuser who's willing to take risks, but our policy is that if you break the catalogs that way you get to keep both pieces. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)

2017-06-07 Thread Tom Lane
e tar format so nobody's bothered. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-07 Thread Tom Lane
Harry Ambrose <harry.ambr...@gmail.com> writes: > Tom - I can provide a jar that I have been using to replicate the issue. > Whats the best transport method to send it over? If it's not enormous, just send it as an email attachment. regards, tom lane -- Se

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

2017-06-07 Thread Tom Lane
following has been reported: > https://www.postgresql.org/message-id/20161201165505.4360.28...@wrigleys.postgresql.org That person never came back with a self-contained test case, either. https://wiki.postgresql.org/wiki/Guide_to_reporting_problems regards, tom lane -- S

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)

2017-06-05 Thread Tom Lane
e what you have here. The fact that those other tables would need to be restored first simply isn't visible to pg_dump. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] index duplicates primary key, but is used more?

2017-06-02 Thread Tom Lane
in any absolute sense; reindexing the older index would reverse that preference, at least for a time. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Slow query plan used

2017-06-02 Thread Tom Lane
"Wetzel, Juergen (Juergen)" <wet...@avaya.com> writes: > Tom Lane <t...@sss.pgh.pa.us> writes: >> You might get some traction by creating indexes on lower(searchfield1) etc. > I will try that. Does that mean the column statistics will only be collected > when

Re: [GENERAL] Slow query plan used

2017-06-01 Thread Tom Lane
collect stats. But if you have other queries with more selective LIKE patterns then maybe a trigram index in particular is worthwhile. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

2017-05-31 Thread Tom Lane
t least "make clean" and preferably "make distclean" before reconfiguring. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

2017-05-31 Thread Tom Lane
n is? Alternatively, if you're attempting to overwrite an old installation, did you remember to restart the server? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 9.5 "chained equality" behavior

2017-05-30 Thread Tom Lane
ems much more likely that people writing that are making a mistake. We discussed the associativity-of-= issue in the thread leading up to that patch, https://www.postgresql.org/message-id/flat/12603.1424360914%40sss.pgh.pa.us but I evidently forgot to mention this detail in the commit log message, s

Re: [GENERAL] Does NUMERIC lose precision?

2017-05-29 Thread Tom Lane
input arguments, but not on their precise values. I don't recall the details beyond that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10

2017-05-28 Thread Tom Lane
Thomas Kellerer <spam_ea...@gmx.net> writes: > Tom Lane schrieb am 26.05.2017 um 20:18: >>> The error message reported in the logfile is: >>> pg_dump: unrecognized collation provider: p >> Ugh :-( ... seems like a rather obvious typo in dumpCollation(). >>

Re: [GENERAL] Help with terminology to describe what my software does please?

2017-05-28 Thread Tom Lane
mparator. You could maybe make your docs a bit clearer if you consistently refer to the namespace objects as "SQL schemas", reserving the generic term for the generic meaning. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Question regarding the output of postgresql *explain* command

2017-05-28 Thread Tom Lane
ng-explain.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10

2017-05-26 Thread Tom Lane
l2 you have installed. Hard to guess more than that. If you're not actually using contrib/xml2 in the 9.6 installation, probably dropping that extension would let you do the upgrade. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10

2017-05-26 Thread Tom Lane
our tree, then that's an error code that FormatMessage doesn't recognize. Anybody have a clue what it means? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10

2017-05-26 Thread Tom Lane
ls when taking > the schema only dump from one database. > The error message reported in the logfile is: >pg_dump: unrecognized collation provider: p Ugh :-( ... seems like a rather obvious typo in dumpCollation(). Thanks for finding it! regards, tom lane

Re: [GENERAL] COPY: row is too big

2017-05-26 Thread Tom Lane
-line storage, but 12-byte fields are too small to benefit from either. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Re: Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup

2017-05-25 Thread Tom Lane
e above patch is simply an impossibly bad idea. Don't do it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block 2264419 of relation "pg_largeobject"

2017-05-25 Thread Tom Lane
David Wall <d.w...@computer.org> writes: > They do have a slave DB running via WAL shipping. Would that likely > help us in any way? Have you tried taking a backup from the slave? It's possible that the corruption exists only on the master. regards, tom lan

Re: [GENERAL] pg_dump 8.3.3 ERROR: invalid page header in block 2264419 of relation "pg_largeobject"

2017-05-24 Thread Tom Lane
et back to where you are. I hope this is being done as part of migration to more up-to-date software. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Why is posgres picking a suboptimal plan for this query?

2017-05-24 Thread Tom Lane
s should convince the planner to pre-run the function to get an estimated result at plan time. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup

2017-05-24 Thread Tom Lane
Michael Paquier <michael.paqu...@gmail.com> writes: > On Wed, May 24, 2017 at 11:18 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> This looks a whole lot like a bug we fixed in 9.3.15, cf >> https://www.postgresql.org/message-id/flat/DB5PR07MB15416C65687A1EA9AC0D26F8D6E

Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup

2017-05-24 Thread Tom Lane
//www.postgresql.org/message-id/flat/DB5PR07MB15416C65687A1EA9AC0D26F8D6E00%40DB5PR07MB1541.eurprd07.prod.outlook.com regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how to use the struct "RangeFunction" in Postgres 9.6 ?

2017-05-22 Thread Tom Lane
want to look at "func_table:" and associated productions in gram.y, and maybe compare those to the RangeFunction-making productions in 9.3's gram.y. (Since RangeFunction isn't used past the raw parsetree stage, it's not very clear to me why you'd need to make one anywhere else ...)

Re: [GENERAL] Partitioned Data and Locking

2017-05-20 Thread Tom Lane
cal and practical difficulties. As one example, once we've released that lock, someone could change the child's constraint, invalidating the proof. (Indeed, since AccessShareLock is such a weak lock, it would more or less require DDL on the child table for there to be any conflict.)

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread Tom Lane
s any special meaning ? Postgres thinks it's a valid identifier character, as long as it's not the first character. I don't believe it's standard SQL, but we hacked it in a long time ago for compatibility with Oracle or somebody like that. regards, tom lane -- Sent via p

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Tom Lane
o.2 library before the /opt/PostgreSQL/9.6/lib/ > one. IIRC this is determined ultimately by /etc/ld.so.conf, but there's a layer of caching that might be giving trouble. See "man 8 ld.so" and also "man 8 ldconfig". Looking at the output of "ldconfig -p" might be info

Re: [GENERAL] sorry, too many clients already error

2017-05-16 Thread Tom Lane
actual Terminate protocol message ('X') or is just closing the socket. If the latter, maybe it isn't really closing because the socket is shared with some child process, or something like that? Turning on log_connections/log_disconnections might help clarify what's happening.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Tom Lane
to see how they could be out of sync. Maybe you have another copy of one of those libraries floating around, and the wrong copy is getting pulled into your link? I'd suggest some investigation with "ldd" and "nm -D" to see what's what. regards, tom lane -- S

Re: [GENERAL] Different query plan used for the same query depending on how parameters are passed

2017-05-16 Thread Tom Lane
text-constant", and that operator doesn't match the index. Probably, casting the parameter to char(n) explicitly would fix this. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

2017-05-16 Thread Tom Lane
stallation before it would play nice with a 9.6 libpq, so that might be surprising. (It would also break existing 9.2 installations that were explicitly setting unix_socket_directory, but we can hope there are very few of those.) regards, tom lane -- Sent via pgsql

Re: [GENERAL] Postgres intermittent connection errors: psql.bin: could not connect to server: Cannot assign requested address

2017-05-16 Thread Tom Lane
t do that, at least not more often than you have to. This particular symptom is a new one on me, but there are lots of other reasons not to do it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscriptio

Re: [GENERAL] Text value within composite function result not quoted

2017-05-15 Thread Tom Lane
ered separately. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Text value within composite function result not quoted

2017-05-15 Thread Tom Lane
he most > felicitous way of representing a text value that I can imagine. > Note that if I add a single space after “Works!”, I get quotes around the > string. As per spec: https://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-IO regards, tom lan

Re: [GENERAL] Add NAMEDATALEN to PG_CONFIG?

2017-05-15 Thread Tom Lane
only make sense to do that if we supported configuring NAMEDATALEN, which we don't really: you have to manually edit pg_config_manual.h, and how well the result works is on your own head. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

2017-05-15 Thread Tom Lane
itself. So I'm thinking what's happening here is the 9.2 psql is picking up a libpq.so supplied by 9.6. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

2017-05-15 Thread Tom Lane
n 9.2 and 9.6. But the first step would be to use "ldd" to see which libpq your invoked psql is pulling in. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-12 Thread Tom Lane
Mathieu Fenniak <mathieu.fenn...@replicon.com> writes: > I've taken your patches, Tom, and applied them to a test deployment of my > actual application. > The most accessible way I have to reproduce this issue is to run a > maintenance task that we typically run during a s

Re: [GENERAL] Top posting....

2017-05-11 Thread Tom Lane
uality and completeness (and the fact that we never ever break > links even when the website is rewritten). Amen to the value. Thanks to those who've made this happen. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] psql: do/should we document that argument and option specification order doesn't matter?

2017-05-11 Thread Tom Lane
ng() does not so blatantly exceed its authority, only the documented argument order will work. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Constraints of view attributes

2017-05-11 Thread Tom Lane
ere isn't anything in Postgres right now that makes that type of inference, let alone a way to export it to userland. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to recover my postgres database ?

2017-05-11 Thread Tom Lane
t you're going to be able to do. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Top posting....

2017-05-11 Thread Tom Lane
ng to a five-minute-old message that probably isn't an issue. The trim-quotes-and-reply-below style evolved for discussions that might last over days, where readers can benefit from a quick reminder. Bottom posting without trimming is just an awful combination: whatever you do, don't do tha

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-10 Thread Tom Lane
Mathieu Fenniak <mathieu.fenn...@replicon.com> writes: > Andres, it seems like the problem is independent of having large data > manipulations mixed with schema changes. The below test case demonstrates > it with just schema changes. > Tom, I've tested your patch, and it seems

Re: [GENERAL] Very suspicious plan difference for select and corresponding delete queries PostgreSQL 9.6.2

2017-05-08 Thread Tom Lane
returning ctid, which it could not get out of the index. This is necessary for possible EPQ rechecks. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Sample in documentation

2017-05-07 Thread Tom Lane
Igor Korot <ikoro...@gmail.com> writes: > On Sat, May 6, 2017 at 8:22 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> I do not see any arrays named "length", nor even any arrays of size 2, >> on that page, so I'm pretty confused what you're talking about. Plea

Re: [GENERAL]

2017-05-07 Thread Tom Lane
se then you *must* look directly at the catalogs. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Sample in documentation

2017-05-06 Thread Tom Lane
not see any arrays named "length", nor even any arrays of size 2, on that page, so I'm pretty confused what you're talking about. Please be more specific. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-05 Thread Tom Lane
r to be invalidating caches >> based upon the cache value. > I think optimizing those has some value (and I see Tom is looking at > that aspect, but the bigger thing would probably be to do fewer lookups. I'm confused --- the lookup side of things is down in the noise in Mathieu's trace.

Re: [GENERAL] PG96 pg_restore connecting to PG95 causes ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout"

2017-05-05 Thread Tom Lane
ing to the destination server version*, not the latest version you can find anywhere. No version of pg_dump has ever promised that its output would load perfectly cleanly into lower-version destination servers, and that's not a set of new compatibility constraints that I'd want to take on.

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-05 Thread Tom Lane
s in the attached patch. It'd be interesting to see if this patch helps your scenario #1. (Patch is against HEAD but seems to apply cleanly to 9.5) Most likely, your scenario #2 is completely stuck on the RelfilenodeMapInvalidateCallback issue, though it would be good to get a trace to confirm that.

Re: [GENERAL] Column information

2017-05-04 Thread Tom Lane
ter_maximum_length | regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Column information

2017-05-04 Thread Tom Lane
EAL, and DOUBLE PRECISION are collectively referred to as approximate numeric types. — Exact numeric types and approximate numeric types are collectively referred to as numeric types. Values of numeric types are referred to as numbers. regards, tom lane -- Sent

Re: [GENERAL] Column information

2017-05-04 Thread Tom Lane
some other size. If you try it on bigint or smallint columns, you'll get other answers. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

<    1   2   3   4   5   6   7   8   9   10   >