I want to keep a history of changes on a field in a table. This will be
the case in multiple tables.
Can I create a trigger that loops the OLD and NEW values and compares
the values and if they are different creates a change string as follows:
e.g;
FOR EACH field IN NEW
IF field.value <>
Thank you for your answer. I guess I better create this history in the
application's data class.
Klint Gore wrote:
Fernando wrote:
I want to keep a history of changes on a field in a table. This will
be the case in multiple tables.
Can I create a trigger that loops the OLD and NEW v
Is it possible to do this?
SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
What I want is to return a boolean, but when I tried SELECT
COUNT(colname)::BOOLEAN FROM table; it says it cannot cast bigint to
boolean.
Is there such IF function or do I have to create my own.
Tha
Thanks this is exactly what I need it.
Fernando
Tom Lane wrote:
Fernando <[EMAIL PROTECTED]> writes:
Is it possible to do this?
SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
SELECT COUNT(colname) > 0 AS colname FROM table;
If you really like to typ
Have you tried Navicat? The light version is free for the Mac (I think).
Andy Anderson wrote:
On May 13, 2008, at 11:42 AM, Merlin Moncure wrote:
Here are some other things we have v. mysql:
*) Much better shell
I tend to agree based on my limited experience.
However, being a GUI-orien
.
Fernando.
Bohdan Linda wrote:
Hello,
I have the following problem. A multiuser app has authentization and
authorization done based on pgsql.
The frontend is web based so it is stateless; it is connecting to database
on every get/post. There is also a requirement that the user is
transparently
Are you calling store procedures that return cursors? I had this
problem with cursors because the transaction gets committed and the
cursor closed after they return. Mind you I had the problem on .NET
using npgsql, so I might be way off.
Cheers
On 20/05/2010 10:05, Giancarlo Boaron wrote:
make the function call in a php file. I'm not using stored procedures.
If I create an empty php file and put only some of these functions,
Apache reports de 'call to undefined function XXX'.
--- Em *qui, 20/5/10, Fernando //* escreveu:
De: Fernando
Assunto: Re: [GENE
tabase to en_US.UTF-8 and sourced SYBASE.sh from
postgres bash_profile
script. Before that, the error was aboit missing dynamic libs.
I know this looks more a sybase thing than a postgresql thing but maybe someone
can understand the
sybase error message and help me. After all I hope s
Dave,
It looks like the postgresql.jar archive is not in your CLASSPATH.
[]s, Fernando Lozano
> I'm not sure this is the right place to enquire...
>
> I'm trying to connect to a postgres datanbase with Java.
>
> import java.sql.*;
>
> public
Hi all,
Necessary to inside insert archives (jpg, doc) of the bd using delphi +
DBExpress
How to make this?
Exists an example?
regards, fern
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
my freebsd 4,7 this creating processes big of postgresql.
help me with some information?
PostgreSQL 7.3.1
CPU states: 0.0% user, 0.0% nice, 0.0% system, 0.0% interrupt, 100%
idle
Mem: 221M Active, 1890M Inact, 272M Wired, 118M Cache, 199M Buf, 9256K Free
Swap: 1024M Total, 276K Used, 1024M
Hello,
i've been reading the README file in the lmgr folder (in src/backend/storage/lmgr/)
and i have a couple of questions about locks:
- What's the difference between the Lightweight Locks (LWLocks) and the Regular
locks (Heavyweight Locks)? For example, if i do a query and it needs a lock, w
S NULL)
OR (NOT field1)))
-> Seq Scan on rel_usr_sector_parte_tecnico r
(cost=0.00..7.61 rows=461 width=0)
(10 rows)
Thanks!
Fernando.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > Now, combined (sorry for the convoluted query, it is build
> > automatically by an app).
>
> > EXPLAIN SELECT DISTINCT p.id
> > FROM partes_tecnicos p
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > Now, combined (sorry for the convoluted query, it is build
> > automatically by an app).
>
> > EXPLAIN SELECT DISTINCT p.id
> > FROM partes_tecnicos p
En un mensaje anterior, Michael Glaesemann escribió:
>
> On Jun 22, 2007, at 10:16 , Fernando Schapachnik wrote:
>
> >EXPLAIN SELECT DISTINCT p.id
>
> Can you provide EXPLAIN ANALYZE? I suspect that when you rewrote the
> query it changed how the planner took into ac
wireless router)
192.168.0.x (clients)
How i make my idle connections alive for long time?
Any idea?
Regards,
Fernando
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para
armazenamento!
http://br.mail.yahoo.com/
---(end of broadcast
od for
network complex..
Thanks for all replies! :-)
regards,
Fernando
- Mensagem original
De: Douglas McNaught <[EMAIL PROTECTED]>
Para: Fernando Xavier <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Enviadas: Terça-feira, 27 de Novembro de 2007 16:33:35
Assunto: Re
00:00 | t
America/Argentina/San_Juan | ARST | -02:00:00 | t
(11 rows)
Thanks for all contributions.
Regards,
Fernando.
---(end of broadcast)---
TIP 6: explain analyze is your friend
> Tom Lane [mailto:[EMAIL PROTECTED] wrote:
>
> "Fernando Hevia" <[EMAIL PROTECTED]> writes:
> > With 8.2.x the ARST abbreviation was recognized after including the
> > following line in /usr/share/postgresql/8.2/timezonesets/Default
>
> > AR
Hi,
I want format a column in select result:
1.1 => 1.10
Any idea?
Thanks!
Fernando
Abraços,
Fernando
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para
armazenamento!
http://br.mail.yahoo.com/
---(end of broadc
En oportunidades anteriores donde me ha tocado trabajar con empresas cubanas
fue la empresa la que gestionó la visa y me la enviaron escaneada. No tuve
que ir a la embajada en ningún momento.
Saludos,
Fernando.
2011/1/11 ๏̯͡๏ Guido Barosio
> Yunior,
>
>En Argentina el tramite de
t perform
f_outer
-
(1 row)
I want to get rid of the CONTEXT messages.
I have tried in psql with "\set VERBOSITY terse" without success. No idea on
what to try on pgadmin though.
Thanks,
Fernando
--- Function declaration follows in case it helps ---
CREATE OR REPLACE FUNCTIO
> -Mensaje original-
> De: Tom Lane [mailto:[EMAIL PROTECTED]
> Enviado el: Lunes, 07 de Abril de 2008 01:37
> Para: Fernando Hevia
> CC: pgsql-general@postgresql.org
> Asunto: Re: [GENERAL] Removing Context messages
>
> "Fernando Hevia" <[EMAIL
:
"table1_pkey" PRIMARY KEY, btree (id)
# drop SEQUENCE table1_id_seq ;
ERROR: cannot drop sequence table1_id_seq because table
table1 column id requires it
HINT: You may drop table table1 column id instead.
Am I doing something wrong?
Thanks!
Fernando.
--
Sent via pgsql-gener
En un mensaje anterior, Merlin Moncure escribió:
> On Thu, May 8, 2008 at 7:52 AM, Fernando Schapachnik
> <[EMAIL PROTECTED]> wrote:
> > Pg 8.1.11, I try to change sequences as default value of a table, then
> > remove old sequence:
> >
> > # \d table1
>
CE name [ INCREMENT [ BY ] increment ]
> >[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO
> > MAXVALUE ]
> >[ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
>
> oop, you are using 8.1 :-). This was added in a later version. drop
> sequen
En un mensaje anterior, Merlin Moncure escribió:
> On Tue, May 13, 2008 at 8:50 AM, Fernando Schapachnik
> <[EMAIL PROTECTED]> wrote:
> > > > ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
> > > >[ MINVALUE minvalue | NO MINVALUE ] [ MAXV
I haven't use the RETURNING clause before, but the "INTO" option, at least
in SELECT sentences, must be outside of the string expression. This way:
EXECUTE 'some query' INTO variable;
Cheers.
2008/5/30 A B <[EMAIL PROTECTED]>:
> I have a query like this in a plpgsql function:
>
> EXECUTE 'INSERT
Hello,
One of my hd failed recently, so I has to reinstall my system, but my data
where on other hd that did
not fail.
So I want to use that data , I tried initd -D /storage/pgCluster but I get
a "directory not empty" message, of course I
want to use that cluster.
How could I use that data?
Th
As a PostgreSQL user, I'd like to bring to the attention of the community
and the developers that Andrey Karpov from PVS-Studio published an article
listing several potential bugs in PostgreSQL. These bugs were revealed by
code analysis with the PVS-Studio tool. He is also offering a license to
the
script in the
middle.
Thank you very much in advance.
Kind regards.
Fernando Pianegiani
eally for free. Behind them there is for sure a
business.
Fernando
> Extreme cross posting, you may need to elect one mailing list and post
> only to it.
>
> I think you may not get good offering for what you are looking for if
> you are only interested in FREE hosting havin
Exuse me, PostgreSQL is completely free, not MySQL.. :-D
On Sat, Aug 6, 2011 at 11:48 AM, Fernando Pianegiani <
fernando.pianegi...@gmail.com> wrote:
> Hello,
>
> thank you for your answer. Sorry for my cross posting.
>
> Are you in any business about hosting platforms??
ended.
Fernando
On Sat, Aug 6, 2011 at 3:28 PM, Antonio Goméz Soto <
antonio.gomez.s...@gmail.com> wrote:
> Well,
>
> I am from the hosting business, and can assure you, what you are looking
> for does not exist.
> This configuration requires specialists on the pro
right income from me in some way (e.g.
a banner installed on my PC or other similar business). Fortunately up to
now I have never asked for charity dear David and I hope to have not to do
it in the future.
Have a good dinner!
Fernando
On Sat, Aug 6, 2011 at 5:35 PM, David Johnston wrote:
>
wn system with all these
> technologies. That's the free hosting solution that might work best
> for you.
>
Simply I don't know how the business works for the hosting platforms. Or
better, now I have understood it. :-) For this reason I asked my question. I
supposed that it was a business similar to the one existing for "File
Hosting".
Thank you for your support. :-)
Fernando
> Best Wishes,
> Chris Travers
>
king others to filter for you -
> only you know what your actual situation is which makes anyone else's
> filtering only an uninformed guess.
>
As answered before, you cannot ask questions on my behalf. :-) I already
filtered any "no free" solutions for valid reasons. What
John, Craig,
how do you explain the services of file hosting? By those services millions
of persons free-load pictures, videos, text, GBs of data, etc.. I think that
what I asked is quite similar, that is the use of a piece of remote hardware
where to have free software installed. The difference i
On Sun, Aug 7, 2011 at 11:22 AM, John R Pierce wrote:
> On 08/07/11 1:46 AM, Fernando Pianegiani wrote:
>
>> how do you explain the services of file hosting? By those services
>> millions of persons free-load pictures, videos, text, GBs of data, etc.. I
>> think th
On Sun, Aug 7, 2011 at 2:41 PM, Craig Ringer wrote:
> On 6/08/2011 4:02 PM, Fernando Pianegiani wrote:
>
>> Hello,
>>
>> do you know any FREE hosting platforms where PostgreSQL, Java SDK,
>> Tomcat (or other web servers) can be already found installed or where
On Sun, Aug 7, 2011 at 4:22 PM, David Johnston wrote:
>
> > this is very difficult, but it is exactly what I am doing in environments
> different from this one. Even if this risks to be considered (not so
> positively) as a request of charity... :-)
>
> At that point, unless you have confidential
ing if somebody knows a hosting service where
PostgreSQL can be used for free is not inappropriate. But if you consider it
inappropriate and you are in a position to cancel my posts you have to
cancel them without any hesitation asap.
Fernando
On Mon, Aug 8, 2011 at 12:45 AM, Joshua Berkus wro
You could also disable "Read and write Unicode UTF-8 files" in
Options->Preferences.
It will not write a BOM but you will not have UTF-8 either.
On Thu, Apr 22, 2010 at 07:29, John Gage wrote:
> Additionally, if the Vim option "bomb" is set to "nobomb" it will strip the
> BOM. This solves my "
Hello,
I try to use an old cluster into a new system.
The new system comes with a newer version of postgres so I uninstalled it
and I installed the same version that I had in the older system --->8.1
I got impressed when I Installed the 8.1 with dpkg -i and it started to run
without starting t
Hi, I've changed the setting log_statement to mod, in order to log data
modifications, and it's working fine with sentences sent by the client
application (psql included), but insert/update/delete sentences executed
inside functions are not logged. Functions are called in a select query.
I've relo
2008/8/29 Bill Todd <[EMAIL PROTECTED]>
> If I have a series of RAISE NOTICE 'xxx' statements in a plpgsql function
> and I call the function from pgAdmin the notice messages are concatenated on
> a single line on the Messages tab. Is there any way to get each message to
> appear on a separate lin
Hello, I'm new to this mailing list, and I have a couple of questions:
Is it really necessary to add the [GENERAL] prefix?
Are messages without this prefix likely to be ignored by automatic filters
or something like that?
Thanks in advance.
2008/9/3 brian <[EMAIL PROTECTED]>
> Fernando Moreno wrote:
>
>> Hello, I'm new to this mailing list, and I have a couple of questions:
>>
>> Is it really necessary to add the [GENERAL] prefix?
>>
>
> The prefix is added by the mailing list soft
>
> BTW, should you have an "else" clause in there? - What happens when the
> comparison fails?
>
As Tom said, a null value would be returned.
Hi, first of all, a new role doesn't have any privilege on any table (every
type of database object has different default privileges), so you only have
to grant select on the tables you want, and yes, one by one.
You can also grant or revoke privileges this way: grant select on
table1,table2,table
Hi there, I'm going to use the db_user_namespace parameter to get a strong
relationship between roles and databases, multiple databases -users
included- residing in the same server without conflicts is my objective too.
Right now I'm working on the backup process, which ideally would let me
mirro
2008/10/7 Alvaro Herrera <[EMAIL PROTECTED]>
> Bruce Momjian escribió:
>
> > Well, I posted about this in August with no one replying:
> >
> > http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php
> >
> > Basically, there is a mismatch between what libpq and the backend think
> > i
2008/10/20 Glyn Astill <[EMAIL PROTECTED]>
> Hi people,
>
> Hopefully this is a quickie, I want to pass in a table name to a plpgsql
> function and then use that table name in my queries.
>
> Is EXECUTE the only way to do this?
>
As far as I know, yes. That's the only way to create queries using
2008/10/22 Ma. Cristina Peña C. <[EMAIL PROTECTED]>
> I want to use a function in to a trigger
>
>
>
> This is my
>
> CREATE FUNCTION "subradio"(integer) RETURNS integer AS 'select cast(count
> (claveubica) as integer ) from asradios where ubicacion =0;' LANGUAGE 'sql';
>
>
>
> And my ttrigger is
Hi, I'm working on a little backup utility for a desktop application. It's
going to execute pg_dumpall (-r) and pg_dump, but first I have to deal with
the permissions needed to do that:
1. Users (pgsql roles) enabled to backup would be superusers all the time.
This sounds insecure.
2. Users will
Hello Scott, thanks for your answer. I've just noticed that my first message
lacked some important info.
First, this is an accounting software, and there's only one database. Almost
all of the options (buttons, generally ) are stored in a set of tables,
beside the database privileges needed to wor
t; does not exist
I intentionally removed other databases name.
Also, i verified that i can run CREATE DATABASE skynet having two databases
with the same name.
Any ideas of what causes this problem?
Regards,
---
Fernando Marcelo
www.consultorpc.com
ferna...@consultorpc.com
--
Sent via pgsql-
Em 08/01/2010, às 14:48, Tom Lane escreveu:
> Adrian Klaver writes:
>> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
>>> Name| Owner | Encoding | Collation |Ctype| Acce
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
> On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
>
>> Hello,
>>
>> Thanks for your quick answers. The extra space is indeed a copy-and-paste
>> issue. Here it is the select that you suggested:
>>
gt; adrian.kla...@gmail.com
Hi,
The reason for pgpool is that we were using it, but decided to stop due to some
problems. At this moment we have pgpool with one node only. Also, i am
connecting directly to postgres in order to verify this problem.
And the difference between this and previous l
Em 09/01/2010, às 19:40, hubert depesz lubaczewski escreveu:
> On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
>> postgres=# drop database skynet;
>> ERROR: database "skynet" does not exist
>
> do:
>
> psql -l | hexump -C
&g
here.
>
> Could you add -qAt to psql options and rerun the command?
>
> Best regards,
>
> depesz
>
> --
> Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
> jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg
An Ubuntu install creates a postgres cluster automatically on
/var/lib/postgresql/8.4/main
Whats the best procedure for moving this cluster to an other location?
Should I just rerun initdb? What happens then with the default cluster or
how could I delete it?
Thanks,
Fernando.
--
Sent via
> -Mensaje original-
> De: Guillaume Lelarge [mailto:guilla...@lelarge.info]
>
> Le 14/01/2010 21:40, Fernando Hevia a écrit :
> >
> > An Ubuntu install creates a postgres cluster automatically on
> > /var/lib/postgresql/8.4/main Whats the bes
> -Mensaje original-
> De:
>
> On Thursday 14 January 2010, Fernando Hevia elucidated thus:
> > An Ubuntu install creates a postgres cluster automatically on
> > /var/lib/postgresql/8.4/main Whats the best procedure for
> moving this
> > cluster to
any way of instructing PG (8.1 if that matters) to place those
files elsewhere without an initdb?
Thanks!
Fernando.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
En un mensaje anterior, Greg Smith escribió:
> >So, any way of instructing PG (8.1 if that matters) to place those
> >files elsewhere without an initdb?
> >
>
> You can create another table just like the original on a tablespace
> using the new storage, drop the original, and then rename the n
Check out the "log_statement" option in the postgresql.conf file
(there's an entire section (18.7) in the docs about logging).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hola, no olvides que esta es la lista de correo para usuarios de habla inglesa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What error are you getting?
I tried your query and I had to add an explicit cast to smallint[] to
make it work. Like this:
... a.attnum = any ((select conkey FROM pg_catalog.pg_constraint WHERE
> oid = 3708025)::smallint[]);
It seems strange to me, I didn't expect the ANY clause to need that
cas
Hi all, I'm using visual foxpro 9 -not my decision- for a client
application. Statements are writen as the typical sql string and sent
through ODBC.
For numbers, I have to convert them first to string and then remove
the spaces, the code looks like this: sql_string = "some sql" +
alltrim( str( som
Thank you very much for your advice, I guess I'm wasting my time in
this 'problem'. I'm going to check that class, it seems pretty useful.
And by the way...yes, this is a born-dead app (at least on the client
side) and it's likely to be ported to .NET in the future, but like I
said before, it's not
Hi, check this out:
http://archives.postgresql.org/pgsql-general/2008-05/msg00938.php
I would say that execute is the only way to achieve some things
related to schemas and temp tables.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
El día 2 de marzo de 2009 18:14, Angelo Astorga
escribió:
> Trabajo con postgresql 7.3.4 y el log se guarda en el dir
> .../data/serverlog, ahora que utilizo postgresql 8.1.11 no encuentro donde
> guarda el log, alguna ayuda de como generar archivo log de postgresql...
>
> aastorga
Esta es la lis
open file references to temporary TOAST tables.
---
Could anyone point me out some documentation about what these schemas mean?
Should I be worried? Anything I should do about it?
Thanks,
Fernando
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
> -Mensaje original-
> De: Tom Lane [mailto:t...@sss.pgh.pa.us]
>
> ... and there's one for each concurrently
> executing backend if it creates any temp tables.
>
That explains the growth I noticed as backends have been incremented
recently.
Thanks!!
--
Sent via pgsql-general mai
ailed: Connection reset by peer
There is no problem when not using SSL. The Samba code doesn't have any
SSL-specifics, leaving it to libpq. Any ideas?
Thanks in advance.
Regards.
Fernando.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comm
Hi folks,
I wanna know from you, how often must I run vaccum analyze on my db?
Once per day, twice... One per hour and so on...
I didn't find a especific document about this question.
Thanks in advance.
Fernando Lujan
---(end of broadcast)---
ually). Is that a safe use? I
would think it is not, but not really sure. I mean, does libpq multiplex queries
and handle concurrency correctly in a such a scenario?
Thanks.
Fernando.
---(end of broadcast)---
TIP 7: don't forget to increase your
En un mensaje anterior, Matt Van Mater escribió:
> I there a way to specify that I want the contribs directory (and its
> children) compiled and installed during the build process in the
> various BSD ports systems? Of course I understand that what works on
> one BSD may not work on the others, bu
Hi everyone,
Which is the best configuration to pg_autovaccum?
Are there benchmarks showing the improvements, after and before the
service had started?
Thanks in advance.
--
Fernando Lujan
---(end of broadcast)---
TIP 9: In versions below 8.0
Hi folks,
I have a table wich contains my users... I want to insert to each user
a random password, so I need a random function. Is there such function
in Postgres? I just found the RANDOM which generates values between
0.0 and 1.0.
Any help or suggestion will be appreciated. :)
Fernando Lujan
On 8/17/05, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> select substring(md5(random()) from 5 for 15);
Thanks everybody, this solution will fullfill my needs... ;)
Sincerely,
Fernando Lujan
---(end of broadcast)---
TIP 9: In versions
ere's no problems with
passwords which a user could remember. At least, the user will not
trouble you with a password reset requirement. :D
Thanks for all replies and suggestions.
Fernando Lujan
---(end of broadcast)---
TIP 1: if posting/readi
Is there a way to do that?
Thanks in advance.
Fernando Lujan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
to see the quantity on-hand reduced by
the amount user 1 took.
Because read uncommitted is not supported is there a way to do this?
Thank you for all your cooperation.
Fernando
because the products are not available
anymore.
This is the problem I want to avoid. Therefore if User1 takes the
product but does not finish the order I want the inventory to still
show that the product is sold out to other users.
Any suggestions on how to implemnt that?
Thank you,
Fernando
allow me to reduce the quantity at the time the order
obtained the product and increase it when the order is cancelled or if
the user forgets or his/her computer crashes.
Is this a good idea? Your input is appreciated.
Fernando
Thank you Mike for your answer. That is what I had in mind.
You guys have helped me alot. Thank you so much for your cooperation.
Fernando
Thank you very much Mike. I will do just that.
FernandoOn 9/30/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> User1 starts order and takes the last two units. User2 starts order 1 minut=> e> after and checks inventory. He sees 2 units left and adds them to the his> order. User1 commits his order. No
2
[FreeBSD] 20040728).
Should I file a bug report?
Thanks!
Fernando.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > I've stumbled upon what seems to be a core-dumping infinite recursion
> > in transformExpr(), on 8.1.6.
>
> A test case would help.
The culprit query looks like:
ading some custom code that sucks
> pthread support into the backend. This is generally a bad idea in any
Not really. Only PLSQL and dblink. Anyway, my understanding is that
this should be already fixed in 8.2 and is not worth looking deeply,
right?
Thanks for your help.
Fernando.
-
and in special to this "someone" that will be happy to
give me some help.
>From Palma de Mallorca
Fernando
- Original Message -
From: "Robert Treat" <[EMAIL PROTECTED]>
To: "Fernando Fernández" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]&g
sleect function(ssd_a) from ...
where function is one of the built-in text function or one of your own written
in some of the supported (by your version) procedure languages.
Regards.
En un mensaje anterior, srini vasan escribió:
> --- srini vasan <[EMAIL PROTECTED]> wrote:
>
> > Hi
> >I a
Just kill the processes. You can grep for postgres AND idle. It doesn't prevent
new connections, but doesn't look like an issue in your scenario. If you need
that, you can restart with a copy of pg_hba.conf that only allows localhost, do
your drop & recreate, and then restart again.
Regards.
Is your system using full RAM? Ie, what does limits -a show?
Regards.
Fernando.
En un mensaje anterior, Sean Shanny escribió:
> To all,
>
> The facts:
>
> PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI
> drives in hardware RAID 0 configuration.
Take a look at datasize: your processes are allowed a maximum of 512 Mb RAM.
Read the handbook to find out how to reconfigure your kernel and the limits
(and/or ulimit) man page to tweak the values for individual processes.
Good luck!
Fernando.
En un mensaje anterior, Sean Shanny escribió
1 - 100 of 143 matches
Mail list logo
