Re: [GENERAL] Some MySQL features

viving dump/reloads -- Aaron J. Seigo Sys Admin

Re: [GENERAL] Re: replication

ay to do it... however, my guess would be to say that these places in the source would be where to start looking... word from those in the know? -- Aaron J. Seigo Sys Admin

Re: [GENERAL] Re: replication

process... and not prone to some app that goes around your wrapped lib and defeats the replication scheme altogether... imo, it should be part of the transaction system =) -- Aaron J. Seigo Sys Admin

Re: [GENERAL] Functions

aram; END; ' LANGUAGSE 'pl/pgsql'; more typing, but easier to read and maintain later... but then, i'm picky. -- Aaron J. Seigo Sys Admin

Re: [GENERAL] FW: inheritance of functions

B. the manual is, as far as my experience has led me to believe, referring to functions "bound" (for lack of a better word) to the parent table -- Aaron J. Seigo Sys Admin

Re: [GENERAL] cidr and inet

hi... > insert into ip values (10.20.30.40); > > It always points to the third part of the IP (ie, 100 > in case of 10.30.100.200) > pgsql is seeing it as a decimal number. enclose it in single quotes and it will work fine. insert into ip values ('10.20.30.40'); -- Aaron J. Seigo Sys Admin

Re: [GENERAL] php - pgsql connection

^^^ my guess is that $port is not assigned. its trying to connect to port 'dbname=', which is actually the start of the next variable pair. $port should have some numeric data in it, something like 5432... -- Aaron J. Seigo Sys Admin

Re: [GENERAL] User defined function

7; || date_part('year','now'::date) - 1)::date; once you know that your select works, pop it into the function. functions don't return the most helpful error messages =) the command line in psql is much better for debugging selects/inserts/etc/etc... -- Aaron J. Seigo Sys Admin

Re: [GENERAL] pl/pgsql and backend crashes

s' that don't pause here can cause problems) - vacuuming after dropping a large function i hope this helps lead the pl/pgsql developers towards the problem. =) other'n that (and a few minor oddities) pl/pgsql is just peachy =) -- Aaron J. Seigo Sys Admin

Re: [GENERAL] max() question

, but if you are doing this over a network, a cursor may not be the easiest thing to implement, depending on what you are using. as for performance of this? i dunno. cursor would be best. -- Aaron J. Seigo Sys Admin

Re: [GENERAL] Hardware optimising

hi... > 128 MB 100 MHz SDRAM > AMD K6-2/300 CPU > 10 GB 7200RPM 9.0ms IBM IDE HDD > > It will, over the next few months, as money becomes available, be upgraded to: > > 256 MB 100 MHz SDRAM > Dual Athlon 500 CPUs > 10 GB UltraII Wide SCSI drive > > The database will contain several million rec