Re: Duplicate Key Values

On 3/6/25 10:11, mark bradley wrote: Here is the table definition: And here is the error message I get when I try to delete a duplicate: Please answer the following: 1) Did you not see duplicates with the old version of pgAdmin4? 2) What do you see if you use psql? 3) Did you upgrade/move

Re: Duplicate Key Values

On 3/6/25 12:06, mark bradley wrote: My mistake I forgot to Cc list on my previous post, which was: That would be an issue and also would mean it is not a PK. In psql do: \d dataset and show the results as text in your reply. Ccing list The below shows there is an index("dataset_pkey") on

Re: Duplicate Key Values

On 3/6/25 10:36, mark bradley wrote: Reply to list also. Ccing list. 1) Did you not see duplicates with the old version of pgAdmin4? I did see it in my last update but have done a couple, so it should have happened then. 2) What do you see if you use psql? Here is the PSQL output: Supply inf

Re: Quesion about querying distributed databases

On Thu, Mar 6, 2025 at 10:47 AM Igor Korot wrote: > Hi, > > On Thu, Mar 6, 2025, 7:32 AM Greg Sabino Mullane > wrote: > >> On Wed, Mar 5, 2025 at 9:44 PM me nefcanto wrote: >> >>> Anyway, that's why I asked you guys. However, encouraging me to go back >>> to monolith without giving solutions on

Re: Duplicate Key Values

Here is the table definition: [cid:ecac8e92-826b-45c8-95a8-aaf0e55c4f9c] And here is the error message I get when I try to delete a duplicate: [cid:a0f5f298-984d-4f89-abd2-475c02e65b9d] Mark Brady, amazon.com/author/markjbrady __

Re: Error on query execution

Igor Korot writes: > On Tue, Mar 4, 2025 at 8:37 PM Tom Lane wrote: >> ... but given that you didn't specify any data type, I think the >> parser will fall back to assuming that $1 is the same type as >> "abf_type", whatever that is. Passing data in binary is not at all >> forgiving about gettin

Re: Error on query execution

H, On Tue, Mar 4, 2025 at 8:37 PM Tom Lane wrote: > > Igor Korot writes: > > binaryIntVal = htonl( (uint32_t) type ); > > paramValues[0] = (char *) &binaryIntVal; > > paramLengths[0] = sizeof( binaryIntVal ); > > paramFormats[0] = 1; > > You're apparently trying to pass this para

Re: Quesion about querying distributed databases

Hi, On Thu, Mar 6, 2025, 7:32 AM Greg Sabino Mullane wrote: > On Wed, Mar 5, 2025 at 9:44 PM me nefcanto wrote: > >> Anyway, that's why I asked you guys. However, encouraging me to go back >> to monolith without giving solutions on how to scale, is not helping. >> > > We did. In addition to the

Re: Quesion about querying distributed databases

On 3/5/25 11:55, Laurenz Albe wrote: On Wed, 2025-03-05 at 12:57 +0330, me nefcanto wrote: Right now this data is in MariaDB, on separate databases (schema) but on one server. The solution in this situation is to have a cross-database query. (this is the status quo of our application) Now our

Re: Quesion about querying distributed databases

On Wed, Mar 5, 2025 at 9:44 PM me nefcanto wrote: > Anyway, that's why I asked you guys. However, encouraging me to go back to > monolith without giving solutions on how to scale, is not helping. > We did. In addition to the ongoing FDW discussion, I mentioned read-only replicas and Citus. As fa

Re: psql and regex not like

On Thu, Mar 06, 2025 at 04:37:56AM -0500, Ron Johnson wrote: > This statement runs great from the psql prompt. Does exactly what I want. > select datname from pg_database WHERE datname !~ 'template|postgres' ORDER > BY datname; > But it doesn't work so well from the bash prompt. Not escaping the

Re: Quesion about querying distributed databases

On Thu, 2025-03-06 at 12:15 +0330, me nefcanto wrote: > We had problems with cross-server queries on SQL Server and MariaDB too. > It seems that cross-server queries are not solved by any engine. But we > had no problem with cross-database queries. That's where it worked well > both on SQL Server a

Re: Review my steps for rollback to restore point

Dear Team, Thank you for all the responses I have received in this matter. I would like to send my final steps that I am going to follow during PITR. kindly take some out to see if these steps are correct or need any correction or advise. *Performing Database rollback using PITR* *Steps: * *Pre

Re: Quesion about querying distributed databases

Hi, On Thu, Mar 6, 2025, 1:44 AM me nefcanto wrote: > I appreciate your time guys. Thank you very much. > > > Having 1 table per database per server is too ugly. > > Our databases are not one table per database. They are mapped to DDD's > bounded contexts and usually by one table per domain enti

Re: psql and regex not like

Hi, On 3/6/25 10:37, Ron Johnson wrote: This statement runs great from the psql prompt.  Does exactly what I want. select datname from pg_database WHERE datname !~ 'template|postgres' ORDER BY datname; But it doesn't work so well from the bash prompt.  Not escaping the "!" generates a bunch o

Re: psql and regex not like

On Thu, Mar 6, 2025 at 4:59 AM Dominique Devienne wrote: > On Thu, Mar 6, 2025 at 10:38 AM Ron Johnson > wrote: > > This statement runs great from the psql prompt. Does exactly what I > want. > > select datname from pg_database WHERE datname !~ 'template|postgres' > ORDER BY datname; > > > > Bu

Re: psql and regex not like

On Thu, Mar 6, 2025 at 10:38 AM Ron Johnson wrote: > This statement runs great from the psql prompt. Does exactly what I want. > select datname from pg_database WHERE datname !~ 'template|postgres' ORDER BY > datname; > > But it doesn't work so well from the bash prompt. Not escaping the "!" >

Re: Quesion about querying distributed databases

On Thu, 2025-03-06 at 06:13 +0330, me nefcanto wrote: > I once worked with a monolithic SQL Server database with more than 10 billion > records and about 8 Terabytes of data. A single backup took us more than 21 > days. > It was a nightmare. Almost everybody knows that scaling up has a ceiling, bu