Hi all I experience the same problem.
Is there a tutorial to track theese kind of problems?
tks
Razvan
Hello Ann
Well, that was not the case, because without the word CONSTRAINT has failed
and with that word has worked fine and I was the only user of the database
at that moment.
But no problem, I know the solution: always use the word CONSTRAINT.
Greetings.
Walter.
On Sun, Aug 23, 2015 at
Hello Karol
No, I don't have a backup previous to add the Primary Key then I can use
for reproduce the problem.
Using ISQL, one time I try to add the Primary Key without using the word
CONSTRAINT, seconds later I try again but using the word CONSTRAINT. The
first time had failed, the second time
Hi,
Please provide full error text and detailed description of the problem.
Regards,
Alexey Kovyazin
IBSurgeon
Hi all
I experience the same problem.
Is there a tutorial to track theese kind of problems?
tks
Razvan
As far as I can tell it sorts as it should. What sort are you expecting?
Mark
- Reply message -
Van: 'Bogdan' bog...@mordicom.si [firebird-support]
firebird-support@yahoogroups.com
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] Error in order by clause
Datum: ma,
It should be
SUMA A B C D E
12 14 2 1 11 1
0 3 3 2 12 2
-1,11,2 2,3 1 11 3
-1,8
Hello Karol
Thank you for your answer.
The query is a very simplified one, just for show the idea.
I can create an index as the following:
CREATE INDEX IDX_ASIENTOSDET1 ON ASIENTOSDET COMPUTED BY (
CAST(ASI_ANOEJE AS CHAR(5)) ||
CAST(ASI_CODSUC AS CHAR(5)) ||
CAST(EXTRACT(MONTH FROM
Hi,
what about drop this PK
do backup restore and try again?
P.S.
If you previously name some constraint as INTEG... then conflict with name can
appear
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015 5:00 PM
To:
On 21/08/15 14:17, 'Bogdan' bog...@mordicom.si [firebird-support] wrote:
order by iif(:i = 1, t.c, IIF(:I = 0, sum(t.a) - sum(t.b), E))
DESCENDING
If i run it with i = 0 it gives wrong sort order.
SUMA A B C D E
-1,11,2
Hi,
No – you can not create single index on more then one table
But you really need it?
How big is resultset? I do not see any filter in this query no HAVING nor WHERE
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24, 2015 7:28 PM
To:
Hello Karol
As I had said before, it is a mystery for me. The Primary Keys created by
me always begin with the PK_ characters, if they begin with INTEG_ is
because were created by ISQL.
But not problem at all, using CONSTRAINT it is solved.
Greetings.
Walter.
On Mon, Aug 24, 2015 at 12:51
Hello everybody
I had the following query:
SELECT
D.ASI_ANOEJE,
D.ASI_CODSUC,
EXTRACT(MONTH FROM C.ASC_FECHAX) AS ASI_NUMMES,
D.ASI_NUMCUE,
D.ASI_NUMSUB
FROM
ASIENTOSDET D
JOIN
ASIENTOSCAB C
ON D.ASI_CODSUC = C.ASC_CODSUC AND
D.ASI_IDECAB = C.ASC_IDENTI
GROUP
Hi-
I used this to get by the error: su: failed to execute /bin/nologin: No such
file or directory
I changed to sbin instead of bin in /etc/passwd
I also log in like this for firebird user:
# su - firebird -s /bin/bash
Now I am getting under the firebird user:
I was told to
Hi-
I changed firebird to #: passwd myfb at the command-line.
At su firebird I get:
su: failed to execute /bin/nologin: No such file or directory
firebird:x:901:902::/:/bin/nologin
not sure what I am doing wrong. I am using firebird 2.5.4 fedora xfce classic.
Please assist!
Addendum: with
Hi-
I figured this question out. An updated NEW question is coming. Thanks for any
assistance.
thanks!
Hi,
as i say previously you can not do this
as index can not be updated if something was changed in ASIENTOSCAB.
And any subseclect is not recognized by plan parser as expression index def
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24,
Hi,
as i say previously you can not do this
as index can not be updated if something was changed in ASIENTOSCAB.
And any subseclect is not recognized by plan parser as expression index def
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, August 24,
Hi,
Probably you mean Lock conflict, not a true deadlock (full error text
will help).
If you see transaction number in the message, you can track it using
MON$ tables, and then find out which connection has started it.
Regards,
Alexey Kovyazin
IBSurgeon
Hi All
If possible at all, how
Hi All
If possible at all, how can I trace which workstation (Firebird Client) is
holding a record hostage and thus causing a deadlock conflict?
Regards
Stef van der Merwe
email s...@autotech.co.za
[Non-text portions of this message have been removed]
Hi to all
Server: Firebird 2.5.4.
I have following stored procedure:
ALTER PROCEDURE TEST_ (
I SMALLINT)
RETURNS (
SUMA NUMERIC(15,2),
A NUMERIC(15,2),
B NUMERIC(15,2),
C INTEGER,
D VARCHAR(10),
E VARCHAR(10))
AS
begin
for select sum(t.a) -
Hi-
I have more intel on the problem.
SQL connect localhost:/var/lib/firebird/data/employee.fdb user SYSDBA
password mypass;
Statement failed, SQLSTATE = HY000
Can't access lock files' directory /tmp/firebird/
I have the fb listening on 3050 now.
tcp6 0 0 :::3050
You are not supposed to login as user Firebird, that is also why it is pointing
to nologin. That user is only the user for running the service, and for
security reasons you shouldn't login with it.
To connect to Firebird, you need to have an account in Firebird (created using
gsec) and connect
I have one more curiosity... I lied actually many more-
why is fedora insisting in package manager to install embedded. Even when i try
to get rid of it fedora chooses to uninstall other files which I canceled and
not do?
could this be part of the problem that i have both embedded AND other
Ok, thank you Karol.
Greetings.
Walter.
On Mon, Aug 24, 2015 at 2:32 PM, liviusliv...@poczta.onet.pl
[firebird-support] firebird-support@yahoogroups.com wrote:
Hi,
as i say previously you can not do this
as index can not be updated if something was changed in ASIENTOSCAB.
And any
At 07:52 a.m. 25/08/2015, thirdshiftco...@yahoo.com [firebird-support] wrote:
I have one more curiosity... I lied actually many more-
why is fedora insisting in package manager to install embedded. Even when i
try to get rid of it fedora chooses to uninstall other files which I canceled
and
Hi Mark Helen-
I somehow lost my post. I will try to make it briefer. I don't know how links
work here.
Mark nailed it on the source of my confusion. I thought like in postgres you
did :
su -
# su - postgres
pg$
Helen was right that I was doing
su - firebird -s /bin/bash
which is a tweak
26 matches
Mail list logo
