[GENERAL] Trying to use PGSql with PHP

2000-10-07 Thread John Tsombakos
I'm trying to setup PostgreSQL on Redhat Linux 6.2 and access it with PHP. I have Apache installed and working, PHP installed and working, and PostgreSQL installed and working. However, I'm trying to get PHP to talk to the PostgreSQL system. I believe I need to install php-pgsql-3.0.15-2.rpm, but

[GENERAL] RE: pgaccess on Win95

2000-10-07 Thread Bill Barnes
>> Has anyone been able to execute the subject on PostgreSQL7.0.2 >> Error message reports unable to find libraries. > >You need to have Tcl/Tk installed. > >-- >Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ I should have been more specific. Sorry! TclPro 1.4 (evaluation

Re: [GENERAL] Newbie, Howto access Array-Slots in user defined functions?

2000-10-07 Thread Tom Lane
[EMAIL PROTECTED] (Martin Jacobs) writes: > Thank your for this hint, but my 6.3.2 installation does not know > a function get_byte(). 6.3.2? You didn't mention that before. There are a ton of array-related bugs in 6.3.2. Try a more recent release. regards, tom lane

[GENERAL] Book now in book-sized format

2000-10-07 Thread Bruce Momjian
I have updated the PDF of my book so it is in the final book-sized format. A final PDF should go to the publisher within weeks. It is expected to be on sale in mid-November. It already appears on Amazon and Barnes & Noble web sites. I have finished the index. If anyone has suggestions for addi

Re: [GENERAL] Newbie, Howto access Array-Slots in user defined functions?

2000-10-07 Thread Martin Jacobs
Tom Lane wrote: > > [EMAIL PROTECTED] (Martin Jacobs) writes: > > CREATE FUNCTION lessbyte (_bytea, _bytea) RETURNS bool > > AS > > 'SELECT $1[1] < $2[1];' LANGUAGE 'sql'; > > ERROR: Unable to identify an operator '<' for types 'bytea' > > and 'bytea' > > You will have

Re: [GENERAL] Using BLOBs with PostgreSQL

2000-10-07 Thread Martin A. Marques
On Sat, 07 Oct 2000, Tim Kientzle wrote: > > I've been using MySQL for initial development; it has pretty > clean and easy-to-use BLOB support. You just declare a BLOB > column type, then read and write arbitrarily large chunks of data. > In Perl, BLOB columns work just like varchar columns; in J

[GENERAL] Postmaster startup problems

2000-10-07 Thread Collin Peters
I'm having problems starting postgres. What happens is that I start it but then it says it isn't running. In one terminal window: postgres@the-kernel:~$ postmaster -D /usr/local/pgsql/data/ >$HOME/pm.log DEBUG: Data Base System is starting up at Sat Oct 7 13:13:29 2000 DEBUG: Data Base Syst

[GENERAL] Using BLOBs with PostgreSQL

2000-10-07 Thread Tim Kientzle
I'm evaluating a couple of different databases for use as the back-end to a web-based publishing system that's currently being developed in Java and Perl. I want to keep _all_ of the data in the database, to simplify future replication and data management. That includes such data as GIF images,

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

2000-10-07 Thread Frank Joerdens
> > idea whether any other databases do it the same way, but simply removing > > the limit on physical tuple length wouldn't have been as nice. Yes, that makes it a lot clearer. This is more or less what I'd been wondering, without really noticing: Why not just remove the limit on physical tuple

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

2000-10-07 Thread Jan Wieck
Tom Lane wrote: > Frank Joerdens <[EMAIL PROTECTED]> writes: > > Can I go around bragging to my SQL-minded friends about using this > > really cool thing that no other database has, or should I keep my mouth > > shut because it's actually not so cool? > > IMHO it's pretty cool. You get the benefi

Re: [GENERAL] Need help : Weird referencial Integrity triggers

2000-10-07 Thread Jan Wieck
Vilson farias wrote: > I've been changing some tables and I saw a strange behavior in pg_trigger. > Check out the commented code below : > > [...] > > Now, if I select the corresponding triggers from pg_trigger, I'll find > three. Why 3? One for update, one for insert and one for delete ? One

Re: [GENERAL] Using UnixODBC and postgresql

2000-10-07 Thread Michael Meskes
On Sat, Oct 07, 2000 at 12:51:54AM +1100, Danny wrote: > 1)Does Postgresql with with UNIXODBC ? Yes, it does without a problem. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!