okmeter.io is good (though it's cloud-based and costs some money), I'm
using it and definitely can recommend.
There much more tools, see: https://wiki.postgresql.org/wiki/Monitoring
On Mon, Jul 24, 2017 at 4:27 AM, PAWAN SHARMA
wrote:
> Hi All,
>
>
> Please provide me a list of tools which we c
figure out what is the reason
and how to solve it (installation is not mine)...
This message is just to say that you're not alone :-) Maybe this is
common problem for win2k3, will see.
--
Sincerely yours,
Nikolay Samokhvalov
Postgresmen LLC, http://postgresmen.ru
--
Sent via pgsql-general
If I'm not mistaken 8th July is official birthday of PostgreSQL. 12
years, great!
(i'm a bit late here in Russia, but it's OK for US ;-) )
Kudos PostgreSQL!
--
Best regards,
Nikolay
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
+ functional XPath indexes to index text data from your
XML, if you have corresponding needs.
Unfortunately, that is almost all you can do speeding up your XPath
queries at the moment, and in terms of performance there is no any
major improvements in 8.3 either.
--
Nikolay Samokhvalov <[E
in current docs:
http://www.postgresql.org/docs/8.3/static/functions-xml.html#FUNCTIONS-XML-PROCESSING
If needed, XPath spec can be found here: http://www.w3.org/TR/xpath.
I can explain if something is difficult to understand.
--
Nikolay Samokhvalov <[EMAIL PROTECTED]>
http://nikolay.samokhv
nows what its going on? Is that some kind of permission?
Apparently, there is contrib/xml2 installed in database 'a'. Use
contrib/xml2's installation SQL script to install this module in
database 'b'.
--
Nikolay Samokhvalov <[EMAIL PROTECTED]>
http://nikolay.sam
Hi all,
does anybody know where to find a good list of PostgreSQL terms
(including both traditional terms and Postgres-specific ones)? At
least a simple list w/o descriptions...
Google didn't help me yet :-\
--
Best regards,
Nikolay
---(end of broadcast)
On 7/10/07, CG <[EMAIL PROTECTED]> wrote:
Can't wait... Got to have it now. :(
I patched xpath.c and created a function which takes a third parameter which
are the known namespaces in a space delimited hash list ... I based the patch
on some example code from the libxml website which works per
AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions
at all. Wait for PostgreSQL 8.3 :-)
On 7/9/07, CG <[EMAIL PROTECTED]> wrote:
select xpath_string($xml$
baz
$xml$
,'//f:bar/text()');
This does not give me back "baz" as I was expecting it to... It seems like
xpath is igno
On 22 May 2007 17:47:46 -0700, EMS Database Management Solutions
(SQLManager.net) <[EMAIL PROTECTED]> wrote:
We, here at EMS Database Management Solutions, are pleased to announce
SQL Manager 2007 for PostgreSQL - the new major version of the
powerful PostgreSQL administration and development too
On 5/15/07, Jeff MacDonald <[EMAIL PROTECTED]> wrote:
I even tried
gmake -I/usr/include/libxml2/libxml
no go.
try -I/usr/include/libxml2
--
Best regards,
Nikolay
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 3/4/07, Peter Schonefeld <[EMAIL PROTECTED]> wrote:
Hi, i'm having trouble getting xpath in Postgres 8.2 to recognise xml
namespaces...could someone please point me to a good reference for the xml2
lib?
This is FAQ-like question.
The thing is that XPath spec doesn't define any default mappin
If you do not need XSTL support (this contrib consists of two parts,
one for XPath and another for XSLT), you can remove any mentioning of
*xslt* from Makefile and xml2.sql.in file and then try gmake again.
On 12/20/06, Paul Silveira <[EMAIL PROTECTED]> wrote:
Hello,
I just installed Postgres
On 10/30/06, Ashley Moran <[EMAIL PROTECTED]> wrote:
... clean, elegant nature
of PHP seems taken from MySQL.
Ashley
XML parsing failed (2 errors) :-)
--
Best regards,
Nikolay
---(end of broadcast)---
TIP 5: don't forget to increase your free
On 10/30/06, Ashley Moran <[EMAIL PROTECTED]> wrote:
Arguably that's because Ruby and Rails share
more of the design philosophy of Postgres, whereas PHP's design
rigour seems to be inspired by MySQL.
Could you please give some example of such "inspired by MySQL features
of PHP design"?
--
Bes
Hi,
What is the best practice for following case:
In my database I have a set (~10) of schemas; my database periodically
is being backed up and restored at another machine. I have set up
search_path via "ALTER DATABASE ... SET search_path TO ..." to make
all needed schemas visible to any user who
As for persistent connection with PHP, start from here:
http://php.net/pg_pconnect.
Also, I recommend to ensure that you have proper set of indexes on
your tables and your system doesn't use badly written queries (such as
join of several dozens of tables :-) ). There is an excellent tool
that can
On 8/24/06, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Wed, 2006-08-23 at 16:04 -0700, Frank Cohen wrote:
>
> These look like good XPath functions. Are they actually in PSQL
> 8.1.4? I did not find them in the Windows installed version. If not,
> are they recommended?
Look at contrib/xml2. The fun
SELECT DISTINCT substring(attribute from '^http://[^/]*/') from pg_atp
where attribute like 'http://%';
w/o DISTINCT there should be duplicates (if any)
don't use "DISTINCT ON" at all, it's evil :-) (why?
http://chernowiki.ru/index.php?node=38#A13)
On 8/8/06, Christoph Pingel <[EMAIL PROTECTED]
On 8/4/06, Q Beukes <[EMAIL PROTECTED]> wrote:
[...]
When I dump the database, the tables dumped for "cbt" dont have alter
commands to set the default values to
"nextval('core.invoicesids_seq')" again. Those columns are simply
created as serial fields, and their values set to "1, false".
So when
Thanks. 'connect to' cannot be sent to server as plain text, surely.
I'm stupid :-(
On 8/4/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
On Fri, 4 Aug 2006, Nikolay Samokhvalov wrote:
> On 8/4/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
> [...]
&g
On 8/4/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
[...]
BTW, difference vanishes due to expression power of SQL -
it supports session comands in the same context as DDL commands and
data manipulation stmts (SQL:200n, 4.33.2.5 'SQL-connection
statements').
Sorry,
On 8/4/06, J B <[EMAIL PROTECTED]> wrote:
On 8/3/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
> Let's believe that that was the real reason... :-)
If not, what was? Is this really a commentary on how many
"enterprise"-y types are using Postgres?
I'
On 8/4/06, Tom Lane <[EMAIL PROTECTED]> wrote:
The reason neither of these are going to happen is that you're confusing
a server-side SQL command (viz CREATE DATABASE) with a client-side
operation (viz choosing to drop the server connection and make a new one
to a different database).
Hmm.. I a
On 8/3/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
http://news.zdnet.com/2100-3513_22-6100795.html
Let's believe that that was the real reason... :-)
"
...
In a letter to the PostgreSQL community of developers, Pervasive
Software President John Farr said last week that the company
"underestimat
On 8/3/06, Christian Rengstl <[EMAIL PROTECTED]> wrote:
...
Unfortunately the query takes pretty long for the big table, so maybe one of
you has a suggestion on how to make it faster.
try smth like this:
select val1, val2, crit from mytable as a where pid='somepid' and
exists(select 1 from m
On 8/2/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
Question,
What is the difference between left join, and left outer join?
I know the difference between inner and outer joins, but I was thinking that
left join == inner join. But from what I am now seeing, it appears that PG
is equating left j
On 8/1/06, Eric Andrews <[EMAIL PROTECTED]> wrote:
... and inside
those boxes are a set of contents. what I want to do is search and
basically "mine" data from the content sets. do I use an array
datatype for the content column, or is there a better more efficient
way to go about this?
What kin
As a alternative way, you may forget about sequence name and create
rule for you table - simple rule that will make 'SELECT idColumnName'
on every INSERT action.
After trying several approaches I've chosen this way in my projects.
It's better way if you have some framework (R2O layer or smth).
On
On 6/29/06, Alain Roger <[EMAIL PROTECTED]> wrote:
Hi,
I would like to provide access to PostgreSQL via PHPpgadmin.
basically when user will enter login + password, he will connect directly to
his database.
what i've done till now, it does not work.
when user enter login and password, phppgad
So, what about it?
I periodically encounter with the same problem. People (e.g. me :-)
but not only) expect that when they use pg_dump to backup some
database (either schema only or both schema and data), all database
properties will be dumped and, then, restored.
People think that this thing s
On 6/5/06, Martijn van Oosterhout wrote:
Yeah, I was working on it but got stuck on the planner/optimiser
changes. In the mean time the tree drifted and lack of interest, which
gets us where we are now...
Very bad news :-(
I were looking forward to this feature... So many troubles in my
proje
On 5/21/06, Brendan Jurd <[EMAIL PROTECTED]> wrote:
Well if you're willing to accept that for the purposes of computing the
aggregates, an interval "month" is equal to 30 days (which is how
avg(interval) already works), then an interval is reducable to a single
quantity -- a number of seconds --
On 5/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
If the intervals are all expressed in seconds then sure, the calculation
is straightforward and useful. I'm wondering what happens when nonzero
values of days and months get in there.
Ah!
Maybe the reason for such thoughts lies in nature of post
First of all, stddev doesn't return square of smth - so, why should we
worry about intermediate results? Furthermore, statistics work with
any 'units' and doesn't worry about physical meaning of variance in
any case (for example, what about variance for the set of lifetime
values of people from to
From my point of view, more important problem is that log doesn't help
to find the query (in other words, log message doesn't show context)
On 5/11/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
Anastasios Hatzis <[EMAIL PROTECTED]> writes:
> My problem is that I don't know where the given cha
select proname from pg_catalog.pg_proc where proname = 'my_proc_name';
On 4/18/06, Alexander Scholz <[EMAIL PROTECTED]> wrote:
> Hi Newsgroup,
>
> I need a query which can check for the existence of a certain stored
> procedure.
>
> (The pendant for MS SQL is
>
> IF EXISTS (SELECT * FROM "sysobjec
hello.
does anybody know any solutions to the problem of searching
words/phrases, which are close to each other by sounding? e.g. soundex
index or smth.
problem I have: tag suggestion mechanism, similar to google suggest,
which is intended to suggest names of people (search field "person's
name"
I hate ILIKE. it's abnormal, as there is no way to forget it and use
standard things (I can hardly wait collation support).
So, every time I type 'ILIKE' I think: I DON'T LIKE ILIKE. In other
words, 'ILIKE' couldn't be true for me and PostgreSQL makes me lie.
--
Best regards,
Nikolay
April, 1st.
On 3/15/06, Stephen Slezak <[EMAIL PROTECTED]> wrote:
> In the interim period while a central PostgreSQL community knowledge base is
> being put together, Pervasive Software is opening up access to our PostgreSQL
> Knowledge Base ( http://www.pervasivepostgres.com/instantkb13/). Any
> interested
On 2/7/06, Martijn van Oosterhout wrote:
> On Tue, Feb 07, 2006 at 03:28:31PM +0300, Nikolay Samokhvalov wrote:
> > The real situation would be as the following.
> > I want to use some algorithm to hide real number of registered users
> > in my table user. So, I don't w
On 2/27/06, Martijn van Oosterhout wrote:
> Huh? We should ofcourse try to implement SQL:2003 wherever we can, but
> to say this means we need to throw out anything not mentioned is silly.
> For example, CREATE INDEX is not in SQL:2003, are you seriously
> suggesting we remove it?
i didn't suggest
On 2/27/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
>
> On Mon, 27 Feb 2006, Nikolay Samokhvalov wrote:
>
> > On 2/27/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > The alternatives to distinct on are painful. They are generally both harder
> > to rea
On 2/27/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> The alternatives to distinct on are painful. They are generally both harder
> to read and run slower.
>
'DISTINCT ON' is evil constuction, because (w/o any 'ORDER BY') it
produses unpredictable result, as 'ORDER BY random()' does.
When newb
On 2/27/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Am Sonntag, 26. Februar 2006 21:24 schrieb Neil Conway:
> > I think a better approach would be to introduce the concept of "SQL
> > dialects", similar to "--std=..." in GCC or SQL modes in MySQL 5. That
> > would help people who want to writ
On 2/26/06, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> Please help.
how?
is there any place where postgres' SQL:2003 incompatibilities are
being discussed?
I really want to have standard-compatible PostgreSQL and some option
in postgresql.conf that would allow me to restrict Postgres' SQL
synta
There is no SERIAL type in the standard at all. Moreover, standard
defines following expression for SEQUENCE GENERATORs:
::= NEXT VALUE FOR
Postgres has non-standard equivalent - nextval()...
So, sequences implementation in PostgreSQL isn't standard-compliant.
On 2/7/06, John D. Burger <[EMAI
On 2/7/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Nikolay Samokhvalov <[EMAIL PROTECTED]> writes:
> > testseq=# CREATE TABLE test(id SERIAL, data TEXT);
> > NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for
> > serial column "t
On 2/7/06, Martijn van Oosterhout wrote:
> On Tue, Feb 07, 2006 at 02:33:56PM +0300, Nikolay Samokhvalov wrote:
> Well, it's a very contrived example (I can't think of a reason why one
> would do that) but I agree it is a bug. You could acheive the same
> effect by s
Maybe it was discussed already, but I think it's very strange behavior
and things should be changed (please correct me if I'm wrong)
Suppose we have database containing only one simple table:
***
template1=# CREATE DATABASE testseq;
template1=# \c testseq
testseq=# CREATE TABLE test(id SERIAL, da
itag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov:
> > Please, suggest any free/opensource tool for DB design under Linux. I
> > need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
> > don't even dream about reverse transformation...) Qui
Please, suggest any free/opensource tool for DB design under Linux. I
need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
don't even dream about reverse transformation...) Quite good example
of such tool is Sybase PowerDesigner (which supports Postgres), but
AFAIK it runs only un
http://www.oracle.com/technology/software/products/database/xe/index.html
http://news.zdnet.com/2100-3513_22-5920796.html
'Oracle intends to release a free version of its database, a reaction
to the growing competitive pressure from low-end open-source
databases.'
Your thoughts?
--
Best regards,
IMHO, Veil is very strange project. Instead of concentrating on good
support of updatable views, developers are trying to reinvent the
wheel. Actually, if restriction-and-projection views would be
updatable w/o overhead (such as creating rules), there'll no need in
such project. It's one of the maj
On 08/10/05, Martijn van Oosterhout wrote:
> On Sat, Oct 08, 2005 at 03:32:00PM +0400, Nikolay Samokhvalov wrote:
> > http://chernowiki.ru/Dev/PostgreSQLComparedWithSQL2003AndOracleSQLServerDB2Etc
> >
> > Perhaps I'm wrong with some issues - any comments are welcome
I use PostgeSQL less than year. Before I worked with MS SQL Server
2000, MySQL 3&4, Oracle8i and Interbase. Also, I studied standards
SQL:1999 and SQL:2003. So, after switching to PostgreSQL I've
encountered with several things that seem strange to me. Of course,
several of them are simply not impl
Consider following SQL:
**
select femail, min(fid) AS main_id, count(fid) AS countids
from users
where count(fid) > 1
group by femail
**
Of course, postgreSQL produce error for such wrong statement:
SQL error:
ERROR: aggregates not allowed in WHERE clause
I think it would be much better if DBMS
57 matches
Mail list logo
