[BUGS] BUG #4709: dump/restore introduces wrong CHECK constraint for inherited table

2009-03-17 Thread Andrey
The following bug has been logged online: Bug reference: 4709 Logged by: Andrey Email address: and...@ulab.ru PostgreSQL version: 8.3.6 Operating system: rhel-4-i386 Description:dump/restore introduces wrong CHECK constraint for inherited table Details: Assume we

[BUGS] BUG #5123: bug in window function "last_value"

2009-10-16 Thread Andrey
The following bug has been logged online: Bug reference: 5123 Logged by: Andrey Email address: and...@ulab.ru PostgreSQL version: 8.4.1-x86_64 Operating system: RHEL5-x86_64 Description:bug in window function "last_value" Details: EXAMPLE: CREATE TABL

[BUGS] BUG #3840: Termination of postgresql/

2007-12-26 Thread Andrey
The following bug has been logged online: Bug reference: 3840 Logged by: Andrey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux Ubuntu 7.04 Description:Termination of postgresql/ Details: When I try to execute query like SELECT

[BUGS] BUG #5757: PL/PGSQL composite variable field error reporting

2010-11-18 Thread Andrey Galkin
The following bug has been logged online: Bug reference: 5757 Logged by: Andrey Galkin Email address: andv...@gmail.com PostgreSQL version: 9.0.1 Operating system: Debian unstable Description:PL/PGSQL composite variable field error reporting Details: 1. Create a

Re: [BUGS] BUG #5757: PL/PGSQL composite variable field error reporting

2010-11-18 Thread Andrey G.
use entry for table "v_comp" LINE 1: SELECT v_comp.non_existing_field ^ QUERY: SELECT v_comp.non_existing_field CONTEXT: PL/pgSQL function "bug_5757_test" line 4 at IF -- ======== Andre

[BUGS] BUG #5776: Unable to create view with parameter in PL/pgsql

2010-11-30 Thread Andrey Galkin
The following bug has been logged online: Bug reference: 5776 Logged by: Andrey Galkin Email address: andv...@gmail.com PostgreSQL version: 9.0.1 Operating system: Debian unstable Description:Unable to create view with parameter in PL/pgsql Details: Below is simple

Re: [BUGS] BUG #5776: Unable to create view with parameter in PL/pgsql

2010-12-14 Thread Andrey G.
eld = $1   ^ QUERY:  CREATE VIEW v4 AS SELECT * FROM t1 WHERE some_field = $1 CONTEXT:  PL/pgSQL function "bug_create_tmp_view_exec_test" line 3 at EXECUTE statement Andrey 2010/12/13 Robert Haas > > On Tue, Nov 30, 2010

Re: [BUGS] BUG #5776: Unable to create view with parameter in PL/pgsql

2010-12-14 Thread Andrey G.
be a good feature. Andrey 2010/12/14 Pavel Stehule : > Hello > > View must not has a parameter in PostgreSQL. You can use a SRF function: > > postgres=# create or replace function parametrized_view(a int) >                  returns setof foo as $$ >                    

Re: [BUGS] BUG #5776: Unable to create view with parameter in PL/pgsql

2010-12-14 Thread Andrey G.
OK. Thanks, Andrey. 2010/12/14 Pavel Stehule : > Hello > > 2010/12/14 Andrey G. : >> Pavel, >> >> As far as I'm aware, SETOF return creates whole result in memory, what >> has some implications. >> > > it's not true for immutable SQL funct

Re: [BUGS] BUG #5776: Unable to create view with parameter in PL/pgsql

2010-12-14 Thread Andrey G.
Robert, Yes, you've read my mind about quote_literal() ;). The bug report is rising exactly the parameter substitution issue. Andrey 2010/12/14 Robert Haas : > On Mon, Dec 13, 2010 at 4:28 PM, Andrey G. wrote: >> It seems my original test, which also includes the EXECUTE approa

Re: [BUGS] BUG #6585: Can't compile from source code

2012-04-13 Thread Andrey Mitroshin
But 9.0.7 compiles fine. 8.4.11 too. On Thu, Apr 12, 2012 at 03:55:01PM -0400, Tom Lane wrote: > m...@akamit.com writes: > > Operating system: AIX 7.1.0 > > While compiling from source the following error stops the compilation > > process > > > ld: 0711-317 ERROR: Undefined symbol: .mbstowcs_l