Re: [GENERAL] Practical Cursors

2001-09-17 Thread Alex Pilosov
On Mon, 17 Sep 2001, Command Prompt, Inc. wrote: > However, using something like PHP will not allow this because HTTP is > stateless and PostgreSQL will not know from one transaction to the next > that the results of the connection are related. > > Is this truly the case, or is there a way for P

Re: [GENERAL] Problem with database: FATAL 1: cannot find attribute 24

2001-09-17 Thread Tom Lane
"Tauren Mills" <[EMAIL PROTECTED]> writes: > Then, I try running postgres like this: > bash$ postgres -d 5 -D /var/lib/pgsql/data dans_pgsql > AATAL 1: cannot find attribute 24 of relation Since there aren't any system catalogs with as many as 24 columns, the problem is clearly a level or two do

Re: [GENERAL] Transaction

2001-09-17 Thread Oliver Elphick
"Mihai Gheorghiu" wrote: >An event triggers a rule / trigger. >Does this (event + rule/trigger) behave as a transaction, or is it necessary >to wrap it into BEGIN...COMMIT? If yes, BEGIN should be before or after the >event (in the rule/trigger)? Any single command is a transaction includ

Re: [GENERAL] Transaction

2001-09-17 Thread Doug McNaught
"Mihai Gheorghiu" <[EMAIL PROTECTED]> writes: > An event triggers a rule / trigger. > Does this (event + rule/trigger) behave as a transaction, or is it necessary > to wrap it into BEGIN COMMIT? If yes, BEGIN should be before or after the > event (in the rule/trigger)? It is always inside a tran

[GENERAL] Practical Cursors

2001-09-17 Thread Command Prompt, Inc.
Hello, We are just about to wrap up our book, Pratical PostgreSQL (the one that used to be The Elephant never forgets) and we have a question. There is an obvious benefit to the use of cursors within a persistent environment. In other words, if my connection to the database is live, I can increa

Re: [GENERAL] Error in compiling PHP with PostgreSQL support

2001-09-17 Thread mike
Hi Cosmos, How did you compile PHP? Was your PHP come with your Linux/Unix software like Red Hat or did you install PHP from scratch? Could you tell me each steps that you did to compile PHP? Did you configure it with apache and enable-track-vars? I had the same problem before and I solved it. Te

Re: [GENERAL] plpgsql/cursor

2001-09-17 Thread Jan Wieck
augie wrote: > can i declare and fetch from a cursor inside a plpgsql function? (pg > version 7.0.3) > > if so, what would the syntax look like? i continue to get parse errors on > 'cursor' in a very, very simple test. Refernce cursors will occur in PostgreSQL v7.2. Not sure when it'll

Re: [GENERAL] NewYork Bombing: SQL server bomb proof!!

2001-09-17 Thread Serge Rielau
This is probably the worst post I have seen in a newsgroup ever. Using this tragedy so promote a product is disgusting. You are not doing the product you are promoting a favor with this. I will not comment on the technical content of this post. Serge ---(end of broadca

Re: [GENERAL] NewYork Bombing: SQL server bomb proof!!

2001-09-17 Thread Bryon Lape
Not to mention that PostgreSQL is WAY ahead on technology. peace_flower wrote: > I can bet that open-source code SQL server like PostgreSQL is bomb-proof > and even in case of nuclear war world-wide, > the source code of PostgreSQL will be very safe at some point on the > planet and can easily b

Re: [GENERAL] NewYork Bombing: SQL server bomb proof!!

2001-09-17 Thread Chris Boyle
As someone that had to wait until 9:30 Tuesday night to find out if friends in the pentagon were okay (and lucky enough to get that call) I can say your posting is so offensive as to induce illness. This puts you in the same category as the scum that are stealing victims SSNs and creating fake ch

[GENERAL] I could do with some guidance

2001-09-17 Thread David. E. Goble
Hi All; Trying to set up a database with postgres. below is what I have so far... In the example I want board to be filled with; Secretary|Goble|David|11/05/1970|280198R How do I do this? Also is what I have so far the best way for this database? Later I will want to write an inferface for it,

[GENERAL] MySQL development MUST immdediately cease - Due to GlobalEconomic condition..

2001-09-17 Thread peace_flower
This is a immediate order to COMPLETELY STOP and CEASE all development of MySQL database server. This is due to rapid changes in the Global Economic conditions.. You do not have time to deal with one powerful SQL server like PostgreSQL, where do you have time to deal with two types of SQL servers

[GENERAL] Longtime to store large object from Visual Foxpro throught ODBC

2001-09-17 Thread kingking
Hi all, Anyone know why store large object which need to wait long long time ! I use Visual Foxpro with ODBC ! Thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAd

[GENERAL] NewYork Bombing: SQL server bomb proof!!

2001-09-17 Thread peace_flower
I can bet that open-source code SQL server like PostgreSQL is bomb-proof and even in case of nuclear war world-wide, the source code of PostgreSQL will be very safe at some point on the planet and can easily be distributed and multiplied rapidly. The reason being internet is nuclear-bomb proof s

Re: [GENERAL] pgdumpall

2001-09-17 Thread Thurstan R. McDougle
The only problem I found using it was with a user large object type used for OLE binary large object data. Dumpall just dumped the OID of the items, not the items themselves There is a -b (dump data and BLOB data) option, if it exists on your version of pg_dump (pg_dumpall passes most parameter

Re: [GENERAL] locale and spanish acute

2001-09-17 Thread Tony Grant
On Fri, 2001-09-14 at 15:49, Peter Eisentraut wrote: > Martín Marqués writes: > > > select count(*) from tab1 where col1 LIKE '%mas%' > > > > but I would like it to catch rows with "más" also. select count(*) from tab1 where col1 ILIKE to_ascii($1) works for me. The variable is passed via .