Bruce,
I would have given you a patch for refint.c (apart from the enhancements it also
solves a problem with cascading delete), but I have only 6.3.2 to create a patch
against and also because I haven't tested it on v6.5. I am again attaching the
refint.c source which I am currently using which c
Leon wrote:
>
> speed of joins and sudden client death. :) The third question
> should be: what do I do with transaction deadlock, since there
> is no lock wait timeouts?
Server should abort one of transaction to resolve deadlock -
we don't use timeouts for this.
Did you get unresolved deadlock
-Original Message-
From: Howie <[EMAIL PROTECTED]>
To: John Huttley <[EMAIL PROTECTED]>
>
>the one thing i miss is the ability to determine a lo's size (
>hinthintnudgenudgewinkwink ).
Here's a snippet of code
lo_lseek(cntl.conn, lo_fax,0, SEEK_END);
length = lo_tell(cntl.conn,lo_f
No idea why it isn't in there. Let me know what I should apply.
> Hi Kai,
>
> It beats me too. I was under the impression that the patch was applied for
> all versions greater than 6.3.2. I haven't bothered to upgrade since then so
> I don't know if it was ever actually applied. Here is a worki
Hi Kai,
It beats me too. I was under the impression that the patch was applied for
all versions greater than 6.3.2. I haven't bothered to upgrade since then so
I don't know if it was ever actually applied. Here is a working copy of
refint.c which I am using now, you can try using it but I haven't
Is there any way that the data of a table (which was deleted by a
programmer using delete from)?
When i installed PostgreSQL one year ago i read something about it, but i
haven't found on the manual.
Thanks in advance.
On Fri, 30 Jul 1999, John Huttley wrote:
>
> You just haven't met the right application yet.
>
> in the manual there is a discussion on other methods that were previosly
> used.
>
> The PG system is good, with minor limitations in the lo* API.
>
> I'm busy writing a faxserver application whe
Hi,
To the best of my knowledge, still no way of droping a field directly by
using ALTER.
Usual trick is to do something like:
SELECT
INTO temp_table
FROM ;
DROP TABLE ;
ALTER TABLE temp_table RENAME TO ;
But bear in my that:
- this will not preserve oid's...
- I think things like RULES
Greetings,
Is there a way to drop a field from a table? ALTER TABLE seems to only
allow the adding and modification of fields.
Thanks.
Jonathan Karlen
**
Jonathan R. Karlen
Karlen Internet Solutions
[EMAIL PROTECTED]
http://www.karlen.com
