Marcus Junius Brutus
  • Member for 7 years, 11 months
  • Last seen more than a month ago
4 answers
67 votes
151k views
11 bookmarks
PostgreSQL: Remove password requirement for user postgres
5 answers
58 votes
77k views
15 bookmarks
What is a valid use case for using TIMESTAMP WITHOUT TIME ZONE?
1 answers
32 votes
14k views
10 bookmarks
restoring Postgres database: pg_restore -vs- just using psql
2 answers
23 votes
46k views
5 bookmarks
Disable all constraints and table checks while restoring a dump
1 answers
9 votes
17k views
1 bookmarks
pg_stat_statements not found even with "shared_preload_libraries = 'pg_stat_statements'
2 answers
6 votes
5k views
1 bookmarks
datetime fractional seconds
2 answers
6 votes
16k views
1 bookmarks
Check whether empty strings are present in character-type columns
2 answers
5 votes
562 views
redundant foreign keys in PostgreSQL - are there any indexing benefits?
1 answers
5 votes
593 views
Postgresql - Sybase concepts correspondence
2 answers
5 votes
1k views
1 bookmarks
idiom to treat empty result set as zero
1 answers
4 votes
1k views
PostgreSQL psql command line tool and SET CONSTRAINTS DEFERRED
3 answers
3 votes
4k views
Crow's Foot notation and identifying -vs- non-identifying relationships
1 answers
3 votes
3k views
relationship between transaction chaining and autocommit
1 answers
3 votes
96 views
create User Defined Type with CHECK
0 answers
3 votes
358 views
transaction chaining, isolation levels and atomicity
1 answers
3 votes
1k views
Full text search in XML documents
1 answers
3 votes
1k views
2 bookmarks
how can an additional natural join with the same table twice *reduce* the row count
1 answers
3 votes
9k views
1 bookmarks
how are passwords encoded in pg_shadow
2 answers
3 votes
1k views
SQL order by query results in any arbitrary (but reproducible) manner
1 answers
2 votes
2k views
how do I know whether I am currently in chained or unchained mode
0 answers
2 votes
459 views
why is the 'Dynamic Ownership Chain' mode of a stored procedure mutually exclusive to "chained" / "unchained"?
0 answers
2 votes
1k views
1 bookmarks
allow multiple NULL values in unique key
1 answers
2 votes
3k views
anonymous blocks inside a transaction
1 answers
2 votes
879 views
trigger can't access column loop
2 answers
1 votes
4k views
1 bookmarks
How to see where the default database is configured for a particular username or login name?
1 answers
1 votes
4k views
check if a user-defined type exists before dropping it
1 answers
1 votes
3k views
1 bookmarks
benefit of using [md5] over [trust] authentication for local Unix sockets
1 answers
1 votes
258 views
why is the name `loop` treated differently in PostgreSQL
1 answers
1 votes
216 views
constraint view CASE values
1 answers
0 votes
168 views
Use a DOMAIN in multiple schemas