[BUGS] RETURN QUERY still does not work perfect in Postgres 8.4

2009-07-03 Thread Michal Szymanski
: http://groups.google.pl/group/pgsql.general/browse_thread/thread/a028c9ed2663b69b?hl=pl# Michal Szymanski http://blog.szymanskich.net -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-05-08 Thread Michal Szymanski
> Exactly what modifications did you make? We have added few new columns and we delete one column. Michal Szymanski http://blog.szymanskich.net -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-05-08 Thread Michal Szymanski
> you have to do vacuum full  cerber.cerber_account Yes I've made vacuum full - result was the same. Regards Michal Szymanski -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-05-08 Thread Michal Szymanski
We use Postgres 8.3.7 on Linux -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] 42804: structure of query does not match error where using RETURN QUERY

2009-05-08 Thread Michal Szymanski
Hi, We call DB procedure that select rows with given ID it works as simple SELECT but for future changes we implement as DB procedure (look below for DB listing). Recently we modified columns in table cerber.cerber_accoun and after this modification procedure does not work anymore and it returns 42

[BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2008-11-06 Thread Michal szymanski
The following bug has been logged online: Bug reference: 4516 Logged by: Michal szymanski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windows Description:FOUND variable does not work after RETURN QUERY Details: This short program

[BUGS] BUG #2494: SCROLL CURSOR does not worl

2006-06-23 Thread Michal Szymanski
The following bug has been logged online: Bug reference: 2494 Logged by: Michal Szymanski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:SCROLL CURSOR does not worl Details: Function with scroll cursor cannot be