no Archives - Page 10 of 10 - Simon Technology Blog

PowerDesigner does not have a Database menu

powerdesigner will only show the database menu when the physical model PDM is selected. You need to double-click pdm to show the database

September 21, 2021By Simo Power Designer database, menu, no, PowerDesignerLeave a Comment

PostgreSQL-9.1 – PgAdmin III does not respond when trying to recover the database

I am trying to restore the database (via a backup file), I am using PgAdmin III (Postgresql 9.1).
After selecting the backup file, a window indicates that pg_restore.exe is running, and then PgAdm

September 21, 2021By Simo Postgresql 9.1, database, III, no, PGADMIN, PostgreSQL, recovery, response, tryLeave a Comment

PostgreSQL remote connection, fatal error: No PG_HBA.conf recorded for host “…”, users “…”, database “…”, SSL close

PostgreSQL remote connection method

Sometimes when connecting remotely, it will report Error connecting to the server: fatal error: not used for host “…”, User “…”, database “…”, pg_hba

September 21, 2021By Simo Postgresql character, close, CONF, connection, database, error, Famless, for, HBA, HBA.conf, host, no, PG, PostgreSQL, Record, remote, SSL, userLeave a Comment

PostgreSQL query is not terminated, the service postgreSQL is not started after reboot

In my work, I am running a complex query. I canceled it and went home yesterday. It is impossible to terminate the query later this morning. There is also a “after termination” “End” function. A co

September 21, 2021By Simo Postgresql no, PostgreSQL, query, Restart, service, startup, TerminationLeave a Comment

PostgreSQL – Is there a way to know the last submission value in the table?

I am using Postgres 9.5. If I update some values of a row and submit them, is there a way to get the old values later? I was wondering if there is something like flashback? But this will be a s

September 21, 2021By Simo Postgresql final, know, method, no, one, PostgreSQL, submit, table, valueLeave a Comment

iPad JavaScript error has no help

I received the following error with iPad, but not in my desktop browser:

JavaScript: Error
undefined
TypeError:’undefined’ is not a function This is a larger js application, this error messa

August 31, 2021By Simo Ipad error, help, iPad, JavaScript, noLeave a Comment

Ruby – Rails Model: Validates_Unique Ness_OF Will not delete the endless space before a unique check? Isn’t the front guide?

Suppose I implement validates_uniqueness_of on the username. If the name’maddy’ already exists, then it will accept the value’maddy’ as the unique value instead of’maddy’. It should remove both sid