I have been looking for such a function. Having Just upgraded to 8.2,
this function is a very welcome addition to my arsenal of tools.
Many thanks!
- Naz.
Reece Hart wrote:
On Sun, 2007-03-18 at 00:40 +0530, Mageshwaran wrote:
how to find the size of a particular database in
Jonathan Vanasco wrote:
hoping someone may be able to offer advice:.
SELECT
*
FROM
table_a
WHERE
id != 10001
AND
(
( field_1 ilike '123' )
OR
( field_2 ilike 'abc' )
)
You seem to use that ilike expression merely as a
Christian Schröder wrote:
Alain Roger wrote:
insert into immense.statususer (statususer_id, statususer_type) values
(SELECT nextval( 'statususer_statususer_id_seq' ),'customer');
The correct syntax would be:
insert into immense.statususer (statususer_id, statususer_type) values
((SELECT
Hi list,
Could someone tell me the experience of many connections to PostgreSQL ?
I am my afraid if when PostgreSQL have many connections (i.e: 1,000) it
could cost much for the solution.
Could someone tell me if my afraid is justifiable ?
---(end of
It depends on the amount of memory you have...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/19/07, Ezequias R. da Rocha [EMAIL PROTECTED] wrote:
Hi list,
Could someone tell me the experience of many connections to PostgreSQL ?
I am my afraid if when PostgreSQL have many connections
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Regards,
Ben
Btw, I personally find a payload/noise ratio of 1/6 atrocious,
and
Hi,
I would like to know if there is a better way how to retrieve result from a
stored procedure (function) than to use 'AS res(col1 varchar, col2
timestamp,..)'
for example, here is a stored procedure :
CREATE OR REPLACE FUNCTION SP_A_003(username VARCHAR)
RETURNS SETOF RECORD AS
$BODY$
On Mon, Mar 19, 2007 at 01:54:14PM +0100, Alain Roger wrote:
Hi,
I would like to know if there is a better way how to retrieve result from a
stored procedure (function) than to use 'AS res(col1 varchar, col2
timestamp,..)'
Sure, create a type with the relevent field name and use that in you
Ben Trewern wrote:
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Perhaps the OP's posit should have been sent to
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Naz Gassiep
Sent: zondag 18 maart 2007 14:45
To: Naz Gassiep
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Design / Implementation problem
Here it is again with more sensible wrapping:
*** The
Hi all,
I participate on realization of warm standby pg 8.2.3, according to
documentation. Mostly all works fine, but one problem remains. The
recovering rdbms eats transfered wal logs fluently, but I cannot see the
way how to recognize if the recovered wal log file is really processed
into
On 3/19/07, Jan Poslusny [EMAIL PROTECTED] wrote:
Hi all,
I participate on realization of warm standby pg 8.2.3, according to
documentation. Mostly all works fine, but one problem remains. The
recovering rdbms eats transfered wal logs fluently, but I cannot see the
way how to recognize if the
hmmm. just a general notice:
A customer loyalty program, which expires earned points, not to let
the customer win anything valuable?
If I were your client, I wouldn't be happy with this.
2007/3/18, Naz Gassiep [EMAIL PROTECTED]:
We are running a customer loyalty program whereby customers
Hello,
I'm using 8.1.8, and I have a situation where a record in one table is
only meaningful when it is referenced via foreign key by one or more
records in any one of several tables.
So, really what I want is when one of the referring records is deleted,
to have a trigger check to see if it
Filip Rembiałkowski [EMAIL PROTECTED] writes:
hmmm. just a general notice:
A customer loyalty program, which expires earned points, not to let
the customer win anything valuable?
If I were your client, I wouldn't be happy with this.
On the other hand, having the possibility is better than
Margaret Gillon offered the following kind support:
We had to run a special utility from Windows...
I will email instructions our admin put together...
Hi Margaret,
I heard from my client this morning and that did the trick!
Thanks again for you help,
Regards,
George
create a function lower index and instead of calling ilike call ~
lower('123')
To clarify a little:
CREATE INDEX table_a_lower_field_1_idx on table_a ((lower(field_1)));
CREATE INDEX table_a_lower_field_2_idx on table_a ((lower(field_2)));
SELECT
*
FROM
table_a
WHERE
I have a query here for which postgres chooses a nested loop, for which
it takes ~19s to complete in the worst-case (measured). However, if I
disable nestloops it completes in ~400ms...
It seems pretty obvious that the planner underestimates the cost of
nestloops here, is there some way to tweak
Does anyone here run Pg on a SurfRAID Triton RAID array? If so,
please let me know how satisfied you are with the performance, and
what kind of performance you get (operations/second, data transfer/
second, etc.)
I'm looking at their fibre attached 16 sata disk solution.
Thanks!
Alban Hertroys wrote:
I have a query here for which postgres chooses a nested loop, for which
it takes ~19s to complete in the worst-case (measured). However, if I
disable nestloops it completes in ~400ms...
It seems pretty obvious that the planner underestimates the cost of
nestloops here,
On 3/19/07, Glen W. Mabey [EMAIL PROTECTED] wrote:
But, really, I just want to be able to test to see how many references
there are to a key. Is there some way to do that?
write a triggers which do that.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
---(end
On Fri, 2007-03-16 at 21:30 -0400, Tom Lane wrote:
Jeff Davis [EMAIL PROTECTED] writes:
The planner chooses what looks to me like a very strange plan for this
query:
Exactly which PG version is this?
= select version();
version
On Mon, 19 Mar 2007, Glen W. Mabey wrote:
Hello,
I'm using 8.1.8, and I have a situation where a record in one table is
only meaningful when it is referenced via foreign key by one or more
records in any one of several tables.
So, really what I want is when one of the referring records is
Glen W. Mabey [EMAIL PROTECTED] writes:
What I'm hoping to find out is whether there is some way to directly
find out how many (using a SELECT query) references there are to a key.
There's no hidden shortcut for that, no.
regards, tom lane
Hello
I want to install Bugzilla on our intranet. I don't want to install MySQL
just because of a bug tracking system so I was quite pleased to read that
Bugzilla has declared full support for PostgreSQL. Yet I was unable to find
the module that would make PostgreSQL 8.x work with Perl (which is
Glen W. Mabey wrote:
On Mon, Mar 19, 2007 at 04:51:57PM +0100, hubert depesz lubaczewski wrote:
On 3/19/07, Glen W. Mabey [EMAIL PROTECTED] wrote:
I'm using 8.1.8, and I have a situation where a record in one table
is
only meaningful when it is referenced via foreign key by one or more
Jaroslav Záruba wrote:
Hello
I want to install Bugzilla on our intranet. I don't want to install MySQL
just because of a bug tracking system so I was quite pleased to read that
Bugzilla has declared full support for PostgreSQL. Yet I was unable to find
the module that would make PostgreSQL
On 3/19/07, Glen W. Mabey [EMAIL PROTECTED] wrote:
write a triggers which do that.
I understand that a trigger should be written, and I have already
implemented two such triggers, as described above.
no, i think i didn't make myself clear.
let's use this situation:
we have tables:
create
Joshua D. Drake wrote:
Jaroslav Záruba wrote:
Hello
I want to install Bugzilla on our intranet. I don't want to install MySQL
just because of a bug tracking system so I was quite pleased to read that
Bugzilla has declared full support for PostgreSQL. Yet I was unable to find
the module that
Alban Hertroys [EMAIL PROTECTED] writes:
It seems pretty obvious that the planner underestimates the cost of
nestloops here, is there some way to tweak this?
The real problem is the factor-of-a-thousand underestimate of the size
of this join:
- Nested Loop (cost=0.00..281.74 rows=2
On Fri, 2007-03-16 at 20:19 +0100, Kacper Chrapa wrote:
Hi !
Is it possible in postgres to define own message for some constraint?
Example:
If i create check constraint on zip_code column , i want to get
a message: Zip code is invalid.Please,input code in format: nn-nnn
and I want to
On 3/19/07, Jeff Davis [EMAIL PROTECTED] wrote:
You can use an AFTER trigger instead of a CHECK constraint (but that may
have a performance impact - test for your application).
are you sure you meant AFTER? why? generally data-checks should be in
before triggers. i guess.
depesz
--
(list re-added)
you need a timezone directory, not just timezonesets. So your problem is
why that's not being installed when you do make install. You need to
check the output from the make install command to see if there are any
errors or warnings related to that. (It's done when make install
On Mon, Mar 19, 2007 at 07:08:41PM +0100, hubert depesz lubaczewski wrote:
On 3/19/07, Jeff Davis [EMAIL PROTECTED] wrote:
You can use an AFTER trigger instead of a CHECK constraint (but that may
have a performance impact - test for your application).
are you sure you meant AFTER? why?
On 3/20/07, Ben Trewern [EMAIL PROTECTED] wrote:
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Maybe use a gmail account for
On 3/19/07, Martijn van Oosterhout kleptog@svana.org wrote:
In an AFTER trigger you can be sure you're seeing what actually got
inserted. In a BEFORE trigger other triggers after you could still
modify the data...
yes but in after trigger the only thing you can do is to raise
exception. you
Jeff Davis [EMAIL PROTECTED] writes:
I have two indexes defined on syslog_p:
syslog_p_severity_ts_idx btree (severity, ts)
syslog_p_ts_where_severity_1_idx btree (ts) WHERE severity = 1
The planner chooses what looks to me like a very strange plan for this
query:
= explain analyze select *
On Mon, 2007-03-19 at 19:08 +0100, hubert depesz lubaczewski wrote:
On 3/19/07, Jeff Davis [EMAIL PROTECTED] wrote:
You can use an AFTER trigger instead of a CHECK constraint (but that may
have a performance impact - test for your application).
are you sure you meant AFTER? why? generally
Hi,
I am having some problems with TSearch2 queries since upgrading from 8.0
to 8.2.
This is the query:
select count(*) from card, to_tsquery('default','test') as q where
(q @@ card.fts);
This works fine on 8.0 but gives the following error in 8.2:
ERROR: No dictionary with name
On Mon, Mar 19, 2007 at 09:46:22AM -0700, Stephan Szabo wrote:
On Mon, 19 Mar 2007, Glen W. Mabey wrote:
Hello,
I'm using 8.1.8, and I have a situation where a record in one table is
only meaningful when it is referenced via foreign key by one or more
records in any one of several
On Mon, 2007-03-19 at 14:31 -0400, Tom Lane wrote:
Jeff Davis [EMAIL PROTECTED] writes:
I have two indexes defined on syslog_p:
syslog_p_severity_ts_idx btree (severity, ts)
syslog_p_ts_where_severity_1_idx btree (ts) WHERE severity = 1
The planner chooses what looks to me like a very
On Mon, 19 Mar 2007, Howard Cole wrote:
Hi,
I am having some problems with TSearch2 queries since upgrading from 8.0 to
8.2.
This is the query:
select count(*) from card, to_tsquery('default','test') as q where (q @@
card.fts);
This works fine on 8.0 but gives the following error in
On Mon, 2007-03-19 at 19:26 +0100, hubert depesz lubaczewski wrote:
On 3/19/07, Martijn van Oosterhout kleptog@svana.org wrote:
In an AFTER trigger you can be sure you're seeing what actually got
inserted. In a BEFORE trigger other triggers after you could still
modify the data...
yes
show us output of select * from pg_ts_dict;
simple;dex_init(internal);;dex_lexize(internal,internal,integer);Simple
example of dictionary.
en_stem;snb_en_init(internal);contrib/english.stop;snb_lexize(internal,internal,integer);English
Stemmer. Snowball.
Oleg,
My problem may have been solved by doing a vacuum full analyse. I
shall check tomorrow and get back to you.
Thanks,
Howard.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Jeff Davis [EMAIL PROTECTED] writes:
What about your patch is a crude hack, by the way? At first glance it
looks like you're using a more correct test.
The surrounding code and comments would need to be changed to reflect
what's going on.
regards, tom lane
On Mon, 2007-03-19 at 11:12 -0500, Glen W. Mabey wrote:
What I'm hoping to find out is whether there is some way to directly
find out how many (using a SELECT query) references there are to a
key.
In the easy case when your schema doesn't change often, you can just
hard code a query of the FK
On Mon, 2007-03-19 at 13:03 -0700, Reece Hart wrote:
The harder and more general case is to build such a query dynamically
from pg_depends
...
See the pg_depends documentation at
Apologies. I intended to write pg_constraint and the documentation at
So what's he meant to do?
Avoiding terms like UPGRADATION would be an excellent start.
Stuart.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Andrej Ricnik-Bay wrote:
On 3/20/07, Ben Trewern [EMAIL PROTECTED] wrote:
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Maybe
Mageshwaran wrote:
Hi,
In our company there are many postgres servers in 7.X version,we are in
the process of upgrading to 8.1 version, can anyone tell me the
method to do this upgradation.
You will want to use the 8.1 version of pg_dump/pg_dumpall to connect to
the 7.4 version of
I was planning to setup a warm standby using WAL Files and my current
setup seems to work.
Here is what I do in the current setup
On the primary:
1. On the primary, setup continuous archive every 2 minutes. The WAL
files are stored on a known location.
2. On the primary :
Hello,
We are planning a PostgreSQL party for the weekend before OSCON in
Portland Oregon. The 22nd is a Sunday, with OSCON beginning on the 23rd
which is Monday. Although the exact venue has not been decided it will
likely be a hotel near the convention center.
We are also reaching out to other
Hello all, I'm new in PostgreSQL...
I would want to know like PostgreSQL manages the type reference that defines
the standard SQL:1999. I want to define the type of attribute like a
reference at other type.
For example, in Oracle8i the definition is:
-- Type Department
CREATE OR REPLACE
To respond to Alvaro's post, I did try setting TZ=PST, no luck there.
As Magnus points out, the install doesn't appear complete because of
the missing timezone dir.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Thanks for responding Magnus.
I did reinstall both msys and mingw, as well as blow away the source
and start over from scratch. Maybe there is a stray file or directory
that's not getting deleted on the clean. Also, does clean just clean
up the compile environment, or does it also clean up the
Hello!! I am working with hermes 2 postgresql and I obtain this mistake I am
thinking this mistake is because it not conect very well. Can someone help me??
thanks very mach 2007-03-15 11:02:51 [Thread-6] ERROR cecid.ebms.spa
Error in collecting message from mail
I am trying to measure the time taken for a number of queries using
\timing .
All queries on my table other than the first one are pretty fast. This
is likely due to caching. Is there any way to clear the internal cache
of Postgres. Should I be worried about the entire OS cache also?
Appreciate
Sorry, but I can't seen anything postgres related in
those errors messages, all seems to point at e-Mail
issues, not database connectivity.
Cheers,
Andrej
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On Mon, 2007-03-19 at 11:30 +0100, Elena wrote:
Hello all, I'm new in PostgreSQL...
I would want to know like PostgreSQL manages the type reference that
defines the standard SQL:1999. I want to define the type of attribute
like a reference at other type.
PostgreSQL doesn't allow
On 3/18/07, Bob Hartung [EMAIL PROTECTED] wrote:
Hi all,
I have been struggling with phpPgAdmin 4.1 - login failures. There
does not yet seem to be a fix. Where can I find a prior version for FC6
- rpm, tar.gz etc.
Thanks,
Bob
Try this one,
61 matches
Mail list logo