6,040 reputation
31331
bio website
location Berlin, Germany
age 38
visits member for 2 years, 2 months
seen Apr 18 at 4:29

Apr
1
comment Is it impossible to store 2^266 records on a database of some kind?
This question appears to be off-topic because unicorns.
Apr
1
comment Select Into Regexp_replace doesn't write changes into newly generated table
Why not use dollar-quotation?
Apr
1
comment Select Into Regexp_replace doesn't write changes into newly generated table
In other words, your regexp_replace() removes quotes from the start of a line, so at least one of the example data, query and output does not match the others.
Mar
28
comment Select Into Regexp_replace doesn't write changes into newly generated table
SELECT regexp_replace($$6''$$, $$^'*$$, '' , 'g'); returns 6''. Could you please post a set of consistent examples? Also, remove the double quotes if they are not part of the real data.
Mar
28
comment Postgresql Database Disk Size Index Optimization
Also, a (btree) index has a given size (24 byte header + data per row), I'm not sure you can optimize it. Maybe you can think about your use cases. However, it is next to impossible to say anything about your problem without the table and index definitions, data amount (and possibly distribution) and typical queries. Some index usage and table statistics could also help.
Mar
28
comment Add 0 into array_agg if there is no matching data
@user36209 could you show that query please?
Mar
27
comment Add 0 into array_agg if there is no matching data
@user36209 What does it return then?
Mar
27
revised Add 0 into array_agg if there is no matching data
removed NULLIFs
Mar
27
answered Add 0 into array_agg if there is no matching data
Mar
26
comment Altering db schema in production environment
@Alexandros you could have waited a bit more... The question is still less than a day old, no need to hurry.
Mar
25
comment how do I debug postgresql 9.1 server terminating
Is there any other unusual log entry preceding the ones you show? A hint usually does not come alone, it is an addition to some other error/warning.
Mar
21
comment How to use the result of regexp_split_to_array() in stored procedure
You have to declare gps_data as text[].
Mar
21
revised How do I determine if a column is defined as a serial data type instead of an integer based off the catalog?
added 4 characters in body
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
No config changes involved?
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
As root, type su postgres, give the password and check if you can ls /usr/share/pgsql/extension/*trgm* - just for excluding that some of the parent directories is missing the necessary permissions.
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
If you su as postgres, do you still see the files?
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
When you copy pg_trgm--1.0.sql to pg_trgm.sql, does the error go away?
Mar
18
revised compare dates in results
streamlining code
Mar
17
comment Trouble adding foreign key on lots of data in Postgres
Gateway timeout is not exactly a PostgreSQL error, AFAIK... Have you already checked the DB logs? Also, while this is happening, a view on pg_locks may reveal some important clues.
Mar
17
comment Is this temp table behaviour documented?
I remembered something along these lines, just could not find the source (maybe should have tried it harder :)