Packaging pgAdmin 4

2021-11-27 Thread Blake McBride
Greetings, I've had ongoing difficulties installing pgAdmin 4. These difficulties have to do with the way pgAdmin is packaged and distributed. For example, I use LinuxMint and Manjaro. The pgAdmin distributions support neither. Although Mint is a derivative of Ubuntu, lsb_release -cs returns a

Re: Packaging pgAdmin 4

2021-11-27 Thread Chuck Davis
Have you checked your distro repositories? The distro I use ships pgAdmin together with the latest and previous versions of postgresql. On Sat, Nov 27, 2021 at 10:52 AM Blake McBride wrote: > Greetings, > > I've had ongoing difficulties installing pgAdmin 4. These difficulties > have to do wit

Match 2 words and more

2021-11-27 Thread Shaozhong SHI
this is supposed to find those to have 2 words and more. select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$'; But, it finds only one word as well. It appears that regex is not robust. Can anyone shed light on this? Regards, David

Re: Packaging pgAdmin 4

2021-11-27 Thread Rob Sargent
> On Nov 27, 2021, at 1:09 PM, Chuck Davis wrote: > >  > Have you checked your distro repositories? The distro I use ships pgAdmin > together with the latest and previous versions of postgresql. > >> On Sat, Nov 27, 2021 at 10:52 AM Blake McBride wrote: >> Greetings, >> >> I've had ongoin

Re: Match 2 words and more

2021-11-27 Thread Rob Sargent
> On Nov 27, 2021, at 5:27 PM, Shaozhong SHI wrote: > >  > this is supposed to find those to have 2 words and more. > > select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$'; > > But, it finds only one word as well. > > It appears that regex is not robust. > > Can an

Re: Match 2 words and more

2021-11-27 Thread Alvaro Herrera
On 2021-Nov-28, Shaozhong SHI wrote: > this is supposed to find those to have 2 words and more. > > select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$'; > > But, it finds only one word as well. How about something like this? '^([[:<:]][[:alpha:]]+[[:>:]]( |$)){2}$' You

Re: Match 2 words and more

2021-11-27 Thread Guyren Howe
On Nov 27, 2021, at 16:27 , Shaozhong SHI wrote: > > select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$’; The simplest thing that does what you says is I think: select name FROM a_table where "STREET_NAME" ~ ‘^([[:alpha:]]+\s)+[[:alpha:]]+$’;

Re: Match 2 words and more

2021-11-27 Thread David G. Johnston
On Sat, Nov 27, 2021 at 5:27 PM Shaozhong SHI wrote: > this is supposed to find those to have 2 words and more. > > select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ > ]+[:alpha:]+$'; > > But, it finds only one word as well. > > It appears that regex is not robust. > > Can anyone shed

Re: Match 2 words and more

2021-11-27 Thread Ron
On 11/27/21 6:49 PM, Alvaro Herrera wrote: On 2021-Nov-28, Shaozhong SHI wrote: [snip] It appears that regex is not robust. This was my attitude when I first started to learn computer programming. /My code is perfect, i//t can't be my fault!! There must be a compiler bug!!!/ Nah. Just i

RE: [EXTERNAL] Re: Inserts and bad performance

2021-11-27 Thread Godfrin, Philippe E
Hi Gavin – thanks I hadn’t realized that about psychopg. I’m on the earlier version, so I can’t use what you recommended at this point. But I did use copy_expert. Interestingly enough the performance of the copy statement is only slightly better than the insert, as I was running inserts with 50

RE: [EXTERNAL] Re: Inserts and bad performance

2021-11-27 Thread Godfrin, Philippe E
Right you are sir! I figured that out a few hours ago! pg From: Ron Sent: Wednesday, November 24, 2021 10:58 PM To: pgsql-general@lists.postgresql.org Subject: [EXTERNAL] Re: Inserts and bad performance On 11/24/21 1:15 PM, Godfrin, Philippe E wrote: [snip] I dropped the unique index , rebuilt