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!
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
>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
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
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
[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
>
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
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
> 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
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
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
"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
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
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
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] --
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
16 matches
Mail list logo