Hi,
Maybe someone on this list actually have already tried this:
I'm planning to make a partitioned database. From Postgres documentation
I can see, that there are basically two methods to route INSERTS into
partitioned table:
one. is a TRIGGER
other. is a RULE
My Table will
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
I'm not finding anything on Google. Does anyone know how to get this?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Maybe this will be helpfull:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Regards,
Blazej Oleszkiewicz
2008/9/4 Artacus [EMAIL PROTECTED]:
I'm writing some ETL procedures in pgplsql. After each insert/update/delete,
I'd like to log how
On Thu, Sep 04, 2008 at 02:07:01AM -0700, Artacus wrote:
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
http://www.postgresql.org/docs/current/interactive/plpgsql-statements.html
search for GET DIAGNOSTICS
Best
Oh, as I was writing a CUBE query today and realized that I forgot to
mention this. And unlike most gripes, like MERGE INTO or CTE's which
are
really convenience things, this is key piece of functionality that
you
just can't reproduce in Postgres.
That said, there's not the same sense
Hi,
I am currently using xml2 functionality in PostgreSQL 8.3.x and want to
substitute it by the newer API as mentioned here:
From PostgreSQL 8.3 on, there is XML-related functionality based on the
SQL/XML standard in the core server. That functionality covers XML syntax
checking and XPath
Hi,
does anybody know how to use the xml2 function xpath_bool with namespaces.
I have used this function successfully as long as my xml documents haven't
contained namespaces. I searched with google and found some readme file
where the function xpath_bool_ns was available that would probably
Where can I find a list of changes for Version 8.4 of postgres?
Paul Tilles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
paul tilles wrote:
Where can I find a list of changes for Version 8.4 of postgres?
It's not officially written anywhere. As a starting point you can look
here:
http://wiki.postgresql.org/wiki/Category:CommitFest
Then look at each Commitfest:2008:xx page, and see the list of committed
patches.
Is there a date for the release of 8.4 ?
joao
On Thu, 2008-09-04 at 10:09 -0400, Alvaro Herrera wrote:
paul tilles wrote:
Where can I find a list of changes for Version 8.4 of postgres?
It's not officially written anywhere. As a starting point you can look
here:
Joao Ferreira gmail escribió:
Is there a date for the release of 8.4 ?
http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Development_Plan
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent
Buenos Dias, necesito saber los pasos para recompilar con soporte para
xml, en redhat 4 entreprise y postgres 8.3.
Gracias,
.
Hi,
On Thu, 2008-09-04 at 10:18 -0430, Ricardo Antonio Yepez Jimenez wrote:
Buenos Dias, necesito saber los pasos para recompilar con soporte
para
xml, en redhat 4 entreprise y postgres 8.3.
You cannot compile PostgreSQL 8.3 on RHEL 4 with xml support -- unless
you install libxml2 from
On Thu, 2008-09-04 at 10:45 -0400, Alvaro Herrera wrote:
Joao Ferreira gmail escribió:
Is there a date for the release of 8.4 ?
http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Development_Plan
/me notes that noone responded like It will be released when it is
ready.
--
Devrim GÜNDÜZ, RHCE
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
From: Akhtar Yasmin-B05532 [EMAIL PROTECTED]
Subject: Re: [GENERAL] Postgres does not start, gives no error
To: Tom Lane [EMAIL PROTECTED]
Cc: Joshua Drake [EMAIL PROTECTED], pgsql-general@postgresql.org
Date: Wednesday,
* [EMAIL PROTECTED] (Richard Broersma) wrote:
On Sun, Aug 31, 2008 at 1:50 PM, Kevin Hunter [EMAIL PROTECTED] wrote:
7. Though I don't personally buy it, I have heard others complain
loudly that there is no print-version of Postgres documentation.
This one should be taken off the
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
From: Akhtar Yasmin-B05532 [EMAIL PROTECTED]
Subject: [GENERAL] Postgres does not start, gives no error
To: pgsql-general@postgresql.org
Date: Wednesday, September 3, 2008, 7:11 PM
HI,
I am facing this peciliar
Coming from MS SQL server, if I ever change anything vital on a
production system, or do any kind of major hackery on my own, I wrap it
in a transaction first:
BEGIN TRANSACTION;
DELETE FROM vital_information WHERE primary_key = 10;
ROLLBACK TRANSACTION;
I then make sure that the result comes
On Thu, Sep 4, 2008 at 1:17 PM, William Garrison [EMAIL PROTECTED] wrote:
Coming from MS SQL server, if I ever change anything vital on a production
system, or do any kind of major hackery on my own, I wrap it in a
transaction first:
BEGIN TRANSACTION;
DELETE FROM vital_information WHERE
exist the file postmaster.pid in your directory?
No the postmaster.pid does not exist in the directory, even when
I start the server, it does not appear, I am assuming, that this file is
present only when postmaster in running.
check the log of the OS and the permissions of the
On Thu, Sep 4, 2008 at 12:28 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Have you tried psql? That's all I usually use. Here's what I get
The only problem with psql is that it is addictive. Once your hooked,
it is hard to use anything else.
:o)
--
Regards,
Richard Broersma Jr.
Visit the
All,
I want to do something simple and the terminology is slipping me. I
want to execute two separate queries that should return 0 or 1 rows and
I want to join the results of those queries into a single row.
SELECT a.col1, a.col2
FROM mytable a
WHERE a.uid = 'abc';
SELECT b.col3,
On Thu, Sep 4, 2008 at 12:53 PM, Akhtar Yasmin-B05532
[EMAIL PROTECTED] wrote:
exist the file postmaster.pid in your directory?
No the postmaster.pid does not exist in the directory, even when
I start the server, it does not appear, I am assuming, that this file is
present only when
On Thu, Sep 04, 2008 at 03:43:33PM -0500, D. Dante Lorenso wrote:
I came up with this query that works, but seems overly complicated:
SELECT a.col1, a.col2, b.col3, b.col4
FROM
(SELECT col1, col3, TRUE AS join_column
FROM mytable
WHERE uid = 'abc') a
FULL OUTER
On Thu, Sep 4, 2008 at 3:22 PM, Sam Mason [EMAIL PROTECTED] wrote:
On Thu, Sep 04, 2008 at 03:43:33PM -0500, D. Dante Lorenso wrote:
I came up with this query that works, but seems overly complicated:
SELECT a.col1, a.col2, b.col3, b.col4
FROM
(SELECT col1, col3, TRUE AS join_column
On Thu, Sep 4, 2008 at 2:22 PM, Sam Mason [EMAIL PROTECTED] wrote:
This still seems a little nasty and I'd prefer to do something like:
my idea seems nastiest of all:
SELECT *
FROM ( SELECT COUNT(*) AS rownbr, A1.col1, A1.col2
FROM Mytable AS A1
INNER JOIN Mytable AS
Hey All,
anybody happen to know if there is a java class 'somewhere' to insert/
update a hstore field in PostgreSQL?
Ries
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Sep 04, 2008 at 03:26:39PM -0600, Scott Marlowe wrote:
On Thu, Sep 4, 2008 at 3:22 PM, Sam Mason [EMAIL PROTECTED] wrote:
The ON clause is just a normal expression, so you can just put a
TRUE in there if you want a cross join. I.e. the following is a
minimal full outer cross join:
On Thu, Sep 4, 2008 at 2:54 PM, Sam Mason [EMAIL PROTECTED] wrote:
SELECT * FROM foo FULL OUTER CROSS JOIN bar;
Admittedly, there aren't too many use cases for this! But it would make
things a bit more regular.
SELECT * FROM foo, bar;
Isn't this have the same results, but with out the
On Thu, Sep 04, 2008 at 02:58:39PM -0700, Richard Broersma wrote:
On Thu, Sep 4, 2008 at 2:54 PM, Sam Mason [EMAIL PROTECTED] wrote:
SELECT * FROM foo FULL OUTER CROSS JOIN bar;
Admittedly, there aren't too many use cases for this! But it would make
things a bit more regular.
SELECT
Maybe you have it configured to log to syslog? Look in
postgresql.conf.
regards, tom lane
HI,
This is regarding the postgres issue..
We are not maintaining any logs for the postgres stop/start.
So it becomes a bit problematic, to debug..
These are the steps we are
On Sep 4, 2008, at 11:34 AM, Akhtar Yasmin-B05532 wrote:
I am really stuck here. And need to get a way thru all of this.
Any suggestions will be really appreciated.
Have you confirmed that the user that you are logged in as when you
attempt to start Postgres has write access to
Hi,
I frequently query PG for between 10k - 65k rows of data and was
wondering if I should be considering usage of cursors.
I’m not too well versed with it’s purpose but based on the docs, it is
supposed to be more efficient and also gives the impression of
responsiveness.
Currently, when I do
2008/9/3 brian [EMAIL PROTECTED]
Fernando Moreno wrote:
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
The prefix is added by the mailing list software. It's there so that people
subscribed to multiple pgsql-*
On Thursday 04 September 2008 3:32:55 pm Christophe wrote:
On Sep 4, 2008, at 11:34 AM, Akhtar Yasmin-B05532 wrote:
I am really stuck here. And need to get a way thru all of this.
Any suggestions will be really appreciated.
Have you confirmed that the user that you are logged in as when you
On Wednesday 03 September 2008 09:17:54 Asko Oja wrote:
On Wed, Sep 3, 2008 at 5:56 AM, Robert Treat
[EMAIL PROTECTED]wrote:
On Tuesday 02 September 2008 17:21:12 Asko Oja wrote:
On Tue, Sep 2, 2008 at 2:09 AM, Michael Nolan [EMAIL PROTECTED] wrote:
Oracle handles connecting to
Hello everyone,
I am trying to run a silent install of Postgres 8.3 using the following command
line:
MSIEXEC /i postgresql-8.3-int.msi /qb /log c:\mydir\logfile.txt
ADDLOCAL=server,nls,psql,pgadmin,includefiles,libfiles,binfiles
INTERNALLAUNCH=1 DOSERVICE=1 CREATESERVICEUSER=0 DOINITDB=1
I'm running all 8.3. But I don't think it makes a difference. There is
some geometry type cube function but its not at all like the OLAP cube
that I'm talking about.
What version of Postgres are you running?
On Wed, Sep 3, 2008 at 10:21 PM, Artacus [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
So that is for real huh? I've been to that web site before and figured
it was more marketing talk about what they wanted to do rather than a
product that was already to market.
2008/9/4 Artacus [EMAIL PROTECTED]:
Oh, as I was writing a CUBE query today and realized that I forgot to
mention
That's just what I needed. Thanks guys!
Artacus
On Thu, Sep 04, 2008 at 02:07:01AM -0700, Artacus wrote:
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
Hi,
I 've finally been able to solve my problem.
There were two errors,
1) The postgres in the data directory had gotten overwritten, so none of the
scripts were running.
I found out this, when I tried making another instance of data.
The initdb was not working. As well asa other scipts.
Had to
Hi,
Please CC your replies to the list, too:
On Thu, 2008-09-04 at 12:20 -0430, Ricardo Antonio Yepez Jimenez wrote:
Gracias Devrim , ya instale la librería libxml2, pero sigue sin
funcional cuando ejecuto un select xmlelement, arroja el siguente
error
You need to rebuild PostgreSQL using
Hello,
We are using postgres for one of our application. Currently using
Postgres 8.3 with CentOS 5.3 x86_64
We are using inherited tables. Base table has 3 columns:
entry_date timestamp with time zone
nametext
valuetext
pk is timestamp
data tables are derived from this base table
43 matches
Mail list logo