Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Vik Reykja
On Tue, Jan 22, 2013 at 2:31 PM, jan-peter.seif...@gmx.de wrote: The statement: 'CREATE EXTENSION uuid-ossp' just gives me a syntax error: ERROR: syntax error at or near - LINE 1: CREATE EXTENSION uuid-ossp ^ ** Fehler ** ERROR: syntax

Re: [BUGS] BUG #7612: Wrong result with join between two values () set

2012-10-18 Thread Vik Reykja
On Thu, Oct 18, 2012 at 5:40 PM, maxim.bo...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 7612 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.2.1 Operating system: Linux Description: Join

Re: [BUGS] hstore parser incorrectly handles malformed input

2012-04-27 Thread Vik Reykja
On Fri, Apr 27, 2012 at 03:12, Tom Lane t...@sss.pgh.pa.us wrote: Does anybody else have an opinion as to which of these solutions is more preferable? I think all unquoted whitespace should be ignored, so I prefer your solution. (note: I haven't actually tested it, I'm going off these emails)

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column xmin

2012-01-26 Thread Vik Reykja
On Wed, Jan 25, 2012 at 22:19, Giuseppe Sucameli brush.ty...@gmail.comwrote: thinking you have no skills, I wrote a patch too and posted it to hackers ML about 2 days ago, but I didn't subscribe that list so it is stalled, waiting for someone's approval. For this reason my email is not

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column xmin

2012-01-24 Thread Vik Reykja
On Tue, Jan 24, 2012 at 14:41, Giuseppe Sucameli brush.ty...@gmail.comwrote: I would try to cook up a patch but I have no skills :-( I'm going to write a patch to fix this problem. I managed to put something together and have posted it on hackers.

Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column xmin

2012-01-23 Thread Vik Reykja
On Mon, Jan 23, 2012 at 11:25, Marc Balmer m...@msys.ch wrote: Am 22.01.12 14:22, schrieb Giuseppe Sucameli: test= create table lx (xmin int); ERROR: column name xmin conflicts with a system column name test= create table lx (i int); CREATE TABLE test= alter table lx add xmin int;

Re: [BUGS] BUG #6192: Incorrect result from operator overlaps

2011-09-01 Thread Vik Reykja
On Thu, Sep 1, 2011 at 10:27, Incorrect result from operator wolfm...@o2.pl wrote: SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps ('2011-08-1'::date,'2011-08-31'::date); Returns false, should return true. According to the documentation, it should return false. Each time period is

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-03-06 Thread Vik Reykja
On Sun, Mar 6, 2011 at 14:29, depst...@alliedtesting.com wrote: The only workaround that I can think of is to use a dummy variable to capture the query result. This has to be done even when the query doesn’t have a result (as when calling a function returning void). do $$declare dummy