Subject Re: [firebird-php] pconnect & disconnect & FK
Author Lester Caine
michal.720 wrote:

> Hello,
> I made a persistent connection to Firebird 1.5 server via PHP
> ibase_pconnect() function.
>
> At this time I need to create table in my database, which has relations
> to some existing tables with foreign keys.
>
> I cannot create this table because the table has relations to other
> tables and the (persistent) connection is still alive.
>
> Thanks for any advice,
> Michal
>
> (I'm using ibWebAdmin.)

I find that from time to time I need to hit 'Restart' on Apache2 simply
to clear the connections and carry out some other steps. But I think you
are possibly seeing a problem because ibWebAdmin already has a link to
the database and is using another to create the new table?
I tend to do this sort of work from IBOConsole, so I have not checked it
out just using ibWebAdmin - and that is when I need the 'Restart' even
when ibWebAdmin is not in use ;)

Anybody fill in some more detail ?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services