Re: [ADMIN] SQL question

2002-02-01 Thread Tom Lane
"Brett W. McCoy" <[EMAIL PROTECTED]> writes: >> select field, length(field) from table where length(field) < 10; >> >> How many times is the length() function called for each row? Once or >> twice? > I would expect it to run both times. More specifically, the one in the select list will be eva

Re: [ADMIN] SQL question

2002-02-01 Thread Brett W. McCoy
On Fri, 25 Jan 2002, Bolt Thrower wrote: > In the query: > > select field, length(field) from table where length(field) < 10; > > How many times is the length() function called for each row? Once or > twice? I would expect it to run both times. I did a similar query with an explain: ex

Re: [ADMIN] Sample database for testing?

2002-02-01 Thread Andy Ruhl
On 1 Feb 2002, Oliver Elphick wrote: > If you do this, you will have mytable in every database you create > thereafter. It is not called a template for no reason! template1 is > copied in its entirety into every new database when it is created. (And > so the rest of the advice is redundant, too

Re: [ADMIN] Sample database for testing?

2002-02-01 Thread Oliver Elphick
On Fri, 2002-02-01 at 20:26, bangh wrote: > There is a database template1 you can play with. > > If there is no table in template1, you can create one by: > > psql template1 > psql> create table mytable ( > psql> mydate datetime, > psql> mymem text); > psql> insert into mytable values('now', 'I

Re: [ADMIN] Sample database for testing?

2002-02-01 Thread bangh
There is a database template1 you can play with. If there is no table in template1, you can create one by: psql template1 psql> create table mytable ( psql> mydate datetime, psql> mymem text); psql> insert into mytable values('now', 'I am doing this today'); psql> select * from mytable; psql>\q

Re: [ADMIN] Urgent help neede - Important - Tks

2002-02-01 Thread Stephan Szabo
On Sun, 27 Jan 2002, [iso-8859-1] Mr OCP wrote: > We are trying to implement replication on postgres 7.2 > with java and to effectively run it we need to drop > all RI triggers from the slave database, but in case > when master database fails, we will be using Slave as > the master and would nee

[ADMIN] data recovery question

2002-02-01 Thread Chris Dircks
I tried searching the archives for this, but the search is broken. I looked by hand for a while, but didn't see an answer... This is for postgresql-6.5.3 running on Redhat 7.0 I'm trying to recover data from a single table file. I recently rebuilt my server and found to my dismay that my full

Re: [ADMIN] SQL question

2002-02-01 Thread Stephan Szabo
On Fri, 25 Jan 2002, Bolt Thrower wrote: > In the query: > > select field, length(field) from table where length(field) < 10; > > How many times is the length() function called for each row? Once or > twice? Pretty sure it'll be twice. ---(end of broadcast)-

Re: [ADMIN] OT: Decent GUI-based reportwriter for Linux?

2002-02-01 Thread Chris Dircks
I work in the IT department at Crystal, so I might be able to shed some light, but I don't speak for the company. You could get away with running scheduled reports on a Windows machine and exporting them to HTML. These HTML files could then be copied to a Linux box for serving. This doesn't all

[ADMIN] Maximum Performance -> File System?

2002-02-01 Thread Jean Huveneers
Hi, ok, conclusion: lots of RAM make Postgres faster, if you adjust you config file. And multi-processor usage depends on your linux kernel. But what is the best file system to use? I'm going to run postgres on a IDE-RAID5 (hardware from 3Ware) ATA-100 system, total capacity around the 160GB, a

[ADMIN] dump file in more readable format

2002-02-01 Thread ms
Hello Is there any utility to convert dump file to format more convenient for reading (eg. retaining REFERENCES). Michal Sienicki mailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Increasing Shared Memory - on MacOS X

2002-02-01 Thread Chad R. Larson
At 09:06 PM 1/24/02 -0500, Tom Lane wrote: >Since OSX is basically BSD under the hood, I'd expect BSD-ish solutions to >be the place to look. Our notes about BSD systems say that a kernel >rebuild is the only way to alter SHMMAX on those kernels :-( OS/X is FreeBSD, with a MACH kernel and Aqu

[ADMIN] Urgent help neede - Important - Tks

2002-02-01 Thread Mr OCP
Hi all We are trying to implement replication on postgres 7.2 with java and to effectively run it we need to drop all RI triggers from the slave database, but in case when master database fails, we will be using Slave as the master and would need to restore all these RI triggers back on. Therefo

[ADMIN] Sample database for testing?

2002-02-01 Thread Andy Ruhl
I'm new to postgresql and I was wondering if there was a "sample" database out there I could use to practice dumping and reloading. I figure I should get good at recovery and administration before I actually use it... I don't have a database to do these kinds of things with and I'd rather not writ

[ADMIN] SQL question

2002-02-01 Thread Bolt Thrower
In the query: select field, length(field) from table where length(field) < 10; How many times is the length() function called for each row? Once or twice? Thanks, -- Steve Chadsey <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: you