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 thread
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 wo
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:
http://sniptools.com/databases
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 bigin
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 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 me errors about utf
Actually I just realized that the SQL below will also pick up on these
perfectly valid-looking columns:
http://factfinder.census.gov/servlet/ReferenceMapFramesetServlet?_bm=y&-zip=27340&-PANEL_ID=rm_result&-_MapEvent=zoomToAddress&-street=&-city=&-rm_config=|b=50|l=en|t=420|zf=0.0|ms=ref_legal_00
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 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 have
Alvaro Herrera 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 files ... Surely the
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:
>
>
> http://factfinder.census.gov/servlet/ReferenceMapFramesetServlet?_bm=y&-zip=27340&-PANEL_ID=rm_result&-_MapEvent=zoomToAddress&-street=
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 NO
"Philippe Lang" 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 which other objects t
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
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"...
>>
>>
>>
>> Is it correct to say that this "hierarchy" does not exist inside
>> Postgresql, and that it is necessar
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
have
On Mon, Dec 14, 2009 at 4:28 PM, Richard Broersma
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.
Did you try a reload
On Mon, Dec 14, 2009 at 9:10 AM, Dave Page 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 Users Group (LAPUG)
Phoenix Kiula 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:
http://archives.postgresql.org/pgsql-g
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 in
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 fa
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 :
> Hi all,
>
> Short version of m
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
