Hi all,
While i'm testing the HEAD version of CVS with this new feature, i
found a possible bug and like that more persons could try it in you
own box.
The attached file is a log of my test and I'm using a unprivileged
user to do it.
Thanks.
--
[]s
Dickson S. Guedes
-------------------------------------
Projeto Colmeia - Florianopolis, SC
(48) 3322-1185 ramal: 27
http://makeall.wordpress.com/
http://pgcon.postgresql.org.br/
http://planeta.postgresql.org.br/
[EMAIL PROTECTED]:/srv/postgresql/HEAD/bin$ /srv/postgresql/HEAD/bin/psql
psql (8.4devel)
Type "help" for help.
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3
(Ubuntu 4.2.3-2ubuntu7)
(1 row)
postgres=# CREATE USER blog;
CREATE ROLE
postgres=# CREATE DATABASE blo
postgres=# CREATE DATABASE blog OWNER
postgres=# CREATE DATABASE blog OWNER blog;
CREATE DATABASE
postgres=# \c blog blog
psql (8.4devel)
You are now connected to database "blog" as user "blog".
blog=> CREATE SCHEMA hr;
CREATE SCHEMA
blog=> CREATE TABLE hr.person(
blog(> nro_doc numeric(10) primary key,
blog(> name varchar(50) not null,
blog(> nro_doc_parent numeric(10) references hr.person(nro_doc)
blog(> );
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "person_pkey"
for table "person"
CREATE TABLE
blog=> SET search_path TO public,hr;
SET
blog=> \dt
List of relations
Schema | Name | Type | Owner
--------+--------+-------+-------
hr | person | table | blog
(1 row)
blog=> \d person
Table "hr.person"
Column | Type | Modifiers
----------------+-----------------------+-----------
nro_doc | numeric(10,0) | not null
name | character varying(50) | not null
nro_doc_parent | numeric(10,0) |
Indexes:
"person_pkey" PRIMARY KEY, btree (nro_doc)
Foreign-key constraints:
"person_nro_doc_parent_fkey" FOREIGN KEY (nro_doc_parent) REFERENCES
person(nro_doc)
Referenced by:
"person_nro_doc_parent_fkey" IN person FOREIGN KEY (nro_doc_parent)
REFERENCES person(nro_doc)
blog=> INSERT INTO hr.person VALUES
blog-> (1234567890,'JOAO DA SILVA',NULL),
blog-> (0987654321,'MARCO ANTONIO DE SOUZA',NULL),
blog-> (0192837465,'MARIA ANTONIETA DA SILVA',1234567890),
blog-> (0987612345,'LUIZ ANTONIO MARCOS',1234567890),
blog-> (0912219083,'ALTAZIGIO FERREIRA MARCOS',0987612345);
INSERT 0 5
blog=> WITH RECURSIVE parents(son_name,son_doc,parent_name,parent_doc) AS
blog-> (
blog(> SELECT name, nro_doc, '' as parent_name, 0 as parent_doc FROM
hr.person WHERE nro_doc_parent is null
blog(> UNION ALL
blog(> SELECT a.name as son_name,
blog(> a.nro_doc as son_doc,
blog(> b.parent_name,
blog(> b.parent_doc
blog(> FROM hr.person a INNER JOIN parents b ON a.nro_doc_parent =
b.parent_doc
blog(> )
blog-> SELECT * from filiacao order by 1,2;
TRAP: FailedAssertion("!(((((Node*)(cte->ctequery))->type) == T_Query))", File:
"parse_target.c", Line: 307)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: LOG: server process
(PID 7055) was terminated by signal 6: Aborted
LOG: terminating any other active server processes
FATAL: the database system is in recovery mode
Failed.
!> LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2008-10-05 17:28:57 BRT
LOG: database system was not properly shut down; automatic recovery in progress
LOG: record with zero length at 0/498380
LOG: redo is not required
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
!> \q
[EMAIL PROTECTED]:/srv/postgresql/HEAD/bin$ /srv/postgresql/HEAD/bin/psql -U
blog
psql (8.4devel)
Type "help" for help.
blog=> WITH RECURSIVE parents(son_name,son_doc,parent_name,parent_doc) AS
(
SELECT name, nro_doc, '' as parent_name, 0 as parent_doc FROM hr.person
WHERE nro_doc_parent is null
UNION ALL
SELECT a.name as son_name,
a.nro_doc as son_doc,
b.parent_name,
b.parent_doc
FROM hr.person a INNER JOIN parents b ON a.nro_doc_parent =
b.parent_doc
)
SELECT * from filiacao order by 1,2;
TRAP: FailedAssertion("!(((((Node*)(cte->ctequery))->type) == T_Query))", File:
"parse_target.c", Line: 307)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: LOG: server process
(PID 7085) was terminated by signal 6: Aborted
LOG: terminating any other active server processes
FATAL: the database system is in recovery mode
Failed.
!> LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2008-10-05 17:30:04 BRT
LOG: database system was not properly shut down; automatic recovery in progress
LOG: record with zero length at 0/4983C4
LOG: redo is not required
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
!> \q
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
