Hi all:
I am a fresh men in PostgreSQL. And i work on benchmark study these
days using PostgreSQL.
Now i have a question: Is there some way to show the lock contention of
PostgreSQL?
As I know, you can use *show mutex status* in MySQL to find which mutex is
hot. But i don't know in
Postg
Hi all:
Recently i do a test of postgresql. To get more information of the
functions in PostgreSQL, i use
opgprof and opannotate, which are two tools in Oprofile. But i can't work
with the tools correctly.
PostgreSQL is compiled with -g option and the errors are like this:
opgprof error:
Bruce Momjian napsal(a):
Where are we on this? Tom thinks we don't want this. TODO has:
I plan to send survey on general list about it today.
Zdenek
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgre
Hi there,
as you now is plJava broken with the actual security releases.
There is a pljava.dll at http://www.ejurka.com/pgsql/pljava/83rc1/ to
fix it for version 8.3RC1.
Is a pljava.dll for version 8.2.6 out?
It's very important for me, need it for my office.
Juergen
--
a limiti a SOLI 9,95 € AL MESE FINO A PRIMAVERA 2008!
http://abbonati.tiscali.it/adsl/prodotti/tc/tandemfree_tel_cc/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
I wonder if I should use PlPython in my projects or not.
Browsing on the Python list it seems that nobody is using
it. Browsing on Google Groups I find worrysome threads talking
about removing support from it in future versions of PostgreSQL.
So, I would like to know what's the current status of Pl
Hi,
just for fun, I wrote a little postgresql contrib,
who has a C function called myfun inside it.
The function myfun returns a value , now I return
a cstring type value, and it works fine if
I run from psql shell:
select value from myfun(paramteres);
but I can't do an insert like:
insert (ch
seems ok.
then we do:
$make
the outcome is the following:
Paolo [EMAIL PROTECTED] /d/msys/1.0/home/src/postgresql-8.1.4
$ make
make -C doc all
make[1]: Entering directory `/d/msys/1.0/home/src/postgresql-8.1.4/doc'
gzip -d -c man.tar.gz | /bin/tar xf -
for file in man1/*.1; do \
mv $file $file.
>> 'exists' isn't a good name for function :(.
>>
>
> Yeah, that isn't going to work. Perhaps "ifexists"? Or just leave well
> enough alone.
>
>
>
Darn. Can't have been thinking clearly this morning.
How about "exist" (no s)?
Maybe 'found', 'present', or 'contains'? (no, I h
loned from and I don't think we store that info anywhere.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
on't really have an implementor's guide.
Thanks for your help and suggestions.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
oaded.
Given that, I assume you don't feel the need to unload old shared libraries if the user (a superuser) removes an entry from backend_load_libraries, right?
In fact, it looks _PG_fini() is only called if you *reload* a library, unless I'm missing something somwhere.
--
Ko
before?) the call to BeginReportingGUCOptions() - by that time, we know whether we are a superuser and we have processed all GUC options.
Also, should we create an on_proc_exit() handler that would unload all dynamic libraries (specifically to call the _PG_fini() functions)?
-- Korry
--
Kor
ou --- I can do it if you don't want to.
I'll take a stab at it... thanks for your help so far.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
$libdir/plugins/ unless you are a superuser.
BTW, is anyone up for renaming the existing "preload_libraries" variable
to "postmaster_load_libraries"? This would be more symmetrical with
"backend_load_libraries", and so perhaps clearer about which does what
Make
Oracle support? Looking at this:
http://thinkoracle.blogspot.com/2005/10/oracle-packages.html
it seems varaiable are per-session.
Package variables are per-session.
Don't forget package initializers too...
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
process
> making it vastly easier for new hackers to get started.
A developers' wiki with links into the list archives would be great.
My thoughts exactly...
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
would be great. Can you point me to the patch you're referring to? I can convert my patch if you prefer.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
I am not sure how you prove the non-existance of a bug. Ideas?
I do that by deleting all of my code (usually by accident :-)
No code, no bugs!
-- Korry
a previous call
*/
Thanks for tackling this problem too.
-- Korry
Korry Douglas [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
Is anyone working on this?
Tom Lane wrote:
> korry <[EMAIL PROTECTED]> writes:
> > The problem is that, each time you go through
> > pgwin32_waitforsinglesocket(), you tie the *same* kernel object
> > (waitevent is static) to each socket.
>
> >
Hi,
Im getting this error when I try to connect to a postgresql database
from a web application running on tomcat
the error is from the postgersql logs
ERROR: No parser with id 17555
The error below is from tomcat logs:
---
(executing StatementCallback): encountered
SQLException [ERR
I changed some codes here, to get
the binary format of timestamp
/*/
so ,what switch should i turn on?
=== 2006-04-18 21:47:42 You Wrote:=======
>"[EMAIL PROTECTED]&qu
Hello:
I find that the real timestamp format(got from the file which is produced by
copying binary to ) is different from what i find in timestamp_send func.
i do think that the binary format of a timestamp "2006-04-18 11:20:20" should
be "44 2B B0 6A 00 00 00 00" standing for "secs:1143713898
Good Morning,
I'm an italian student and I'm working on a project involving postgres. I'm
sorry for my very bad english. I've some questions:
1)Does postgres upport semi-joins?
2)What about projections or selections in query tree writing? Does Postgres
support algebraic space (in other word when/
Good Morning,
I'm an italian student and I'm working on a project involving postgres. I'm
sorry for my very bad english. I've some questions:
1)Does postgres upport semi-joins?
2)What about projections or selections in query tree writing? Does Postgres
support algebraic space (in other word w
unsubscribe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Ok!
The Links your posted are great and i guessing it will help me a lot!
But the other Question (if Tablepartitioning under Developemt and will
it be supported generally)
is still alive.
Josh
Qingqing Zhou wrote:
<[EMAIL PROTECTED]> writes
I have done the following Post to PSQL Perfo
Hi PSQL Hackers,
I have done the following Post to PSQL Performance, but Richard Huxton
say it
might be a better Idea to post it again on you List so i forward the
message.
[EMAIL PROTECTED] wrote:
Hi all,
Ia a Guy from Germany an a strong Postgres believer!
It is the best OpenSource Database i
[EMAIL PROTECTED] ("Gevik Babakhani") writes:
>Maybe it is me but, I am trying to send a posting regarding a solution
>proposal for a TODO item.
>My posting has a .tgz attachment but it seems that it never arives at
>hackers list!
>This is very frustrating. I even ask Br
> Tom Lane
> Eric Kerin <[EMAIL PROTECTED]> writes:
> > The issues I've seen are:
> > 1. Knowing when the master has finished the file transfer transfer to
> > the backup.
>
> The "standard" solution to this is you write to a temporary file na
> Tom Lane wrote
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > It would be my intention (in 8.1) to make those available via
> switches e.g.
> > NOT LOGGED options on CREATE INDEX and COPY, to allow users to take
> > advantage of the no logging o
I notice that PITR doesn't function correctly on Windows. Has that been
reported elsewhere?
The archive_command parameter %p resolves to a full path containing slashes
rather than backslashes. This is not a Windows file, so any attempt to copy
it fails. There isn't any way to avoid that.
I'm sur
> Tom Lane
>
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > This is not a provably correct state machine
>
> I think the discussion ends right there.
Yes...
Negative results are worth documenting too, IMHO.
Best Regards, Simon Riggs
---
> Tom Lane
>
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > Please could we have a development schedule page on the web site...?
>
> You haven't been around here long, have you?
Gee, Tom, you noticed? What gave it away? :)
(I wasn't in
Please could we have a development schedule page on the web site...?
The information it should contain would be like this (and others)
Current Development Release: (Coordinator: Bruce Momjian)
8.0:Beta1, released 2 August 2004
Beta2, deadline 2 September 2004
On Thu, Aug 12, 2004 at 01:13:46PM -0400, Tom Lane wrote:
> Kenneth Marshall <[EMAIL PROTECTED]> writes:
> > On Thu, Aug 12, 2004 at 09:58:56AM -0400, Tom Lane wrote:
> >> How would a read-only action work to block out the checkpoint?
>
> > The latch+versio
Changed a couple of lines and traslated them in a better way.
Regards,
Fabrizio Mazzoni
# SOME DESCRIPTIVE TITLE.
# FIRST AUTHOR <[EMAIL PROTECTED]>, YEAR.
#
msgid ""
msgstr ""
"Project-Id-Version: PostgreSQL v7.4\n"
"POT-Creation-Date: 2003-10-05 13:25
Fixed up alignment problems and improved some translations.
Regards,
Fabrizio Mazzoni
# SOME DESCRIPTIVE TITLE.
# FIRST AUTHOR <[EMAIL PROTECTED]>, YEAR.
#
msgid ""
msgstr ""
"Project-Id-Version: PostgreSQL v7.4\n"
"POT-Creation-Date: 2003-10-05 13:26-03
Hello everybody,
how far have you got with statement-level triggers development?
Regards,
Claudio.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Friday 21 Mar 2003 12:25 pm, Tom Lane wrote:
> "Shridhar Daithankar<[EMAIL PROTECTED]>"
<[EMAIL PROTECTED]> writes:
> > And What's so holy about "" if it is a function?
>
> The problem is that TIME(n) is a datatype name, not a function call,
(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi,
Just stumbled upon this. Is it correct to conclude that foreign keys are not
inherited from this text?
phd=# create table perbookings(type smallint) inherits (bookings);
CREATE TABLE
phd=# \d perbookings;
Table "public.perbookings"
Column |
On Tuesday 18 Mar 2003 8:07 pm, Nigel J. Andrews wrote:
> On Tue, 18 Mar 2003, Shridhar
Daithankar<[EMAIL PROTECTED]> wrote:
> > I consider this as a bug but given my understanding of sql, I won't count
> > on it. Any comments?
>
> If a is to be referenced in a f
Hi,
Today I discovered that if there is a compund primary key on a table, I can
not create a reference from another table to one of the fields in the primary
key..
Look at this..
phd=# create table tmp1(a integer,b integer,primary key(a,b));
NOTICE: CREATE TABLE / PRIMARY KEY will create impl
Hi all,
I was just wondering.The patches for making ecpg thread safe that were
floating around few days back, are they going to make in any near future
releases?
I am badly bitten by libpq as code i my multithreaded app. is growing
steadily. I find myself making stupid mistakes every now and t
On Friday 14 Feb 2003 9:05 pm, you wrote:
> Martin Coxall <[EMAIL PROTECTED]> writes:
> Here's a pretty topic for a flamewar: should it be /etc/postgres/ or
> /etc/postgresql/ ?
I vote for /etc/pgsql. Keeping in line of unix philosophy of cryptic and short
names. Who wants
On Tuesday 11 Feb 2003 10:56 pm, you wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > What if we supplied several sample .conf files, and let the user choose
> > which to copy into the database directory? We could have a "high read
> > performance"
s so things have
changed for sure, but you got the idea, right?
Shridhar
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Friday 31 Jan 2003 9:56 am, you wrote:
> Kevin Brown <[EMAIL PROTECTED]> writes:
> But this only wins if a child process inheriting an open file also
> inherits copies of any locks held by the parent. If not, then the
> issue is moot. Anybody have any idea if file locks work
through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Firebird uses a set of Borland command line tools and Borland's make,
which they give away as a free download. Even if you're compiling for
Windows, the build process uses Borland's command line "make". A batch
build script copies makefiles from a single source directory and spreads
them aro
This is a multi-part message in MIME format.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I am sure, many of you would like to delete this message before reading, hold
on. :-)
I'm afraid most posters did not read the message. Those who replied
"Why bother?" did not address your challenge:
I think threads are useful in difference situations namely parallelising
blocking conditio
spese, stessa banca, più interessi.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=657&d=12-7
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
used to and sadly often expect poor interfaces
with the programs they use. Windows users are far less forgiving. If, what you
are talking about, is truly wide spread use for PCs and small-time web-servers
then a Windows interface is damn near necessary.
Eric
-Original
Message-
I'm pleased to see some renewed interest in
pg_access. It seems obvious to me that MS Access is not currently...and
probably never will be able to handle data in a robust and reliable
fashion. MS Access' apparent success is due to the user interface quality
and "ease of use" for "non-progr
ing credit where credit is due. I like to see
copyright notices and references to the GPL in Linux oriented code. It
gives me a better "feel" for those "upon whose shoulders I stand".
Arthur
- Original Message -
From: "mlw" <[EMAIL PROTECTED]>
To: &
Dear Team,
I'm wide open to other ideas for the support of
robotic vision through tools already built into PostGreSQL. But you've
already admitted to certain speed limitations...and robotic vision is going to
require much more intense processing power. An MVD might allow the data
stream
Dear Team,
I've read your comments. No, I don't think
that MVD's are the best thing since sliced breadbut they do have a certain
"simplicity" that seems to hold the key to high speed analysis of large volumes
of streaming data from the "eyes" of a robot. This stream of data must be
q
Dear Team,
I have been monitoring this list for quite some
time now and have been studying PostGreSQL for a while. I also did some
internet research on the subject of "multi valued" database theory. I know
that this is the basis for the "Pick" database system, FileMaker Pro, "D3", and
a
I just tried to get PostgreSQL from CVS , but it rejected the password
'postgresql' for user 'anoncvs':
$ export CVSROOT=:pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot
$ cvs login
(Logging in to [EMAIL PROTECTED])
CVS password:
cvs login:
[EMAIL PROTECTED] (Lamar Owen) wrote in message
news:<[EMAIL PROTECTED]>...
> [trimmed cc:list]
> On Wednesday 18 July 2001 17:09, Bruce Momjian wrote:
> > OK, we need to vote on whether Oid's are optional, and whether we can
> > have them not created by defaul
64 matches
Mail list logo