Re: [BUGS] BUG #7644: Missing implicit types of Result and failing type-conversion

2012-11-12 Thread Bernhard Reutner-Fischer
On 10 November 2012 16:58, Tom Lane wrote: > "Bernhard Reutner-Fischer" writes: > > Fair enough but what about the failure for the case with the Result > > that fails to merge? There I do have a cast > > No you don't: > > >

Re: [BUGS] BUG #7644: Missing implicit types of Result and failing type-conversion

2012-11-11 Thread Bernhard Reutner-Fischer
On 10 November 2012 16:20:24 Tom Lane wrote: rep.dot@gmail.com writes: > select distinct on (bug) bug > from ( > select * from (select 'string one' AS bug from generate_series(0,1)) > s1 > UNION > select * from (select 'string two' bug from generate_series(0,0)) > s2

Re: [BUGS] BUG #6315: FETCH NEXT :next ROWS ONLY fails

2011-12-01 Thread Bernhard Reutner-Fischer
On 1 December 2011 22:50, Alvaro Herrera wrote: > > Excerpts from Tom Lane's message of jue dic 01 18:32:58 -0300 2011: >> Boszormenyi Zoltan writes: >> > 2011-12-01 20:09 keltezéssel, rep.dot@gmail.com írta: >> >> Binding for "OFFSET :offset" works fine but binding for a >> >> "FETCH NEXT :

Re: [BUGS] BUG #4549: ecpg produces code that don't compile

2008-11-26 Thread Clemens A. Fischer
7; to if(var_name != NULL) *(strchr( ... or something like that? Clemens Am Mittwoch, den 26.11.2008, 14:20 +0100 schrieb Michael Meskes: > On Tue, Nov 25, 2008 at 10:44:32AM +, Clemens Fischer wrote: > > Using ecpg and gcc generates the following output: > > ecpg -t -o ecpgtest-multi

Re: [BUGS] BUG #4550: ecpg problem with copy command and hostvar

2008-11-26 Thread Clemens A. Fischer
Hallo Michael, Am Mittwoch, den 26.11.2008, 14:49 +0100 schrieb Michael Meskes: > On Tue, Nov 25, 2008 at 12:28:38PM +, Clemens Fischer wrote: > > The copy command can't be used with a hostvar. > > This is essentially the answer. The major difference between the ecpg ver

[BUGS] BUG #4550: ecpg problem with copy command and hostvar

2008-11-25 Thread Clemens Fischer
The following bug has been logged online: Bug reference: 4550 Logged by: Clemens Fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: QNX 6.3 Description:ecpg problem with copy command and hostvar Details: Hello List, Don't

[BUGS] BUG #4549: ecpg produces code that don't compile

2008-11-25 Thread Clemens Fischer
The following bug has been logged online: Bug reference: 4549 Logged by: Clemens Fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: QNX 6.3 Description:ecpg produces code that don't compile Details: Hello List, Don't kn

[BUGS] BUG #4266: regress test: could not dump unrecognized node type: 925

2008-06-26 Thread Clemens Fischer
The following bug has been logged online: Bug reference: 4266 Logged by: Clemens Fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: QNX Description:regress test: could not dump unrecognized node type: 925 Details: I cannot decode

[BUGS] BUG #4265: PostgreSQL fails to compile

2008-06-26 Thread Clemens Fischer
The following bug has been logged online: Bug reference: 4265 Logged by: Clemens Fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: QNX Description:PostgreSQL fails to compile Details: I cannot decode any information of this bug in

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Mika Fischer
* Tom Lane <[EMAIL PROTECTED]> [2008-03-17 14:44]: > "Mika Fischer" <[EMAIL PROTECTED]> writes: > > I'm currently working on the bash-completion package. The problem with > > postgresql is that psql cannot safely be called because there is no way to >

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Mika Fischer
* Alvaro Herrera <[EMAIL PROTECTED]> [2008-03-17 15:43]: > Hmm, why do you need to connect to a database? Some time ago I came up > with this: > > _postgres() > { > local cur; > COMPREPLY=() > cur=${COMP_WORDS[COMP_CWORD]} > prev=${COMP_WORDS[COMP_CWORD-1]} >

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Mika Fischer
* Tom Lane <[EMAIL PROTECTED]> [2008-03-17 15:28]: > Mika Fischer <[EMAIL PROTECTED]> writes: > > What the current code does is: > > Run "psql -l" to get the list of local databases, and > > run "psql -qtc 'select usename from pg_user'

[BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Mika Fischer
The following bug has been logged online: Bug reference: 4040 Logged by: Mika Fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Ubuntu Linux 8.4 beta Description:psql should provide option to not prompt for password Details: Hi

[BUGS] Problem identifying constraints which should not be inherited

2007-04-12 Thread Chris Fischer
notice that the check constraint is not created with ONLY in the dump and, therefore, ends up on t2 when executed. Chris Fischer Database Engineer <http://www.channeladvisor.com/> ChannelAdvisor Corporation 2701 Aerial Center Parkway Morrisville | North Carolina | 27560 919.228.2011 M

[BUGS] [postgres] pgcluster

2005-11-15 Thread Stephan Fischer
Hi, ich bin dabei DB-Server zu einem Cluster zusammen zuführen mit PGCLUSTER. Hat schon jemand von euch damit gearbeitet und kann mir mal seine Meinung/Erfahrung dazu sagen (positiv oder negativ). Werde auch meine Erfahrung noch Erfolg hier mal posten. Server: 7.4.1 (suse9.0) pgcluster-1.1 Grüs

[BUGS] BUG #1852: compilation failed

2005-08-28 Thread fischer
The following bug has been logged online: Bug reference: 1852 Logged by: fischer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 beta1 Operating system: irix Description:compilation failed Details: mipspro 7.43. CFLAGS=-O3 -mips4. options: ./configure

[BUGS] I can't start postgres anymore

2002-11-08 Thread Fabien Fischer
Hello, I can't start postgres anymore When I try to start postgresql script I've the following error message in the logfile : ### DEBUG: database system was interrupted being in recovery at 2002-11-07 14:12:46 CET This probably means that some data blocks are corrupted and you w