le nobody else has either. It's a PostgreSQL
> > extension, so people arriving from outside don't even know it exists,
>
> Say again? Both the SCROLL option to DECLARE CURSOR and FETCH PRIOR are
> straight out of the SQL92 spec.
>
i think Simon is talking about DISTI
; Example - field employeeName in table Employees
postgres converts all your uppercase in object names to lowercase...
if you really want mixed case you must put the name in quotes.
Try with:
ALTER TABLE "Employees" ADD CONSTRAINT employeenametest
CHECK (employeename != 'Ke
tp://archives.postgresql.org/pgsql-bugs/2008-06/msg00175.php
if you can compile postgres from sources you can apply the fix Tom
shows. If not you have to wait for 8.3.4.
Is not time for a new minor release?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de s
o confusions about the order
of columns in INSERT statements, eventually you will be forced to put
column names in every INSERT statement (ie: if you start to work in an
enterprise with an already implemented postgres database)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de Postg
nd this??
>
ah? from where do you download it? are you sure it's not asking you to
*assign* a password for the postgres database user?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via p
On Mon, Mar 2, 2009 at 12:21 PM, Tom Lane wrote:
>
> Before considering complicating the definition of lastval, I'd vote
> for removing it entirely. It's a foot-gun and will never be anything
> but.
>
+1
--
Atentamente,
Jaime Casanova
Soporte y capacitación
the error message? a little test case would be useful
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscripti
BLE ... TYPE.
now, back to the problem... is not easier to define a column as TEXT
and to put a check to constraint the length? if you wanna change the
constraint that will be almost free
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaq
D CHECK (length(column) =
a_value) as many times as you want without the need for a table
rewrite
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.
t into t values (0,'30 days'), (1,'1 month');
>> INSERT 0 2
>> test-std=# select * from t as a, t as b where a.i=b.i;
>
> Reproducible in 8.2.13 as well ..
>
and the same in HEAD
PS: the analyze not always brings the problems, i had to turn off
enable_merge
On Tue, May 12, 2009 at 11:57 AM, Rodrigo Peres Chapelin
wrote:
> Hi,
>
> can i install Postgresql 8.2.3 on Red Hat 5 64 bits?
>
is this a bug of some kind?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil -
ld have been specified that way...
i say pay the price for WITH HOLD and SCROLL and don't allow scrolling
ability if SCROLL hasn't been specified
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +5938717115
a problem that looks a lot like the
one you reported here...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your sub
bug
happen)?
>
> Also, we are not able to login to the database with PgAdmin, getting same
> error “out of shared memory”
>
what's the value in max_connections?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ec
cc: the -list this time
-- Forwarded message --
From: Jaime Casanova
Date: Thu, Jul 16, 2009 at 5:18 PM
Subject: Re: [BUGS] WARNING: out of shared memory
To: "Juan C. Aragon"
it's better for you to always write to the list because there are more
people that c
thing like that) for avoiding
duplicate code... but that's another patch, is worth the trouble?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
Index: src/pl/p
On Mon, Jul 20, 2009 at 9:55 AM, Tom Lane wrote:
> Jaime Casanova writes:
>> this one applies, compiles and it actually fixes the bug...
>
> And introduces a bunch of new ones. Surely you don't think that version
> of compatible_tupdesc() is good enough.
>
i gue
On Mon, Jul 20, 2009 at 10:09 AM, Alvaro
Herrera wrote:
> Tom Lane escribió:
>> Jaime Casanova writes:
>> > this one applies, compiles and it actually fixes the bug...
>>
>> And introduces a bunch of new ones. Surely you don't think that version
>&g
On Mon, Jul 20, 2009 at 11:34 AM, Jaime
Casanova wrote:
> On Mon, Jul 20, 2009 at 10:09 AM, Alvaro
>>
>> Getting rid of the check on natts was "ungood" ... it needs to compare
>> the number of undropped columns of both tupdescs.
>>
>
> ah! ok, i see...
ou know if this bug has been fixed or not? What would be the solution
> then?
>
That was fixed in 8.3.6
(http://www.postgresql.org/docs/8.4/static/release-8-3-6.html) but we
are in 8.3.7 now better go to the last...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Ase
On Tue, Jul 28, 2009 at 12:12 PM, Robert Haas wrote:
>>>
>>> patch attached
>>>
>> super, thanks
>>
>> Pavel
>
> So is this Ready for Committer?
>
i think so... but being me who added the last bit of code i didn't
felt confident to ma
ers/2009-07/msg00210.php
>
> It will be in 8.4.1.
>
> regards, tom lane
>
if you can compile code then you can download the latest snapshot of
8.4.0 (with the fix) from here
http://www.postgresql.org/ftp/snapshot/stable/8.4/
--
Atentamente,
Jaime Casanova
S
. you have a specific problem of this kind?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Fri, Aug 21, 2009 at 2:58 PM, Robert Haas wrote:
>
> Maybe you are doing this inside a transaction someplace? If so, it
> won't be visible to other transactions until you commit.
>
but then, if he simply restart the service the transaction will rollback
--
Atentament
ter position in both strings where the
> letters become different.
>
this is completely non-sense. can you present a test case that proves
what you're claiming?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel.
MySQL migration wizard does not start
> Details:
>
> I have downloaded and installed PostgreSQL 8.4 and installed the mysql
> migration wizard.
MySQL migration wizard is a tool from EnterpriseDB
(http://www.enterprisedb.com), you should go ask them...
--
Atentamente,
Jaime Casano
+
bpprovee | 111 | 0
(1 row)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
uot;test_foo" line 5 at RETURN QUERY
>
yeah! that bug was fixed here
http://archives.postgresql.org/pgsql-committers/2009-08/msg00068.php
but only in the currently in develop 8.5
are we going to backpatch this? while i think we should i know nothing
about how feasible that is
--
Atenta
0'::timestamp with time zone;
timestamptz
---
1900-01-01 00:00:00-05:14
(1 row)
"""
is this intended? why we treat '1900-01-01 00:00:00' different?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y
On Sun, Sep 27, 2009 at 9:45 PM, Robert Haas wrote:
>
> (with apologies to anyone on this mailing list who ACTUALLY speaks
> Spanish - it must have hurt to read that)
>
actually it was very good!
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y d
On Thu, Nov 19, 2009 at 1:03 PM, Orange wrote:
>
> Hi it shows like you see bellow
>
> The stange that once I copy it to other file it shows right
>
and this is related to postgres... because...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría
ad of simply 'duration >= '
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
get this
same error (not always, it seems this time the index is being created
but this time i did it inside a transaction)...
doesn't the index creation of the index block the table so, that
message should not appear?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreS
On Thu, Jan 21, 2010 at 12:45 PM, Tom Lane wrote:
> Jaime Casanova writes:
>> When we perform a test migration of the data we found some errors on
>> the logs, one of them is this one:
>
>> """
>> mic=# ALTER TABLE tcom_invitacion ADD primary key (
was created with uppercase you could need to
quote "ColumnName" (this is not single quote, though)
can you give a simple test case? i mean, a create table (maybe some
test data) and a select... that works the way you describe on those
OSes
--
Atentamente,
Jaime Casanova
Soporte y capa
e sistem,
> the paga that do it dont work.
>
how do you install it? what do you mean by: "i can open a database but
in the sistem, the paga that do it dont work.". you have any install
errors?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo
. then we can announce 10.0
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
bug report form should only be used for reporting bugs and
problems with the PostgreSQL database. Problems with database
connectors such as ODBC and JDBC, graphical administration tools such
as pgAdmin or other external projects should not be reported here;
please report to those projects directly.
ct list :(
besides my abilities with web forms are very poor... but if some one
is willing to help me a little i can try
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailin
a @$#! bug tracker.
>
after seen the commitfest app, i can swear the bug tracker you write
should be cool
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (p
ike
patch reviewers but they just respond the easy ones, and let difficult
ones for more experienced people, and maybe something like "fix bug
fest" maybe at the end of commit fests?
of course most of this is just a dream, or not?
--
Atentamente,
Jaime Casanova
Soporte y capacita
A to A for that
database and user?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
-- Forwarded message --
From: 陳裕耀
Date: 2010/4/22
Subject: Re: [BUGS] BUG #5433: pg_dump (8.4.3) copy database failure!
To: Jaime Casanova
於 2010/4/22 下午 12:56, Jaime Casanova 提到:
On Wed, Apr 21, 2010 at 11:21 PM, y.y.Chen wrote:
pg_dump in A=> pg_dump -h A db >
27;;
then add to pg_hba.conf a line like this:
host dbname username ip_web_server/32 md5
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your sub
iption:duplicate key violates unique constraint
Details:
the first thing you have to do is to upgrade at least to 7.4.13 (the
last release in that branch) and try again. Maybe the bug was already
fixed.
--
regards,
Jaime Casanova
"Programming today is a race between software engineers strivi
s easy to
determine, in recent releases it's mandatory unless you specify the
opposite in postgresql.conf with the add_missing_from parameter
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof pr
as nothing to do
with the upper query so the upper query can return more than number of
rows specified in the subselect...
no clue which ones :-/
LIMIT is often meaningfull only in conjuction with ORDER BY
--
regards,
Jaime Casanova
"Programming today is a race between software engineer
e +/-10 records affected. each mov_id can hold one or more (usuals up to
5) names. but here, the subquery seemed to return ~3700 distinct mov_ids,
thus around 37000 names where damaged by the following programmatical
updates instead of only a hands full...
have you tested the query in psql?
batch file
Details:
I was unable to install Postgres because of the following message "Failed to
create temporary batch file", which interrupts the installation.
do you have write permissions on the directory you are installing at?
--
regards,
Jaime Casanova
"Programming to
-- Forwarded message --
From: Fadi Thabtah <[EMAIL PROTECTED]>
Date: Sun, 1 Jul 2007 12:56:52 +0100
Subject: RE: [BUGS] BUG #3421: Failed to create temporary batch file
To: Jaime Casanova <[EMAIL PROTECTED]>
yes I do.
Fadi
From: Ja
t and specifically for bugs reporting. If you
want help with your work and because of the nature of it yo can write
in english to [EMAIL PROTECTED] or to
[EMAIL PROTECTED] if you don't know english you can write
in spanish to [EMAIL PROTECTED]
--
regards,
Jaime Casanova
"Programming today
t to the reader to interpret the two separate
representations as meaning a single time point based on the context.
"""
--
regards,
Jaime Casanova
Soporte de PostgreSQL
Guayaquil - Ecuador
Cel. 087171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Sat, May 17, 2008 at 1:45 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> [ redirecting to -bugs ]
>
> "Jaime Casanova" <[EMAIL PROTECTED]> writes:
>> On Sat, May 17, 2008 at 11:55 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> "Jaime Casanova&
> uescc.sql
it add the create statement for the database but not
add appropiates alter database for the parameters i
set search_path in this case.
But, pg_dumpall does.
a bug in pg_dump?
regards,
Jaime Casanova
_
Do You Yahoo!?
In
--- Alvaro Herrera <[EMAIL PROTECTED]> escribió:
> On Tue, Oct 19, 2004 at 02:25:35PM -0400, Tom Lane
> wrote:
> > Jaime Casanova <[EMAIL PROTECTED]> writes:
> > > but when i do a: pg_dump -C uescc > uescc.sql
> > > it add the create statement for
c.sql
***
These are the answers from psql
***
uescc=# \i c:/func.sql
BEGIN
DROP FUNCTION
psql:c:/func.sql:77: ERROR: syntax error at or near
"ELSE" en el carßcter 1720
psql:c:/func.sql:77: LINE 53: ELSE
psql:c:/func.sql:77:^
ROLLBACK
uescc=#
***
but in that
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> Jaime Casanova <[EMAIL PROTECTED]> writes:
> > CASE rs_dtran.fpg_codigo
> > WHEN ''EF'' THEN
> >
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> Jaime Casanova <[EMAIL PROTECTED]> writes:
> > --- Tom Lane <[EMAIL PROTECTED]> escribió:
> >> if/then/else is a statement, not a component of
> an
> >> expression.
> >> CASE is an expression
--- Tom Lane <[EMAIL PROTECTED]> escribió:
> Jaime Casanova <[EMAIL PROTECTED]> writes:
> > --- Tom Lane <[EMAIL PROTECTED]> escribió:
> >> It most certainly did not work in 7.4.2, or any
> >> other PG release.
> >> plpgsql doesn'
ady exist in
the script but the the create table was after a create
view that uses that table.
so pg_dump wasn't able to determine that dependency.
regards,
Jaime Casanova
_
Do You Yahoo!?
Información de Estados Unidos y América La
g 1=1;
>
returns no rows
> insert into tab values(1);
> insert into tab values(2);
> select 1 from tab having 1=0;
>
returns no rows
> select 1 from tab having 1=1;
>
returns 2 rows
regards,
Jaime Casanova
---(end of broadcast)
to apply the removing
> action.
>
i don't think it's a postgresql bug but a pgAdmin (or whatever gui
interface you are using) one.
regards,
Jaime Casanova
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ste,
> cualquiera que le pongo. ¿Como puedo solucionar eso?, ¿queda registrado en
> algun lado el usuario que tuve?. Por favor, necesito la respuesta rapido.
>
Borra el usuario postgres que se creo para arrancar el servicio, busca
en panel de control->herramientas administrat
subscribe to pgsql-cygwin list.
This message could help you, i think
http://archives.postgresql.org/pgsql-cygwin/2004-06/msg00074.php
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 6: Have
eric constants may be written
here, too, but they will all be converted to strings. Please check the
description of the implementation language of the trigger function
about how the trigger arguments are accessible within the function; it
may be different from normal function arguments.
--
Ate
rule if the condition were pass...
http://www.postgresql.org/docs/8.0/static/sql-createrule.html
ALSO
ALSO indicates that the commands should be executed in addition to the
original command.
If neither ALSO nor INSTEAD is specified, ALSO is the default.
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t; especials (á,é,í,ó,ú y ñ).I have a the last Odbc device but I can't
> nothing to do.
>
> I hope that you can help me.
>
> Thanks a lot.
>
This is not an ODBC problem... you have to create the database with
ENCODING LATIN1...
--
Atentamente,
Jai
ired after ): there are 0 rows in ttest
>
> fired before -> before -> after -> after
>
>
> Is this my fault?
>
The triggers are fired in alphabetical order, check the names of the triggers...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
T a,b,c
> FROM bar
> ;
>
That is because there isn't an ON COMMIT clause for CREATE TABLE AS
see compatibility section in:
http://www.postgresql.org/docs/8.1/static/sql-createtableas.html
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 6: explain analyze is your friend
gt; Index Cond: ((title >= 'teane'::bpchar) AND (title < 'teanez'::bpchar))
>
> I'am not sure is this a bug or not, but without some modifications in the
> postgres.conf the difference are more significant ( 22.530 ms ! to 2 ms).
>
Maybe you are using a non C-loc
the transaction closes.
^^^
---
This is the behaviour i see in informix (i dunno for other major
databases)... Cursors closes at end of transaction or by the user...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
> This message was sent using IMP, the Internet Messaging Program.
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.or
lem...
you must say what the problem was... what were you doing when
happened... what version of postgres...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 6: explain analyze is your friend
ould be nice to simply apply the constraint to all
> entries in the array if a constraint for type X is applied to X[].
>
>
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below
uments, it works.
>
> Where am I wrong ?
>
> Thanks in advance for your help.
>
and... where is the function? how is defined? how do you use it?
code, please wiyhout that you can't expect any help...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
--
structure.
>
> Please, help. I'll gladly provide any additional information as sonn as I
> know where to look.
>
> Robert
>
> PS. Spotting that kind of bug on production database (as it was i my case)
> can really spoil a day :)
>
Last year come up an issue with simil
ch to your tree source recompile
and you will have your problem solved now...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 1/4/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Jan 04, 2006 at 12:20:28PM -0500, Jaime Casanova wrote:
> > On 1/4/06, Brian Hirt <[EMAIL PROTECTED]> wrote:
> > > that's strange, because I'm running 8.1.1.
> >
> > what Tom i
erver closed the connection unexpectedly
>
> Works for me as of 8.1 branch tip, so the fix is in either 8.1.1 or
> 8.1.2.
>
>regards, tom lane
>
must be in 8.1.2 because i'm saying the same error in 8.1.1
--
regards,
Jaime Casanova
(DBA: DataBase Aniqui
tly on the column I will wait for the next release to
> test it (I don't have the source on my machine).
>
> BTW, I also observed the same behavior in 8.0.5 as well.
>
>
> John Supplee
>
of course. Tom backpatch all branches until 7.3...
--
regards,
Jaime Casanova
(DBA:
it in 8.1.1, so i guess you are right in tell that old
branches are broken...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an inde
aboration or if..un has information agradeceria hug thanks
>
Sorry there is no spanglish list... please, post in english or in
spanish in [EMAIL PROTECTED] (i recommend you do that)
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
wn issue, do it this way
CREATE OR REPLACE FUNCTION bugtest() RETURNS int AS
$BODY$
BEGIN
execute 'create temp table bugt(i int)';
execute 'insert into bugt values(1)';
execute 'drop table bugt';
RETURN 0;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> instead of dd/mm/
> Please tell me how to fix this
> Thank you
>
Then, this is a pgAdmin bug and you have to report it to the pgAdmin team...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The following bug has been logged online:
Bug reference: 2195
Logged by: Jaime Casanova
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.1
Operating system: Windows XP
Description:log_min_messages crash server when in DEBUG3 to 5
Details:
Hi,
in my machine
(GCC)
3.4.2 (mingw-special)
(1 fila)
pruebas=# select (1::float-1::float)*(-1);
?column?
--
0
(1 fila)
This is good for me... maybe a bug already fixed?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
how do you determine it is corrupted?
3) it gives you some error messages? which one?
4) How old is the data that you loss?
5) are you aware that you have to have write-cache disabled on your
disks in other to assure the data get it to the disk?
6) how frequent are you executing VACUUM?
--
Jaime C
him some code to try... anyone remeber
some change in that area or in an area that could affect the npgsql
driver?
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
the trigger inserting a new value on the
same table forcing a new execution of the trigger making it
recursive...
> I am thinking its a bug in postgres..
it's too early to blame postgres
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de Postgre
: Installation error
> Details:
>
> When trying to install version 9.0.2 in a Win XP 32 get the error :
>
> "Unable to write inside TEMP environment variable path"
>
this seems a permissions issue, are you using an Administrator account
or something with enough
postgresql.org? besides, a report needs a lot more info,
for example postgresql version, operating system, exact message
errors, and so on
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-bugs mailing list (pgsql-bugs@post
information to
determine what the problem is, which you obviously haven't do it.
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
estion from the page Hubert show you
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
to the standby (because the standby
is a synchronous standby, it keeps waiting until the standby aknlowdge
to have received the wal), so what you are cancelling now is the
primary waiting for the standby...
btw, i guess we should be defaulting to asynchronous standbys (ie:
synchronous_commit=loc
');
>
> By the way, another issue that I found is when I execute \df. It
> doesn't display anything (I must
> force with * to do that).
i can confirm this
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-bugs
Craig Ringer writes:
> -ENOCOFFEE
>
LOL. this one is the best i have heard this year
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL
Soporte 24x7, desarrollo, capacitación y servicios
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make chan
gt; and no_active"
> PL/pgSQL function "enablenode_int" line 32 at SQL statement
>
what do you have in timezone in postgresql.conf? certainly, the
timestamp format looks odd
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL
bility issues
> with PostgreSQL.
> Could you please connect me to the appropriate
> individual for this?
>
if you think this compatibility issue is a bug of postgresql, this
list is just fine otherwise write to pgsql-hack...@postgresql.org...
--
Jaime Casanova www.2ndQuadrant.com
oncurrent also,
but at least faster... unless i'm missing something
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-USERS
> Is there any workaround?
> How could we create temp database and tables on slave?
>
not with streaming replication
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci
1 - 100 of 121 matches
Mail list logo
