am Tue, dem 14.10.2008, um 8:33:21 +0200 mailte Luca Ferrari folgendes:
> Hi all,
> I've got a query with a long (>50) list of ORs, like the following:
>
> SELECT colB, colC FROM table WHERE colA=X OR colA=Y OR colA=Z OR
>
> Is there any difference in how postgresql manages the above query
Hi all,
I've got a query with a long (>50) list of ORs, like the following:
SELECT colB, colC FROM table WHERE colA=X OR colA=Y OR colA=Z OR
Is there any difference in how postgresql manages the above query and the
following one?
SELECT colB, colC FROM table WHERE colA IN (X,Y,Z,...)
Whic
paulo matadr wrote:
I have 3 database in my cluster , and would make backup online just
one database ,atually i using pg_hotbackup
--backupdir=/var/lib/pgsql/backups --datadir=/var/lib/pgsql/data
but this command make a full backup in cluster.
All databases share the same write-ahead log fi
Hi Shane,
I'm trying to untangle some postgresql issues on OSX. I'm now using a
macport installation for postgresql 8.3.4 and I'm using my own custom
Portfile to configure the installation (hardly changed from the main
Portfile, really). Anyhow, the macport install creates a lauchdeamon config
t
On Mon, Oct 13, 2008 at 1:02 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> Anyway I don't find myself comfortable with replies in these 2 lines
> of reasoning:
> 1) default configuration of PostgreSQL generally doesn't perform well
> 2) PostgreSQL may be slower but mySQL may trash your da
There are a couple of ways to solve your problem
Heres my thoughts off the top of my head and what little i know about
auctions and how they are run. Also i hope the formating comes out.
please note these table do not contain all columns i would have in them
its just an idea of how i would g
Eric Haszlakiewicz <[EMAIL PROTECTED]> writes:
> I created this, which seems to solve the problem:
> create function casting_eq_operator(integer, "char")
>returns boolean as 'begin
> return $1 = cast ($2 as integer);
> end;' language plpgsql immutable strict;
> CREATE OPERATOR = (PROCEDU
I attended the PostgreSQL Conference West 2008 and had a great time again
this year. My photos of the event are up here:
http://db.endpoint.com/pg-conf-08
I also blogged about the event:
http://blog.endpoint.com/2008/10/postgresql-conference-west-2008-report.html
--
Daniel Browning
End Point C
Craig Bennett wrote:
If you want to take a particular system out to extra digits, it's
probably good to record the rounding error as a separate component of
the transaction (that is, if you want everything to balance out
perfectly).
I think you have two different problems here. On the one
Peter Eisentraut, April 1 2008
> Am Dienstag, 1. April 2008 schrieb rupesh:
> > ERROR: operator does not exist: numeric = character varying at character
> > 675
> > HINT: No operator matches the given name and argument type(s). You might
> > need to add explicit type casts.
> > (0.735 sec)
> >
>
If you want to take a particular system out to extra digits, it's
probably good to record the rounding error as a separate component of
the transaction (that is, if you want everything to balance out
perfectly).
I think you have two different problems here. On the one hand you have
rounding
CREATE PROCEDURE list_user_accounts(IN user_id INT)
BEGIN
-- Return first result set (single row)
SELECT * FROM users WHERE id = user_id;
-- Return second result set (zero or more rows)
SELECT * FROM accounts WHERE account_holder = user_id;
END
On Mon, Oct 13, 2008 at 8:56 PM, Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
>
> Maybe I'm going to revisit Postgresql again in 2009 or 2010 :)
good luck, we'll pray for your data to be safe with mysql. cos you can't
trust the thing without a good prayer.
one thing, all software works differe
Hi Merlin,
> Stored procedure support is a pretty complicated feature. They differ
> with functions in two major areas:
>
> *) input/output syntax. this is what you are dealing with
> *) manual transaction management. stored procedures should allow you
> emit 'BEGIN/COMMIT' and do things like
Great news. Thanks.
Hello,
We finally got around to releasing Replicator as FOSS. It is BSD
licensed and available here:
https://projects.commandprompt.com/public/replicator/wiki
(Yes it is a self signed cert, its on the list to fix).
Enjoy folks!
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 199
On Mon, Oct 13, 2008 at 6:33 AM, Gregory Stark <[EMAIL PROTECTED]> wrote:
> justin <[EMAIL PROTECTED]> writes:
>
>> special note do not use only 2 decimal points in the accounting tables. If
>> your application uses 10 decimal places somewhere then every table in the
>> database that has decimals
"Richard Broersma" <[EMAIL PROTECTED]> writes:
> On Mon, Oct 13, 2008 at 9:52 AM, Reg Me Please <[EMAIL PROTECTED]> wrote:
>> Is there a way to know how a NATURAL JOIN is actually done?
> Here is what the manual says about natural joins:
> http://www.postgresql.org/docs/8.3/interactive/queries-tab
On Mon, Oct 13, 2008 at 1:11 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Mon, Oct 13, 2008 at 9:29 AM, Matthew Wilson <[EMAIL PROTECTED]> wrote:
> I don't have the book in front of me at the moment, but I remember
> this exact problem and a unique solution using a schema redesign
> around
On Mon, Oct 13, 2008 at 9:29 AM, Matthew Wilson <[EMAIL PROTECTED]> wrote:
> Any advice? I wonder if this is a sign of a bad design, or maybe if
> there's some nicer SQL techniques I could use.
I don't have the book in front of me at the moment, but I remember
this exact problem and a unique sol
Thank you very much, Josh.
This worked. The backward slashes were the problem.
I had tried the quote part earlier, but even that did not work because of
the backward slashes.
Is there somewhere I can document this for other newbies facing the same
issue?
Again, thank you very much.
On Sun, Oct 1
On Mon, Oct 13, 2008 at 9:52 AM, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Is there a way to know how a NATURAL JOIN is actually done?
Here is what the manual says about natural joins:
http://www.postgresql.org/docs/8.3/interactive/queries-table-expressions.html#QUERIES-FROM
...
Finally, NATURA
Hi all.
I'm running v8.3.3
First point.
Is there a way to know how a NATURAL JOIN is actually done?
That is, which fields are actually used for the join?
The EXPLAIN directive doesn't show anyting useful.
Second point.
I have this:
CREATE TABLE tab_dictionary ( item text primary key );
CREATE
I track employee qualifications in one table and I track job
requirements in another table. A job requires zero-to-many
qualifications, and for an employee to be qualified for that job, the
employee must have ALL the requirements.
For example, In my job requirements table, I record that a nurse m
On Mon, Oct 13, 2008 at 8:09 AM, Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
>>> I came across a blog post of yours (
>>> http://okbob.blogspot.com/2007/11/stacked-recordset-multirecordset.html
>>> ) as well as several list posts indicating that multiple result sets
>>> might be in the working. S
On Mon, Oct 13, 2008 at 6:44 AM, Gregory Stark <[EMAIL PROTECTED]> wrote:
> How much memory the OS allows Postgres to allocate will depend on a lot of
> external factors. At a guess you had some other services or queries running at
> the same time the first time which reduced the available memory.
2008/10/13 arnuld uttre <[EMAIL PROTECTED]>:
>> On Mon, Oct 13, 2008 at 3:15 PM, Grzegorz Jaśkiewicz
>> <[EMAIL PROTECTED]> wrote:
>
>> what does your pg_hba.conf says ?
>
> # TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD
>
> # IPv4-style local connections:
> #hostall
I am curious as to the ability to update individual configurations
so lets say i want to change Apache maxRequests
MaxKeepAliveRequests 200
or possibly update the PHP module?
LoadModule php4_module "$APACHE_HOME/modules/php4apache2.dll"
OR staying on topic lets say i want to update postgres ma
John DeSoi wrote:
On Oct 13, 2008, at 5:08 AM, admin wrote:
However, PostgreSQL support in the PHP CMS world seems lacking. Joomla
is basically a MySQL-only shop. Drupal is *maybe* suitable, but who
really knows where it will end up?
My hope is that Drupal is moving in the right direction.
On Oct 13, 2008, at 5:08 AM, admin wrote:
However, PostgreSQL support in the PHP CMS world seems lacking.
Joomla is basically a MySQL-only shop. Drupal is *maybe* suitable,
but who really knows where it will end up?
My hope is that Drupal is moving in the right direction. With version
6
On Mon, 13 Oct 2008 16:48:33 +0300
Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
> It seems like the PHP PG binding does allow (?) retrieval of
> multiple result sets through pg_get_result(), but only for
> requests issued asynchronously:
> http://bg2.php.net/manual/en/function.pg-get-result.php
On Mon, Oct 13, 2008 at 8:19 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> There was a time when Microsoft was trying to cast IIS as faster than
> Apache, so they released a benchmark showing IIS being twice as fast
> as apache at delivering static pages. Let's say it was 10mS for
> apache and 2
On Mon, Oct 13, 2008 at 12:00 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> Alright, my benchmarks might have been a bit naïve.
> When it comes to hardware, my webserver is a SunFire X2100 with an Opteron
> 1210 Dual Core and 4 GB DDR2 RAM, running 64-bit Ubuntu Linux Server 8.04
> LTS.
>
> When it
Hi Ivan,
> It seems anyway that the usefulness of this feature largely depends
> on the language library.
> eg. I can't see a way to support it with php right now but it is
> supported by python.
> Am I missing something?
Yes, the client library will have to support multiple result sets too.
For
Gregory Stark wrote:
justin <[EMAIL PROTECTED]> writes:
special note do not use only 2 decimal points in the accounting tables. If
your application uses 10 decimal places somewhere then every table in the
database that has decimals needs to have the same precision. Nothing is more
annoyi
Hello
2008/10/13 Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> On Mon, 13 Oct 2008 15:19:33 +0300
> Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
>
>> Well, (in MySQL at least) in that case you're still going to get a
>> result set, it's just going to be an empty one (result with no
>> rows).
>
>>
On Oct 13, 2008, at 4:08 AM, admin wrote:
I am also evaluating Drupal + PostgreSQL at the moment. We are
building a local government website/intranet that doesn't need to be
lightning fast or handle millions of hits a day, but it does need to
be rock solid and potentially needs to manage c
On Mon, 13 Oct 2008 15:19:33 +0300
Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
> Well, (in MySQL at least) in that case you're still going to get a
> result set, it's just going to be an empty one (result with no
> rows).
> So, no matter how many rows the SELECT statements resolve to,
> you're
In response to "arnuld uttre" <[EMAIL PROTECTED]>:
> I see postgres has 3 password mechanism:
>
> 'createuser -d -P arnuld' -- which will ask for the password
> according to P flag used here.
> 'createuser -d -P -W arnuld' -- which will ask for the 2 passwords
> belonging to P and W flags
"arnuld uttre" <[EMAIL PROTECTED]> writes:
> I see postgres has 3 password mechanism:
> 'createuser -d -P arnuld' -- which will ask for the password
> according to P flag used here.
> 'createuser -d -P -W arnuld' -- which will ask for the 2 passwords
> belonging to P and W flags.
>
>> CREATE PROCEDURE list_user_accounts(IN user_id INT)
>>
>> BEGIN
>>
>> -- Return first result set (single row)
>> SELECT * FROM users WHERE id = user_id;
>>
>> -- Return second result set (zero or more rows)
>> SELECT * FROM accounts WHERE account_holder = user_id;
>>
>> I came across a blog post of yours (
>> http://okbob.blogspot.com/2007/11/stacked-recordset-multirecordset.html
>> ) as well as several list posts indicating that multiple result sets
>> might be in the working. Should I check the situation again when 8.4 is
>> released?
> I have only very raw
> On Mon, Oct 13, 2008 at 5:11 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> Well exactly that. What information is missing?
>
> There is a parameter on createdb command line
> (As well as CREATEDB command in SQL) which
> needs to be set to unicode.
yes my friend :) -E utf8
thanks
> Hint:
arnuld uttre wrote:
...
and I phpBB can connect to the DB now but with a new problem from
phoBB3:The database you have selected was not created in UNICODE
or UTF8 encoding. Try installing with a database in UNICODE or UTF8
encoding.
what to do about it ?
Well exactly that. What informatio
On Mon, 13 Oct 2008 12:17:21 +0300
Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
> CREATE PROCEDURE list_user_accounts(IN user_id INT)
>
> BEGIN
>
> -- Return first result set (single row)
> SELECT * FROM users WHERE id = user_id;
>
> -- Return second result set (zero or
> 2008/10/13 arnuld uttre <[EMAIL PROTECTED]>:
>> On Mon, Oct 13, 2008 at 3:15 PM, Grzegorz Jaśkiewicz
>> <[EMAIL PROTECTED]> wrote:
>
>> what does your pg_hba.conf says ?
> ..SNIP...
> local allall ident sameuser
okay, I have changed that line to:local allall trust
I see postgres has 3 password mechanism:
'createuser -d -P arnuld' -- which will ask for the password
according to P flag used here.
'createuser -d -P -W arnuld' -- which will ask for the 2 passwords
belonging to P and W flags.
It does not m
2008/10/13 Vladimir Dzhuvinov <[EMAIL PROTECTED]>:
>
>>> So, is it true that as of Postgresql 8.3 there is no way to have a
>>> pgpqsql function return multiple SELECTs?
>
>> it's true.
>
> Thank you for the definite answer, Pavel :)
>
> I came across a blog post of yours (
> http://okbob.blogspot.
On Fri, 10 Oct 2008, Pascal Cohen wrote:
Are there best practices to reduce the migration time ?
There's a number of resources in this area listed at
http://wiki.postgresql.org/wiki/Bulk_Loading_and_Restores
I wanted to have an expectation of the migration duration and performed it on
a le
"David Wilson" <[EMAIL PROTECTED]> writes:
> create index val_datestamp_idx on vals(datestamp) tablespace space2;
>
> About 30 seconds into the query, I get:
> ERROR: out of memory
> DETAIL: Failed on request of size 536870912.
>
> Increasing maintenance_work_mem from 1GB to 2GB changed nothing
On Mon, Oct 13, 2008 at 5:05 PM, Stuart Bishop <[EMAIL PROTECTED]> wrote:
> So what was the final recommended process for building a stand alone
> database from a pg_dump of a replicated node?
> So if I'm reading this thread correctly, the alternative is 'DROP _sl
> CASCADE;', which doesn't do a
On Fri, 10 Oct 2008, Bart Grantham wrote:
The Opterons are 2220 SE's, the Xeons are 5450's I think (family "15", model
"6").
Xeon - 3056 MB in 2.00 seconds = 1527.85 MB/sec
Opteron - 4944 MB in 2.00 seconds = 2472.50 MB/sec
There's something wrong with that Xeon system. That number should
>>> I'm setting us up a separate staging / test server and I want to read
>>> in a pg_dump of our current origin stripping out all the slony stuff.
>>>
>>> I was thinking this could serve two purposes a) test out backups
>>> restore properly and b) provide us with us with the staging / test
>>> ser
On Mon, Oct 13, 2008 at 11:57 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> In any case, if anyone has any tips, input, etc. on how best to configure
> PostgreSQL for Drupal, or can find a way to poke holes in my analysis, I
> would love to hear your insights :)
It'd be more accurate to configure
am Mon, dem 13.10.2008, um 11:34:03 +0200 mailte A. Kretschmer folgendes:
> or, simpler in plain sql:
>
> test=# create or replace function srf (OUT a int, OUT b int) returns setof
> record as $$select 1,2;select 1,3;$$language sql;
> CREATE FUNCTION
> test=*#
> test=*#
> test=*# select * from s
justin <[EMAIL PROTECTED]> writes:
> special note do not use only 2 decimal points in the accounting tables. If
> your application uses 10 decimal places somewhere then every table in the
> database that has decimals needs to have the same precision. Nothing is more
> annoying where a transactio
"Grzegorz Jaśkiewicz" <[EMAIL PROTECTED]> writes:
> that would be a type mismatch, heh.
prepare "select * from foo where a = any($1::int[])"
then pass "{1,2,3}"
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's
>> So, is it true that as of Postgresql 8.3 there is no way to have a
>> pgpqsql function return multiple SELECTs?
> it's true.
Thank you for the definite answer, Pavel :)
I came across a blog post of yours (
http://okbob.blogspot.com/2007/11/stacked-recordset-multirecordset.html
) as well as s
> On Mon, Oct 13, 2008 at 3:15 PM, Grzegorz Jaśkiewicz
> <[EMAIL PROTECTED]> wrote:
> what does your pg_hba.conf says ?
# TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD
# IPv4-style local connections:
#hostall all 127.0.0.1 255.255.255.255
what does your pg_hba.conf says ?
you sure you want to use 7.4 on new installations ? that's like - years
behind.
Hi,
According to the documentation (
http://www.postgresql.org/docs/8.3/interactive/sql-createtrigger.html
), the feaure "SQL allows triggers to fire on updates to specific
columns (e.g., AFTER UPDATE OF col1, col2)" is missing.
After a bit of research, I found that this feature was in the TODO
li
I created a new user and then a new DB with that user, where the user
is the owner:
-bash-3.00$ createuser -d -P
Enter name of user to add: arnuld
Enter password for new user:
Enter it again:
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
[EMAIL PROTECTED] ~]$ created
2008/10/13 Vladimir Dzhuvinov <[EMAIL PROTECTED]>:
> Hi,
>
> I've got a financial MySQL database where the application accesses data
> through a layer of stored procedures. For various reasons I'm currently
> investigating my options to migrate to another SQL RDBMS.
>
> Postgresql seems to offer a
am Mon, dem 13.10.2008, um 12:17:21 +0300 mailte Vladimir Dzhuvinov folgendes:
>
> However, after consulting the docs and running a few tests, it looks
> like Postgresql misses a crucial feature which my application depends
> upon - returning multiple SELECT result sets from functions/stored
> pr
On Mon, Oct 13, 2008 at 10:08 AM, admin <[EMAIL PROTECTED]> wrote:
> I am also evaluating Drupal + PostgreSQL at the moment. We are building a
> local government website/intranet that doesn't need to be lightning fast or
> handle millions of hits a day, but it does need to be rock solid and
> pote
Hi,
I've got a financial MySQL database where the application accesses data
through a layer of stored procedures. For various reasons I'm currently
investigating my options to migrate to another SQL RDBMS.
Postgresql seems to offer a few nice advantages over MySQL (e.g.
stricter data integrity th
I am also evaluating Drupal + PostgreSQL at the moment. We are building
a local government website/intranet that doesn't need to be lightning
fast or handle millions of hits a day, but it does need to be rock solid
and potentially needs to manage complex business processes. So
PostgreSQL seems
Robert Treat wrote:
>>> I have a table contains some duplicate records, and this table create
>>> without oids, for example:
>>> id | temp_id
>>> +-
>>> 10 | 1
>>> 10 | 1
>>> 10 | 1
>>> 20 | 4
>>> 20 | 4
>>> 30 | 5
>>> 30 | 5
>>> I want
Anton Andreev wrote:
> When I create a check constraint in PgAdmin3 1.8.4 on a Postgresql
> 8.3.3: ((A and B) or (C and D))
> I get with create script: (A and B or C and D) which is wrong.
No, it isn't - both are the same.
AND has higher operator precedence than OR, see
http://www.postgresql.org
On Sun, 12 Oct 2008 22:14:53 -0700
"Uwe C. Schroeder" <[EMAIL PROTECTED]> wrote:
> > I have been testing it a bit performance-wise, and the numbers
> > are worrying. In my test, MySQL (using InnoDB) had a 40% lead in
> > performance, but I'm unsure whether this is indicative for
> > PostgreSQL per
70 matches
Mail list logo
