Yes it’s possible. The wpdb object can be used to access any database and query any table. Absolutely no need to be WordPress related, which is very interesting. The benefit is the ability to use all the wpdb classes and functions like get_results, etc so that there’s no need to re-invent the wheel. Here’s how: … Read more
First of all your code is unsafe. Need to add the sanitize functions and the escaping query to the database The code is valid. Perhaps the problem is that you are simultaneously writing and deleting to the temporary table “faculty_temp” and the fetch request is sent when data is deleted or modified. Need to change … Read more
I believe this error message is due to a “zombie transaction”. Look for possible areas where the transacton is being committed twice (or rolled back twice, or rolled back and committed, etc.). Does the .Net code commit the transaction after the SP has already committed it? Does the .Net code roll it back on encountering … Read more
There’s a book in Martin Fowler’s Signature Series called Refactoring Databases. That provides a list of techniques for refactoring databases. I can’t say I’ve heard a list of database patterns so much. I would also highly recommend David C. Hay’s Data Model Patterns and the follow up A Metadata Map which builds on the first and is far more ambitious … Read more
you’ve used double quotes on “X”. this should be ‘X’. the X object is an function in the MDSYS schema, “ogc_x”, so when you say est.tipo_estatus = “X” instead of the correct est.tipo_estatus = ‘X’ it gets translated (as “” is as an identifier so “X” is the same as just typing X) to est.tipo_estatus = mdsys.ogc_x and of course fails.
https://www.postgresql.org/docs/current/static/sql-createrole.html These clauses determine whether the new role is a “superuser”, who can override all access restrictions within the database. yes – all privileges in all databases on the specified cluster
I have the below error when I execute the following script. What is the error about, and how it can be resolved? Error: Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF.
I’m in charge of some applications that manage many TB of images. We’ve found that storing file paths in the database to be best. There are a couple of issues: database storage is usually more expensive than file system storage you can super-accelerate file system access with standard off the shelf products for example, many web servers … Read more
SELECT DISTINCT <insert all columns but the PK here> FROM foo. Create a temp table using that query (the syntax varies by RDBMS but there’s typically a SELECT … INTO or CREATE TABLE AS pattern available), then blow away the old table and pump the data from the temp table back into it.