Re: [GENERAL] Yet another btree gotcha

1999-10-05 Thread Mike Mascari
I realize that this is somewhat off topic, but I have seen far better improvments in query speeds when using a multifield index instead of individual ones. So, for the given select below: SELECT km.km, su.su FROM km, su WHERE km.id = su.id AND km.rel = su.rel AND km.item = su.item AND su ~ '

Re: [GENERAL] You are really hosed.

1999-10-05 Thread Mike Mascari
--- Nikos Mouat <[EMAIL PROTECTED]> wrote: > > Hi, >I'm trying to backup a database using pg_dump, > but whenever I try I > get an error telling me I am really hosed. The > template1 database works, > psql works fine, the database is live and working > just peachy, but I can't > back it up. W

[GENERAL] Yet another btree gotcha

1999-10-05 Thread Gene Selkov, Jr.
I am wondering whether it's normal to see dropping a btree improve the query which could never complete enough that it completes in a blink? I realize the data I have here represent the worst possible input to btree, and I'm probably better off without any index at all, but I guess it is somethin

Re: [GENERAL] copying from one table to another

1999-10-05 Thread Charles Tassell
Try something like: INSERT INTO selection (fieldlist) SELECT fieldlist from temp_section; SELECT INTO won't work, as it requires you to be creating the destination table (well, you could drop temp_section first, but that could be annoying.) At 11:51 PM 10/5/99, Omega Weapon wrote: >I have two i

[GENERAL] You are really hosed.

1999-10-05 Thread Nikos Mouat
Hi, I'm trying to backup a database using pg_dump, but whenever I try I get an error telling me I am really hosed. The template1 database works, psql works fine, the database is live and working just peachy, but I can't back it up. What does this mean? Why doesn't it want to work?? nm -- [n

Re: [GENERAL] Confusion in Insert Query syntax

1999-10-05 Thread Bruce Momjian
> Hi All, > > If I type \h insert at psql it shows me, > > INSERT INTO class_name [(attr1, ...attrN)] > VALUES (expr1,..exprN) | > SELECT [DISTINCT [ON attrN]] > expr1, ...exprN > [FROM from_clause] > [WHERE qual] > [GROUP BY group_list] >

[GENERAL] Confusion in Insert Query syntax

1999-10-05 Thread Shadkam Islam
Hi All, If I type \h insert at psql it shows me, INSERT INTO class_name [(attr1, ...attrN)] VALUES (expr1,..exprN) | SELECT [DISTINCT [ON attrN]] expr1, ...exprN [FROM from_clause] [WHERE qual] [GROUP BY group_list] [HAVING having_c

Re: [GENERAL] Foreign Key

1999-10-05 Thread Bruce Momjian
> > > > Hello everyone, > > I would just like to know if the Foreign key constraint feature should be a one > of a near release... Any idea? Planned for 6.6, due in a few months. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (610)

[GENERAL] copying from one table to another

1999-10-05 Thread Omega Weapon
I have two identical tables -- section and temp_section. I use the section table for keeping original values and temp_section for editing. How do I copy the values from temp_section to section? = Weapon __ Do You Yahoo!? Bid and sell for free

[GENERAL] Foreign Key

1999-10-05 Thread Frederic . Boucher
Hello everyone, I would just like to know if the Foreign key constraint feature should be a one of a near release... Any idea? Thanks

Re: [GENERAL] Foreign Key

1999-10-05 Thread Howie
On Tue, 5 Oct 1999 [EMAIL PROTECTED] wrote: > Hello everyone, > > I would just like to know if the Foreign key constraint feature should be a one > of a near release... Any idea? for now, refint ( $PGSQL_SRC_ROOT/contrib/spi/ ) is what one should be using for foreign keys. requires two trigg

[GENERAL] Disk Access Information

1999-10-05 Thread Mengzhi Wang
Hi, I am interested in the access pattern of database systems to memory and disks. I plan to get started with postgreSQL because of free source code. Have someone already had such kind of information? Mengzhi

Re: [GENERAL] leaking FD's ?

1999-10-05 Thread Michael Simms
> > Hi > > > > I am running a process that does a fair number of selects and updates but > > nothing too complex. > > > > I have the postmaster starting like such: > > > > /usr/bin/postmaster -o "-F -S 10240" -d 1 -N 128 -B 256 -D/var/lib/pgsql/data -o >-F > /tmp/postmasterout 2> /tmp/postmast

[GENERAL] Table Names.......

1999-10-05 Thread Dale Anderson
Is there any way to use table names longer than 32 characters Dale.

[GENERAL] Some information about JDBC

1999-10-05 Thread Ing. Arturo de la Torre
Hi :-) I am making some probes with JDBC, please if some body have some examples please send me Sincerely Arturo

Re: [GENERAL] get the list of databases

1999-10-05 Thread Doran L. Barton
Not long ago, Xavier COUDIN proclaimed... > using psql, it is possible to get the list of databases using the > instruction "\l". > > How can I do when I make connection through DBI/DBD ? Well you need to connect to *some* database (i.e. template1) and then you can issue the following SQL q

[GENERAL] get the list of databases

1999-10-05 Thread Xavier COUDIN
using psql, it is possible to get the list of databases using the instruction "\l". How can I do when I make connection through DBI/DBD ?

[GENERAL] where can i find ???

1999-10-05 Thread Chris Ian Capon Fiel
where can i find information about postgres design limits specifically 1) Max number of clients connected in one server 2) Maximum Database size 3) Maximum number of files per database 4) Maximum number of database