word.
It can decouple DB schema from the application or it can increase the
coupling.
Choosing JS for performance in the stored procedure realm is going to
encourage coupling and make scalability harder and it is going to become
a mess when you'll need to refactor.
[1] https://en.wikipedia.org/w
something.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/ (EPR) very postgres oriented, same family of odoo
supporting postgres.
Still looking for some good advice.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
me, but I don't have that much
experience managing Java on the web.
https://www.odoo.com/ supports postgres but it is an ERP and it is far
more complicated than I would like.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list
Hi,
I was looking for a open source CRM, PHP or python based, with a large
community where Postgresql is a first class citizen.
I'd prefer ease of use over features.
Thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it http://www.borgonovo.net
--
Sent via pgsql-general mailing list
most people perceive as the mainstream if you don't have
a big marketing dept lying.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Where can I check in which version the default setting for fsync was
changed?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
get hung on the comma and extra set of
parenthesis?
ivan@dawn:~$ psql -h lan test -c 'drop function process_table
(action TEXT, v_table_name varchar(100));'
DROP FUNCTION
ivan@dawn:~$
the psql command all on the same line.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via
On Wed, 16 Nov 2011 09:17:45 +0100
Thomas Kellerer spam_ea...@gmx.net wrote:
Ivan Sergio Borgonovo, 16.11.2011 01:01:
test=# begin;
create or replace function process_table (
action TEXT, v_table_name varchar(100)
) RETURNS BOOLEAN
AS $$
DECLARE
BEGIN
return
(
action TEXT, v_table_name varchar(100)
);
commit;
BEGIN
CREATE FUNCTION
DROP FUNCTION
COMMIT
test=#
Repeat just the input parameters.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
going on?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 7 Nov 2011 19:07:29 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
2011/11/7 Ivan Sergio Borgonovo m...@webthatworks.it:
On Mon, 7 Nov 2011 17:55:11 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
this is know bug/feature based on caching plans
What puzzled
-and-return-tsvectors-tables
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
than anything else?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 08 Aug 2011 05:38:02 +0800
Craig Ringer ring...@ringerc.id.au wrote:
On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringerring...@ringerc.id.au wrote:
By the way, one of the reasons you're not finding much free
hosting
if you succede to make it
work.
Does this project has any chance to be included in contrib? It seems
alive and kicking.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Is there a place where I can find comparison in performances of
different postgresql versions, hopefully related to new
feature/improvements?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
by
ioi.idordine,
ioi.grupposped,
ioi.idart,
ioi.qevasa, ioi.qfuoricat, ioi.qinris,
ioi.qnonpub, ioi.qann, ioi.qord, ioi.qpren,
ioi.qrichpag, ioi.qinriass, ioi.qinesa
;
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
On Tue, 10 May 2011 15:59:07 +0200
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
Sorry for the noise. The csv was automatically generated. The code
was right but during generation there was some problem with the box
generating it (php segfaulting) and there were some unclosed quotes
in a much
to know if there is any cleaner
solution for 8.3.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
61 20 46 | 61 65 6E 74 | 69 6E 61 2C
20 35 33 0D | 0A 22 09 22 | 35 30 30 31 | 34 22 09
\tVia Faentina, 53\r\n\t
What am I missing?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the problem you're encountering.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the license of the above didn't help to make
people willing to improve and make the code more popular.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
. I know one of the statement. I'd
like to know the other.
How?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 08 Nov 2010 15:45:12 -0500
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I get
DETAIL: Process 24749 waits for ShareLock on transaction
113443492; blocked by process 25199. Process 25199 waits for
ShareLock on transaction 113442820
not really sure how to add a
semaphore...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to know which statement
were producing the lock?
One for sure was the update.
On 28 Oct 2010, at 19:28, Ivan Sergio Borgonovo wrote:
I'm running this query when I'm the only user and this should be
the only thing running.
update catalog_items
...
from (
select a.id, a.codice
On Fri, 29 Oct 2010 10:21:14 -0400
Vick Khera vi...@khera.org wrote:
On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
What I'm planning to do is:
max_connections = 5
shared_buffers = 240M
work_mem = 90MB
maintenance_work_mem = 1GB
max_fsm_pages
On Thu, 28 Oct 2010 08:58:34 -0400
Vick Khera vi...@khera.org wrote:
On Wed, Oct 27, 2010 at 10:26 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I'm increasing maintenance_work_mem to 180MB just before
recreating the gin index. Should it be more?
You can do this on a per
;
end;
$$ language plpgsql volatile;
What could it be? how can I fix it?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 28 Oct 2010 13:57:18 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I'm running this query when I'm the only user and this should be
the only thing running.
And I get
DETAIL: Process 7188 waits for ShareLock on transaction
surely drop the gin index and recreate it when everything is
over.
I'm not sure if it's a good idea to drop the triggers since I'll
have to update the tsvectr later and I suspect this will cause twice
the disk IO.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
of single statement
update
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
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, 28 Sep 2010 20:19:10 +0200
Alban Hertroys dal...@solfertje.student.utwente.nl wrote:
On 28 Sep 2010, at 12:49, Ivan Sergio Borgonovo wrote:
The hardware on the 2 machines is a bit different.
MS SQL 2005 runs on a box that is 2 years old, 2 SATA drives on
RAID 1 hw, 2 Xeon dual core
.
What about the ratio of R/W? If it is a mostly read system is the
memory/IO throughput still a limiting factor for increasing
shared_buffers?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
-pc-linux-gnu, compiled by GCC cc (GCC)
4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, locks, solved bug (it is a reasonably old
version)...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 12 Aug 2010 12:50:49 +0100
Thom Brown t...@linux.com wrote:
On 12 August 2010 12:14, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I've
delete from catalog_items where ItemID in (select id from
import.Articoli_delete);
id and ItemID have an index.
catalog_items is ~1M
On Wed, 28 Jul 2010 22:24:07 -0700
Joshua D. Drake j...@commandprompt.com wrote:
On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
BTW up to my memory Django suggest postgres. I haven't seen any
benchmark of Django with pg vs mysql.
Django was originally developed
python/django based cms are flourishing... and given
Django originally supported DB was Postgres...
http://www.django-cms.org/ [1]
Migration of Onion from Drupal/Mysql - Django/Postgresql is
emblematic.
[1] I think I could make a quick benchmark if possible on postgresql
and mysql
--
Ivan Sergio
Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/d1/content/howto-duplicating-schema-postgresql
and
http://www.webthatworks.it/d1/content/excluding-some-tables-data-backup-including-their-schema
makes a breeze to duplicate sites.
And you can still conserve all triggers pk, fk, on duplicate
cascade...
--
Ivan Sergio Borgonovo
http
On Wed, 28 Jul 2010 18:56:56 -0400
Greg Smith g...@2ndquadrant.com wrote:
Ivan Sergio Borgonovo wrote:
Are there companies that offer drupal/postgres tuning?
I am quite sure that Command Prompt would be happy and fully
prepared to sell you Drupal + PostgreSQL tuning services. We also
have
If I'd like to learn how to manage resources in postgres and grant
different users different time slot/memory/CPU?
eg. I'd like to grant to user A to execute queries that last less
than 1min or that occupy no more than X Mb... etc...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
On Fri, 16 Jul 2010 19:43:01 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
On 16/07/10 19:21, Ivan Sergio Borgonovo wrote:
If I'd like to learn how to manage resources in postgres and
grant different users different time slot/memory/CPU?
eg. I'd like to grant to user
tools.
[1] I find some inconsistency of mysql a bit painful to live with...
as I find some inconsistency in PHP equally irritating but they are
there, quite diffused and still for certain domains the best
compromise available.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
quadratically painful.
I perfectly agree. But maybe the number of hackers involved in a
project could grow faster if the project serves more purposes.
Reuse lower maintenance costs too.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
advantage
while they could write a better one that at least wouldn't make a
pain to post the application.
When thinking about portable code I generally find this documents
useful:
http://sql-info.de/postgresql/postgres-gotchas.html
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
but I'm worried this may incur in some overhead
I currently can't afford.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
experience to share on upgrading from source on Debian?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
was actually thinking to test 9.0 in my /home on some real world
DB. That could be a chance to learn how to upgrade from source.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
if;
end if;
_Authors := '';
end if;
_ItemID := _row.ItemID;
_Name := trim(E' \t' from _row.Name);
if(length(_Name)0) then
_Authors := _Authors || ', ' || _Name;
end if;
end loop;
return;
end;
$$ language plpgsql volatile;
--
Ivan Sergio
On Fri, 07 May 2010 10:29:20 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I've been having this:
psql:include/custom/import_update.custom.sql:63: ERROR: deadlock
detected DETAIL: Process 13349 waits for AccessExclusiveLock on
relation
of:
http://www.webthatworks.it/d1/node/page/excluding_some_tables_data_backup_including_their_schema
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
)
that looks it can handle both jobs (apache and pg) at a reasonable
speed (roughly twice faster than needed) but that is still a bit
slower than what I'd like on catalogue updates.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
into catalog_related (itemid,
related_itemid, rank) ^
HINT: You will need to rewrite or cast the expression.
PostgreSQL 8.3.4 on x86_64-pc-linux-gnu
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
I've finished to write an extension to manipulate tsvectors and
tsquery in C.
I think it could be useful for someone else and I think I may take
advantage at someone else looking at the code too.
What would be the right place where to publish the code and how?
--
Ivan Sergio Borgonovo
http
...
There is no other function named catalog_relateditems
I'm on 8.3.9 debian lenny
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 3 Mar 2010 16:05:29 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I've a function defined as:
create or replace function catalog_relateditems(__itemid bigint,
families int[]...
Forget about it... there was a typo (missed out) that mixed in/out
parameters.
Sorry
On Wed, 03 Mar 2010 10:22:31 -0500
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I've a function defined as:
create or replace function catalog_relateditems(__itemid bigint,
families int[]...
If you want any useful comments, you're going to have
the debian lenny version in a new virtual
machine.
Meanwhile if someone could give a glimpse to the source it would be
really appreciated.
http://www.webthatworks.it/d1/files/ts_utilities.tar.bz2
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql
On Thu, 11 Feb 2010 20:11:54 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I'm still having trouble making this work:
http://pgsql.privatepaste.com/14a6d3075e
I tried to play with
item-operator.left
to see if reshuffling the expression could make any difference.
item-operator.left
()
#11 0x005a6c68 in ?? ()
#12 0x005a7b30 in PostmasterMain ()
#13 0x0055aaae in main ()
version is:
PostgreSQL 8.3.9 on x86_64-pc-linux-gnu, compiled by GCC
gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general
How am I supposed to output multibyte strings in an errmsg (and Co.)
as in
errmsg(operator not permitted '%s', mbstring)
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On Thu, 11 Feb 2010 20:11:54 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I'm still having trouble making this work:
http://pgsql.privatepaste.com/14a6d3075e
Finally I got it working, not the above version anyway...
CREATE OR REPLACE FUNCTION tsvector_to_tsquery(IN tsv tsvector
version I've posted
but still it returns an empty tsquery.
Things that works:
- tsvector_tsquery_size returns reasonable total length of strings
and total number of (operand + operator)
- curout is actually filled with a lexeme
- filters (wf, posmax) work
--
Ivan Sergio Borgonovo
http
storing
part of documents in precomputed tsvectors with no weight and then
build up a search with merged tsvectors with weights using ts_rank.
OK.. trying to finish up my tsvector_to_tsquery function in a
reasonable way first.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via
...
);
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to tsvectors without
positions?
Is there any use-case?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of adding weights to
vectors with no position
b) I missed any obvious way to add weights to tsvectors that were
initially without positions
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this
select
date '2008-05-01' + i
from generate_series(0,
(date '2009-12-10' - date '2008-05-01')) s(i);
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
them in practice in some
C functions that taken a tsvector build up a tsquery to be used to
find similar documents.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
:
http://www.webthatworks.it/d1/node/page/pseudo_random_sequences_postgresql
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the rank for each of them.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
( 'java':A | 'java':B ) | 'java':C
(1 row)
I did try to pass them through nodetree... but the result keeps on
being different.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
:
setweight(vector tsvector, weight char) returns tsvector
Am I missing them? Is that use supported in future versions?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Mon, 25 Jan 2010 12:01:04 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I think I've learned how to use pg text search from Oleg and Teodor
documentation since I've found on my code this use of setweight:
query := query
setweight(configuration, 'banana apple orange', 'B
lexemes may be
important... but well deciding what's important is another can of
worms... and as anticipated ts_rank should be good enough for me.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
[], lexeme text
record
- will turn a tsvector + operator into a tsquery
'orange':A1,2,3 'banana':B4,5 'tomato':C6,7 -
'orange':A | 'banana':B | 'tomato':C
or eventually
'orange':A 'banana':B 'tomato':C
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
On Wed, 20 Jan 2010 17:43:27 +0100
Adrian von Bidder avbid...@fortytwo.ch wrote:
On Wednesday 20 January 2010 15.42:14 Ivan Sergio Borgonovo wrote:
I'd also appreciate some suggestion about dev environment and
best practices on Debian, something that could help me to
compile, install, test
On Fri, 22 Jan 2010 11:02:46 -0500
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
If I had to build stuff in the pg source tree I'd just clone a
contrib directory and change the makefile [1]. What am I
supposed to do if I'd like to create a contrib
string_to_array
select (string_to_array('tano pino gino', ' '))[i] from
generate_series(1, 3) s(i);
You'd get the idea... to get the length of the array you've
array_length.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Tue, 19 Jan 2010 10:12:21 +0100
Dimitri Fontaine dfonta...@hi-media.com wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I'd appreciate any pointer that will quickly put me on the right
track.
I'd guess you begin here:
http://wiki.postgresql.org/wiki/Developer_FAQ
practices on Debian, something that could help me to compile,
install, test easily on Debian.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Wed, 20 Jan 2010 16:56:04 +0100
Dimitri Fontaine dfonta...@hi-media.com wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I haven't been able to find anything better than the online
manual and pg source code to learn how to write extensions.
Maybe this will help:
http
of the
function.
I grep throu contrib and I wasn't able to find anything that really
enlighted me about BlessTupleDesc.
I'll try to see if tomorrow things will look clearer.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
I'd like to extend full text search so that I can transform tvectors
in tquery and have direct access to a tvector as a record/array.
I'm on Debian.
This is my first experience with pg source code.
I'd appreciate any pointer that will quickly put me on the right
track.
thanks
--
Ivan Sergio
since tsvectors store
positions too, but it will be a step forward in making easier to
compare documents to find similar ones.
An operator that check the intersection of tsvectors would come
handy.
Adding a ts_rank(tsvector, tsvector) will surely help too.
thanks
--
Ivan Sergio Borgonovo
http
?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in plpgsql.
Am I missing something?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to the client and
then build the tsquery there and send it back to the server.
I'm on 8.3 but I don't think it makes any real difference for this.
Sorry if I'm still missing the obvious.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
the children should have their own pk and not share them.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 11 Jan 2010 12:30:45 -0500
Francisco Reyes li...@stringsutils.com wrote:
Ivan Sergio Borgonovo writes:
Is there a way to know/estimate how much is left to complete a
restore?
Not sure on plain ASCII files but if your pg_dump used Fc then at
restore you can pass the -v flag
On Mon, 11 Jan 2010 18:36:18 +
Sam Mason s...@samason.me.uk wrote:
On Fri, Jan 08, 2010 at 11:28:15AM +0100, Ivan Sergio Borgonovo
wrote:
Is there a way to know/estimate how much is left to complete a
restore?
maybe something like pv would help?
http://www.ivarch.com/programs
dynamically the statement as a list of union or
building up a view is there any other way?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tweak in pg config to make it faster?
For dev only... could I just stop the dev server, copy the *files*
on flash and mount them on the notebook?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
were looking for?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 28 Dec 2009 21:20:17 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
pg_dump -Fc -Z9 -s -t *.cache* -d mydb schema_only.bak
pg_dump -Fc -Z9 -T *.cache* -d mydb nearly_full.bak
cat nearly_full.bak schema_only.bak | pg_restore -1 -d mydb
It seems it is working... I'll test
1 - 100 of 520 matches
Mail list logo
