pretty safe: neither datestyle nor timezone should
affect the timestamp-without-timezone variant of to_char(),
and this particular format string doesn't depend on lc_time.
regards, tom lane
USER
to reset the role's password.
regards, tom lane
> https://www.postgresql.org/docs/current/sql-altertable.html
> And none seem to involve the generated expression column. So the answer is
> no.
I think what you'd need to do is drop the existing column
and then add a generated column.
regards, tom lane
Marcos Pegoraro writes:
> But wouldn't it be good that VACUUM FULL uses that index defined by
> Cluster, if it exists ?
No ... what would be the difference then?
regards, tom lane
surprised that's not noticeable in your
test case.
regards, tom lane
ll their commands. This might not even require malicious
intent, merely faulty coding --- but the opportunity for malicious
intent is staggeringly large.
regards, tom lane
bit wasteful. But it'll likely outperform any other solution
for the union queries. Notably, adding or deleting a partition would
be much less painful than redefining a UNION ALL view.
regards, tom lane
f you're letting a user that's not 100.00% trusted write event
triggers. (Much less execute any SQL command whatsoever, which
is what it sounds like David is suggesting you create a function
to do.)
regards, tom lane
n particular, it does not grant you any powers over
installation-wide objects such as roles.
regards, tom lane
out ordering.
regards, tom lane
have that suggests any
plausible line of investigation towards a software problem.
If we can see a crash stack trace or two, maybe that would change.
regards, tom lane
finitions. Or ... do you have any PG extensions installed?
regards, tom lane
se it'd show up as the backend dying from SIGKILL).
regards, tom lane
8G RAM, but maybe
something is misconfigured to give up way below that. In any
case, you'll never find the cause from the client side.
> Last attempts have been with ubuntu 22.04.04 and postgreSQL 16.
16 dot which?
regards, tom lane
Thomas Kellerer writes:
> Tom Lane schrieb am 11.04.2024 um 01:02:
>> Jan Behrens writes:
>>> While writing a PostgreSQL client library for Lua supporting
>>> Pipelining (using PQsendQueryParams), I have been wondering if there
>>> are any single SQL comma
that in other RDBMSes and probably somebody will be
motivated to make it possible in Postgres.
regards, tom lane
memory
> using numactl (or similar commands regarding cpuset) and partitioning.
Seems straightforward enough to me, as long as you put the instances
onto distinct port numbers. Are you encountering problems?
regards, tom lane
t
do leap seconds.) The real number of distinct zones in a
standard tzdata file set these days is a shade under 600.
regards, tom lane
Adnan Dautovic writes:
> On 05. Apr 2024, at 16:13, Tom Lane wrote:
>> Out of curiosity, does
>> SET timezone to 'GMT';
>> work?
> Yes, it yields:
>> SET
>>
>> Query returned successfully in 84 msec.
I expected that, because the name &qu
ce about it
until you did a postmaster restart.
regards, tom lane
gt; PG_CATALOG.PG_ROLES.ROLNAME%type
Exactly. The %type bit is important.
regards, tom lane
esql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES
regards, tom lane
ich is a thin wrapper
over the wire-protocol Parse command). There is a different namespace
for cursors. Cursors do share that namespace with the wire-protocol
"portal" concept, but libpq doesn't directly expose portals.
regards, tom lane
same "portal" namespace.
regards, tom lane
t unexpected times --- for instance, it might appear once
during the planner's constant-folding phase, even though naive
interpretation of the query suggests that it should appear many
times or not at all. But beyond that possible POLA violation,
neither of these functions will bother Postgres any.
regards, tom lane
ng to restore onto a different OS platform with
different locale naming conventions. The easiest way to deal with it
probably is to edit the dump file and change "C.UTF-8" to "C.UTF8"
everywhere. (Manually editing an 8G dump file might be no fun, but
"sed" should make short work of it.)
regards, tom lane
y
a fair number of entries in that have gone missing. Postgres
itself would never modify that data after installation, so
we're left to speculate about filesystem corruption or
somebody's odd desire to remove "unnecessary" files.
Out of curiosity, does
SET timezone to 'GMT';
work?
regards, tom lane
ot requiring there to be different code paths
for EXPLAIN and normal query running in various places.
regards, tom lane
lling to work on fixing
it, I suggest finding a job where you don't have to deal with that.
regards, tom lane
Fire Emerald writes:
> The partitioning must be the problem somehow.
[ shrug... ] You're still not providing any details that would
let somebody else reproduce or diagnose the problem.
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
regards, tom lane
ed on Microsoft SQL Server.
SQL Server doesn't need to worry about an extensible type system.
regards, tom lane
hat FK constraints are satisfied on-the-fly.
regards, tom lane
them", and that the reason your code is failing is
that there's still a reference to the PLyCursor somewhere after the
plpython function exits, perhaps in a Python global variable.
regards, tom lane
Don Seiler writes:
> On Tue, Mar 26, 2024 at 9:09 AM Tom Lane wrote:
>> ... So you could overshoot the specified target by
>> more or less the amount of WAL that could be emitted between two
>> checkpoints. Perhaps it's tighter nowadays, but I really doubt that
>>
t's tighter nowadays, but I really doubt that
it's exact-to-the-kilobyte-at-all-times.
regards, tom lane
s that we should warn only when the command
is a complete no-op, that is none of the mentioned privileges
matched. But I've not thought about it very hard.
regards, tom lane
ne should get notified of.
To do that, we'd have to remember that you'd said NULL, which we
don't: the word is just discarded as a noise clause. Considering
that this usage of NULL isn't even permitted by the SQL standard,
that seems like a bit too much work.
regards, tom lane
hat the planner does with a small table
is what it will do with a large table.)
regards, tom lane
CPU#25 stuck for 3121s! [migration/25:166]
Sounds like failing hardware to me :-(
regards, tom lane
ble, only with the
transaction's own existence. It can't conflict when acquired,
because the virtual XID is unique (at least across existing sessions).
It exists so that other sessions can wait for this one if needful, by
trying to take share lock on the virtualxid.
regards, tom lane
Adrian Klaver writes:
> Haven't had a chance to go through this yet. I'm going to say though
> that Tom Lane is looking for a shorter generic case that anyone could
> run on their system.
Yeah, it's a long way from that trigger function definition to a
working (i.e. failing
ined example that triggers this?
regards, tom lane
regards, tom lane
untdown is already running (or not) for the current command, and
it's too late to change it with effect for that command.
regards, tom lane
lot of decimal places by the end of the query, I fear.
regards, tom lane
hassan rafi writes:
> The issue of high query planning time seems to intermittently resolve
> itself, only to reoccur after a few hours.
I wonder if you are running into the lack of this fix:
Author: Tom Lane
Branch: master Release: REL_16_BR [9c6ad5eaa] 2022-11-22 14:40:20 -0500
that, it wouldn't be terribly practical
to insist on creating a separate copy of record_out (and every other
function that accepts composite types) just so that it could have a
hard-wired notion of what rowtype it's going to deal with.
regards, tom lane
n't say that these problems are insoluble, but they do
look pretty difficult.
regards, tom lane
this rule is applied after constant-folding,
so that what we're left with is normally going to contain variables
at every level. extract() is problematic because it combines a
text constant with a datetime (collation-less) variable.
regards, tom lane
ortant for performance.
regards, tom lane
proving that mess sometime. One thought
that comes to mind is to have a server option authorizing postgres_fdw
to believe that all local collations exist on the remote side.
regards, tom lane
s still a Frickin Lot Of Money in any non-hyperinflated currency,
but it's the sort of restriction that banks don't like to hear of.
regards, tom lane
aurenz that it's hard to see much use-case here
that's not sufficiently covered already.
regards, tom lane
pyOutResponse messages don't carry any
column name or type indications, so yes it's normal.
https://www.postgresql.org/docs/current/protocol-message-formats.html
Maybe we missed a bet there, but AFAIR you are the first person to
ask for this in twenty-plus years.
regards, tom lane
umn not existing. Maybe it's okay to let plpgsql_parse_wordtype
etc throw the error for themselves, though.
regards, tom lane
uld be explained if the users have
different search paths.
regards, tom lane
ot about the special characters
in the names, rather about search_path not including the NODE⠒V view.
Consider schema-qualifying the view name, or attaching a "SET
search_path" clause to the function.
regards, tom lane
x WHERE name = 'User '||trunc(r*100) ;
or in this case better to shove the whole constant computation
into the CTE.
regards, tom lane
But
it hasn't gotten further than preliminary discussion.
For the moment, I think the only feasible solution is for your trigger
function to set the search path it needs by adding a "SET search_path
= whatever" clause to the function's CREATE command.
regards, tom lane
the quotes from the schema owner.
I'd advise reading this section carefully:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
Notably, the advice to "always quote a particular name or never quote
it" could be a useful rule for you here.
regards, tom lane
e(p_start_time,p_end_time)) ...
regards, tom lane
of thing is one of the fundamental advantages that open-source
distros have over closed-source ones, so you shouldn't ignore it.
regards, tom lane
he diff between the .out files isn't pretty self-explanatory,
you can try checking the git log for the "_1.out" file to see why it
was created.
regards, tom lane
version
of the extension's SQL declarations. Those are likely to remain
there indefinitely.
regards, tom lane
in v16, the loOpen fails, returning -1, while
> it used to be OK.
> So this must be a bug fix of some kind I guess. Using INV_READ fixed the
> test.
Yup, see commit 55f480278
regards, tom lane
ibility
before making the change on your production database. There are
likely to be a few gotchas.
regards, tom lane
ou use a cursor, and that doesn't
always work well :-(
regards, tom lane
some false positives.)
Alternatively, change your PATH to put /usr/local/bin in front
of /usr/bin.
regards, tom lane
u could make that happen. In any
case, more eyeballs reviewing that patchset would be welcome.
regards, tom lane
enied for table outbox_event
You need SELECT privilege too in order to read the "id" column.
regards, tom lane
her involves only free() operations
and no other resources). I think the only real win we'd get from
such a layer is that OpenSSL's allocations would be better exposed
for accounting purposes, eg the pg_backend_memory_contexts view.
That's not negligible, but I don't find it a compelling reason to
do the work, either.
regards, tom lane
uot;returns table(id int)"
of the function, which has no associated table.
regards, tom lane
hat and not rechecked the length while
storing into the matview. Not sure if this behavior change was
intentional or an accidental product of refactoring.
regards, tom lane
Atul Kumar writes:
> I checked the permissions on /tmp directory and it shows "drwxrwxrwt."
> already, do I need to check something else as well ?
That seems fine, but what about the socket file itself?
regards, tom lane
ould be to remove or increase all the
varchar limits in the matview declaration, load the data, and then
probe for bad entries with something like "select * from matview where
length(some_varchar_field) > 255".
regards, tom lane
socket does not
> exist?
Nope, that should mean either that /tmp is not readable, or that the
socket file is there but has restrictive permissions.
That doesn't necessarily make Adrian's answer wrong though.
regards, tom lane
.00..1.05 rows=5 width=16)
NOTICE:-> Hash (cost=1.05..1.05 rows=5 width=4)
NOTICE: -> Seq Scan on int4_tbl (cost=0.00..1.05 rows=5 width=4)
DO
regards, tom lane
eory, if you use --enable-depend, you needn't do
"make clean". But I don't trust that a whole lot personally.
I find that using ccache gets most of the win with fewer assumptions.
regards, tom lane
t in LIBS if you specified
--with-openssl, but maybe it failed to. Can you check the
configured value of LIBS (in src/Makefile.global) to see?
If it's not there, it would be useful to see the contents of
the config.log log file.
regards, tom lane
tant
which this isn't, nor does << have a negator operator that could
allow the NOT to be simplified out.
Wouldn't
drange && daterange(CURRENT_DATE, NULL, '[)')
serve the purpose? That should be indexable.
regards, tom lane
ow unbalanced they are? (Assume PG12+.)
As far as I know, we don't have a problem of that sort. Continued
insertions will eventually force a split of the root node, which will
rebalance the tree.
regards, tom lane
ould print "(ALL t.a >= $0 FROM SubPlan 1)".
Some of the other SubLinkTypes might be harder to represent
in a way that makes sense to users.
I made a quick-hack patch to play with, if you're interested.
regards, tom lane
diff --git a/src/backend/utils/adt/ru
Jim Vanns writes:
> I should have already stated I did begin with EXPLAIN but given they
> don't easily work with (the internals) stored/procedures, it wasn't
> useful in this case.
auto_explain with nested statements enabled might help?
regards, tom lane
might matter for such a low-level failure
as this.
regards, tom lane
Dominique Devienne writes:
> On Tue, Jan 16, 2024 at 10:59 PM Tom Lane wrote:
>> The problem is that now you have a switch somewhere (whether a GUC
>> or something else, still a switch) that fundamentally changes the
>> transactional semantics seen by applications
;> confirm my suspicion - does anyone have any tips on that?
> Explain:
> https://www.postgresql.org/docs/current/sql-explain.html
Specifically, if EXPLAIN ANALYZE shows a lot of time spent in the
enforcement trigger for the FK, this is likely what's happening.
regards, tom lane
ken client code.
regards, tom lane
step won't really care. See use_physical_tlist() in createplan.c.
What I'm confused about is why 9.4 didn't do the same.
That optimization heuristic is very old, and certainly
would be applied by 9.4 in some circumstances. Testing
says the behavior in this specific case changed at 9.6.
I'm not quite interested enough to drill down further...
regards, tom lane
uff might be
needed in that infrastructure to make it work for a COBOL wrapper
... but I think somebody else has to take point on making that
happen.
regards, tom lane
ings -- we simply don't store anything for a null column).
There's more detail at
https://www.postgresql.org/docs/current/storage-page-layout.html
regards, tom lane
format fields. As noted upthread, SET LOCAL together with a (dummy)
"SET timezone" clause in the function definition can be used to get
the effect of a function-local setting of the parameter. I don't
know of another way to achieve that result above the C-code level.
regards, tom lane
Did you get any warnings during build?
regards, tom lane
umn. Check again.
I am guessing that the OP tried to put a literal NUL character
into the COPY data. A bytea value in COPY data needs to be
text-encoded as per one of the alternatives explained in the
manual. Alternatively, you could jump through the hoops involved
in sending binary COPY data.
regards, tom lane
like an
oversight.
regards, tom lane
code though.
regards, tom lane
umber and re-compile, or would that break other
> things?
A bit of "git blame" archaeology says that that traces back to
commit bf7737a938827608ce79586efe55c642c1a4a7d3
Author: Tom Lane
Date: Wed Jan 26 21:55:26 2005 +
On Windows, set the postmaster executabl
egards, tom lane
regards, tom lane
ctual fix, perhaps a newer version of LLVM is needed?
I don't see a problem testing this query on my RPI with Ubuntu 23.10
(LLVM 16).
regards, tom lane
o have an exception for that.
regards, tom lane
1 - 100 of 2521 matches
Mail list logo
