I've some tables that are just cache.
I'd like to just dump the table schema without dumping the table
contend.
I think I could do it in 2 steps but I'd like to avoid it.
Is there a way?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
On Mon, 28 Dec 2009 19:39:36 +
Raymond O'Donnell r...@iol.ie wrote:
On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
I'd like to just dump the table schema without dumping the table
contend.
pg_dump -s -t table name db name
My fault. I was not clear enough.
I'd like to make
that will make reporting easier/faster.
--
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, 17 Dec 2009 10:38:32 +0100
A. Kretschmer andreas.kretsch...@schollglas.com wrote:
In response to Ivan Sergio Borgonovo :
I've a web application.
I'm logging data related to the landing page and subsequent
selected hits.
create table track_hit (
hitid serial not null
regexp? Can accents be ignored during searches?
--
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, 1 Dec 2009 11:39:06 +0900
Schwaighofer Clemens clemens.schwaigho...@tequila.jp wrote:
On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I need to create a new schema with all the content in an existing
one, just with a new name.
The way I've found
On Tue, 1 Dec 2009 09:53:12 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
On Tue, 1 Dec 2009 11:39:06 +0900
Schwaighofer Clemens clemens.schwaigho...@tequila.jp wrote:
On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I need to create a new
?
--
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
even knowing the reason.
--
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, 18 Nov 2009 11:38:46 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/11/18 Ivan Sergio Borgonovo m...@webthatworks.it:
On Tue, 17 Nov 2009 20:16:36 -0800
David Fetter da...@fetter.org wrote:
On Tue, Nov 17, 2009 at 09:33:05AM -0700, Konstantin Izmailov
wrote:
Some
part of it
and on the fall back on our beloved DB.
I think there are far more people knowing just one DB and badly than
companies with such strict (insane) policies and... well PostgreSQL
is very standard compliant.
I'd beat another horse ;)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
sequence
alter table ... owner to
alter sequence ... owned by ...
alter table ... set default ...
Is there a less painful approach?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
;
In this case test.mytable will be chosen.
Is there a way to ask postgresql the schema of the table that will be
chosen?
--
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 Thu, 12 Nov 2009 10:38:27 +
Richard Huxton d...@archonet.com wrote:
Ivan Sergio Borgonovo wrote:
I have a search_path that may not just consist of $user, public.
eg.
$user, public, test, import
I'd like to know which table is going to be chosen if I do a
select * from mytable
a tagged csv.
Currently I'm mostly looking around to see where it would be
convenient to move the boundaries of the problem.
I'd be curious about what kind of performance impact they may have
compared to COPY.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general
is
needed for shop_commerce_gift_giftcode_key constraint
was it something that was fixed between the releases or I just
didn't take note of what I really did in the staging box?
btw I was using the same pgsql version from my desktop to \d the
tables.
--
Ivan Sergio Borgonovo
http
On Mon, 02 Nov 2009 09:53:06 -0500
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
This statement succede in 8.3.8
alter table shop_commerce_gift drop constraint
shop_commerce_gift_pkey;
but failed in 8.3.4.
Uh, that doesn't seem to match the name
in pw_res.
--
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
. Every issue you've
described so far is database design 101 and should present no real
problem. I think you're agonizing over nothing...
That's always a good advice. Sometimes you're out just for moral
support.
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql
filling
pw_resource.
I could make the constraint deferrable, add a on delete cascade to
pw_email.password but:
- I'm not sure it is a good design
- I'm still not sure it can work as expected
Before testing if it can work I'd like to hear some comment on the
design.
thanks
--
Ivan Sergio Borgonovo
On Tue, 27 Oct 2009 09:17:59 +
Richard Huxton d...@archonet.com wrote:
Ivan Sergio Borgonovo wrote:
Hi,
I've to generate unique password and associate them with emails.
Association with emails is just to mail the password, email +
password aren't the password, just the password
query.
Any clean technique?
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, 26 Oct 2009 14:15:26 +0100
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I've a list of emails and a list of users (with emails).
If the list of emails was already inside a table
create table mails (
mail varchar(64)
);
create table users (
name varchar(127),
mail
On Mon, 26 Oct 2009 14:56:26 -0400
Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
To make it more concrete I came up with:
select coalesce(u.mail,j.mail) from (
select (array['m...@example1.com','m
, yourinput)
(or ts_rank_cd)
--
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
~ 'gino' AND summary ~ 'pino')
you just need to weight the input query as well
inputquery := setweight(cfg, inputtitle, 'A', '');
inputquery := inputquery setweight(cfg, inputsummary, 'B', '');
...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
now ts_rank* are black boxes for me. I envisioned I may enjoy
some finer tuning on ranking... but currently they really do a good
job.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
that explain in more
details setweight?
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
assigned to a group
already.
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 Thu, 20 Aug 2009 14:31:02 -0400
Alvaro Herrera alvhe...@commandprompt.com wrote:
Ivan Sergio Borgonovo wrote:
I've
create table pr(
code varchar(16) primary key,
...
);
create sequence pr_code_seq owned by pr.code; -- uh!
actually stuff like:
alter table pr drop column
with temp tables IME.
Why?
you mean that since you generally use temp table for computation and
looping several times over the table... a more expressive language
would be suited?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
)),7 , to_hex((rand()*2^31)::int)
);
I was wondering if there is any better way to get alphanumeric
random string quickly. Since uniqueness is assured by passing a
sequence to fesitel_encrypt, I just need turning into to
alphanumeric quickly.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
code;
or just
drop table pr
seems to work as expected (they drop the sequence too).
Should I be concerned of anything since it looks like a hack?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
That's a common problem you may just have to adapt to plpgsql.
[1]
select s.i, feistel_decrypt(s.i) from generate_series(0,16) as s(i)
order by feistel_decrypt(s.i)
did it in a hurry... didn't check
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
to dynamically build the query on the client
side.
--
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 int example there with the text one.
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
of permitted (table, key) and
then just pass the table and the key value.
What should be the equivalent of quote_ident in PHP?
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
.
Sometimes ago Daniel Verite posted an implementation of a fiestel
cipher in plpgsql.
I'm happily using it to generate pseudo-random hex strings.
--
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
I've
create or replace function(...
declare
col1 varchar(32);
...
create table pippo(
col1 varchar(32),
...
Unfortunately I can't schema specify the column to avoid name
overlap.
Is there another way other than just simply rename the variable?
thanks
--
Ivan Sergio Borgonovo
http
On Tue, 4 Aug 2009 16:01:58 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
I've
create or replace function(...
declare
col1 varchar(32);
...
create table pippo(
col1 varchar(32),
...
Unfortunately I can't
-PostgreSQL-Databases-and-Servers.html
http://www.postgresql.org/docs/8.3/static/dblink.html
--
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 manage
this situation so that I could make it as simple as possible AND
lower as much as possible the chances that the transaction will have
to be rolled back.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
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
versions they come from).
--
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
correct the comments.
--
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
option was pg for licensing reasons.
Or am I misunderstanding what you wrote? or... am I plainly wrong?
--
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
.
I'm not planning to use pg_pconnect.
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 Tue, 07 Jul 2009 12:07:48 +0200
Daniel Verite dan...@manitou-mail.org wrote:
Ivan Sergio Borgonovo wrote:
r2:=l1 # 1366.0*r1+150889)%714025)/714025.0)*32767)::int;
-- but what about this? where does it come from?
This function:
(1366.0*r1+150889)%714025
implements
END;
$$ LANGUAGE plpgsql strict immutable;
Anything else to suggest or copy from?
--
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
it
I have to rewrite the function to customize it.
Is there a generic way to do this? An aggregate maybe?
array_accum
http://www.postgresql.org/docs/8.2/static/xaggr.html
?
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
was thinking to automate the application of schema changes with a
hook in svn, but right now it doesn't look as a good investment.
Still I'm very interested in techniques to version schema changes
and bring them together with code change and being able to diff them.
thanks
--
Ivan Sergio Borgonovo
http
with a general replication solution?
The applications I mostly deal with are e-commerce sites.
--
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
...
itemlisttemp tables will be very small (30 as an upper limit) and
arrays as well will contain very few elements (4 as an upper limit).
I'm aware of the drawback of de-normalization.
Should I be aware of anything else when using arrays this way?
thanks
--
Ivan Sergio Borgonovo
http
On Tue, 23 Jun 2009 17:39:46 -0300
Emanuel Calvo Franco postgres@gmail.com wrote:
2009/6/23 Ivan Sergio Borgonovo m...@webthatworks.it:
I've a temporary table where I'd like to resume data coming from
several other tables (normalised the usual way).
eg.
a list of items that may
the definition of temp table is very
terse... and a bit confusing (at least for me) about global and
local.
I gave a quick look at what's available on MS SQL... and they have
an sort of in memory temp table but you can't modify its schema.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
On Mon, 22 Jun 2009 11:40:08 +0200
Martijn van Oosterhout klep...@svana.org wrote:
On Mon, Jun 22, 2009 at 09:53:59AM +0200, Ivan Sergio Borgonovo
wrote:
The OS knows much less about what anonymous memory (memory not
backed by a file) means to a program and can't be as clever
On Sun, 21 Jun 2009 10:57:51 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
On Fri, 2009-06-19 at 20:23 +0200, Ivan Sergio Borgonovo wrote:
If I could easily load all the dataset into an array, loop
through it and then just update the computed field it would be
nice... but how
On Sun, 21 Jun 2009 21:43:16 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
On Sun, 2009-06-21 at 14:57 +0200, Ivan Sergio Borgonovo wrote:
I think everything could be summed up as:
select into t myaggregate1(field) from dataset where condition1;
if(t10) then
update dataset
to incur in any disk write.
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
... what about all the UPDATEs involved to change field N+1 of
the temp table? Will be they expensive?
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
as a working strategy.
The restore shouldn't be fragmented.
What are the side effects of a vacuum full?
Any cheaper way to cause a heavy vacuum full or just its side
effects?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On Fri, 05 Jun 2009 17:35:19 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I don't get it.
Why dropping the triggers would cause a deadlock anyway?
I bet it is due to my naïve view of the problem but I think a
trigger is a function. Unless
activity on the table on which the
triggers are acting is minimal if not absent.
But I suspect my understanding of how these things work is very
naive... so some general clue would be appreciated as well.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing
On Fri, 05 Jun 2009 10:46:11 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
I've encountered this error for the first time
psql:./import_stock_scratch.sql:9: ERROR: deadlock detected
DETAIL: Process 11095 waits for AccessExclusiveLock
clockin))/3600 AS NUMERIC),2) AS
hours FROM timeclock;
satisfying?
template1=# select extract(days from ('2009-01-01'::timestamp -
'2008-01-01'::timestamp))+5::int;
?column?
--
371
(1 row)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list
Excel/Access 2003 can't return result sets
coming from functions?
- if Excel/Access can't return results from a function is there a way
to masquerade the function (accepting parameters) behind a
table/view.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general
On Tue, 26 May 2009 11:41:50 +0200
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
I've built some functions just for encapsulation reasons and
avoiding to pass the same parameter over and over.
I'd like to access the result from Excel but it seems (and I'm not
pretty sure
import.transaction from :csvfile
but I get
some.sql:3: :csvfile: No such file or directory
I tried -v --set etc...
Same result.
How can I pass variables to a sql script?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
the overhead of starting a
perl interpreter for that.
Do I have to write the function in C maybe?
Isn't it a job for group by?
select count(*), myvalue from table group by myvalue order by
count(*) desc limit 1;
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general
background but where transactions and some
advanced features are essential to survival I got the impression
that actually even for small SOHO applications even when server and
client are on the same box pg may be a very good choice.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via
On Wed, 20 May 2009 11:59:34 +0100
Raymond O'Donnell r...@iol.ie wrote:
On 20/05/2009 11:49, Ivan Sergio Borgonovo wrote:
I think you could connect from Delphi through ODBC, meybe even on
some .NET driver. I think ODBC should be more mature... but don't
trust me.
You can use ODBC
On Wed, 20 May 2009 06:59:28 -0400
Dave Page dp...@pgadmin.org wrote:
On Wed, May 20, 2009 at 6:49 AM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
]
I was surprised how polished the installation was.
Thanks :-)
Beside the fact I can only thank for all the great work around
as a ''get you started tool. We still expect you to
Exactly.
--
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, 18 May 2009 09:14:41 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
Ivan Sergio Borgonovo wrote:
I'd like to know if:
- it is possible to load in an Excel sheet a table (view, query
result) coming from postgresql and to use those data to do
further computation
Wizard
- replication solution (I wonder if it is easier to have a working
solution with aptitude or Stack Builder)
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
not in aggregates.
Postgresql is a bit stricter than mysql but it generally saves you a
lot of debugging later.
--
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
release but OS
release as soon as 8.4 end up in the backport of 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
/example... doesn't make it clear) why it should be
faster or less invasive?
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 Thu, 23 Apr 2009 12:00:30 +0200
Karsten Hilbert karsten.hilb...@gmx.net wrote:
On Thu, Apr 23, 2009 at 11:33:34AM +0200, Ivan Sergio Borgonovo
wrote:
Karsten Hilbert karsten.hilb...@gmx.net wrote:
On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
I have a set
On Tue, 14 Apr 2009 13:26:24 -0700
Steve Crawford scrawf...@pinpointresearch.com wrote:
Ivan Sergio Borgonovo wrote:
I still have to investigate if the tables are getting really
larger... but at a first guess there shouldn't be any good
reason to see tables getting so large so fast... so I
?
The only thing that should have been really changed is the number of
concurrent connections during a backup.
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
.
Is there anything smaller?
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
month's
is.
Can vimeo movie be downloaded?
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
of small files (even empty) somewhere?
It happened to me when I was running a spider using curl and the
spiders where not exiting properly when another process was killing
them...
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general
a backup?
It was serving more than one DB and I assume that only one is
causing problems. Can I skip just that one from recovery and start
from backup?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Wed, 08 Apr 2009 10:59:54 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Ivan Sergio Borgonovo m...@webthatworks.it writes:
2009-04-08 16:36:53 CEST LOG: startup process (PID 3176) was
terminated by signal 11: Segmentation fault 2009-04-08 16:36:53
CEST LOG: aborting startup due to startup
4681.9%
Richard Huxton 4321.8%
Craig Ringer3381.4%
Ivan Sergio Borgonovo 3141.3%
I just wrote privately to Tom that I'm ashamed I ask so much and
answer so few.
But well I'm an exception ;) I'm the top of non-contributors.
--
Ivan Sergio
doing it.
[1] slow vacuum full and gin index 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
to play it
- several servers that will actually play the media
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 Fri, 3 Apr 2009 02:05:19 +0100
Sam Mason s...@samason.me.uk wrote:
On Thu, Apr 02, 2009 at 09:48:33PM +0200, Ivan Sergio Borgonovo
wrote:
I didn't find any elegant example of cursor use in PHP... OK PHP
is not the most elegant language around... but still any good
exapmle someone could
verylargetable; --no where clause);
vs.
the \copy equivalent
any way to avoid 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
On Thu, 2 Apr 2009 17:27:55 +0100
Sam Mason s...@samason.me.uk wrote:
On Thu, Apr 02, 2009 at 11:20:02AM +0200, Ivan Sergio Borgonovo
wrote:
This is the work-flow I've in mind:
1a) take out *all* data from a table in chunks (M record for each
file, one big file?) (\copy??, from inside
of RAM.
--
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
can concatenate files...).
echo select :a; | psql --set a=3 test
?column?
--
3
(1 row)
of course in spite of piping your sql, you could put it into a file.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
.
Not really a security concern, but an early warning for some mistake.
--
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 php.
Still I wouldn't consider it a first source of slowdown.
For making a difference in plan management you've to use another
family of functions pg_prepare/pg_execute.
I'm not an expert but not every time caching plans is what you'd like
to do.
--
Ivan Sergio Borgonovo
http
- htmlentities is about formatting for web output
- pg_escape_string is to prepare input for sql and avoiding sql
injection
- pg_query_params is a relative of pg_escape_string but somehow used
differently
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing
the correct result. If it gets interpreted
when I create the view it should report an error since those tables
don't exist in the public or group_role schema.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
. Someone may just close you out
from your own home.
Unless you're accessing the server from static IP and you can use
white listing.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
101 - 200 of 520 matches
Mail list logo