On 1/4/19 10:26 AM, Rich Shepard wrote:
On Fri, 4 Jan 2019, Rob Sargent wrote:
Is the end_date always knowable at record insert?
Rob,
Not always. Sometimes projects have known end dates, other times the
end
is interminate until it happens.
CHECK(end_date is null or start_date
As is often the case, I'm unsure of which of these methods to use, or if
I'm using them correctly.
PG10.5, jooq-3.10.8, postgresql-42.1.4, linux (redhat 6.9) and logback
to a file.
I have been using close() for a while but thought I would make use of
either the returned long from endCopy() o
> On Jan 9, 2019, at 10:02 AM, github kran wrote:
>
>
> Hi Postgres Team,
>
> I have an application using RDS Aurora Postgresql 9.6 version having 4 TB of
> DB size. In this DB we have a table PRODUCT_INFO with around 1 million rows
> and table size of 1 GB.
> We are looking for a implemen
On 1/9/19 10:21 AM, github kran wrote:
Thanks for your reply Rob. Reading the below documentation link says
the EVENT trigger is only supported for DDL commands. Is it not correct ?.
_1) https://www.postgresql.org/docs/9.6/event-trigger-definition.html _
(An event trigger fires whenever the ev
> On Jan 9, 2019, at 11:11 AM, github kran wrote:
>
> Rob - It's a Java based application. We dont have triggers yet on the table
> and is trigger a only option in 9.6 version ?.
>
> On Wed, Jan 9, 2019 at 12:01 PM Rob Sargent <mailto:robjsarg...@gmail.com>
report this. I know Lukas Edar monitors it as well
>
> Dave Cramer
>
> da...@postgresintl.com
> www.postgresintl.com
>
>
>> On Tue, 8 Jan 2019 at 16:29, Rob Sargent wrote:
>> As is often the case, I'm unsure of which of these methods to use, or if I&#x
On 1/11/19 3:56 PM, Rich Shepard wrote:
A table has this column definition:
next_contact date DEFAULT '2020-11-06'
CONSTRAINT valid_next_date
CHECK (next_contact >= CURRENT_DATE),
(and I don't know that it needs a default).
In an input statement that column is l
On 1/11/19 4:21 PM, Rich Shepard wrote:
On Fri, 11 Jan 2019, Rob Sargent wrote:
psql:activities.sql:2: ERROR: invalid input syntax for type date: ""
LINE 2: ...reaction they''ve experienced
On 1/15/19 9:02 AM, Ron wrote: select distinct on (C.contact_id)
C.contact_id, C.lname, C.fname, C.direct_phone, O.org_name, A.next_contact
from Contacts as C
join Organizations as O on C.org_id = O.org_id
join Activities as A on C.contact_id = A.contact_id
where A.next
On 1/15/19 12:42 PM, Ramamoorthi, Meenakshi wrote:
Dear folks:
1)Can someone please send me a link of all companies using PostgreSQL ?
Postgres is free. There is no list of licensed sites
2)Both government and private companies using PostgreSQL
3)Any security issues found earlier and the
On 1/31/19 12:48 PM, legrand legrand wrote:
Hi,
We have use it to "archive" 2 Oracle databases (8i and 9i)
to pg 9.5 on windows (for a target of more than 250GB).
We also use it to monitor our Oracle 11g databases,
storing some performances / capacity planning data
(like ASH, AWR, ...) in Pos
On 2/20/19 3:22 PM, Tiffany Thang wrote:
Hi Adrian,
I managed to backup my table in parallel using -Fd but I'm back to my
original issue where I could not restore the table to a different schema.
For example,
I would like to backup testuser1.mytable and restore it to
testuser2.mytable.
pg_
On 2/20/19 4:21 PM, Tiffany Thang wrote:
Hi Ron,
How would that work if I'm only interested in importing/refreshing a
single table in a target schema that contains several other tables?
Thanks.
Tiff
On Wed, Feb 20, 2019 at 5:36 PM Rob Sargent <mailto:robjsarg...@gmail.com
Using PG10.7, I have a database per investigator with one or more
identical schemata per project. So far I've gotten by defining public
functions (as postgres) which reference tables /without/ schema
reference. Each project has a role which sets the search_path such that
the project specific
On 2/28/19 12:27 PM, David G. Johnston wrote:
On Thursday, February 28, 2019, Rob Sargent <mailto:robjsarg...@gmail.com>> wrote:
but this fails in one of two ways: either the create function
call fails lacking a definition of "segment" or, if I create a
p
I’m using 10.7. Does an empty result set generate this error by any chance.
One of my plpgsql functions is now throwing this error:
select * from genome_threshold_mono('11-O3C.pbs','1-O3C_chr',1.96, 100);
NOTICE: group id is 5eed8d65-d39a-4f72-97a3-ca391b84880d
NOTICE: New threshold: 661281
> On Mar 6, 2019, at 6:29 AM, Tom Lane wrote:
>
> Rob Sargent writes:
>> One of my plpgsql functions is now throwing this error:
>
>> ERROR: query has no destination for result data
>> HINT: If you want to discard the results of a SELECT, use PERFORM
> On Mar 6, 2019, at 6:32 AM, Ron wrote:
>
> On 3/6/19 1:45 AM, Rob Sargent wrote:
> [snip]
>> This construct had been working until recent changes but I cannot relate the
>> message to any deformity in the current schema or code.
>> Any pointers apprecia
> On Mar 6, 2019, at 7:41 AM, Adrian Klaver wrote:
>
> On 3/6/19 7:37 AM, Pavel Stehule wrote:
>
>> or
>> \sf+ functioname
>
> Cool, I learned something new.
>
>> Regards
>> Pavel
>
>
using \ef function 65 puts the cursor on the first line of the loop. So a
debugging statement got in the
> On Mar 6, 2019, at 10:29 AM, Adrian Klaver wrote:
>
> On 3/6/19 8:19 AM, Rob Sargent wrote:
>>> On Mar 6, 2019, at 7:41 AM, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com>> wrote:
>>>
>>>> On 3/6/19 7:37 AM, Pavel Stehule wrote
> On Mar 15, 2019, at 12:59 PM, Adrian Klaver wrote:
>
> On 3/15/19 11:54 AM, basti wrote:
>> this is a dns database, and the client is update the _acme-challenge for
>> LE certificates. I don't want that the client can insert "any" txt record.
>> the client should only insert data if the hostn
> On Mar 15, 2019, at 4:43 PM, Morris de Oryx wrote:
>
> The original question has already been answered really well, but it reminds
> me to mention that Postgres text/varchar values are case-sensitive. Here's a
> list of the times when I would like a case-sensitive text field:
>
>Never
ine? I
> don't know. There may be names for different substances which differ
> only in case. But those are parts of a formal language, and as
> programmers we already know about case-sensitive formal languages.
>
I don’t think it’s solely about the semantics. One might be contractual
On 3/18/19 5:18 AM, Morris de Oryx wrote:
Sounds like I may have touched a nerve with some. If so, no offense
intended!
There are cases where case-sensitivity is required or desirable, it
would be silly to argue otherwise. Where you have such cases, then
case-sensitive queries are great. Som
PG10.7, Centos7
On Mar15 we filled our default tablespace/WAL partition. Cleaned up some old
dumps and restarted. pg_wal had apparently exploded but cleaned itself up by
the next day. On Mar16 I ran CHECKPOINT in all databases on that server (except
template0). All seems fine except for 271
> On Mar 26, 2019, at 8:08 AM, Adrian Klaver wrote:
>
> On 3/25/19 5:10 PM, Rob Sargent wrote:
>> PG10.7, Centos7
>> On Mar15 we filled our default tablespace/WAL partition. Cleaned up some
>> old dumps and restarted. pg_wal had apparently exploded but cleaned it
On 3/28/19 7:30 AM, Michael Paquier wrote:
On Tue, Mar 26, 2019 at 09:50:37AM -0600, Rob Sargent wrote:
No, sorry I should have said that up front. We’re simple folk.
What is the WAL position (LSN)
postgres=# select * from pg_current_wal_flush_lsn();
pg_current_wal_flush_lsn
> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote:
>
>> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote:
>> This is pg10 so it's pg_wal. ls -ltr
>>
>>
>> -rw---. 1 postgres postgres 16777216 Mar 16 16:33
>> 0001
>
> > On Mar 30, 2019, at 10:54 AM, Gmail > <mailto:robjsarg...@gmail.com>> wrote:
> >
> >
> >>>> On Mar 29, 2019, at 6:58 AM, Michael Paquier >>>> <mailto:mich...@paquier.xyz>> wrote:
> >>>
> >>> On
> On Apr 3, 2019, at 5:23 PM, Rene Romero Benavides
> wrote:
>
>
>
> On Wed, Apr 3, 2019 at 1:05 PM Rob Sargent <mailto:robjsarg...@gmail.com>> wrote:
>
>
>> On Apr 1, 2019, at 9:20 PM, Rene Romero Benavides > <mailto:rene.romer...@gmail.com
As per your configuration :
max_wal_size = 50GB
this seems to be the cause for the WAL files piling up.
this has been declared twice, the last one is taking effect.
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
I've manage to generate anothe
ize, the smaller the value, the more frequent the
checkpoints, but your checkpoint_timeout value is 300 (5 minutes)
which is likely to be happening first, and thus being the one
triggering checkpoints that often.
On Wed, Apr 10, 2019 at 1:12 PM Rob Sargent <mailto:robjsarg...@gmail.com>>
On 4/26/19 3:25 PM, Steven Schlansker wrote:
Hi Postgres fans,
We store a Java Map in Postgres as a jsonb column.
As json does not have a UUID type, it is of course stored as text.
A simple value might be:
{"04e623c0-6940-542f-a0de-4c999c626dfe": 5000,
"6d3e24b6-9e8c-5eb1-9e4c-f32cc40864
On 4/26/19 3:53 PM, Steven Schlansker wrote:
On Apr 26, 2019, at 2:33 PM, Rob Sargent wrote:
On 4/26/19 3:25 PM, Steven Schlansker wrote:
How can I efficiently implement the feature I've described? It seems difficult
to use computed indexing with GIN.
Storing the map in a
On 5/2/19 9:19 AM, Guntry Vinod wrote:
Hi Adrian\Kiran,
Below is the issue.
We are migrating from Db2 to Postgre.
The Db2 dump consists of back Slash \ with in the data [dump] , but postgre is
not escaping the Slash.
For example if name consist of Vinod\G after the inserting the dump the v
On 5/3/19 10:05 AM, Guntry Vinod wrote:
Hi Team,
Here we go. I will give the problem in more detail
Step 1:We get the dump from DB2 and this dump is flat file which can be csv,txt
Step2:There is table in PostGre where we are suppose to upload the dump
Step3:We are using copy command to uploa
8 is very old but in 9.4 the doc says
The fourth form (your example) changes the default tablespace of the
database. Only the database owner or a superuser can do this; you must
also have create privilege for the new tablespace. This command
*physically moves* any tables or indexes in the dat
Which part confused you Ravi?
Here’s my take
> On May 14, 2019, at 4:06 AM, Ravi Krishna wrote:
>
>>
>>
>> Not , am saying we have the daily backup and full backup in prod server only
>> and there is one database like a4 the db size is 1.5TB.
>> so am not restore again in prod .
Production s
On 5/15/19 2:57 PM, Julie Nishimura wrote:
This puzzles me too! I found that bizarre myself. What is even more
interesting, we have about 80 databases, and all of them now have
default_tablespace=vol4, except only one - "control" database. The
only explanation I would have that all of those da
Don’t use the alias on the column(s) being set.
This passed the parser:
UPDATE personnes T1 SET nom_naiss=T1.nom FROM personnes T2, personnes T3
WHERE T1.id=T2.id_mere AND T2.id_pere=T3.id AND T1.nom != T3.nom;
(I have no data in my table so I can’t confirm the logic. You seem to want to
updat
>
> Each row in the source file (exported from the spreadsheet as .csv and
> renamed to .txt for processing in emacs and awk) is a mixture of attributes
Absolutely no need to rename the .csv for those tools.
> that belong in either or both of the organization and people tables in my
> database. An
> On Jun 10, 2019, at 6:40 AM, Igor Korot wrote:
>
> Hi, Adrian,
>
>> On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver
>> wrote:
>>
>>> On 6/10/19 9:30 AM, Igor Korot wrote:
>>>
>>>
>>> According to
>>> https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserti
>
> >> 1) Are you really wanting to insert a file at a time at the psql command
> >> line?
> >
> > Yes.
> Gnarly. I suppose you could open the pdf in emacs and tell emacs to NOT
> render it. Cut the entire buffer and paste it, properly quoted, into your
> psql command line. But \lo stuff see
Is reindex table redundant after vacuum(analyse,verbose)?
On 6/14/19 2:13 PM, Ron wrote:
On 6/14/19 2:55 PM, Rob Sargent wrote:
Is reindex table redundant after vacuum(analyse,verbose)?
Instead of "redundant", I'd call it "backwards", since doing a
vacuum(analyse,verbose) on a freshly reindexed table seems more fruitf
On 6/19/19 2:49 PM, Tom Lane wrote:
Brent Bates writes:
I tried putting the pg_hba.conf back to stock defaults and that didn't
help any. Here is a snippet of the current file:
# TYPE DATABASEUSERADDRESS METHOD
# "local" is for Uni
> On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote:
>
> Hi,
> I have two arrays which I need to combine based on the individual values;
> i could do a coalesce for each field but was wondering if there is an easier
> way
>
> array_a{a, null,c, d,null,f,null} primary
> array_b{null,2 ,nul
On 6/24/19 4:46 PM, Alex Magnum wrote:
Yes, they are.
On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent <mailto:robjsarg...@gmail.com>> wrote:
On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote:
Hi,
I have two arrays which I need to combi
On 6/24/19 4:46 PM, Alex Magnum wrote:
Yes, they are.
On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent <mailto:robjsarg...@gmail.com>> wrote:
On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote:
Hi,
I have two arrays which I need to combi
On 6/24/19 5:19 PM, David G. Johnston wrote:
On Mon, Jun 24, 2019 at 4:11 PM Rob Sargent <mailto:robjsarg...@gmail.com>> wrote:
On 6/24/19 4:46 PM, Alex Magnum wrote:
Yes, they are.
On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent
mailto:robjsarg...@gmail.co
On 6/28/19 5:41 PM, Benedict Holland wrote:
Hello all,
I really can't figure this one out. I am trying to get debug working
on a postgrseql 10 database on ubuntu. I installed the proper package
postgresql-10-pldebugger*. *When I go to create the extention, I get
the error:
create extension
> On Apr 27, 2023, at 12:40 PM, Michael Xu wrote:
>
>
> Hi,
>
> By default, pgsql accepts double quotes around schema's name in a query, e.g.
> select * from "ads"."MyTableName". In our env, it throws 42P01:relation
> "ads.MyTableName" does not exist. It is okay if no double quote around s
On 5/2/23 13:15, Tomas Pospisek wrote:
Oh, I think your idea to use pgbouncer to take care of the SSL
termination is elegant. I don't think me I'd characterize it as a hack
if properly set up. Why do you consider it a hack?
*t
Let me guess: postgres IS NOT listening on the other port, pgb
On 5/18/23 11:49, Ron wrote:
On 5/18/23 10:54, Stephen Frost wrote:
Greetings,
* Tony Xu (tony...@rubrik.com) wrote:
The FAQ (copied below) mentioned that native transparent data encryption
might be included in 16. Is it fair to assume that it will support database
level encryption, that is, w
On 5/30/23 22:25, Lian Jiang wrote:
hi,
I am using psql to periodically dump the postgres tables into json
files which are imported into snowflake. For large tables (e.g. 70M
rows), it takes hours for psql to complete. Using spark to read the
postgres table seems not to work as the postgres r
> On Jun 8, 2023, at 8:21 PM, Nim Li wrote:
>
> Hello.
>
> We have a PostgreSQL database with many tables, as well as foreign table,
> dblink, triggers, functions, indexes, etc, for managing the business logics
> of the data within the database. We also have a custom table for the purpose
On 7/18/23 11:58, Devin Ivy wrote:
Hi all,
I'm hoping to ensure I understand the implications of dropping a large
table and the space being reclaimed by the database and/or OS. We're
using pg v14.
This table is quite large with a primary key and one additional
index—all together these are o
On 7/19/23 17:15, David Rowley wrote:
On Wed, 19 Jul 2023 at 07:41, Rob Sargent wrote:
You might consider deleting portions of the table in separate (consecutive)
batches (maybe 5% per delete). And then truncate table is not logged so that
might be an alternative.
Can you explain why this
On 8/14/23 09:29, Sai Teja wrote:
Could anyone please suggest any ideas to resolve this issue.
I have increased the below parameters but still I'm getting same error.
work_mem, shared_buffers
Out of 70k rows in the table only for the few rows which is of large
size (700MB) getting the issue.
So the less obvious solution that works is to create a temporary
table. A little verbose, but I get to keep the types.
`CREATE TEMPORARY TABLE _ ON COMMIT DROP AS SELECT OLD.*;`
_ as a table name makes things a little easier to type.
Rhys
Peace & Love | Live Long & Prosper
If the connectio
On 8/15/23 12:38, Adrian Klaver wrote:
On 8/15/23 08:08, Jason Long wrote:
Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?
There are, but make your life easier and learn to use psql:
https://www.postgresql.org/docs/current/app-psql.html
On 8/15/23 12:57, Adrian Klaver wrote:
On 8/15/23 11:43, Rob Sargent wrote:
On 8/15/23 12:38, Adrian Klaver wrote:
On 8/15/23 08:08, Jason Long wrote:
Hello,
Does PostgreSQL have a graphical environment for management or is
it only managed through CLI?
There are, but make your life easier
On 8/16/23 12:30, Guyren Howe wrote:
For some reason, I was thinking the rule could see just the fields
from the command, but you’re right; a rule won’t work. Sorry.
Guyren G Howe
On Aug 15, 2023 at 23:22 -0700, Russell Rose | Passfield Data Systems
, wrote:
I have just had a quick look at rul
> On Aug 16, 2023, at 1:35 PM, Adrian Klaver wrote:
>
> On 8/16/23 12:01, Rob Sargent wrote:
>> On 8/16/23 12:30, Guyren Howe wrote:
>>> For some reason, I was thinking the rule could see just the fields from the
>>> command, but you’re right; a rule won’t wo
On 8/17/23 07:35, Sai Teja wrote:
Hi Team,
Even I used postgreSQL Large Objects by referring this link to store
and retrieve large files (As bytea not working)
https://www.postgresql.org/docs/current/largeobjects.html
But even now I am unable to fetch the data at once from large objects
sele
On 8/21/23 11:17, Edoardo Panfili wrote:
Use the type appropriate getter, not getString, to retrieve the value
of the underlying real typed column.
I know, but in this occasion I need to use text value.
Otherwise, I agree this seems like a bug, probably in the JDBC
driver, though one pertain
On 8/23/23 13:23, Hellen Jiang wrote:
Sorry it is a typo in the email. My readonly role is dbreadonly. It
works well so far except no access to new tables created by read write
role. It has access to new tables created by admin role.
I granted dbreadonly as the following:
-- Read-only role
On 9/6/23 05:08, pgdba pgdba wrote:
Hello, when I restore with Pgbackrest, I get the following error, I
couldn't find a solution when I researched, can you support?
postgres@dev-test:~$ pgbackrest
--config=/etc/pgbackrest/pgbackrest.conf --stanza=db3
--log-level-console=info --type=immediate
On 9/6/23 11:27, pgdba pgdba wrote:
I removed it but I keep getting the same error
OK. The custom here is to put your response at the bottom of short
messages ("bottom post") or intermixed with original as appropriate on
On 9/7/23 23:51, Sai Teja wrote:
Thank you so much for all your responses.
I just tried with Hash, GIN etc
But it didn't worked. And I think it is because of "Xpath" expression
which I used in the index create command.
But is there any alternative way to change this Xpath? Since I need to
p
On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) wrote:
Environment: Ubuntu 22.04 lts, postgres 15 installed via
postgres.org repository
I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html
I’m logged on as the pos
On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) wrote:
Environment: Ubuntu 22.04 lts, postgres 15 installed via
postgres.org repository
I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html
I’m logged on as the pos
On 9/25/23 06:38, Raivo Rebane wrote:
Hi, now I use -
org.postgis
postgis-jdbc
1.3.3
org.postgresql
postgresql
42.5.4
But I got error -
Exception in thread "main" java.lang.NoSuchMethodError:
'org.postgresql.core.Encoding
On 9/28/23 09:41, Raivo Rebane wrote:
Now I changed the Postgres Server to version 15 and making Tomcat 9.0
project.
Now I am using postgresql-42.6.0.jar driver, but Tomcat gives error :
java.sql.SQLException: No suitable driver found for
jdbc:postgresql://localhost:5432/mushroom_database
What
> On Oct 6, 2023, at 7:47 AM, Tom Lane wrote:
>
> Luca Ferrari writes:
>> I'm wondering why in COPY TO (file or program) I cannot use generated
>> columns: since I'm pushing data out of the table, why they are not
>> allowed?
>
> There's a comment about that in copy.c:
>
> * We don't includ
On 10/18/23 10:15, Adrian Klaver wrote:
On 10/18/23 04:27, Shaozhong SHI wrote:
My postgres is playing up.
I terminated session that is causing blocks many time.
New block appears.
Endless.
What should I do?
Provide more information.
1) Postgres version.
2) Define what blocks means.
3)
On 12/6/23 20:45, arun chirappurath wrote:
Hi All,
Is there a way we can disable autocommit option inside query writing
area? Not by choosing auto commit from drop down menu.
Thanks,
Arun
maybe "begin; ; commit;"
On 12/19/23 12:14, veem v wrote:
Thank you for the confirmation.
So at first, we need to populate the base tables with the necessary
data (say 100million rows) with required skewness using random
functions to generate the variation in the values of different data
types. Then in case of row b
On 1/16/24 06:00, Raul Giucich wrote:
Hi Arun, can you share the sql used for this insert. Visually it seems
some character are affecting the data.
Best regards,
Raul
Raul, the OP attached the sq.
On 1/16/24 09:29, Bablu Kumar Nayak wrote:
Dear PostgreSQL Team,
I am writing to inform you that our PostgreSQL database service is
currently down. We are experiencing an unexpected interruption, and we
are seeking your expertise to help us resolve this issue promptly.
We would greatly appr
On 1/16/24 10:20, Ron Johnson wrote:
Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by
a different name (while also referring to it by the original name).
We have an application running on DB2/UDB which (for reasons wholly
unknown to me, and probably also to the current de
On 1/16/24 15:39, Ron Johnson wrote:
On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote:
On 1/16/24 10:20, Ron Johnson wrote:
Some RDBMSs have CREATE ALIAS, which allows you to refer to a
table by a different name (while also referring to it by the
original name).
We have
On 1/16/24 17:03, Ron Johnson wrote:
On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote:
On 1/16/24 15:39, Ron Johnson wrote:
On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent
wrote:
On 1/16/24 10:20, Ron Johnson wrote:
Some RDBMSs have CREATE ALIAS, which allows you
On 1/16/24 17:39, Jim Nasby wrote:
On 1/16/24 4:57 PM, Rob Sargent wrote:
Or perhaps you have to beef the sed up to use word boundaries just
in case.
I'm not a Java web developer... 😁
You need to adjust you glasses if that's what you see me as.
Reality is that bas
> On Jan 18, 2024, at 9:46 AM, Adrian Klaver wrote:
>
> On 1/18/24 08:37, Jim Vanns wrote:
>> Hi Tom/Adrian.
>> 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. Also, I keep havi
On 1/17/24 16:25, Jim Nasby wrote:
On 1/16/24 6:41 PM, Rob Sargent wrote:
On 1/16/24 17:39, Jim Nasby wrote:
On 1/16/24 4:57 PM, Rob Sargent wrote:
Or perhaps you have to beef the sed up to use word boundaries
just
in case.
I'm not a Java web developer... 😁
You need to a
> On Feb 17, 2024, at 8:24 AM, Karsten Hilbert wrote:
>
> Dear list members,
>
> maybe I am overlooking something.
>
> PostgreSQL offers UPSERT functionality by way of
>
>INSERT INTO ... ON CONFLICT ... DO UPDATE ...;
>
> Consider this pseudo-code schema
>
>table master
>
> On Feb 28, 2024, at 8:53 AM, Sasmit Utkarsh wrote:
>
> Hi Postgresql Team,
>
> Getting error while executing the below \df command to list the
> procedures/functions. whereas query gives the appropriate results Please
> assist on how to troubleshoot this.
>
> [sutkars...@dxctravel.svcs.e
On 2/29/24 01:18, Matthew Dennison wrote:
Here's the results:
psql: error: connection to server at "hostname.mydomain.net" (::1), port 5432
failed: GSSAPI continuation error: Unspecified GSS failure. Minor code may provide more
information: No Kerberos credentials available (default cache:
> On Mar 9, 2024, at 9:01 AM, kuldeep singh wrote:
>
>
> Copy may not work in our scenario since we need to join data from multiple
> tables & then convert it to json using row_to_json . This json data
> eventually needs to be stored in a target table .
>>
Wait. You're getting the data
On 3/20/24 10:51, Celia McInnis wrote:
The view is being used in some web query software that multiple people
will be accessing and the contents of the view depend on what the
person is querying, so I think that temporary views or tables are a
good idea. I change to non-temporary views or ta
On 3/27/24 17:05, Jeff Ross wrote:
On 3/27/24 15:44, Tom Lane wrote:
Perhaps "pinned" in the error message means "open"?
No, it means "pinned" ... but I see that plpython pins the portal
underlying any PLyCursor object it creates. Most of our PLs do
that too, to prevent a portal from disapp
On 3/29/24 15:36, David Gauthier wrote:
Ya, I kind of agree on the >1 DB connections not allowed. It
(perl/DBI) does allow for >1 active DB handles (objects). But of
course those handles/objects have different names and that's how to
work with the different ones (not a DB prefix like what
On 6/4/24 11:40, Shaheed Haque wrote:
We use it. I bet lots of others do too.
Of course. There are lots of small, real, useful databases in the wild.
On 6/4/24 13:15, Ron Johnson wrote:
On Tue, Jun 4, 2024 at 2:55 PM Rob Sargent wrote:
On 6/4/24 11:40, Shaheed Haque wrote:
>
> We use it. I bet lots of others do too.
>
>
Of course. There are lots of small, real, useful databases in the
wild.
On 6/12/24 15:48, Ron Johnson wrote:
On Wed, Jun 12, 2024 at 5:28 PM Rich Shepard
wrote:
I have a table with 3492 rows. I want to update a boolean column from
'false' to 'true' for 295 rows based on the value of another column.
Is there a way to access a file with those conditio
On 6/19/24 09:03, Yongye Serkfem wrote:
Hello Engineers,
I am facing an issue with the manual failover of the standby to the
master role. I was able to promote the standby and got it out of
recovery mode. How do I direct applications to point to the standby
which has assumed the role of the
On 6/19/24 15:55, David G. Johnston wrote:
On Wednesday, June 19, 2024, Adrian Klaver
wrote:
On 6/19/24 14:33, Rich Shepard wrote:
On Wed, 19 Jun 2024, Adrian Klaver wrote:
I should have added to previous post:
What is the exact command string you are us
> On Jun 20, 2024, at 7:05 AM, Rich Shepard wrote:
>
> On Thu, 20 Jun 2024, Karsten Hilbert wrote:
>
>> Shot in the dark: are you be any chance using tab-completion
>> when running the SELECT before the COMMIT ?
>
> Karsten,
>
> Nope. I prepare DDL, DML, and DQL scripts in emacs, then run
> On Jul 9, 2024, at 7:21 PM, Krishnakant Mane wrote:
>
>
>> On 7/10/24 06:44, Guyren Howe wrote:
>>> On Jul 9, 2024, at 17:58, Krishnakant Mane wrote:
>>> Hello.
>>>
>>> I have a straight forward question, but I am just trying to analyze the
>>> specifics.
>>>
>>> So I have a set of que
401 - 500 of 643 matches
Mail list logo
