Hi Craig,
Do you mean that you use the postgresql role system as authentication
and authorization mechanism in your app through hibernate?
I don't understand how that should work. How do you authenticate?
As far as i know, the way to achieve what you want is through an
authorization layer on top
Hi all - I'd like some advice on how to write a rather complicated (for me,
anyway) query and if there's any nifty Postgres features I can take
advantage of in this situation. Imagine a database, if you will, used to
store recipes. I have a recipes table:
RecipeId
RecipeTitle
RecipeRating
And
Dear All
I have 2 table :
1. hotel_pbx_country
2. hotel_pbx_area
Country is one2many to area
Area have a field called prefx
The prefx field is auto filled by country.code and area.code
and for that purpose, i created trigger and function
Trigger-
CREATE TRIGGER
2009/12/16 Bino Oetomo b...@indoakses-online.com:
Dear All
I have 2 table :
1. hotel_pbx_country
2. hotel_pbx_area
Country is one2many to area
Area have a field called prefx
The prefx field is auto filled by country.code and area.code
and for that purpose, i created trigger and function
Dear Mr. Stehule
Thankyou for your super prompt (came to my mailbox less then 2 minutes
since my post) enlightment.
I'll try it
Sincerely
-bino-
Pavel Stehule wrote:
Hello
NULL and any is NULL. So you have to use coalesce function.
like
NEW.prefix = ctrcode || coalesce(NEW.code, '');
Awesome, I'll give this a shot.. Blacklist.UserId will be indexed and all
the recipe links are of course already indexed, but I'll run it under the
query analyzer to see if there's any other fine tuning needed. I appreciate
your help!
Mike
On Wed, Dec 16, 2009 at 1:27 AM, Timo Klecker
Hi Mike,
here is an untested weird nested query for your problem:
SELECT * FROM Recipes r where lower(RecipeTitle) like lower('%pasta%')
and not exists
(select 1 from ingredients inner join blacklist using (IngredientId) where
RecipeId = r.RecipeId and blacklist.UserId = 123 limit 1);
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should look
at? Or if there
* Craig Ringer:
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
The solution to the problem seemed to be to change the value for the
wal_sync_method setting to fsync_writethrough from the default of fsync.
I was curious if there were perhaps any other reasons that we should
On 16/12/2009 5:06 PM, Willy-Bas Loos wrote:
Do you mean that you use the postgresql role system as authentication
and authorization mechanism in your app through hibernate?
Correct.
Actually I make a plain 'ol JDBC connection with the user-supplied
credentials to test the user's auth and
On 16/12/2009 6:41 PM, Florian Weimer wrote:
* Craig Ringer:
When you're dealing with end users who have machines running
god-knows-what kinds of awful hardware drivers
Even Mac OS X? There should be less variety.
Of disk and other critical drivers, sure.
There is, however, a huge variety
Hello Craig - thanks for the reply. I will reply below.
On Tue, Dec 15, 2009 at 9:34 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 16/12/2009 6:39 AM, Michael Clark wrote:
Hello all,
Over the past 6 months or so I have posted to the list a couple times
looking for information
Hi Scott and Craig,
On Tue, Dec 15, 2009 at 9:45 PM, Craig Ringer
cr...@postnewspapers.com.auwrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to
Greg Smith wrote:
Howard Cole wrote:
Postgres comes out on top for most of the benchmarks against MySQL
and SQL Server, in fact in the authors original article he goes as
far as recommending using Postgres. More interestingly, the article
seems to indicate that W2K8 server is faster for
Phoenix Kiula wrote:
On Tue, Dec 15, 2009 at 9:26 PM, Howard Cole howardn...@selestial.com wrote:
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-8 stuff.
I tried
Hi Greg, thanks for the reply!
On Tue, Dec 15, 2009 at 10:52 PM, Greg Smith g...@2ndquadrant.com wrote:
Michael Clark wrote:
Secondly, I ask about an alternative solution to the corruption problem
because with preliminary testing we have seen a significant degradation in
performance. So
Dear all -
How can we check when a procedure last modified or last
DDL change happened to a table in postgres? Which Pg_* do we need to query
to get the details
Regards
On Wed, Dec 16, 2009 at 5:41 AM, Florian Weimer fwei...@bfk.de wrote:
* Craig Ringer:
On 16/12/2009 3:54 PM, Florian Weimer wrote:
* Michael Clark:
and with no power protection, then I expect it does. Add laptop
users with ageing/flakey batteries, laptops let go flat after they
go
2009/12/16 akp geek akpg...@gmail.com:
Dear all -
How can we check when a procedure last modified or last
DDL change happened to a table in postgres? Which Pg_* do we need to query
to get the details
Regards
Maybe follow this line of thinking:
On Wed, Dec 16, 2009 at 6:05 AM, Howard Cole howardn...@selestial.com wrote:
Better still, just fix using Iconv then import the clean data into
8.3 or 8.4
FWIW, If I was going to make a choice between 8.3 and 8.4, I would
choose 8.4. It looks like the future 8.5 release will be able to
On Wed, Dec 16, 2009 at 12:47:36AM -0800, Mike Christensen wrote:
When the user searches for a new pasta dish, the UI would generate a query
something like this:
SELECT * FROM Recipes where RecipeTitle ilike '%pasta%';
I only need the data from the recipes table since I display a summary
Thanks.. Will try that one
Regards
On Wed, Dec 16, 2009 at 9:29 AM, Brian Modra epai...@googlemail.com wrote:
2009/12/16 akp geek akpg...@gmail.com:
Dear all -
How can we check when a procedure last modified or
last
DDL change happened to a table in postgres? Which
On 16/12/2009 15:01, Richard Broersma wrote:
It looks like the future 8.5 release will be able to
preform an in-place upgrade on 8.4.
Really? That would be *wonderful*. I know it's impossible to be
definitive, but how likely would you say this is?
Ray.
--
Raymond O'Donnell :: Galway ::
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is try to push
the system into hibernation instead of going down hard. That *should*
clear any disk caches as part of the graceful shutdown. But
Raymond O'Donnell r...@iol.ie writes:
On 16/12/2009 15:01, Richard Broersma wrote:
It looks like the future 8.5 release will be able to
preform an in-place upgrade on 8.4.
Really? That would be *wonderful*. I know it's impossible to be
definitive, but how likely would you say this is?
It's
hm. I wonder if this is confusion between value/reference datums. Can
you do a quick check to see exactly where it's crashing (either before
you get into the function, at the getarg, or in the return)?
you can elog(WARNING, msg) to print out debug info from inside the
function.
merlin
It's
I have a very similar case, I am using erlang with postgres.
I began a transaction then make an insertion and then I got the error
ERROR: current transaction is aborted, commands ignored until end of
transaction block when i try any other query.
When i added the rollback line, It gave me another
Hello,
Thank you all for your advice. It has been helpful to read you.
I think we will be looking into open source data integration as it seems to
be the most flexible option in regards to our business.
A question: what are the assistance and training capabilities open source
software gives
I have a very similar case, I am using erlang with postgres.
I began a transaction then make an insertion and then I got the error
ERROR: current transaction is aborted, commands ignored until end of
transaction block when i try any other query.
When i added the rollback line, It gave me another
I have a table with column of character varying(100). There are about
150.000.000 rows in a table. Index was created as
CREATE INDEX idx_stringv
ON bn_stringvalue
USING btree
(lower(value::text));
I'm trying to execute queries like 'select * from stringvalue where
value=lower(?)'. Making
show us explain select *
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Dec 16, 2009 at 04:56:16AM -0800, yuliada wrote:
I have a table with column of character varying(100). There are about
150.000.000 rows in a table. Index was created as
CREATE INDEX idx_stringv
ON bn_stringvalue
USING btree
(lower(value::text));
I'm trying to execute
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is try to push the
system into hibernation instead of going down hard. That
jackassplus jackassp...@gmail.com :
I'm just using squirrel to
Sure!
But it's bad.
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
+261 34 29 155 34 / +261 33 11 207 36
--
Sent via pgsql-general mailing list
Michael Clark wrote:
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com
mailto:g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing. The best you can do is
On Wed, Dec 16, 2009 at 2:05 PM, Greg Smith g...@2ndquadrant.com wrote:
Michael Clark wrote:
On Wed, Dec 16, 2009 at 11:25 AM, Greg Smith g...@2ndquadrant.com wrote:
Florian Weimer wrote:
I hope that Mac OS X turns off write caches on low battery.
I've never heard of such a thing.
Hello,
I need a long text form from a file in my plpgsql variable.
Can anyone think of a more straightforward way to read the file than
the following:
CREATE FUNCTION test() RETURNS void AS
$BODY$
DECLARE
mytxt text;
BEGIN
CREATE TEMP TABLE x (x text);
COPY x from
All,
I've been installing postgres from source on os x for years, but I haven't
generally run 'make check' before I install. I don't feel that running 'make
check' is terribly necessary in this case - it's a personal sandbox on my
laptop, with no production value. Regardless, I realize that
Bucardo is released under the BSD license (see htt://bucardo.org for more
details). It's actively developed, and we at End Point have found it very
useful and reliable. But we wrote it :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
On Tue, Dec 15, 2009 at 03:05:34PM
Hi Everyone:
Tomorrow, I will need to present to a group of managers (who know nothing about
DBs) why I chose to use PG over MySQL in a project, MySQL being the more
popular DB choice with other engineers, and managers fearing things that are
different (risk). I have a few hard tecnical
Hello Tim,
Thanks for the reply! I'm still not sure why it's bad to have named
subroutines. At any rate I cant use anon subs since we have a complicated
reporting subsystem that relies on Perl formulas being eval-ed at runtime,
and these refer to various subroutines.
I have since resolved the
Tim Hart tjh...@me.com writes:
creating template1 database in
/Users/thart/projects/pgsql/src/test/regress/./tmp_check/data/base/1 ...
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=1, size=1613824, 03600).
HINT: This error
Managers want support, they can't live without. Every piece of
software has its flaws and needs patches. PostgreSQL is supported for
5 years, the latest version (8.4) will be supported at least until
2014. In total there are 6 supported version as we speak, 7.4 - 8.4.
MySQL has active
Gauthier, Dave wrote on 16.12.2009 22:02:
Hi Everyone:
Tomorrow, I will need to present to a group of managers (who know
nothing about DBs) why I chose to use PG over MySQL in a project,
What kind of project is that?
If you are developing something that you are selling to other people,
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
The main thing I intended to put into such an update when I get to it is
talking about
hello
look on orafce from pgfoundry. There modul utl_file
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#UTL_FILE
Regards
Pavel Stehule
2009/12/16 Erwin Brandstetter brsaw...@gmail.com:
Hello,
I need a long text form from a file in my plpgsql variable.
Can anyone
Greg Smith wrote on 16.12.2009 22:44:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
There is an update:
Thomas Kellerer wrote:
Greg Smith wrote on 16.12.2009 22:44:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
There is an update:
On Wed, Dec 16, 2009 at 03:15:21PM -0600, Peter wrote:
Hello Tim,
Thanks for the reply! I'm still not sure why it's bad to have named
subroutines. At any rate I cant use anon subs since we have a complicated
reporting subsystem that relies on Perl formulas being eval-ed at runtime,
and
On Dec 16, 2009, at 3:16 PM, Tom Lane wrote:
Were you running a live PG instance on the box at the same time? OS X's
default SHMMAX is small enough that PG will eat all of it by default,
meaning that attempting to start a second postmaster on the box will
fail.
Yeah - I was.
I stopped my
On 12/16/2009 3:15 PM, Peter wrote:
Hello Tim,
Thanks for the reply! I'm still not sure why it's bad to have named
subroutines. At any rate I cant use anon subs since we have a complicated
reporting subsystem that relies on Perl formulas being eval-ed at runtime,
and these refer to various
Greg Smith g...@2ndquadrant.com writes:
They do have a regression test suite:
http://dev.mysql.com/doc/refman/5.0/en/mysql-test-suite.html
But it's not really clear that they run it on every platform, i.e.
http://ourdelta.org/hidden-tests-of-the-mysql-testsuite
They definitely don't run
On mån, 2009-12-14 at 09:27 -0500, Tom Lane wrote:
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
Thanks! The queries I wrote in my email were just an example, my actual
implementation specifies all column names required and also uses full text
search. I just didn't want to paste in that much cruft :)
I'll do some tests with your technique below and see which works better..
Mike
On Wed,
On mån, 2009-12-14 at 16:58 +0100, Philippe Lang wrote:
My idea was to parse the functions definitions in order to build
dependencies between the functions. I'm not sure how difficult it is,
especially with overloaded functions, which require more than a simple
pattern search inside the
On Wed, Dec 16, 2009 at 2:44 PM, Greg Smith g...@2ndquadrant.com wrote:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
The main thing
On Dec 16, 2009, at 3:05 PM, Scott Marlowe wrote:
On Wed, Dec 16, 2009 at 2:44 PM, Greg Smith g...@2ndquadrant.com wrote:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this
My schema uses table inheritance. I was presenting records to the UI
for insert/update by a defined view
CREATE VIEW monster AS SELECT * FROM
parent_table NATURAL LEFT JOIN child1 NATURAL LEFT JOIN.
Inserts and updates from the UI were to monster, which then used RULEs
to redirect the query
On Dec 16, 10:47 pm, pavel.steh...@gmail.com (Pavel Stehule) wrote:
hello
look on orafce from pgfoundry. There modul utl_file
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#UTL_FILE
Thanks Pavel, that should do the trick.
I assume then, there is no easier built-in way in
EnterpriseDB wrote a white paper called PostgreSQL vs. MySQL: A
Comparison of Enterprise Suitability, which is fairly accessible:
http://downloads.enterprisedb.com/whitepapers/White_Paper_PostgreSQL_MySQL.pdf
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list
Hi,
If we have clients that are going to buy new computers or upgrade
current ones, what we can recommend to them for optimal system
performance to run Postgres. These can be servers or desktop PCs. We
can have from 1-10 users in at a time. At this point all of our
database's are small but
Greetings! I am trying to avoid the old problem of inserting a 40
character string into a 20 character field. However, I'd like to avoid
hard-coding the acceptable length (20). Is there a way to say cast to
the same type as a given column? E.g., if I have tables Long and
Short:
CREATE TABLE
Greetings! I am trying to avoid the old problem of inserting a 40
character string into a 20 character field. However, I'd like to avoid
hard-coding the acceptable length (20). Is there a way to say cast to
the same type as a given column? E.g., if I have tables Long and
Short:
CREATE TABLE Long
On 17/12/2009 7:21 AM, Christine Penner wrote:
Hi,
If we have clients that are going to buy new computers or upgrade
current ones, what we can recommend to them for optimal system
performance to run Postgres. These can be servers or desktop PCs. We can
have from 1-10 users in at a time. At this
Sam Mason wrote:
Wouldn't this be lower(value) = lower(?) ?
Yes, I use it as lower(value) = lower(?), I typed inaccurate example.
Sam Mason wrote:
So each query is taking approx 300ms? How much data does each one
return?
No more than 1000 rows.
Sam Mason wrote:
How about
If I search for something which is not in db like 'dfsgsdfgsdfgdsfg' it
always work fast. I suspect that speed depends on number of rows retruned,
but I don't know exactly...
--
View this message in context:
http://old.nabble.com/Slow-select-tp26810673p26821859.html
Sent from the PostgreSQL -
Justin Bailey jgbai...@gmail.com writes:
I have tried using the PL/PGSQL
feature where types can be copied in a declaration:
DECLARE
myVal Short.shortCol%TYPE;
But I can still put values which are too long into that variable, so
it doesn't help me.
Really? Works for me, in
2009/12/17 Erwin Brandstetter brsaw...@gmail.com:
On Dec 16, 10:47 pm, pavel.steh...@gmail.com (Pavel Stehule) wrote:
hello
look on orafce from pgfoundry. There modul utl_file
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#UTL_FILE
Thanks Pavel, that should do the trick.
I am newbee for Bucardo.
Whenever i am trying to add database or try to look into show all command. It
shows me following error.
Connecting to database 'bucardo' as user 'bucardo'
DBI
connect('dbname=bucardo;port=5433','bucardo',...) failed: FATAL:
password authentication failed for user
In response to Sam Jas :
I am newbee for Bucardo.
Whenever i am trying to add database or try to look into show all command.
It shows me following error.
Connecting to database 'bucardo' as user 'bucardo'
DBI connect('dbname=bucardo;port=5433','bucardo',...) failed:
On 17/12/2009 5:02 AM, Gauthier, Dave wrote:
Hi Everyone:
Tomorrow, I will need to present to a group of managers (who know
nothing about DBs) why I chose to use PG over MySQL in a project, MySQL
being the more popular DB choice with other engineers, and managers
fearing things that are
yes. I have an entry in pg_hba.conf file as well I have made entry in .pgpass
also.
Thanks
Sam Jas
--- On Thu, 17/12/09, A. Kretschmer andreas.kretsch...@schollglas.com wrote:
From: A. Kretschmer andreas.kretsch...@schollglas.com
Subject: Re: [GENERAL] Fw: password authentication failed
To:
Quick question about the following statement:
but no multi-master is on the horizion
From what I understand, there's several multi-master solutions such as
Bucardo, rubyrep, PgPool and PgPool II, PgCluster and Sequoia. Also
Postgres-R, which is still in development. Perhaps you just meant
73 matches
Mail list logo
