6,509 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 6 months
seen 9 hours ago

Jun
5
comment How can I get PostgreSQL to not advance sequences when COPY fails?
The sequences are designed like that, the are not supposed to produce contiguous numbers. However, you can reset them before (re)trying the COPY with SELECT setval('sequence_name', (SELECT max(id) FROM table));
Jun
3
comment trigger_file doesn't work
Do the logs tell you something happening when you create the file?
Jun
3
comment Recursive calls in stored procedure and temporary tables
How about moving the 'non-recursive' functionality (including the temp table creation) out to an other function and call the recursive magic from it? At the same time, some indentation in your code could help readers understanding what you try to achieve. At at still the same time, are you sure that floating point variables are good for this sort of calculation?
Jun
3
revised Recursive calls in stored procedure and temporary tables
added 283 characters in body
Jun
3
comment Organizing Database Objects in a Database that are not part of the systems original Database Objects?
On one hand, a sensible naming convention can solve part of your problem. A more sophisticated solution is to use schemas: they are a good way to organize your stuff and also make you able to set access rights at this level.
Jun
2
revised Change column type from varchar to text in all tables at once
added 42 characters in body
Jun
2
comment Change column type from varchar to text in all tables at once
In my experience, all varchar(255) columns are of this type because of false assumptions about the performance gained this way or copypaste-like development behaviour. Usually, over 32 characters or so, limits are not really meaningful.
Jun
1
revised If PostgreSQL starts after copying data, is the data ok?
edited body
Jun
1
revised Is there a configuration setting for how many pages ANALYZE will scan?
added 3 characters in body
Jun
1
comment How un-clustered is a CLUSTER USING table in PostgreSQL
I edited back your title as psql is a client for PostgreSQL, it has no tables at all.
Jun
1
revised How un-clustered is a CLUSTER USING table in PostgreSQL
edited title
Jun
1
revised How un-clustered is a CLUSTER USING table in PostgreSQL
rolled back to a previous revision
Jun
1
comment Optimize a query on two big tables
Nice one! I'd add that one could give better names to these tables. Changing the names could be rather painful, though.
May
30
revised pgAdmin Slony Creation Scripts
deleted 17 characters in body; edited tags
May
30
revised Using PgBarman for PostgreSQL 9.3 backup
edited tags
May
28
awarded  Revival
May
28
revised pgAdmin on a fresh OS X Server installation
added 62 characters in body
May
28
revised Problem JOINing three tables
deleted 508 characters in body
May
28
comment How do I decompose ctid into page and row numbers?
@ErwinBrandstetter: sure :) My builtin orthography processor keeps failing occasionally.
May
27
awarded  Enlightened