rol.
if you have 9.3 or superior you can know how big is that pending list
installing pgstattuple.
CREATE EXTENSION pgstattuple;
SELECT * FROM pgstatginindex('tridx_logs_01_msg');
NOTE: remember that pending_pages is expressed in 8kb-pages
if that is the problem or if you are in <= 9.2 then try
pendency libraries.
Now. the data 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-gen
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick wrote:
> 2013/10/4 Jaime Casanova :
>> 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 the functions fro
-- Forwarded message --
> From: Shahzad Bashir
> Date: Thu, Oct 3, 2013 at 5:43 AM
> Subject: RE: [ADMIN] Database replication to 50-80 nodes
> To: Jaime Casanova
>
>
> hi,
> I am very much new to postgres, infact just started... can anyone please share
On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova 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 ne
ming.
but it would be a good 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 m
nel... it will cause more
problems than the one it solves.
what you can do is:
1) execute:
SET enable_hashjoin TO OFF;
SELECT here
RESET enable_hashjoin TO ON;
2) in a function:
CREATE FUNCTION do_something() RETURNS bigint AS
$$
SELECT here
$$ LANGUAGE sql SET enable_hashjoin TO OFF STABLE;
't get
reformatted 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)
and then you can have "partitioned" tables, while the system consider
them almost independent tables (they are dependent only in the sense
that if you read 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 ta
th the `pg_ctl
> restart` approach, or is it safe to use?
>
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 cha
n't tried.
anyway 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: Sopor
end 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
server "set synchronous_commit 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
you can see an estimate of how 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 sub
wo tables that logs all changes in
the database... normally 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
the "Migration 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: Sopo
On Wed, Jul 27, 2011 at 7:24 PM, Toby Corkindale
wrote:
> On 28/07/11 03:47, Jaime Casanova wrote:
>>
>> On Wed, Jul 27, 2011 at 4:36 AM, Toby Corkindale
>> wrote:
>>>
>>> So that looks good, but then I try this on the slave:
>>> # repmgr -f /e
;cannot cast type boolean to text"
are you aware 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-
while archive_command can 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 (p
.2 port=5432 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 subscripti
');
>
> 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
insert into request_queue (request_id, received_time
>
> )
>
> values (new.request_id, SYSTIMESTAMP
>
> );
>
>
>
> How can I insert a dynamic timestamp value in postgress, please?
>
Maybe this document can help
ght as well run analyse immediately on that table.
>
> My table is a read-only table after all.
> That's another reason why I'm reluctant using ANALYZE .
>
sorry, i don't follow that... why do you think that a read-only table
doesn't need an ANALYZE?
--
Jaime Casano
itial date and now()::date - '1 day' 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/pgsql-general
ll tables
> I'm used 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.2n
On Wed, Apr 27, 2011 at 1:48 PM, Dave Page 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
hive_command='exit 0'
max_wal_senders =
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
ave 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
Profe
p; restore the only real way to do this?
>
it's safe to just install any version of 8.2.x, copy the whole data
directory (plus any tablespace's directories you could have) and start
again... probably you want to REINDEX your indexes (read the release
notes to see what specific kind of in
On Tue, Jun 8, 2010 at 12:49 PM, Jeff Amiel 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 P
r r 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)
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 chang
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 - Ecuador
Cel.
OUNT
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 subscript
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-gener
On Wed, Jan 13, 2010 at 11:31 AM, Amy Smith 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
before update
on test1 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 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 capacitac
but must be 4.
no. b value "must 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í
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 (p
E?
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
ith anyone trying to change 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
t using cursor is another (preferred?) 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/mailpref/pgsql-general
that's basically LIMIT, 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
On Mon, Dec 7, 2009 at 5:49 AM, Dave Page 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 si
;t
> have, so what you describe is what we would expect.
>
then we have a bug (at least in 8.3, haven't tried in 8.4)... i see
this a month ago, an autovacuum blocking a lot of concurrent updates
and selects... once i pg_cancel_backend() the autovacuum process the
other ones starting
ast)
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.or
at or near "IF"
>>
if you're inside a server-side function then you cannot use 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
Gua
.
>
> 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 capac
hine actively refused it.
> 2009-01-27 18:52:08 LOG: unexpected EOF on client connection
>
guess this messages are received after the CANCEL QUERY
if the series of deletes are all executed inside a transaction then
they all were rollback if not only the last one (the one that
generates the error
09:42:15 LOG: database system is ready
> 2009-01-28 09:42:15 FATAL: the database system is starting up
>
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)
--
Atentament
On Wed, Jan 28, 2009 at 12:56 AM, Abdul Rahman 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 P
ink 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 sistem
nk
> FROM
>foo
>WINDOW w AS (partition by typ order by ts desc)
> WHERE
>foo_rank < 4;
>
> ERROR: syntax error at or near "WHERE"
> LINE 8: WHERE
>^
the WINDOW specification goes after the WHERE clause not before
--
Atentamente,
25%
5 47%
then only partial indexes on values 1 and 2 are of some value
--
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
ow it) - you 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 - Ecu
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://www.postgresql.org/ma
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 sis
s 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 sub
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 se
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
s failed. Two postmasters, one data area, 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 li
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
ny one has 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 subscrip
ys this
>
can we make \d show if the sequence is owned 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 - E
predefined statements?
--
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
lazy millionaire :)
>
> I don't quite understand you here. I'm sure we all crave the lazy
> millionaire bit, but what would a lazy millionaire do other than
> programming for fun?
>
read dozens of mails from a forum?
--
Atentamente,
Jaime Casanova
Soporte y capacitació
> directly but you can implement using dblink or a plperl function that
> connects back to the database.
>
what about RAISE NOTICE?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsq
helpful.
VACUUM FULL is recommended for cases where you know you have deleted
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
spa
5;
> commit;
> Query result with 2 rows discarded.
>
>
> Query 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) 87
/wiki/Working_with_CVS
>
that is for setup your local copy of the repository, you should only need 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
you really need it maybe you
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 m
;
insert...
insert...
...
commit;
or
set synchronous_commit 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)
hat? if they are non WAL 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-
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,
Ja
maybe the add_missing_from parameter in postgresql.conf is what you
need to get some 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
NCURRENTLY you could
> mark the index not ready to use yet (see pg_index.indisvalid 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
them... the effect, most of the time, is that
indexes will not be used but you can't be sure...
the better solution was the first one: dropping the index inside a
transaction, execute the explain analyze of the query and rollback the
transaction
--
regards,
Jaime Casanova
Soporte y ca
LUES (33,'[EMAIL PROTECTED]','bill',
calc('[EMAIL PROTECTED]', 'bill'));
or maybe using a trigger before insert but you're insert should look like:
INSERT INTO b(id, email_a, name_a) VALUES (33,'[EMAIL PROTECTED]','bill');
unction again.
>
create, and use the sequence through EXECUTE
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,
a' to
> 'España'. Searching online, I found a few ideas (soundex, intuitive
> fuzzy something-or-other) but mostly they seem like overkill for this
> application.
>
what about using to_ascii() ?
http://www.postgresql.org/docs/8.3/static/functions-string.html
--
regards,
Jai
los mensajes a la 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
"Program
s.html#PLPGSQL-STATEMENTS-RETURNING
espero que 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
> I'm wondering what are these since I've not set up table 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
--
any
> benefit in this scenario.
>
do you know that early 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
ch) we had the semblence of a patch and an actual plan for
> implementing this, but no one got interested enough to finish it for 8.3.
> Should you happen to know an ambituous C hacker, there is a good chance it
> could be included in 8.4.
>
really? i don't remember it? can you po
--
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."
n informix is better than oracle in this point. last time i try
this on informix it did the right thing...
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 so
0 sec)
Tom's example seems to show 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
e, CREATE VIEW
on top and use an INSERT/UPDATE/DELETE rule on the view 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
b
at this thread
http://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 progra
. Como 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
the creation never finish and finally, after 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 un
beginning 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, th
7;s possible to stick it into an INTO TEMP clause.
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 ra
-announce, and they know it.
i thought there is a list 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 bi
he marketing weenies might know
better 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-pr
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
help you?
if you 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
1 - 100 of 233 matches
Mail list logo
