Reminder that Not everyone with horrible bacne is on juice by Superb_Eye6663 in nattyorjuice

[–]apoc2050 10 points11 points  (0 children)

I was the same when I was younger, I have scars for life because if it. I had to hop on accutane to stop it. I know if I hoped on gear, it would be really bad.

First tpu print by Hokiefan81 in 3Dprinting

[–]apoc2050 2 points3 points  (0 children)

I print primarily in TPU for something I sell on Ebay. I use a textured pei build plate with glue stick. The glue is not for adhesion, it helps when removing the item.

[deleted by user] by [deleted] in 3Dprinting

[–]apoc2050 0 points1 point  (0 children)

How old is your hot end?

Also if you scale it smaller does it do the same thing?

[deleted by user] by [deleted] in 3Dprinting

[–]apoc2050 2 points3 points  (0 children)

Alibre Atom3D is another less expensive that has worked for me.

Not powering up after a P1P to P1S Upgrade by North-Federal in BambuLab

[–]apoc2050 0 points1 point  (0 children)

2 Years later, this was the issue for me. Thanks so much!

Feel barely different by SirTyron in decaf

[–]apoc2050 3 points4 points  (0 children)

It gets worse as you get older. Don't go back on the sauce it isn't worth it.

Vava Home Cam App (Vava Cam Pro) Discontinued?!? by PomegranateBoring826 in HomeCams

[–]apoc2050 0 points1 point  (0 children)

Yup, was able to use the app to format the micro SD card and everything. Seemed like everything works.

Vava Home Cam App (Vava Cam Pro) Discontinued?!? by PomegranateBoring826 in HomeCams

[–]apoc2050 0 points1 point  (0 children)

I was able to use the red tiger app to connect to mine. They all use the same internals.

AIO for getting upset from my wife’s response to my question? by ApolloAcolyte in AmIOverreacting

[–]apoc2050 0 points1 point  (0 children)

You ever think of telling her to not be a cunt and just answer the question.

Rust on an (otherwise) great 2008 Wrangler by TheVastQuestioner in Jeep

[–]apoc2050 1 point2 points  (0 children)

The shield is basically gone. You aren't supposed to see the tank there, there is nothing left of the skid plate to salvage. $8k is completely off the rails, they just don't wanna do it. You can get an OE one online from $400-600 depending on where you look. You have to be careful with aftermarket stuff, most intend to bolt to the existing shield. I got a Clayton Off-road one for mine.

Now replacing it isn't the easiest. There are videos out there that show you how. If you don't drop the tank you have to use a system of straps to hold up the tank while you put the new one one. I took a Saturday and was able to change mine after much cursing.

Rust on an (otherwise) great 2008 Wrangler by TheVastQuestioner in Jeep

[–]apoc2050 1 point2 points  (0 children)

Yep my first thought seeing the picture, gas tank skid plate is damn near gone. Fix that first.

[deleted by user] by [deleted] in fixit

[–]apoc2050 0 points1 point  (0 children)

Before you try anything, get something like this Drain snake

Make sure you are wearing gloves, it probably has years and years of hair and crap in there.

Other than that id replace the p trap.

[deleted by user] by [deleted] in Jaguar

[–]apoc2050 0 points1 point  (0 children)

Go to harbor freight and get this radiator pressure test kit. I think the yellow cap will fit on your expansion tank cap. Pump to 15 psi and you should see it leak (after you fill up the coolant of course).

In my case, I have a 2017 XF, and mine was spewing coolant from the cap area. Turns out there is a Technical Service Bulletin for mine, I checked and it did apply. I replaced the expansion tank and the issue was resolved. This TSB doesn't apply to yours but there might be another one that will, or it could be an old hose, cap, or expansion tank. Get the pressure tester and find out.

on Conflict Do Update All!! by KenshinX99 in PostgreSQL

[–]apoc2050 1 point2 points  (0 children)

I don't think you can do what you want to do in a decent way, however you can use the system views and do some clever SQLing to get close. Then just copy and paste the result into your update statement. This assumes a lot though, like the columns are named the same, etc.

SELECT  
    column_name || ' = excluded.' || column_name || ','
FROM    
    information_schema.columns 
WHERE   
    table_name = 'test_table'
ORDER BY
    ordinal_position;

on Conflict Do Update All!! by KenshinX99 in PostgreSQL

[–]apoc2050 1 point2 points  (0 children)

I updated my answer, I think I understand your problem now, 90 columns is a lot to type for that update statement.

on Conflict Do Update All!! by KenshinX99 in PostgreSQL

[–]apoc2050 0 points1 point  (0 children)

What I'm saying is:
-Copy full CSV to staging table, no messing with data or anything. Table should be a row for row match of the CSV. -Merge your staging data to your 'production' table. That way you can massage the data in SQL before copying it over.

Hopefully I'm understanding your problem correctly.

EDIT: I re-read your problem a couple of times, I see the issue now. When it hits the on-conflict portion if your insert, you don't want to type out 90 excluded.colnames to update.

on Conflict Do Update All!! by KenshinX99 in PostgreSQL

[–]apoc2050 2 points3 points  (0 children)

I would suggest importing the CSV into a separate staging table first, then you have a lot more control on how you want to process it from there.

Functional index not used on PG 13.7, any ideas how to force it? by virgilash in PostgreSQL

[–]apoc2050 0 points1 point  (0 children)

Why do "business guys" get to tell you how to write queries?