Re: [GENERAL] Connect to a database in a .sql file

be appreciated. What's going to play the script? If psql, then check out the \c command. klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I

Re: [GENERAL] Function keys cause psql to segfault

(Segmentation fault) @ 0 (0) --- +++ killed by SIGSEGV +++ esc O P is PF1 on a VT100/VT200. Does it make any difference if you change the terminal emulation in putty or the term setting in redhat? klint. +---+-+ : Klint Gore

Re: [GENERAL] MS SQL - PostgreSQL

/docs/8.0/static/plpgsql-statements.html klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail

Re: [GENERAL] Debug plpgSQL stored procedures

it was some time ago. The EMS manager can apparently do it. http://www.sqlmanager.net/en/ klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

from advocacy could contact eweek and put them straight. klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities

Re: [GENERAL] Case insensitive unique constraint

in. Is there an easy way to go about this? Am I about to write my first server side function for postgresql? how about create unique index tbl_iname_idx on tbl (lower(name_field)) klint. +---+-+ : Klint Gore: Non

[GENERAL] mail change for list?

Is the new mailing software for the postgres lists going to stay like it is? The list identification header changed from X-Mailing-List: pgsql-general to List-ID: pgsql-general.postgresql.org klint. +---+-+ : Klint Gore

Re: [GENERAL] Problem in creating a table

On Tue, 17 May 2005 15:47:55 +0900, Wen Guangcheng [EMAIL PROTECTED] wrote: OFFICE_ID VARCHAR2(7)NOT NULL, This used to be oracle? drop the 2 from the varchar. klint. +---+-+ : Klint Gore: Non rhyming

Re: [GENERAL] Problem in creating a table

klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England

Re: [GENERAL] Why sequential scan for currval?

. index scan when compared to a constant? currval is volatile which means it can change from one row in a statement to the next. So the scan has to be sequential to check if the value of currval() has changed. klint. +---+-+ : Klint Gore

[GENERAL] field definitions in view results?

on redhat linux 9. klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England

Re: [GENERAL] Postgres mystery

columns are supplied, as well as one other. At least one of column4, recordname.column1, recordname.column2, recordname.column2 is null. If you append a null to a string, the result is null. klint. +---+-+ : Klint Gore

Re: [GENERAL] inherited table and rules

=# SELECT * FROM people; you need to put the only on this query. Do you really want inheritance or do you just need an table with the same/similar structure? Maybe people_history should use like instead of inherits. klint. +---+-+ : Klint Gore

Re: [GENERAL] inherited table and rules

SET color = 'black' WHERE usr_pkey = 1; 42*42+42 = 1806 klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities

Re: [GENERAL] inherited table and rules

. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless

Re: [GENERAL] sql question

mytable order by 1,2 klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New

[GENERAL] duplicate msgs when delivery through commandprompt.com

postgresql.org (svr1.postgresql.org [200.46.204.71]) by commandprompt.com (8.12.8/8.12.8) with ESMTP id iBMMgjlY007311; Wed, 22 Dec 2004 14:42:46 -0800 klint. +---+-+ : Klint Gore: Non rhyming

Re: [GENERAL] Non-aggregate values attached to aggregates?

. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless : : Armidale

Re: [GENERAL] [PERFORM] HELP speed up my Postgres

. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England : are useless : : Armidale NSW 2351 Australia

Re: [GENERAL] count(1) return 0?

not needed anyway. an exact value is specified in the where clause so it's not going to be different either. klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang

[GENERAL] query results different after vacuum analyze? 7.4.0

that's been since fixed? Or do I need to try and work out a test case? klint +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I

[GENERAL] plan-reading extensive tutorial?

tried the obvious with vacuum full analyze, and changing the settings (like enable_seqscan, join_collapse_limit, from_collapse_limit...). klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED

[GENERAL] bugs list working???

case in the message involves base64 data. Is there any way of tracking if this is the case? klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I

Re: [GENERAL] count(1) return 0?

need to get iplaybadly into the result set first. try something like select fixture, home, sum(case winner=home then 1 else 0 end) from results group by fixture, home klint. +---+-+ : Klint Gore: Non rhyming

Re: [GENERAL] Help with a query

') = any(grolist); klint. +---+-+ : Klint Gore: Non rhyming: : EMail : [EMAIL PROTECTED] : slang - the: : Snail : A.B.R.I.: possibilities : : Mail University of New England

<    1   2