Here is a query which will look at the pg_catalog views to extract a list of constraints along with their respective schema, table, name, and definition.
pg_namespace.nspname as schema_name,
pg_class.relname as table_name,
pg_constraint.conname as constraint_name,
pg_get_constraintdef(pg_constraint.oid, true) AS constraint_def, *
INNER JOIN pg_catalog.pg_namespace ON pg_constraint.connamespace = pg_namespace.oid
INNER JOIN pg_catalog.pg_class ON pg_constraint.conrelid = pg_class.oid
AND pg_namespace.nspname = 'public'
In a previous post I showed how to fix Ubuntu 20.04 icons. Now with 22.04 it is a bit different. What would normally work does not work now because Firefox is running as a snap package and cannot manage Gnome extensions.
I was having an issue on Ubuntu 20.04 where anytime I would save a file to the desktop, the desktop would freeze for a few seconds, and all icons would disappear or reappear. This happened when dragging items to the Trash as well.
The journey to get the answer was not very direct, but in the end, here is what I did to fix it:
I am not sure if they had any effect or not. I do know that on the 5.10 kernel which comes with linux-oem-20.04, it did not help. On the 5.11 kernel, it also did not help. Not sure if the effect of running it helped on 5.6 or not.
PP0001 is our first Creo 7 based 3D assembly which is going to be built as a physical prototype. It’s been a great exercise in learning Creo, and just simple mechanical engineering. We will have the parts 3D printed via Catalyst Services out of ABS and Nylon. Several reamers have been ordered from McMaster Carr to hopefully achieve a press fit and a slip fit for the steel pins.
One of the harder things in designing machines is figuring out how all of the parts interface with each other precisely. In Creo 7 Parametric, the ability exists to draw a series of master sketches which describe how parts interface, then extrude new bodies from these sketches, then create new parts from the bodies, and finally assemble them.
In this case we wanted to make sure that the follower, despite it’s curved shape, moved perpendicular to the surface of the wheel. We created a series of 4 sketches using many construction lines (which don’t show up after you exit sketching mode). These sketches described the key interface and clearance parts of the mechanism, including the maximum and minimum location of the follower as it rides over the highs and lows of the cam wheel. Using this geometry, we could accurately place the tension spring to put a calculated amount of force between the two parts, while ensuring that there was no part interference.
Additional sketches were then created referencing this base geometry to put the finer details on the actual parts to be extruded. They were then extruded, carefully being sure to mark them each as new bodies. Notice even the pin itself was sketched here because all of the pin holes and the pin itself might as well reference the same size circle.
Each body was then saved to it’s own part:
And finishing touches were placed on each part in it’s own file. It’s important not to clutter up the base part too much, but rather keep it focused on overall shapes to the degree needed to ensure everything fits.
Finally all parts were assembled into an assembly, and further revisions were made to the base sketches to improve overall look, size, and function.
Today I learned that Creo Parametric has first class support for equations which can be turned into sketch items, and the incorporated into a model. In this example I created a sine wave.
y = sin(x*2) * 100
And told Creo to extend it from x=0 to x=900. Here is a picture of editing the equation.
Once I had that curve defined, I created a sketch on the same plane, and then used the “Project” tool to project the sinewave into the current sketch. After adding sides and a bottom, I had a closed shape.
From there it was a simple matter to extrude, offset, cut, and add some colors.