[GENERAL] pl/pgsql

1999-09-23 Thread Paul Kelly
hi, is there any way in pl/pgsql to create a function that causes postrges to call an external program, or to call a function in a C shared lib? Paul -- Paul Kelly [EMAIL PROTECTED] U-NET Internet Noc Some day now!

Re: [GENERAL] data mart indexing support?

1999-09-23 Thread amy cheng
ok, I did research on to-do list, doc, general list, sql list and hacker list, seems that (correct me if I'm wrong): 1) no bitmap index; 2) can not use multiple indices within one query; 3) can not do Cartesian first then do join -- is there a way to configure the optimizer? I wish I can be a

Re: [GENERAL] Question on confusing behavior

1999-09-23 Thread Bruce Momjian
>Today, I told someone the syntax for "count" without thinking, and > got it wrong - and in so doing, I found some interesting behavior. > > > select count('table.fieldname'); > > works. however... > > select count('table.fieldname') where table.fieldname='something'; Using the table.fie

[GENERAL] User Gallery in a mess

1999-09-23 Thread Michael Simms
Hi Has anyone looked at the user gallery recently? Its a bit of a mess. You need to clean up some of the entries, such as the one where all fields were filled in with testing_shit Also, you need to make sure that if the URL entry doesnt start off with a protocol, you add http:// to the start, c

[GENERAL] Question on confusing behavior

1999-09-23 Thread Steve Wolfe
Today, I told someone the syntax for "count" without thinking, and got it wrong - and in so doing, I found some interesting behavior. select count('table.fieldname'); works. however... select count('table.fieldname') where table.fieldname='something'; not only barfs, it kills your connect

Re: [GENERAL] another BUG

1999-09-23 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > hello, > > bd=> INSERT INTO pg_group VALUES('group-tgy'); > bd=> \z > NOTICE: get_groname: group 87 not found > pqReadData() -- backend closed the channel unexpectedly. > This probably means the backend terminated abnormally >

[GENERAL] That migration problem

1999-09-23 Thread Sebestyen Zoltan
Since then, I successfully solved the problem, so no help is required.. Sebestyén Zoltán <[EMAIL PROTECTED]>I can't choose what I can't believe That the way of life is to

Re: [GENERAL] That migration problem

1999-09-23 Thread Stuart Rison
Hello, Since I am going to do the very same upgrade in the near future, I'd be very grateful if you could send a brief posting on how you resolved that problem (and indeed any other you encountered during the upgrade). Regards, S. On Thu, 23 Sep 1999, Sebestyen Zoltan wrote: > Since then, I s

Re: [GENERAL] Is it possible run pgsql in Windows 95 ?

1999-09-23 Thread Bruce Momjian
> Hi, > > Is it possible run pgsql in Windows 95 ? Does someone has some example, > note .. No, you can only run sql clients on windows95. The PostgreSQL server has to be on Unix or NT. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (6

[GENERAL] 6.4.2->6.5.2 migration problem..

1999-09-23 Thread Sebestyen Zoltan
Hi, I would like to upgrade from 6.4.2 to 6.5.2, so I compiled 6.4.2 and now want to dump the existing database so in order to transfer it to the new postgresql. Unfortunately, pg dump can't fulfill his task, it's complaing that some procedural language is missing. What can I do in this case? He

Re: [GENERAL] Change table structure.

1999-09-23 Thread Shadkam Islam
Just to add to it... If you want to drop a column and you do not want to lose data from the table you may follow the following sequence, select field1,field2... from TableToBeChanged into TableToBeChanged_OldData; where field1,field2... will be having all the columns except the one you want to

Re: [GENERAL] Change table structure.

1999-09-23 Thread Teodor Cimpoesu
"Michal A. Kowalski" wrote: > > Hi, > > is there any way to change table structure without doing DROP and CREATE > again? nope, only if you rename (table|attr) name(s) or add an attribute. -- CIMPOESU Teodor, Web Programmer @ DIGICOM S.A. Bucharest, Romania @ Internet, site development @ [EM

Re: [GENERAL] Change table structure.

1999-09-23 Thread Stuart Rison
AFAIK, you can add and and rename columns no problem: functions=> \h alter table Command: alter table Description: add/rename attributes, rename tables Syntax: ALTER TABLE class_name [*] ADD COLUMN attr type ALTER TABLE class_name [*] RENAME [COLUMN] attr1 TO attr2 ALTER T

Re: [GENERAL] List of all PostgreSQL functions

1999-09-23 Thread Bruce Momjian
See FAQ. psql \df command. [Charset koi8-r unsupported, filtering to ASCII...] > Hi All. > > Does anywhere exists list of all PostgreSQL functions with description? > > Sincerely yours, Yury. > don.web-page.net, ICQ 11831432 > > > > -- Bruce Momjian

[GENERAL] Change table structure.

1999-09-23 Thread Michal A. Kowalski
Hi, is there any way to change table structure without doing DROP and CREATE again? Regards, MAK. ___ -- Michal A. Kowalski -- http://www.minfo.com.pl -- [EMAIL PROTECTED] --

[GENERAL] data mart indexing support?

1999-09-23 Thread amy cheng
greetings, all experts & newbies there!!! my questions are all related with data warehouse indexing: 1) does PG support bitmap index? 2) can PG use multiple indices with in ONE query? so that we do not need to make multiple attribute indices (composite indices). 3) can PG actually do Cartesia