user’s environment but
don’t do that for pg_dump.
In short it seems like you need to trace down your O/S environment
differences when each command is run.
David J.
;
To be clear, there is no way to supply a password as a command line
argument. It is fundamentally a bad idea and we don't even make it an
option.
You need to decide on one of the actual ways of supplying a password, or
choose an alternative authentication method like peer.
David J.
given the availability of
other better options. Namely PGPASSWORD, .pgpass, or, less
desirably.pg_service.conf
The URI format that includes a password should be reserved for client
libraries and avoided when using psql (just the password part really though
I much prefer the service file option myself).
David J.
ter off getting closer to your goal by
reading books and articles about those applications and then asking better
questions. Or at minimum being more detailed in stating your goal and
requirements.
David J.
gh for development it
shouldn’t matter so long as the application is configurable. Configure it
for local during development and when in production it pulls production
configuration.
David J.
r than an issue with the
feature. You should probably provide a (minimally) reproducing script for
at least the client with annotations as to what is happening externally to
the script as it is being run.
IOW, you don't get to keep the function a black box while also saying it is
exactly the details of what is inside that function that is failing.
David J.
client, upon speaking with the server, will decide whether to send the
plaintext password to the server or encrypt it prior to transmission.
What would be the point of storing the encrypted password instead of the
plaintext one?
David J.
as a large degree of
mitigation by adopting technology driven coding and naming standards. For
production outputs it doesn't even do that great a job as final output
names should strive to be human friendly as opposed to the developer
friendly names used in data models.
David J.
On Mon, Jun 22, 2020 at 3:32 PM Pavan Kumar wrote:
> Adrian, David,
>
> Thank you so much for the quick response.
>
> What would be the point of storing the encrypted password instead of the
> plaintext one?
> As per our organization security policies, we can 't keep
.org/docs/12/tutorial-transactions.html
David J.
...". I'd like to point out that you
seem to be saying that you simultaneously have a connection pool and don't
have a connection pool involved here...
As I suggested on the other thread, and repeated above, you need to build
up a script that can reproduce the problem. Something that can open a
connection to the server and then wait for a period of time before
executing a query against it to see if that session gets dropped on the
client side while still remaining visible on the server.
David J.
4/continuous-archiving.html
Or, probably better, consider using a third-party system.
David J.
he performance weighted setup.
David J.
ndQuery cannot be called again (on the same
connection) until PQgetResult has returned a null pointer, indicating that
the command is done.
David J.
On Friday, June 26, 2020, Samuel Williams
wrote:
> Thanks David,
>
> You are correct.
>
> I was giving an example of what I was hoping to achieve, not what I
> expected to work with the current interface.
>
What about, as it says, sending multiple statements in a sing
slow, this can be a significant source of latency
>
I don’t have any insight into the bigger picture but I’d concur that no
other option is documented so what you desire is not possible.
David J.
On Monday, June 29, 2020, David Gauthier wrote:
>
>sqf_id | sqf_sl | as_cl |
> wa_id | type
>
> +---
> --+-+---+---
>
> * arazhang_20.06.28-
The convention here is to bottom post or inline responses.
On Wed, Jul 1, 2020 at 9:51 AM David Gauthier
wrote:
> Actually, I want the outer join first. If it finds something, then move
> on to the inner join and filter out all those that don't join to a rec with
> 'auto
e (basebackup is more
likely, but pg_dump would be more useful) and still observe the problem
then maybe I see hope for digging down into the cause. Otherwise I’d limit
my decision to testing for the symptom with the solution being to rebuild
any problem views.
David J.
On Thu, Jul 2, 2020 at 8:06 AM Anders Steinlein wrote:
> On Thu, Jul 2, 2020 at 3:55 PM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Thursday, July 2, 2020, Anders Steinlein wrote:
>>>
>>>
>>> I just wanted to add that we
nt of the default equality operator. But then those casts also make me
question whether the source tables are defined using text instead of citext
in which case the joins using text equality would be expected and their
using citext equality in the new queries potentially suspect.
David J.
safety for convenience that
is good - each user can make that trade-off for themselves and in the
process be aware of what exactly their decision entails.
David J.
table.
>
Re-reading the original email I see both the answer to your question and
the data being queried.
David J.
ake it use it.
>
Use it how? You are still evaluating 250k groups so doing anything
piece-wise seems like an expected loss compared to sequential scan.
David J.
main script with \i or \ir
David J.
fset 11?
>
Given all of the disclaimers about serial value issuance you should assume
that it is possible.
David J.
member of role userA
>
Create a "group role" that retains ownership and then add both users to
that group.
David J.
ared
to is different for each row because random() is volatile and thus
evaluated for each row.
David J.
On Tue, Jul 14, 2020 at 8:25 AM David Gasa i Castell
wrote:
> And my surprise went when I see the connection done while there is no user
> granted to connect the database...
>
https://www.postgresql.org/docs/12/ddl-priv.html
"""
PostgreSQL grants privileges on some ty
oop.
Everytime that statement gets executed within the loop a new random number
is produced.
I mean, even "id 3 date = '2000-01-01'" is repeatedly casting (I think) the
string to a date and assigning it to the variable even though that
statement overall is effectively immutable.
David J.
secondary server shouldn’t impact the primary. You might be
recording more detail to WAL than strictly necessary but that isn’t wrong
outright.
David J.
My suggestion to the OP is to just get password or other PostgreSQL-only
authentication working, possibly with the help of PostgreSQL people, and
then decide whether the convenience of what is basically single-sign-on is
worth the learning curve.
David J.
g (or any features beyond what's documented on the
pg_dump reference page).
David J.
g down the server?
Additionally, you will want to examine, and probably relay, the contents of
the log file during these shutdown/startup periods.
David J.
cal for someone else to
duplicate the problem.
David J.
On Wed, Jul 22, 2020 at 8:24 AM Samuel Nelson
wrote:
> Is there a way to force the delete to cascade to tables in a specific
> order?
>
No really, but you can defer constraint checking.
https://www.postgresql.org/docs/12/sql-set-constraints.html
David J.
are problems you
could end up performing unnecessary work. Memory consumption probably
increases as well since constraint related information cannot be discarded
as each command completes but must be kept around for the eventual
validation.
David J.
>
> It should work starting from Postgres 9.0
Removing the $ from your regexp pattern should work for the 4 provided
examples.
You cannot remove stuff from the end of a string if you require that the
end of said string match what you want to return.
David J.
porary file and edited in the same fashion.
David J.
On Wednesday, July 22, 2020, David G. Johnston
wrote:
> On Wednesday, July 22, 2020, Emanuel Araújo wrote:
>
>>
>> \r
>> \e
>> -> Open temp file with the same last command "select 1;"
>> is it right?
>>
>>
> Documentation s
onf file from the server (if you wanted a
shared pg_service.conf file you could do so but you would probably want a
separate configuration machine to provide it, not the PostgreSQL server).
And the server doesn't recognized service names supplied by the client - it
only recognizes credentials and a database name (and other configuration
settings too)
David J.
crete types are always canonicalized while ranges over
non-discrete types (i.e., float) cannot.
David J.
ient are usually
installed from the same source and the same default certificate files are
provided to each.
David J.
The convention on these lists is to inline or bottom-post.
On Mon, Aug 10, 2020 at 11:11 AM Martin Gainty wrote:
> cant you use keytool ?
>
That wasn't the question, the OP already indicated they can do this
successfully in JDBC.
David J.
a using a “text/varchar” field or a number using an integer field. For
bytea the content is just raw bytes instead of characters or numbers.
David J.
raised the issue. Nothing else I am doing.
>
>>
>>
You should supply code that demonstrates what you have tried so far and the
errors you are getting (or commented out pseudocode in the places where you
are not sure what to write).
David J.
On Mon, Aug 17, 2020 at 12:53 PM David Gauthier
wrote:
> Looking at psql command line options, I see "-v" (lowercase) which is
> described as...
>
> -v assignment
> --set=assignment
> --variable=assignment
>
> Perform a variable assignment, like the \set
On Monday, August 17, 2020, David Gauthier wrote:
> OK, trying to piece together something that might work but I don't see the
> pieces falling into place.
> From the link you provided...
>
> "The most fundamental way to set these parameters is to edit the file
> po
On Mon, Aug 17, 2020 at 5:46 PM David Gauthier
wrote:
> >> You lass in the $USER to you client software where it executes a
> post-connect hook SQL script populating a temp table with that value,
> usually via a function.
>
> A "post-connect hook SQF script" ?
On Mon, Aug 17, 2020 at 5:46 PM David Gauthier
wrote:
> Users will connect to the DB and then update a table using SQL at the
> prompt. And I want a post update trigger to identify who (linux user on
> the client side) just made that change.I was sort of hoping that this 8
&g
ot;xmltable"
Keep in mind that "context as a document value" can just be a literal.
David J.
sible way to query this without stressing out Postgres too
> much ? I'm guessing a CTE of some sort ?
>
>
Suggest you provide your desired output in table format, and show “the
query” that you mention.
David J.
On Wed, Aug 19, 2020 at 8:19 AM Laura Smith <
n5d9xq3ti233xiyif...@protonmail.ch> wrote:
> On Wednesday, 19 August 2020 15:09, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> > On Wednesday, August 19, 2020, Laura Smith <
> n5d9xq3ti233xiyif...@p
u describe is an
iterative algorithm and so I'm wondering why place the arbitrary
restriction on using pure SQL when it likely wouldn't provide a very
readable nor performant solution relative to a procedural (pl/pgsql or
otherwise) one?
David J.
on - read the documentation, psql section, for the exact syntax.
David J.
On Mon, Aug 24, 2020 at 7:21 AM harish supare
wrote:
> thanks for the reply David.
>
> In case of Colon I need to set the variable first, my requirement is my
> select query should prompt for the input.
>
>
Please don't top-post.
psql does not have a feature that will
org/docs/12/sql-update.html
David J.
at
> (sensibly) didn't work, and I needed a loop to call the
> function in, but I might be thinking of something in an
> outer join's "on" clause. Does that make sense?
>
You probably tried it before we added LATERAL to our engine.
David J.
nd hopefully back-patched, instead. I
concur with the observation that one would expect these two features to
interact better with each other and think it could possibly be done as a
bug fix for the POLA violation.
David J.
[1]
https://github.com/postgres/postgres/commit/2f178441044be430f6b4d626e4dae68a9a6f6cec
les are not chosen for new plans
while the temporary table exists, unless they are referenced
with schema-qualified names. Any indexes created on a temporary
table are automatically temporary as well.
David J.
s and where the writes, should be in our
> application.
>
Seems as if pgPool is at least worth considering...
David J.
age-id/flat/CA%2BHiwqFvkBCmfwkQX_yBqv2Wz8ugUGiBDxum8%3DWvVbfU1TXaNg%40mail.gmail.com
David J.
On Tue, Mar 3, 2020 at 4:19 PM David G. Johnston
wrote:
> On Tue, Mar 3, 2020 at 4:11 PM Adrian Klaver
> wrote:
>
>> On 3/3/20 3:06 PM, David G. Johnston wrote:
>> > On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver > > <mailto:adrian.kla...@aklaver.com>>
On Fri, Oct 2, 2020 at 1:43 PM Brajendra Pratap Singh <
singh.bpratap...@gmail.com> wrote:
> How can we create a user profile in open postgresql db?
>
?
CREATE TABLE user_profile (...);
INSERT INTO user_profile VALUES (...);
David J.
On Sunday, October 4, 2020, Robert Inder wrote:
> than shipping an empty file every few minutes?
>
The file is not empty. We’re talking 16 megabytes in a default setup...
David J.
ints
will be skipped even if checkpoint_timeout has passed. ‘
https://www.postgresql.org/docs/13/wal-configuration.html
David J.
min does not exist then how did I connect to the
> idempiere database?
>
Underscore versus hyphen.
David J.
n values to be set.
https://www.postgresql.org/docs/13/sql-alterrole.html
David J.
Which
brings me back to first understanding how the unaltered system works before
trying to make alterations. You may choose to learn that using an 8.3
server but you will probably find little help if you go that route.
David J.
David J.
t;
https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_PostgreSQL_report_a_column_not_found_error_when_using_the_wrong_name_in_a_subquery.3F
I am pondering trying to get the FAQ entry incorporated into the actual
documentation.
David J.
to the -admin list; not the right
place and not enough information provided.
David J.
ted.
>
>
> Please help why that parameter is stopping database to start.
>
>
You might get better results if you use the support channels for the
project as noted in its documentation.
David J.
Moving this over to -hackers and the commitfest
https://www.postgresql.org/message-id/CAKFQuwaZjsaQ9KdDKjcwgGo3axg2t0BdBVYJiHf%3DH9nbvsxQbQ%40mail.gmail.com
David J.
On Thu, Oct 1, 2020 at 5:14 PM David G. Johnston
wrote:
> On Wed, Sep 30, 2020 at 7:41 AM Tom Lane wrote:
>
>> I
mic inertia working
against adding minor useful functions such as these.
With the new documentation layout I would at least consider updating the
description for the normal functions with an example on how to formulate an
expression that works contra-normally, and in the case where there does
exist such a specialized function, naming it.
David J.
ntax error so its the actual data that
seems to matter.
David J.
parens:
INSERT INTO tbl (i) VALUES (1), (2), (3); --this is perfectly valid
That said seeing the first few rows, in addition to the last few, would
help.
David J.
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard
wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote:
>
> > That said seeing the first few rows, in addition to the last few, would
> > help.
>
> David,
>
> insert into organizations
> (org_nbr,org_name,org_url,
^
> > I'm not seeing why that's an error. All previous rows terminate with a
> comma
> > and I don't know where else to look for the reason. What am I missing
> > seeing?
>
> Rob/Paul/David/Tom/Adrian:
>
> Found the probl
On Fri, Oct 30, 2020 at 9:03 AM David Gauthier
wrote:
> I was thinking of a pre-insert and pre-update trigger which could make the
> translation. But I'd rather not try to do this one char at a time...
> translate "..." today to fix today's issue, then "--&q
rected.
>
> I've not encountered this issue before. Where should I look for the error?
>
You encountered and asked on this exact same issue Friday...the advice in
that "Multi-row insert: error at terminal row." all still applies.
David J.
in some
> hard coded way.
>
The Google Sheet source document has column ordering. If that is what you
want to rely upon have your Python code capture that into an array and
attach that array to the json document as a separate
"field_headers_ordered" key (or something similar).
David J.
gt;
>>>
Please start new email threads when you have new questions.
If you run vacuum manually in a session, and then disconnect that session,
the vacuum stops just like any other command.
David J.
On Fri, Nov 6, 2020 at 2:34 PM Sri Linux wrote:
> Could you please provide me the link to start new questions?
>
>>
>>>
Assuming you are using Gmail...
https://business.tutsplus.com/tutorials/how-to-compose-and-send-your-first-email-with-gmail--cms-27678
David J.
to
omit critical info on your first two emails) that would discourage you from
just killing the server and starting a new vacuum.
David J.
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you David
>
> vacuum is done but the application is very slow, is this normal behavior?
> Will it run any background process after vacuum causing this slowness?
>
Please don’t top-post.
Are you still running under single-user?
David J.
On Friday, November 6, 2020, Sri Linux wrote:
> Thank you very much David,
> No, vacuum activity wiht single-mode user is completed. I restarted all
> services and the application is online but pretty slow.I will open a new
> case but confused about how to do a new post in the Postgr
On Mon, Nov 9, 2020 at 9:08 AM mark armon <1994hej...@gmail.com> wrote:
>
> How to set up a schema default date (now) to '2020-01-01'? Whatever
> timezone would be OK.
>
What is a "schema default" (date or otherwise)?
David J.
oving forward to a new format that is similar to the old one
while retaining the content changes that would be a possible way forward.
David J.
needs to be skimmed over.
My suggestion is to add a "table of contents" at the top of non-trivial
sections that simply lists available functions by name (generally ignoring
argument variations) and a quick one line description of purpose. Once a
person finds the name of the function that suits their needs they can then
reference the main table for details, warnings, and examples.
David J.
rson finds the name of the function that suits their needs they can then
> reference the main table for details, warnings, and examples.
>
>
> This is what TOCs are for, no?
>
>
Are you criticizing my over-explanation of the phrase "table of contents"
here?
David J.
On Mon, Nov 9, 2020 at 3:30 PM Ron wrote:
> On 11/9/20 3:05 PM, David G. Johnston wrote:
>
> On Mon, Nov 9, 2020 at 2:01 PM Ron wrote:
>
>> My suggestion is to add a "table of contents" at the top of non-trivial
>> sections that simply lists available fun
ts.
While you can leverage probably a custom configuration variable it might be
less subtle to simply store the desired reference in a SQL function and
then call the function.
David J.
hrow enough time and effort at it so
I'm not sure how to constructively answer the last two questions. Why do
you ask?
David J.
thing our tables could probably be improved
by enforcing a maximum width to the content area.
David J.
th FROM is an inclusive bound, whereas the upper bound
specified with TO is an exclusive bound."
David J.
any
concrete suggestions on what should have been done, or done differently?
David J.
oo.
Showing before and after directory structures can help.
David J.
On Fri, Nov 13, 2020 at 2:08 PM Edson Richter
wrote:
> *De:* Tom Lane
> *Enviado:* sexta-feira, 13 de novembro de 2020 17:58
> *Para:* Edson Richter
> *Cc:* David G. Johnston ; pgsql-general <
> pgsql-gene...@postgresql.org>
> *Assunto:* Re: Range partitioning and o
---+-+-
> public | test | table | postgres | 0 bytes |
> (1 row)
>
> It should have tables 'trade', 'trade4' and some others.
>
What about?
\l+ (Letter “el”)
David J.
On Sunday, November 15, 2020, Maksim Fomin wrote:
> ‐‐‐ Original Message ‐‐‐
> On Sunday, November 15, 2020 7:27 AM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
> On Sunday, November 15, 2020, Maksim Fomin wrote:
>
>>
>> > plsql -d
1001 - 1100 of 2416 matches
Mail list logo
