[GENERAL] DBI/DBD::Pg mem. use goes exponential

Hi, I'd really like to aviod another list (ie. interfaces) if at all possible, so... Got a script (trimmed version below) that starts to have exponential memory use after a number of iterations around the while(($sth->fetch())) { } struct. Table is quite small (520 odd rows) and the row siz

[GENERAL] using schemas to create a virtual DB?

Hi, I need to give some partners to a read only subset of my data. I'm currently looking at schemas, not something I've looked at or used before. Can I use schemas to create a virtual DB (built by views) onto my main DB? Or is this a dead end thought? Cheers, Bob This message has been scann

[GENERAL] sharing tcl proc's between functions

Hi, Is it possible to share some TCL proc's between a set of functions? Something like proc mything { } proc otherthing { } create function wantsthings (text) returns text as ' return [mything [otherthing fubar]] ' language 'pltcl'; Cheers, Bob This message has been scanned

Re: [GENERAL] Drawbacks of using BYTEA for PK?

>He is talking about the MAC which in itself is supposed to be >globally unique. Nothing to do with IP numbers. Supposed is the word... Don't count on MACs being unique. Under some OS's you can set them to what you want. Bob == When logic and proportion Have f

[GENERAL] debug logs: query: rollback

begin ProcessUtility: begin CommitTransactionCommand StartTransactionCommand query: rollback ProcessUtility: rollback CommitTransactionCommand proc_exit(0) shmem_exit(0) exit(0) Cheers Bob Parkinson [EMAIL PROTECTED] -- Technical Manager

[GENERAL] CurrentMemoryContext

o bit works, but I'm trying to now build the Perl module calling the C code. I'm getting Undefined symbol "CurrentMemoryContext" I can see this symbol refered to in palloc.h but beond that I'm stuck.

[GENERAL] alternative DB locations

invalid. This may be due to a character that is not allowed or because the chosen path isn't permitted for databases createdb: database creation failed The shell is bash. What am I missing please? Cheers, Bob Bob Parkinson [EMAIL PROTECTED] -

Re: [GENERAL] Error with tcp/ip networking

ane how about lsof, at: ftp://cc.vic.purdue.edu/ omni:rwp> lsof -i | grep post postgres 14054 postgres3u inet 0x64b0f900 0t0 TCP *:5432 (LISTEN) Bob Parkinson [EMAIL PROTECTED] -- Technical Manager:

[GENERAL] pg_dump/load quoting.

m","str") VALUES (1047676,1047673,'CAB','breeders'' associations'); ERROR: parser: parse error at or near "associations" Whats happening please? Its quoted correctly, isn't it? I've just read the example/para about 'dianne'