Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas
  • Member for 7 years, 1 month
  • Last seen this week
6 votes
1 answer
13k views

Split a comma-separated record into its own rows

5 votes
3 answers
730 views

Why is NOLOCK implemented like that?

5 votes
1 answer
8k views

Postgresql cannot peer authenticate using usermap (provided user name (^dbuser^) and authenticated user name (^sysuser^) do not match)

4 votes
1 answer
5k views

Could once `max_standby_archive_delay` and `max_standby_streaming_delay` with value -1 can cause replication stop on heavy loads?

3 votes
2 answers
860 views

What the difference between User, Login and role in postgresql?

2 votes
1 answer
3k views

How I can remove autoincrement from a Primary key in postgresql?

2 votes
1 answer
46 views

Ensuring no unwanted tables have changed after a risky operation is performed

2 votes
0 answers
305 views

How I can find out which postgresql I am connected into when behind a load balancer?

2 votes
0 answers
1k views

Does the `hot_standby_feedback=on` may cause `SSL SYSCALL error: EOF detected` error?

1 vote
0 answers
2k views

What does the error means: `SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected (SQL: )`

1 vote
2 answers
9k views

Why does my SELECT query not return null values? [duplicate]

1 vote
1 answer
496 views

How to enforce a column value on duplicate values on postgresql using constraint?

1 vote
0 answers
14 views

How I can find whitch reports use views that are generated from specific tables?

1 vote
2 answers
11k views

How I can filter a array_agg value in postgresql?

1 vote
1 answer
1k views

Would refreshing a materialized view in a transaction allow me to have test-only specific data on it?

1 vote
2 answers
740 views

Creating a foreign server in Postgres only if not exists

1 vote
1 answer
584 views

How I can monitor Amazon RDS Postgresql table size once the `hot_standby_feedback` is on

1 vote
1 answer
314 views

Loading Custom Rules into unaccent postgresql hosted into an amazon aws instance

1 vote
1 answer
2k views

Postgresql cannot restore partial pg_dump "relation "public.my_table_seq" does not exist"

1 vote
1 answer
768 views

List Postgresql foreign data wrappers without the use of the `psql` command

1 vote
1 answer
334 views

How I can find out the foreign wrapper that a foreign table belongs to?

1 vote
2 answers
893 views

Replicate a database with a subset of data offered by custom queries [closed]

1 vote
1 answer
34 views

How I can order my results by relevance when using like?

1 vote
1 answer
674 views

How I can find which sequence is associated with a Primary Key of Serial type? [duplicate]

1 vote
1 answer
105 views

How I can retrieve the latest records without using lateral join?

1 vote
0 answers
17 views

How I can generate statistics for my less used columns of a specific table in my database?

0 votes
1 answer
48 views

How to drop a unique index that is used upon a foreighn key?

0 votes
1 answer
27 views

Why constraint fails on preventing the insert statement execution?

0 votes
2 answers
71 views

How I can check whether 2 databases haves same data and schema fast?

0 votes
1 answer
45 views

How I can place further constraints upon foreign key?