Hi List,
Below function throwing error when i execute it on PostgreSQL 9.0.
ERROR: SPI_execute_plan_with_paramlist failed executing query "SAVEPOINT
my_savepoint": SPI_ERROR_TRANSACTION
CONTEXT: PL/pgSQL function "rlbk" line 5 at SQL statement
I searched and found that it is reported to p
Hi,
postgres version: 9.0.3
OS: debian squeeze 64bit
if pg_restore is used with -jN it fails if the dump has comments on indices.
Steps to reproduce (db testdb):
CREATE DATABASE testdb;
\c testdb
CREATE TABLE tab (id INT);
INSERT INTO tab VALUES (1);
CREATE INDEX idx ON tab USING btree (id);
CO
Em 10-02-2011 09:56, Jan-Peter Seifert escreveu:
However, as long as I have BTREE_BUILD_STATS defined, 'make check' fails on
me with the following message:
It is a bug. The attached patch fixes it. I didn't investigate when it was
broken; maybe one or two releases ago when someone reorganizes t
"Jaiswal Dhaval Sudhirkumar" writes:
> ERROR: SPI_execute_plan_with_paramlist failed executing query "SAVEPOINT
> my_savepoint": SPI_ERROR_TRANSACTION
This is not a bug. It's an extremely well-documented limitation that
you can't use those commands in a plpgsql function.
You can get the effect
Arnd Hannemann writes:
> if pg_restore is used with -jN it fails if the dump has comments on indices.
Reproduced here, thanks for the report!
> The problem seems to be a false assumption in pg_backup_archiver.c:
> ...
> Comments are in SECTION_NONE so they get restored here regardless of
> depe
The following bug has been logged online:
Bug reference: 5894
Logged by: Piergiorgio Buongiovanni
Email address: piergiorgio.buongiova...@netspa.it
PostgreSQL version: 8.4.4
Operating system: RedHat Centos
Description:Rules' behaviour when SERIAL data types are used
D
"Piergiorgio Buongiovanni" writes:
> We are experiencing a problem on using rules and serial data types with
> PostgreSQL.
> We are trying to align two tables in two different schemas through rules and
> the main table has a column of data type SERIAL.
> ...
> Now we create a rule in order to alig
Euler Taveira de Oliveira writes:
> Em 10-02-2011 09:56, Jan-Peter Seifert escreveu:
>> However, as long as I have BTREE_BUILD_STATS defined, 'make check' fails on
>> me with the following message:
> It is a bug. The attached patch fixes it. I didn't investigate when it was
> broken; maybe one o
