The Heap™ – Consultancy ©®

Dec 13 '16 at 9:28, by Andriy M

I thought "morning" defaulted to "good morning", not "grumpy morning". I'll try to remember to be explicit next time.

I guess that needed some explanation :)

dezso

@TomV thank you very much for your efforts

9:14 AM

Good morning, @dezso

Good morning everyone

9:42 AM

mornin

hot2use

9:56 AM

@TomV Your efforts are appreciated.

1 hour later…

Q: Data entry form/subform in a Many-to-Many relationship

11:00 AM

Could we have this one migrated to Stack Overflow?

I have an Access database with a many-to-many relation. The origin table is called Property and the destination table is called Person. A property can have more than one owner, and a person can own more than one property. I created a join table to accommodate this M-M relationship. Here is the r...

ms-access many-to-many ms-access-2007

The OP seems to agree that the question isn't really about the database side.

in Discussion between Andriy M and Techie_Gus, 2 mins ago, by Techie_Gus

Whatever you may see fit. At the end of the day, the objective is to solve the issue whilst respecting the community guidelines.

Philᵀᴹ

Oooh, Postgres has had Logical Replication committed. github.com/postgres/postgres/commit/…

11:26 AM

@Philᵀᴹ yes. It's an extension currently. Meant to be in core in next major release.

2 hours later…

1:31 PM

@AndriyM voted

Strange. Says it's locked, but doesn't say it's migrated. And the question isn't there in the OP's SO profile, so the migration is indeed not completed.

Even though it's been on hold for 6 min

Could be some kind of delay but seems a little too long now

@AndriyM could it be that people voted to be off topic?

but not send it to SO?

I voted to "off-topic : send it to SO"

@ypercubeᵀᴹ Could be, but then I wouldn't expect it to be locked.

Q: Too many triggers in the database

@ypercubeᵀᴹ I thinkI saw a blue 4 next to "send it to SO" when I cast the last vote

it says "close, invalidated" whatever that means on the timeline

Philᵀᴹ

2:29 PM

-2

Hi this is a theoretical one. I work for small software company and developing multiclient software for medium insursnce compsny to do multlpe areas existing erp adn crm do not do. Our system architect is from times of mainframe and some of developers are too but they smart and learn fast if nee...

trigger architecture application-design check-constraints

No idea what he's asking

But some would say that 1 trigger is too many in a database

@Philᵀᴹ the same user has asked this one (now closed): dba.stackexchange.com/questions/161880/…

2:54 PM

@Philᵀᴹ I think it's about how many business rules in the database is too many.

Which is primarily opinion-based, I'd say

@AndriyM yeah, I got the same from reading it.

But the title says "triggers" ...

Perhaps most of the rules are the kind that they think can be implemented only with a trigger (if they should be implemented in DB).

3:26 PM

@AndriyM I flagged the q.

3 hours later…

Paul Vargas

6:20 PM

@Lamak Sometimes I think about retiring, but what would I do?

Lamak

not really sure

rest?

Paul Vargas

@Lamak Yes! That would be great!

Lamak

I know. Read a book, drink some coffee, etc

2 hours later…

Max Vernon

8:07 PM

migrating databases off of SQL Server 2000 is so much fun. And by fun, I mean no fun at all. Almost every gun in your belt is powerless against that pile of rubble.

@MaxVernon Thank ye gods you are migrating away from SQL 2K

Max Vernon

@TomV yah, every one that goes away is a celebration!

swasheck

DROP ALL DATABASES. RESTART FROM SCRATCH

I have some customers still to support (a handful) on a couple hundred total and everytime I think "oh yes, query analyser to run queries and the other thing to manage the database" is utter disappointment

enterprise manager, shudder

swasheck

enterprise mangler.

that was the BOMB