Hello.
I'd like to collect some statistics in my application (using JDBC). In
Oracle I could collect data, sent to client, using the following query:
SELECT S.value FROM V$MYSTAT S,SYS.V_$STATNAME NAMES
WHERE NAMES.STATISTIC#=S.STATISTIC#
AND NAMES.NAME='bytes sent via SQL*Net to client';
Can
Hi all,
I have a simple question: Are the temporary database objects created
within a pgplsql function visible/available outside the function (or
implicit transaction) in any way. I am dropping and creating temporary
database objects within a function and I am calling this function in
from a
Hello,
In order to have a global map of the dependencies of the functions,
views, tables in a PG database, I'd like to have some sort of
dependency tracking tool, that would show for each object:
- which other objects depend on this object
- on which other objects this object depends
This would
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's archives but could not come up with an answer.
Google returns some sites like these:
Hi,
I am using Postgres 8.3. I have a table defined like this:
===
-- Table: timeson
-- DROP TABLE timeson;
CREATE TABLE timeson
(
id bigint NOT NULL,
enddatetime timestamp without time zone NOT NULL,
startdatetime timestamp without time zone NOT NULL,
times_id
Actually the title of my email should have been how to **replace**
utf-8 values.
Thanks.
On Mon, Dec 14, 2009 at 7:03 PM, Phoenix Kiula phoenix.ki...@gmail.com wrote:
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives
Actually I just realized that the SQL below will also pick up on these
perfectly valid-looking columns:
On 14/12/2009 4:35 PM, Allan Kamau wrote:
and I am calling this function in
from a threaded application which could use the same connection in
more than one thread(is this possible/or even safe).
No!
Admittedly it depends on the client interface/driver, but at least for
direct psql, PgODBC
Tom Lane wrote:
Greg Smith g...@2ndquadrant.com writes:
wrote:
Hi,guys.I ama studentwho want to studyPostgreSQL.I encountered the
following errors which I don't know how to fix while I using eclipse
to built pgsql:
I don't know why this specific one isn't working, but we do
Alvaro Herrera alvhe...@commandprompt.com writes:
Tom Lane wrote:
Hm, I wonder whether the reason the OP ran into trouble was that he
followed that guide :-(. Relying on manual invocation of configure
is a sure recipe for hitting weird breakage anytime somebody changes
the configure input
On 14 Dec 2009, at 13:21, Phoenix Kiula wrote:
Actually I just realized that the SQL below will also pick up on these
perfectly valid-looking columns:
On Monday 14 December 2009 3:04:07 am Fred Janon wrote:
Hi,
I am using Postgres 8.3. I have a table defined like this:
===
-- Table: timeson
-- DROP TABLE timeson;
CREATE TABLE timeson
(
id bigint NOT NULL,
enddatetime timestamp without time zone NOT NULL,
Philippe Lang philippe.l...@attiksystem.ch writes:
In order to have a global map of the dependencies of the functions,
views, tables in a PG database, I'd like to have some sort of
dependency tracking tool, that would show for each object:
- which other objects depend on this object
- on
Philippe Lang wrote:
Hello,
In order to have a global map of the dependencies of the functions,
views, tables in a PG database, I'd like to have some sort of
dependency tracking tool, that would show for each object:
- which other objects depend on this object
- on which other objects
Tom wrote:
In order to have a global map of the dependencies of the functions,
views, tables in a PG database, I'd like to have some sort of
dependency tracking tool...
snip
Is it correct to say that this hierarchy does not exist inside
Postgresql, and that it is necessary to parse the
I might be bringing this up too soon, however the link to the 8.4.2
windows binaries needs to be updated:
http://www.enterprisedb.com/products/pgdownload.do#windows
It currently shows the binaries for 8.4.1.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
When upgrading pg 8.4.1 to 8.4.2 the following error message appeared:
-Error-
[quote]Error copying file from package archive
(...)/postgresql-8.4.2-1-windows.exe to (...)/bin/comerr32.dll[/quote]
After selecting retry, the install process completes successfully.
P.S.
I tried posting this to
Hi All,
I have solaris 10 update5 sunfire X4240 with 32GB RAM and ZFS system.I am
having problem while configuring below parameters especially how shmmni
works ---
1) shmmax
2) shmmni
3) arc_max
4) shared_buffers
Since, it's a dedicated server i want to utilize all resources.As of now i
On Mon, Dec 14, 2009 at 4:28 PM, Richard Broersma
richard.broer...@gmail.com wrote:
I might be bringing this up too soon, however the link to the 8.4.2
windows binaries needs to be updated:
http://www.enterprisedb.com/products/pgdownload.do#windows
It currently shows the binaries for 8.4.1.
On Mon, Dec 14, 2009 at 9:10 AM, Dave Page dp...@pgadmin.org wrote:
It currently shows the binaries for 8.4.1.
Did you try a reload?
Yes, It shows 8.4.2. Actually the page refreshed two minutes after I
sent the email.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL
Phoenix Kiula phoenix.ki...@gmail.com writes:
Is there any SQL possibility to find these columns and replace them
with utf-8 equivalents using some postgresql commands? Couldn't find
anything in the Strings functions (chapter 9 of manual).
I've bookmarked this for later:
December 14th, 2009, the PostgreSQL Conference U.S. team is pleased to
announce the East 2010 venue and call for papers. This year the premiere
East Coast PostgreSQL Conference will be returning to history Drexel
University in Philadelphia.
The event this year is being held at Drexel University
Hi all,
Short version of my question:
What's the best way to compare arbitrary records (OLD and NEW, in my
case) using PL/pgSQL in Postgres 8.3, without knowing anything about
the structure of the records? If the answer is to cast OLD and NEW to
text, and then compare, as suggested in [1], what
I have a few things to report so I'm not sure if one email is good or
several but here goes.
We are using Postgresql 8.3.8
We were having a blocking query problem that should have been fixed by
statement_timeout = 9 however this seems to have had zero effect.
The query we have was like so:
Greetings!
The Gluster Team is happy to announce the release of Gluster Storage Platform
3.0. The Gluster Storage Platform is based on the popular open source clustered
file system GlusterFS, integrating the file system, an operating system layer,
a web based management interface, and an easy
Hello
NEW and OLD is comparable in 8.4. In 8.3 and older you have to use
little bit different syntax
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body
Regards
Pavel Stehule
2009/12/15 Josh Kupershmidt schmi...@gmail.com:
Hi all,
Hello.
It seems that this works (I made tests on permanent table, postgresql
8.4.0):
CREATE OR REPLACE FUNCTION track_updates()
RETURNS TRIGGER AS $$
DECLARE
BEGIN
IF TG_OP = 'UPDATE' THEN
IF NEW IS NOT DISTINCT FROM OLD THEN
RAISE NOTICE 'OLD and NEW are the same!';
27 matches
Mail list logo