--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Tsakiridis Orestis wrote:
Hi,
I'm looking for a way to monitor all the queries that are executed by
the server and to be able, by using these queries, to reproduce the
data in all databases.
Beware - query shipping runs into problems with
DELETE FROM my_table WHERE ts < now()
> The idea is
Hi,
I'm looking for a way to monitor all the queries that are executed by the
server and to be able, by using these queries, to reproduce the data in all
databases. The idea is to periodicaly (e.g. every two minutes) store the newly
executed queries in a sort of wal segment file. I first tried
LLC wrote:
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as f1 and f2.
I
subscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
set pgsql-general digest
---(end of broadcast)---
TIP 8: explain analyze is your friend
digest-status LISTNAME
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
remove
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
set nomail
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
have any installation files that combine both postgreSQL and PHP
together without the need to configure one by one?
On Mon, 12 Jun 2000, I'm Your Handiman -Online- wrote:
# > test
#
# kewl i'm in..sorry all for the test...:(
# anywayjust installed postgresSQL 7.0 and everything took fine
It's OK to just post your question, the test is kinda redundant if
you're going to ask a question imme
I'm Your Handiman -Online- wrote:
> test
kewl i'm in..sorry all for the test...:(
anywayjust installed postgresSQL 7.0 and everything took fine
is this normal?
[postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
DEBUG: Data Base System is startin
test
configset pgsql-general delivery_rules << ENDAAK
/(\.fi|\.no|\.dk|\.se)$/
sort
maxaddrs=50
minseperate=5
hosts=(towerguard.unix.edu.sollentuna.se=(esmtp,pipelining,onex))
backup=(hub.org=(esmtp,pipelining,onex))
/(\.nz)$/
sort
maxaddrs=50
minseperate=5
hosts=(postgresql.godzone.net.nz=(esmtp,pipe
Hallo,
it was really helpfull but unfortunatly in this time I don't have time
for your interesting group, so I invite you to delete my address from
your list.
Thanks Zamuner Lisa
Hello All,
I am writing the second time about my problem, maybe this time
somebody will answer. The problem is following:
I use a cyrillic characters in the names of tables and fields. When
I use plpgsql function as a trigger I have a record NEW in this
function, and consequently this record has
Hello All,
Does anybody knows where to send bugreport for postgresql? I can't
find this information on postgres site.
Best regards,
Yury ICQ 11831432
mailto:[EMAIL PROTECTED]
Hello,
I've recently installed the snapshot from this
past Sunday to test our applications against
6.5 in anticipation of migrating to it. As a result,
I have noticed a few peculiarities which the
June 6th snapshot exhibited. Our CGI code is
throwing the following exception as the result of
hello ,all:
It's known that some database system such as Oracle,Sysbase can
support the Two-Phase Commit that postgreSQL cann't. I want to make the
postgreSQL cooperate with other database under a transaction manager so
that we can deal with distributed transactions.
Now I met some ques
Does anybody know if 'LEFT','RIGHT','SUBSTR' are
working with psql,
I keep getting the magical parse error at or
near 'left'.
Thanks
Hi,
I am getting a PQExec error when I run this query.
delete from a where age('now
Hi all
How can i put limited length varchar(20) to SQL function?
I have:
create table bb (
c varchar(20),
d int4
);
create function ins ( ???varchar???, int4) returns int4
as 'insert into bb (c, d) values ($1, $2);
select 1;
'
la
Authenticated sender is <[EMAIL PROTECTED]>
Subject:Bull's Eye Targeting Software
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
EMAIL MARKETING WORKS!!
Bull's Eye Gold is the PREMIER email address collection tool.
This program allows you to de
Hello
could you explain me (Postgres 6.3.2):
/home/przemol> psql store3
store3=> create user pos;
ERROR: defineUser: user "pos" has already been created
store3=> drop user pos;
NOTICE: Dropping database store3
ERROR: destroydb cannot be executed on an open database
store3=>
I don't understand
29 matches
Mail list logo
