hegemon

Warsaw, Poland

19h
awarded Popular Question
20h
awarded Yearling
20h
awarded Teacher
22h
revised Postgresql: datatype for email address
added 71 characters in body
22h
answered Postgresql: datatype for email address
Jul
7
awarded Popular Question
Jun
13
revised Where does the magic column "name" come from?
Added version tag, since the quirk appears to work only in some versions of Postgres.
May
29
comment How to make Chrome remember password for an AJAX form?
This solution works in my app. There's no need to reload whe whole page, only iframe address should change. I've also had to make the target page (blank.html, renamed to blank.php) return a random string to make it work. It' is also wise to use method="post", so that plaintext passwords don't get stored in the server's access log.
May
28
answered Node.js npm install express failed to fetch from registry
May
27
awarded Yearling
May
27
awarded Yearling
May
8
revised Create Alias for PostgreSQL Table
edited body
May
8
comment Create Alias for PostgreSQL Table
In that case you are doomed with triggers or rules, however an upgrade might be easier than implementing those.
Apr
26
answered Create Alias for PostgreSQL Table
Apr
25
comment Looping through a postgres table and returning the wekid
I think the "weekid" can be obtained form date using the following query: select (date_trunc('week', '2014-04-21'::date) + interval '4 days')::date::text; The expression converts any date in the week to last Monday's date, then adds 4 days to advance to Friday (add 5 for Saturday). The result is converted to date and then to string to drop hours from the result./
Apr
25
comment Postgres performs full table scan instead of applying other WHERE clause first
Is it typical for your queries to return no rows? I bet the timing changes when an existing annotation name is selected. Also a question, how many annotation names you have?
Apr
25
comment Duplicate values present in primary key column in postgresql
There is a gotcha: "The schema containing the citext operators must be in the current search_path (typically public); if it is not, the normal case-sensitive text operators will be invoked instead." - maybe you recreated the table in different schema.
Feb
20
awarded Supporter
Feb
14
awarded Popular Question
Feb
10
awarded Nice Answer
1 2 3 4 5