Alain Roger wrote:
> 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)
> RETURN
Dhaval Shah wrote:
The optimization step I am looking for is as follows, instead of doing
a tar/gzip of the data directory, I am planning to do a pg_dumpall of
the primary. That is, the new steps will be:
0. Ensure that no application connects to the db.
1. On the primary, do a pg_dumpall
Tha
I am trying to put my database in recovery mode and I get the following error:
===
LOG: starting archive recovery
LOG: restore_command = "/myrestore/pg_restore.sh %f %p"
0001.history pg_xlog/RECOVERYHISTORY
[Main]: Server requested for 0001.history to be copied to
pg_xlog/RECOVE
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 refe
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?
http://
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 th
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]
hk.hku.cecid.piazza.commons.net.ConnectionException: Unable to connect to
i
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 i
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,
http://ftp.uni-koeln.de/mirrors/fedora/linux/
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?
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 TYP
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
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 : pg_start_backup('label
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 post
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?)
>
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
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
http://www.postgresql.org/docs/8.2/inte
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
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
-
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
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."
"ru_stem_koi8";"snb
On Mon, 2007-03-19 at 19:26 +0100, hubert depesz lubaczewski wrote:
> On 3/19/07, Martijn van Oosterhout 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 afte
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 8.
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
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
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 'en
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? ge
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 an
On 3/19/07, Martijn van Oosterhout 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 cannot fix the data,
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 mail
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? wh
(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 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
--
http://w
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 wa
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
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
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 ta
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 Postgr
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 mor
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" <[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
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 recor
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, 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
> >records in any on
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
---(en
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
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!
=-=-=-=
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 t
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
id
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
---
"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 bet
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 was
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
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 r
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 db
>-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:
>
>
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 pgsql-admin@pos
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
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$
DECLAR
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,
> a
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 connection
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 broadcast)---
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
> ((S
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 me
64 matches
Mail list logo
