directori *is* compatible if you keep using 9.2 so i
would install the right binary from yum.postgresql.org and use
existing data directory
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general
-- Forwarded message --
From: Shahzad Bashir shahzadbashir4...@hotmail.com
Date: Thu, Oct 3, 2013 at 5:43 AM
Subject: RE: [ADMIN] Database replication to 50-80 nodes
To: Jaime Casanova ja...@2ndquadrant.com
hi,
I am very much new to postgres, infact just started... can
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/10/4 Jaime Casanova ja...@2ndquadrant.com:
what version of postgres is this? starting in 9.3 you can create
foreign tables between postgres databases, before that you can create
a foreing server and use
On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev gray...@gmail.com wrote:
On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova ja...@2ndquadrant.com wrote:
but it would be a good idea to set hot_standby_feedback to on and
max_standby_archive_delay to something larger than 30s
Doesn't replica need
idea to set hot_standby_feedback to on and
max_standby_archive_delay to something larger than 30s
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-general mailing list (pgsql
TO OFF STABLE;
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
by the mail client.
what version of postgres is this?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
the parent it will read the childs too) but for the
user they will look as one single table.
so even say see limited by table size is not that true from certain
point of view
maybe: limited by other constraints (or some other words to say that)
--
Jaime Casanova www.2ndQuadrant.com
?
it's safe as long as you let repmgr do it ;)
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
that will guarantee you will lose your master instalation on OS
crash and i think to remember that even if the OS doesn't crash there
is a risk (altough i can't find the mail saying that)
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via
and to
receive), so it will take some time until standby catch up
2) what if the wal segment that was being used when you stopped
walsender is reused in master before walsender is reactivated?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent
to on (of course, this
SET is a command you send to the server just like any other SQL
command)
don't forget to reset synchronous_commit or use set local, otherwise
you will let this node as the sync rep until disconnect
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y
only one of the table should be in use while
Slony is processing the queu of the other and truncate it. but if the
slon process are not running those tables start to grow... can you
check that the slon processes are running
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL
many dead tuples are looking at the
n_dead_tup in pg_stat_all_tables
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Wed, Jul 27, 2011 at 7:24 PM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
On 28/07/11 03:47, Jaime Casanova wrote:
On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
So that looks good, but then I try this on the slave:
# repmgr
to
Version X.X in the release notes for the above mentioned versions
2) Do I need to upgrade JDBC driver when I upgrade to postgres9.0.
probably but i'm not so sure about it
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql
that support for 8.2 will stop in December 2011, right?
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
be changed at anytime just reloading
archive_mode needs to restart the server. so this is just a good
configuration for 24x7 setups
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
user=repmgr dbname=repmgr
(1 row)
this is on the master or the slave?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
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-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
)
values (new.request_id, SYSTIMESTAMP
);
How can I insert a dynamic timestamp value in postgress, please?
Maybe this document can help you
http://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
--
Jaime Casanova
on that table.
My table is a read-only table after all.
That's another reason why I'm reluctant using ANALYZE table.
sorry, i don't follow that... why do you think that a read-only table
doesn't need an ANALYZE?
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación
to MySQL where this was
as easy as running:
CREATE TABLE test (
id INT PRIMARY KEY AUTO INCREMENT);
in postgres is as easy as
CREATE TABLE test(
id SERIAL PRIMARY KEY);
hey! it's even less keystrokes!
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y
' the
final one, replace them with you're own range
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On Wed, Apr 27, 2011 at 1:48 PM, Dave Page dp...@postgresql.org wrote:
I'm pleased to announce that effective immediately, Magnus Hagander
will be joining the PostgreSQL Core Team.
Congratulations!
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación
='exit 0'
max_wal_senders = number of slaves or greater
on slave:
=== postgresql.conf ===
hot_standby=on
=== recovery.conf ===
standby_mode='on'
primary_conninfo = 'host=master_ip'
or you can use repmgr to make all this easier:
http://projects.2ndquadrant.com/repmgr
--
Jaime Casanova www
not have to supply a password. Try the command without a password.
right. and because the OP is a good reader he should read chapter 19.1
(http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html) and
use trust in authentication method
--
Jaime Casanova www.2ndQuadrant.com
Professional
to reindex)
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Jun 8, 2010 at 12:49 PM, Jeff Amiel jam...@istreamimaging.com wrote:
Does Slony manage it's own vacuuming separate from postgres' autovacuum?
Yes it does: http://www.slony.info/documentation/maintenance.html
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de
in select col_a from t loop
update t set col_c = col_a + col_b where col_a = r.a;
end loop;
return;
end;
$$ language plpgsql;
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
in some lower
end versions of our product.
why you can't upgrade to say: 8.1.20... it has the same behaviour as
8.1.4 and less bugs...
--
Jaime Casanova www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
the fantasy of some one or are there
numbers supporting that?
if the app is correctly written the connections wiil be taken and
relesead as needed then you can use a connection pooler
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil
%2C_and_COUNT
http://wiki.postgresql.org/wiki/Using_EXPLAIN
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
with
say the number 2 or any other single number in that field.
create unique index unique_field_idx
on table1(field)
where field = 1;
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql
On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith vah...@gmail.com wrote:
all
how to set up PGTAB file ? any example for
PGTAB=/opt/postgres/utilities/conf/pgtab
what is pgtab for? and where do you get it?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo
for each row execute procedure keep_a_in_b_test1();
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
allowed
2) create pg_catalog.pg_autovacuum with structure it has until 8.3 (i
guess if those programs are broken enough to ask for the catalog maybe
it is also asking for specific columns of the catalog)
3) Exit and start the service again
--
Atentamente,
Jaime Casanova
Soporte y capacitación de
the structure of the table
(ALTER, DROP) and with commands TRUNCATE, REINDEX, CLUSTER, and VACUUM
FULL, and every select take it
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general
?
no
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
automatic...
but if you insist in plpgsql you can execute select version() into
some_text_var and act acordingly
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql
be 1, you want it to be 4...
in an update the columns always hold the old value until the statement
is finished, the only way i can think for doing this is with a trigger
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel
?) solution for this,
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
, you have to combine that with OFFSET
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Mon, Dec 7, 2009 at 5:49 AM, Dave Page dp...@pgadmin.org wrote:
The new committers are:
Robert Haas
Simon Riggs
Greg Stark
ITAGAKI Takahiro
Congratulations!
+1
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
)
equal or (better) lower than buffers_clean, rigth?
or i'm understanding wrong?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
COMMIT nor
ROLLBACK; if you aren't inside a server-side function then you cannot
use IF
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
be exactly one
match.
Am I just missing something obvious, or does postgresql (currently) not do
that?
postgres will look at all tables involved, i think there is work to
make it smart enough to make what you describe but that's in the
future...
--
Atentamente,
Jaime Casanova
Soporte y
the ROLLBACK never
executed based on... reponse time? very unscientific (there are plenty
other reasons for that to happen)
[1] http://www.postgresql.org/docs/8.3/static/tutorial-transactions.html
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
On Wed, Jan 28, 2009 at 12:56 AM, Abdul Rahman abr_...@yahoo.com wrote:
What do the logs show?
Message just showed the time it took to delete certain number of records.
can you show that message? copy 'n pasted from logs!!
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
starting up again
none of these are saying the time for some records being deleted, read
my prior post about why is not possible that message (commit never
executed)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel
are all executed inside a transaction then
they all were rollback if not only the last one (the one that
generates the error) was rolledback
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql
4;
ERROR: syntax error at or near WHERE
LINE 8: WHERE
^
the WINDOW specification goes after the WHERE clause not before
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
triggers que tenga una tabla
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
can
use list pgsql-es-ayuda
(http://archives.postgresql.org/pgsql-es-ayuda/).
oops! i answered in spanish too! i never saw the list it was sent to...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
Hi,
currently i'm trying to $SUBJECT, my actual approach is to look at
n_tup_upd and n_tup_hot_upd assuming the more near they are the
better... is that a good assumption? what else can i see?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
this error can you show what were you doing?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Hi,
any one has doing this... is there a good tutorial o directions for it?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Thu, Dec 4, 2008 at 4:02 AM, Richard Huxton [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
we created an user to him and give him privileges to pg_locks and
pg_stat_activity (and the functions pg_stat_activity is calling) but
still he see the columns that comes from the functions as null
tried that configuration?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
(and the functions pg_stat_activity is calling) but
still he see the columns that comes from the functions as null... is
there a way to give him access to that data without give him
superuser?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil
, and no
recoverable data.
the worst part of learning the lesson ;)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Wed, Dec 3, 2008 at 4:30 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Wed, Dec 3, 2008 at 2:29 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Wed, Dec 3, 2008 at 2:23 PM, Jaime Casanova
[EMAIL PROTECTED] wrote:
On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote:
On Wed
by the table (ie: serial
or manually created and owned) or is a manually created and maked
default sequence? maybe a flag?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list
,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
would a lazy millionaire do other than
programming for fun?
read dozens of mails from a forum?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general
about RAISE NOTICE?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
the majority of rows in a table, so that the steady-state size of the
table can be shrunk substantially with VACUUM FULL's more aggressive
approach. Use plain VACUUM, not VACUUM FULL, for routine vacuuming for
space recovery.
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría
returned successfully with no result in 58 ms.
don't do it in pgAdmin but in psql
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
this:
http://www.postgresql.org/docs/8.3/static/anoncvs.html
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
can make your own wrapper in ine of your includes:
#define VARATT_SIZEP(_PTR) \
VARATT_SIZEP_DEPRECATED(PTR)
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql
to off;
copy command;
set synchronous_commit to on;
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Fri, Aug 1, 2008 at 3:32 PM, Alex Vinogradovs
[EMAIL PROTECTED] wrote:
Isn't hash indexing implementation non-WAL ?
yes, but that's because no one thinks is worth the effort of making
them WAL logged while they keep slower than btree...
--
regards,
Jaime Casanova
Soporte y capacitación de
logged the only way to
re-create them after a recovery is with a REINDEX... dropping the
index and create after the bulk is just the same, i think...
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list
sleep :)
it's there for older application like yours
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
analyze of the query and rollback the
transaction
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
or
pg_index.indisready depending on version).
if i mark the index not ready (using pg_index.indisvalid or
pg_index.indisready depending on version), will the index be updated
if in another transaction i make an insert?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil
:
INSERT INTO b(id, email_a, name_a) VALUES (33,'[EMAIL PROTECTED]','bill');
and in the trigger fill the tot column
--
regards,
Jaime Casanova
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
EXECUTE 'create temp sequence seq1';
EXECUTE 'select nextval(' || quote_literal('seq') || ') ';
the same apply for all kind of temp objects, in 8.3 this no longer
will be an issue
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better
overkill for this
application.
what about using to_ascii() ?
http://www.postgresql.org/docs/8.3/static/functions-string.html
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
lista de la comunidad
hispana ([EMAIL PROTECTED])
i think you already did it, just write a mail to the list address...
but, this is an english list... so write in english or better write to
the spanish list ([EMAIL PROTECTED])
--
Atentamente,
Jaime Casanova
Programming today is a race between
te sirva - hope it helps you
--
Atentamente,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning
partitioning
just yet.
postgres uses datafiles from up to 1GB, if a table has more data than
that limit then postgres creates more files.
http://www.postgresql.org/docs/8.2/static/storage-file-layout.html
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving
optimization is the root of all evil?
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning
hacker, there is a good chance it
could be included in 8.4.
really? i don't remember it? can you point me where that patch is?, i
can't find it, either
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs
,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning.
Richard Cook
that mysql inserts a commit immidiatelly
after a DDL but this one example shows the thing is worse than that.
if that is the case this 3 rows should have been gone with the
rollback.
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better
...
sadly enough, i don't have an informix database at hand to confirm if
my memory has no corrupted indexes ;)
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger
to rewrite
those operations to the equivalents on the tables... that way you will
have your TRIGGERS validating the data...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce
://archives.postgresql.org/pgsql-general/2005-12/msg00487.php
http://dev.mysql.com/doc/refman/5.1/en/join.html
(Join Processing Changes in MySQL 5.0.12)
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
valido si existe o no el indice para luego
eliminarlo ??
Gracias.
from 8.2 you can do:
DROP INDEX IF EXISTS name ;
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger
of the script and ROLLBACK at the end until you fix all
messages)...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning
many minutes, I kill the
creation with Ctrl+c.
perhaps the table is locked, view in pg_locks...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots
On 1/18/07, Steve Atkins [EMAIL PROTECTED] wrote:
Anyone else get spam from EnterpriseDB today, talking about
Postgresql Support Services?
yes...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs
by now.
Hopefully whoever is responsible is cleaning out their desk this afternoon.
please, no!!
just be more careful...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce
for that...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning.
Richard Cook
.
regards, tom lane
IIRC, you can do it using CREATE TEMP TABLE t1 ON COMMIT DROP AS query
but i think this new in 8.2
why not extending this to SELECT INTO TEMP?
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger
want to do it yourself then you should get the sources and compile...
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe
: 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
upgrade
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs
1 - 100 of 230 matches
Mail list logo