Re: [HACKERS] RE: [GENERAL] pg_dump return status..

2001-01-06 Thread Philip Warner
e looks like it does an exit(1) whenever there is an error. Is there a Unix/C/shell interaction that's not working for you? -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ -

[GENERAL] Matrix implementation?

2000-11-23 Thread Philip Warner
Has anyone ever implemented a matrix data type that they would be willing to share? All I want is basic addition & subtraction (don't even need multipication), but an avg & sum implementation would be nice... ----

Re: [GENERAL] Not null contraints

2000-10-13 Thread Philip Warner
ck. Not much magic here... > Just to confirm - does this mean we have ALTER TABLE ADD CONSTRAINT, but not ALTER TABLE DROP CONSTRAINT. If so, should it go on a list somewhere? -------- Philip Warner|

Re: [GENERAL] Question about pg_dump

2000-10-13 Thread Philip Warner
somewhere? ---- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500

Re: [GENERAL] Question about pg_dump

2000-10-13 Thread Philip Warner
arily the absolute latest data. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-13 Thread Philip Warner
something that would embarrass someone if it were publically >known. Personal opinions are of course private. Can you think of an example of a secret embarrassing item that has affected the direction of the project? I'd be fascinated! -------

Re: [GENERAL] How does TOAST compare to other databases' mechanisms?

2000-10-12 Thread Philip Warner
that I have not done anything similar so far)? -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 |

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Philip Warner
ecause the sights were set unreasonably high. What is needed now is an agreed and reasonable set of guidelines or principles. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd

[GENERAL] Postmaster crashes periodically

2000-10-10 Thread Philip Warner
d see if there is a specific database causing the problem. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel:

Re: [GENERAL] Question !

2000-10-09 Thread Philip Warner
where, I think... -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 |

Re: [GENERAL] pg_dump on view

2000-10-03 Thread Philip Warner
nia_wykonane. Explanation from >backend: 'ERROR: cache lookup of attribute 0 in relation 54498 failed >'. > >what does it mean? How to get rid of it, any hints? I'd guess this means that the underlying table has been deleted... ---

Re: [HACKERS] Re: [GENERAL] Trouble with float4 after upgrading from 6.5.3 to 7.0.2

2000-08-07 Thread Philip Warner
. Am I missing something? -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \

Re: [HACKERS] Re: [GENERAL] Trouble with float4 after upgrading from 6.5.3 to 7.0.2

2000-08-07 Thread Philip Warner
At 12:11 7/08/00 -0400, Tom Lane wrote: >Philip Warner <[EMAIL PROTECTED]> writes: >> pjw=# select float8(float4(10.1)); >> float8 >> -- >> 10.103814697 >> (1 row) > >> I would have expected the latter to be at worst 10.

Re: [HACKERS] Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2

2000-08-07 Thread Philip Warner
ning, I see that (short of varchar conversions!), it is probably quite hard to do since we can't tell the 'correct' value. ---- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (

Re: [GENERAL] Problem with inserting newlines and ' characters

2000-07-24 Thread Philip Warner
;); then if (!$sth->execute($sno, $date, $tmpstring)) die_horribly this way you'll get the value out of preparing the statement. You might also want to use 'prepare_cached'. I don't know if your original query should work, but it

RE: [GENERAL] how connect visual basic to pgsql?

2000-07-24 Thread Philip Warner
FTP working fine.). >Other side I have VB-6.0 on Windows-NT-Workstations 4.0. > >After reinstall the VB6.0 the error msg. has been changed. >Now new error is : "could not connect to the server, could not connect to >the remote socket." This looks like either (1)

RE: [GENERAL] how connect visual basic to pgsql?

2000-07-24 Thread Philip Warner
At 08:13 24/07/00 -0400, Robert D. Nelson wrote: >= Original Message from [EMAIL PROTECTED] (Philip Warner) at 7/22/00 6:45 >am >>At 10:32 22/07/00 +0530, anuj wrote: >>> >>>When I do connectivity then error come - "Provider cannot be found.

RE: [GENERAL] how connect visual basic to pgsql?

2000-07-22 Thread Philip Warner
, but I could be wrong. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 |

Re: [GENERAL] how connect visual basic to pgsql?

2000-07-21 Thread Philip Warner
support in PG, then use PG just like any other ODBC data source. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81

Re: [GENERAL] pgdump & blob

2000-07-13 Thread Philip Warner
obs/ ---- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82

Re: [GENERAL] Getting closer with functions, but...

2000-07-12 Thread Philip Warner
on triggers also includes a useful example. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __-

Re: [GENERAL] RE: [HACKERS] pg_dump & blobs - editable dump?

2000-07-12 Thread Philip Warner
ly, the table data is of unknown uncompressed size. I *could* do two 'COPY TO STDOUT' calls, just to get the size, but that seems like a very bad idea. -------- Philip Warner| __---_ Albatross Consulting Pty. Lt

[GENERAL] Re: [HACKERS] pg_dump & blobs - editable dump?

2000-07-12 Thread Philip Warner
stdout Is that sufficient? Or are you strictly interested in the text output side of things? -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C

RE: [GENERAL] RE: [HACKERS] pg_dump & blobs - editable dump?

2000-07-12 Thread Philip Warner
ow how big it will be until it is written. The custom output format can handle this, but in streaming a tar file to tape, I have to know the file size first. This means writing to /tmp. I supose that's OK, but I've been trying to avoid it. ---

[GENERAL] RE: [HACKERS] pg_dump & blobs - editable dump?

2000-07-12 Thread Philip Warner
database Or, pg_dump -Fc --blobs | pg_restore --db=dbname to copy a database with blobs... So, in summary, I think most of what you want is already there. It's just the human-readable part that's a problem. *Please* let me know if there is some issue I have not considere

[GENERAL] Re: [HACKERS] pg_dump & blobs - editable dump?

2000-07-12 Thread Philip Warner
At 10:13 12/07/00 -0400, Lamar Owen wrote: >Philip Warner wrote: >> My guess is that this will involve a plain text schema dump, followed by >> all BLOBs in separate files, and a script to load them. To implement this >> I'll obviosly need to be passed a directory/fi

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread Philip Warner
Sadly I am still waiting for complete answers to most of my questions. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread Philip Warner
I think he'll say that the license applies to the source; if a commercial fork was made, then they are free to hide the source. But if they ever release the source, then it has to go under the BSD again. -------- Philip Warner

Re: [GENERAL] PostgreSQL & the BSD License

2000-07-07 Thread Philip Warner
he technology becomes out of date first" I guess the key bit is "rather than virtually impossible as it is now". So, I am now asking him how he would define our 'community': my inclination is that it has to include the WW Dev team, and almost certainly the users. Or at lea

Re: [GENERAL] proposed improvements to PostgreSQL license

2000-07-06 Thread Philip Warner
he core developers do leave, then there is a higher chance of a quick uptake. Or have I missed something? Did you have some kind of "contractually binding verbage" in mind? -------- Philip Warner| __---_ Albat

Re: [GENERAL] responses to licensing discussion

2000-07-04 Thread Philip Warner
is going to get up. I agree. But I'd like to propose a further addition to the exclusions regarding limiting liabilities. I'll send it to the list ASAP. Philip Warner| __---__

Re: [HACKERS] Re: [GENERAL] Revised Copyright: is this morepalatable?

2000-07-04 Thread Philip Warner
e changes that to 'any use whatsoever'. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __--

Re: [GENERAL] responses to licensing discussion

2000-07-04 Thread Philip Warner
aiting on an answer for if whether Marc can be sued because he provided the software from his server. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) |

[GENERAL] Re: [HACKERS] Revised Copyright: is this more palatable?

2000-07-04 Thread Philip Warner
en to any reason why I as a developer should feel stronger as a result of your suggested clause. Certainly if I were a private company who wanted to use PG, I would feel more comfortable with this clause, but that is not how you are marketing it. -

[ANNOUNCE] Re: [GENERAL] Re: [HACKERS] proposed improvements to PostgreSQL license

2000-07-04 Thread Philip Warner
ho offer it on servers, and people who apply patches from other people (who may not themselves be contributors or developers). It's just a box of worms - no source can be too open, and no indemnity can be too strong. -------

[ANNOUNCE] Re: [GENERAL] Re: [HACKERS] proposed improvements to PostgreSQL license

2000-07-04 Thread Philip Warner
that bother me. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61)

Re: [GENERAL] Installing DBD::Pg

2000-07-03 Thread Philip Warner
, they may be under /var/lib/pgsql). -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | ___

Re: [GENERAL] disk backups

2000-07-02 Thread Philip Warner
rsion on the FTP site first... -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 |

Re: [GENERAL] Announce: Testers needed for revised pg_dump/pg_restore

2000-07-02 Thread Philip Warner
It's probably best to look in the directory: ftp://ftp.rhyme.com.au/pub/ for the latest version. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 65

Re: [GENERAL] pg_dumpall and check constraints

2000-07-01 Thread Philip Warner
s seems like a very convenient feature...if it's not too hard. -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ T

Re: [GENERAL] Announce: Testers needed for revised pg_dump/pg_restore

2000-07-01 Thread Philip Warner
This is also available via ftp from: ftp://ftp.rhyme.com.au/pub/pg_backup_110.tar.gz Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498

[GENERAL] Announce: Testers needed for revised pg_dump/pg_restore

2000-07-01 Thread Philip Warner
If anybody out there is comfortable with using make, has the PG sources on their machine, and is interested in testing a new version of pg_dump, please let me know. Details of the revised pg_dump, and new pg_restore are at the end of this message. Thanks, Philip Warner. - The

Re: [GENERAL] disk backups

2000-07-01 Thread Philip Warner
At 23:34 1/07/00 +1000, Martijn van Oosterhout wrote: > >> Philip Warner needs alpha testers for his new version of pg_dump ;-). >> Unfortunately I think he's only been talking about it on pghackers >> so far. > >What versions does it work on? > 6.5.x and 7.

Re: [GENERAL] pg_dumpall and check constraints

2000-06-30 Thread Philip Warner
anyway, why not do it for them? -------- Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | ___