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
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
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
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 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
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
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
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
>
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:
>
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
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??
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
script in the
middle.
Thank you very much in advance.
Kind regards.
Fernando Pianegiani
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
Podran grabar videos (screencasts) de todas las actividades del pgday? para
asi se tenga mas difusion y poder bajar los videos.
Saludos
Fernando Lopez
Bolivia
El 11 de enero de 2011 16:30, Ing. Yunior Mesa Reyes escribió:
> Para divulgar por todas las vías posibles...
>
> Durante
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
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:
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 "
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
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
> -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
> -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
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
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
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
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 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:
>>
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
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-
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
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
> -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
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
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
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
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 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
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
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
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
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
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
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
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/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
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
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
>
> BTW, should you have an "else" clause in there? - What happens when the
> comparison fails?
>
As Tom said, a null value would be returned.
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
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/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
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
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
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
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
.
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
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
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
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
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
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 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
>
:
"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
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
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 <>
> -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
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
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
> 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
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
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
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
as Gracias
Saludos Fernando
-
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
d round-up 9.
Reading http://www.ai.com.br/pessoal/indices/2A1A.HTM show the correct way
(sorry, the page is in brazilian portuguese).
Anyway, the document shows: DO NOT DO RECURSIVE ROUNDS! hehe.
Thanks for the answer and sorry for the incorrect question.
Regards,
Fernando Pinheiro
2007/7/11
laces parameter
+ 1 to determine which is the rounding (ROUND(1.8951, 2) returns 1.90).
I've tested in 8.1.3 and 8.2.4.
Is it expected to work this way? There's a way to "force" the round to
consider all the decimal places?
Thanks,
Fernando Pinheiro
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
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
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
on to log_statement you can also set log_min_duration_statement
to 0 and that will also log queries in your log file.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.co,)
On 5/29/07, Diego Fernando Arce < [EMAIL PROTECTED]> wrote:
>
> show log_statement;
>
> log_statement
> -
erpriseDB ( www.enterprisedb.com)
On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED]> wrote:
>
> this is a part of postgrsql.conf
>
>
> log_statement = 'all' # n
rver_start = off
*in 8.1.6 and 8.1.4 it works *
On 5/29/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Did you try doing "log_statements = all" in your postgresql.conf file?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 5/29/07, Diego Fernando Arce <[EMAIL PROTECTED
hello, I have a question, does not work monitor stats in postgres 8.1.8
I cannot see querys in execution
help me please..
DiegoF
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.
-
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:
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/
Estimados,
Disculpen por la pregunta pero con postgres puedo sacar un dump desde dentro
de la base y obtener lo mismo que con pg_dump
Gracias Saludos
-
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
Every two days, Postgres 8.1 Server is unconfigured without apparent
changes done. The service under windows XP is always stoped.
I work under XP SP2.
has somebody any idea?
Do the list accept messages in spanish?
---(end of broadcast)---
TIP 9
.utf8
en_PH
en_PH.utf8
en_SG
en_SG.utf8
en_US
en_US.iso885915
en_US.utf8
en_ZA
en_ZA.utf8
en_ZW
en_ZW.utf8
I don't see en_US.UTF-8 there why..??
I have tried doing initdb to an empty cluster and copying the data folder but
the erros is the same.
Could you help me to resolve this.
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
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
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
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
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
Is there a way to do that?
Thanks in advance.
Fernando Lujan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
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
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
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
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
1 - 100 of 143 matches
Mail list logo
