[BUGS] BUG #5068: LIKE
The following bug has been logged online:
Bug reference: 5068
Logged by: Paulo
Email address: correio@gmail.com
PostgreSQL version: 8.4
Operating system: win2003
Description:LIKE
Details:
like to select a field containing Numeric 4 and compared with a char(30)
field.
In oracle and postgresql to version 8.2 worked perfectly, now the new
version no longer works, as we have many queries in this format.
attached to select what worked and from 8.4 no longer works, which featured
not work and select track
...
("A"."ACL_CdCurLet" LIKE btrim(:DB-LIKE))
OR
( (UPPER(translate(btrim("B"."ALE_Ano"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV'))) )
EXEC SQL
DECLARE CSR-CURLET CURSOR FOR SELECT
"A"."EMP_CdEmpresa"
,"A"."ACL_CdCurLet"
,"A"."ALE_CdLetivo"
,"A"."ACU_CdCurso"
,"A"."ACL_NrAulasDia"
,"A"."ACL_DuracaoAula"
,"A"."ACL_Nome"
,"B"."EMP_CdEmpresa"
,"B"."ALE_CdLetivo"
,"B"."ALE_Ano"
,"B"."ALE_Periodo"
,"B"."ALE_NmLetivo"
,"B"."ALE_DataInicio"
,"B"."ALE_DataFinal"
,"C"."ACU_CdCurso"
,"C"."ACU_NmCurso"
,"C"."ACU_AbrCurso"
,"C"."AEN_CdEnsino"
,"D"."AEN_CdEnsino"
,"D"."AEN_NmEnsino"
,"D"."AEN_AbrEnsino"
FROM "aMatCurr" "A"
,"aLETIVO" "B"
,"aCURSO" "C"
,"aENSINO" "D"
WHERE ( "A"."EMP_CdEmpresa" = "B"."EMP_CdEmpresa" )
AND ( "A"."ALE_CdLetivo" = "B"."ALE_CdLetivo" )
AND ( "A"."ACU_CdCurso" = "C"."ACU_CdCurso" )
AND ( "C"."AEN_CdEnsino" = "D"."AEN_CdEnsino" )
AND ( "B"."EMP_CdEmpresa" = :aLETIVO-EMP-CdEmpresa )
AND (
("A"."ACL_CdCurLet" LIKE btrim(:DB-LIKE))
OR
(
(UPPER(translate(btrim("B"."ALE_Ano"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
OR
(
(UPPER(translate(btrim("C"."ACU_NmCurso"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
OR
(
(UPPER(translate(btrim("C"."ACU_AbrCurso"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
OR
(
(UPPER(translate(btrim("D"."AEN_NmEnsino"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
)
ORDER BY "B"."ALE_Ano"
,"C"."ACU_NmCurso"
,"A"."ACL_Nome"
LIMIT :w-Limit
END-EXEC
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #3787: configure: error: readline library not found
The following bug has been logged online: Bug reference: 3787 Logged by: paulo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.14 Operating system: MANDRIVA Description:configure: error: readline library not found Details: Help -me no install configure: error: readline library not found If you have readline already installed, see config.log for details on the failure. It is possible the compiler isn't looking in the proper directory. Use --without-readline to disable readline support. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[BUGS] BUG #4764: error -7 in like translate
The following bug has been logged online:
Bug reference: 4764
Logged by: Paulo Marques
Email address: paulo.da...@gmail.com
PostgreSQL version: 8.3
Operating system: win server 2003
Description:error -7 in like translate
Details:
Select the following operating normally in previous versions and the Oracle,
but in version 8.3 always returns with error -7.
The error occurs just like in the upper (translate...
tanks
---
EXEC SQL
DECLARE CSR-CALENDARIO CURSOR FOR SELECT
"A"."ACA_CdCalend"
,"A"."ALE_CdLetivo"
,"A"."ACA_NmCalend"
,"A"."ACA_DataInicio"
,"A"."ACA_DataFim"
,"B"."EMP_CdEmpresa"
,"B"."ALE_CdLetivo"
,"B"."ALE_Ano"
,"B"."ALE_Periodo"
,"B"."ALE_NmLetivo"
,"B"."ALE_DataInicio"
,"B"."ALE_DataFinal"
FROM "aCALENDARIO" "A"
,"aLETIVO" "B"
WHERE ( "B"."EMP_CdEmpresa" = :aLETIVO-EMP-CdEmpresa )
AND ( "A"."ALE_CdLetivo" = "B"."ALE_CdLetivo" )
AND (
(
(UPPER(translate(btrim("A"."ACA_CdCalend"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
OR
(
(UPPER(translate(btrim("A"."ACA_NmCalend"),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
LIKE
(UPPER(translate(btrim(:DB-LIKE),
'ÁÀÂÃÄÉÈÊËÍÌÎÏÓÒÕÔÖÚÙÛÜÇKZYW',
'AOCCSIV')))
)
OR
(
to_char("A"."ACA_DataInicio",'DD/MM/')
LIKE
btrim(:DB-LIKE)
)
)
ORDER BY "B"."ALE_Ano"
,"B"."ALE_Periodo"
,"A"."ACA_DataInicio"
LIMIT :w-Limit
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4968: Uma ajuda
The following bug has been logged online: Bug reference: 4968 Logged by: Dielton Paulo Email address: dpa...@sefaz.ba.gov.br PostgreSQL version: postgre 8.4 Operating system: Windows XP Description:Uma ajuda Details: Boa Tarde, Trabalho na Secretára da Fazenda do Estado da Bahia, e nós estamos usando o postgre 8.4 estamos tentando acessar o postgre através do access 2000, mas ocorre um erro do tipo "Erro out memory in query". Se vocês puderem nos ajudar agradeço. Atenciosamente, Dielton Paulo -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4969: ajuda
The following bug has been logged online: Bug reference: 4969 Logged by: Dielton Paulo Email address: dpa...@sefaz.ba.gov.br PostgreSQL version: 8.4 Operating system: Windows XP Description:ajuda Details: Good afternoon, Working in the Secretary of Finance of the State of Bahia, and We are using postgres 8.4 we are trying to access the postgres Access by 2000, but an error of type "error out in memory Query. " If you can help us appreciate that. Sincerely, Dielton Paulo -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #5708: configuration php.ini
The following bug has been logged online: Bug reference: 5708 Logged by: paulo pillon Email address: paulo.pil...@bol.com.br PostgreSQL version: 8.3 Operating system: windows 7 Description:configuration php.ini Details: please. preciso de ajuda para configurar o php.ini usando postgres 8.3 no windows 7. já fiz a recomendacao de No Windows descomente a linha com “extension=php_pgsql.dll” e restarte o apache. mas nao habilita o postgres dentro do php. o que posso fazer? grato pela atencao. paulo pillon -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] pg_dump problem
PgSQL 7.0.2
I used pg_dump to dump the schema of a db. I created table part_presencial
with this command
create table part_presencial(
login char(15) not null,
id_curso_polo int4 not null,
data_encontro date not null,
nota numeric(2,2) null,
foreign key(login,id_curso_polo) references matricula,
foreign key(id_curso_polo,data_encontro) references presencial,
primary key(login,id_curso_polo,data_encontro));
But pg_dump gives me this:
CREATE TABLE "part_presencial" (
"login" char(15) NOT NULL,
"id_curso_polo" int4 NOT NULL,
"data_encontro" date NOT NULL,
"nota" numeric(2,2),
PRIMARY KEY ("login", "id_curso_polo", "data_encontro")
);
Why doesn't pg_dump give me foreign keys constraints? It happens to all the
tables with foreign keys.
-
Paulo Roberto Siqueira
[EMAIL PROTECTED]
Database Administrator
Goiania - GO - Brazil
[BUGS] Wrong link
I know it shouldn't be posted here, but I didn't find another place to
point an error on one link in the documentation.
Info Central--> Documentation --> How PostgreSQL Processes a Query -
flowchart, modules.
I tried many times fro three days and always got a message saying that page
couldn't be found.
What's wrong?
Paulo
[BUGS] Problems with my server...
Hi, there !! I've got a problem in my PostgreSQL server. Anytime I issue some commands (like vacuum...) I got the following message: prescricoes=> vacuum; ERROR: cannot find attribute 3 of relation pg_views prescricoes=> what can be wrong ?? I think that all my data is there and I have no views defined, so I really don't know what's going on... Can someone help me?? Thank you for your support, Paulo Ferreira ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
