« first day (3340 days earlier)      last day (34 days later) » 

6:26 AM
@Philᵀᴹ Nice. I was always more into techno than house but I've always wanted to see Lucy Fur live
6:57 AM
I'll put some of those names in a mixcloud search though
7:14 AM
7:29 AM
7:45 AM
Morning all!
@McNets Worse than ships on fire off the shoulder of Orion, a table with 35,000 (yes, 35k - that's not a typo) fields!
@Vérace ouch
8:19 AM
Q: Possibility to use typesetting on Database Administrator site

LennartThough not daily, from time to time it would be really good to be able to use typesetting (like MathML, Latex, etc) to be able to express formulas etc for theoretical stuff. In the long run, I think the site would benefit from it since it would encourage more detailed explanations in question/an...

8:38 AM
@TomV-trytopanswers.xyz my other half is a techno producer
8:55 AM
@MasterDatabase One of the objections is performance - but aren't we constantly being told (well, if you look it up anyway) how efficient SE is and how the whole site is practically running on the spare CPU cycles of Joel Spolsky's mother's washing machine?
Following up on the answer in a comment on meta with a message in chat?
I guess that's one way to avoid down votes
btw I haven't closed it as a dupe because I don't mind us revisiting this after 4 years
I don't remember it all that well, but I think the performance objections were more about client rendering speed than the impact on the servers.
You'd also have to think about the impact of TeX-specific bugs appearing on dba, or breaking existing posts in some way...and so on. I don't think it's necessarily as simple as just turning it on and enjoying the benefits.
This other meta Q & A is a great place to explore performance (especially scrolling speed):
Q: MathJax basic tutorial and quick reference

MJD(Deutsch: MathJax: LaTeX Basic Tutorial und Referenz) To see how any formula was written in any question or answer, including this one, right-click on the expression it and choose "Show Math As > TeX Commands". (When you do this, the '$' will not display. Make sure you add these. See the next p...

10:01 AM
Q: Planned maintenance scheduled for Saturday, March 7, 2020 at 14:00 UTC (9AM US/Eastern)

Taryntl;dr; Planned service interruption that will impact all Stack Overflow/Stack Exchange sites, Jobs, Chat, and Teams. All sites will be read-only for up to an hour on Saturday, March 7, 2020. Enterprise cloud-hosted instances will not be impacted. Short Version: There will be a service degradati...

10:32 AM
What could go wrong
For a short time I was confused by "Intermediate Version of What's Taking Place?", because I read it at first as "[Intermediate Version of What]'s Taking Place?" rather than as "Intermediate Version of [What's Taking Place?]"
11:06 AM
@PaulWhite9 everything
11:45 AM
@Taryn Don't make plans for Sunday :)
4 hours later…
3:25 PM
@Taryn Is Score in Comments nullable because the column was added to the table later and NULL was just a fast way of adding it? There seem to be no nulls in that column, and it's not obvious what null would mean.
3:53 PM
@PaulWhite9 I'm trying to get the answer to this.
@PaulWhite9 it was added far later - there wasn't voting on comments when they were originally added
4:06 PM
@Taryn what would happen if you manually edited the score to a negative value? Would it appear?
@ypercubeᵀᴹ not sure, I'd have to dig into the code.
4:32 PM
Just update one comment in a random, low viewed post and see how long it takes until it shows up on Meta as how did this get -1?
4:59 PM
Yeah, do it. This Saturday. We'll blame the leap year.
5:10 PM
we almost scheduled the SQL upgrade for this Saturday
6:07 PM
Q: How do I prevent PostGIS's "ST_MakeEnvelope" function from returning more than four "corners"?

JhonathanThis is weird. I haven't made any changes to my SQL or application code in quite some time, yet in the last few days, it's suddenly started throwing tons of errors. It seems to be related to how PostGIS's function "ST_MakeEnvelope" has started outputting more than four "corners" or "coordinates",...

^^^ Should it be closed as tip of the iceberg or Too localized?
Have a look at comments
I think it was an error ;)
1 hour later…
7:24 PM
goddamn I really wish sql server had an 'everything else' like * is for all
7:56 PM
@James look at EXCEPT
I think he means in a select statement
select * not including SomeColumn, OtherColumn from....
SQL Assistant - Softtreetech (<== Advertisement; no Ref Code)
> SQL Assistant will boost your database development productivity by 300%
Great, I can do nothing faster!
8:02 PM
300%, hmm, that won't make me a 10xer
Yeah. Sux.
If I use SQL Assistant on top of SQL Assistant, will that make me as productive as (x+300%)²?
On an unrelated topic - how come my newly created postgres roles can't log in? Everything except the postgres user gets an "password authentication failed for user" error. None of the Google results appear to be related so I have to assume I'm creating the role incorrectly somehow.
This is my first semi-serious foray into postgres so it's safe to assume that the dumbest possible answer to my question is probably correct.
You might want to aim for a too localized on the main site.
@MikeTheLiar did you start your scripts with "By the power of GraySkull"?
8:08 PM
Did you modify the pg_hba.conf file to allow your host to connect?
That might be the dumbest answer
@James of course. I'm assuming the database reads my comments
@Johnakahot2use not intentionally
But if I use the postgres mega-database-admin account, it works
local connection or remote?
drop role if exists TestUser;
create role TestUser with
password 'Correct-Horse-Battery-Staple'
valid until '2200-01-01';
My Password Generator Excel Sheet spits out this:
Looks similar.
Without quotes " the TestUser probably gets lower-cased to testuser.
That might be the second dumbest answer
select * from pg_roles;
@MikeTheLiar yup
8:24 PM
Interestingly, when I try to connect via CLI testuser does not exist
your login command in my PostgreSQL -----^
My command ------^
And it would have to be:
DROP ROLE "TestUser";
This is weird but I'm willing to chalk it up to "stuff I don't understand and use the quotes" but:
With "TestUser" my app can connect to the database at least. It fails immediately for an unrelated reason but it connects, so I'm calling that a win
"Second Dumbest Answer" FTW
wait a second
I can read, I promise
That first error message is the database "testuser" does not exist
psql -h HOSTNAME -p 5432 -U TestUser -W DATABASENAME
8:45 PM
This is back to the TestUser without quotes:
But I'm willing to let this be confined to the dustbin of the ages
If I had to understand every weird error I encountered, I'd never get anything done
Mine works as designed with double-quotes:
Q: PostgreSQL error: OperationalError: FATAL: role "username" does not exist

MiskinSenseiI got this error When I'm trying to run the Code. I searched the site like this problem But It couldn't solve my problem. When I'm trying to create superuser with my username (which is TCOYUKSEL) , It create another one with "tcoyuksel" ozgur.py Line 9 db = psycopg2.connect("dbname=news"...

I mis-typed the Correct-Horse-Battery-Staple password first time round.
cu. Off back home.
@Johnakahot2use The definite conclusion here is either user double quotes or snake_case_all_the_things
My guess is snake case is the preferred style with Postgres
8:52 PM
A reasonable_guess
Curiously, the SQL Server system catalogs prefer snake case while the famous demo database AdventureWorks uses camel case. For some reason I find this rather minor issue very puzzling
9:28 PM
But what about pubs?
It's my understanding that Microsoft has been known to outsource things like the creation of demo databases
9:49 PM
@Taryn Thank you!

« first day (3340 days earlier)      last day (34 days later) »