Skip to main content
Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas
  • Member for 7 years, 4 months
  • Last seen more than a month ago
6 votes
1 answer
15k views

Split a comma-separated record into its own rows

5 votes
3 answers
737 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
1k 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
315 views

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

2 votes
0 answers
2k 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
521 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
12k 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
786 views

Creating a foreign server in Postgres only if not exists

1 vote
1 answer
658 views

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

1 vote
1 answer
327 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
782 views

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

1 vote
1 answer
401 views

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

1 vote
2 answers
932 views

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

1 vote
1 answer
49 views

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

1 vote
1 answer
780 views

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

1 vote
1 answer
121 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
55 views

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

0 votes
1 answer
28 views

Why constraint fails on preventing the insert statement execution?

0 votes
2 answers
130 views

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

0 votes
1 answer
47 views

How I can place further constraints upon foreign key?