On Tuesday 20 January 2009 03:27:14 Henry Interiano wrote:
> Hola a todos
>
> necesito ayuda como configurar mi base de datos como aceptar conexiones ssl
> desde cualquier ip, mi base de datos esta instalada en Windows:
-> pgsql-es-ay...@postgresql.org
--
Sent via pgsql-general mailing list (pgs
Hi all,
I wonder how to find how much postgresql memory consumption is (real, not
allocated) ?
thx.
Hola a todos
necesito ayuda como configurar mi base de datos como aceptar conexiones ssl
desde cualquier ip, mi base de datos esta instalada en Windows:
En donde tengo que hacerlo:
pg_hba.conf
postgresql.conf
Gracias
Henry Interiano
San Pedro Sula, Honduras
___
Thomas Kellerer wrote:
> A B wrote on 18.01.2009 22:43:
> > From the docs:
> > http://www.postgresql.org/docs/8.3/interactive/sql-update.html
> >
> > "According to the standard, the column-list syntax should allow a list
> > of columns to be assigned from a single row-valued expression, such as
On Monday 19 January 2009 22:49:17 Gerhard Heift wrote:
> On Mon, Jan 19, 2009 at 08:19:06PM +0100, Reg Me Please wrote:
> > Hi all.
> >
> > I have a maintenance PL/pgSQL function that needs to recreate a partial
> > index (not a REINDEX, though).
> > In the WHERE condition of the index I have one
Greetings:
I already did some searches on the "pg_restore: [archiver] entry ID
-825110830 out of range -- perhaps a corrupt TOC" error and am still not
sure why my database's not restoring after upgrading the FreeBSD and select
ports such as PostGreSQL. I did see something from a long time ago ab
On Mon, Jan 19, 2009 at 08:19:06PM +0100, Reg Me Please wrote:
> Hi all.
>
> I have a maintenance PL/pgSQL function that needs to recreate a partial index
> (not a REINDEX, though).
> In the WHERE condition of the index I have one of the function arguments.
> A plain "CREATE INDEX ... WHERE ..." w
On Sun, 18 Jan 2009 22:12:07 +0100
Ivan Sergio Borgonovo wrote:
> I've to apply a discounts to products.
>
> For each promotion I've a query that select a list of products and
> should apply a discount.
>
> Queries may have intersections, in these intersections the highest
> discount should be
On Mon, 2009-01-19 at 14:09 -0500, Faheem Mitha wrote:
> Yes, I have pg superuser privileges. I *think* this is the same as having
> sudo rights for postgres, right? Are you suggesting adding another entry
> to the library path, or whatever this is called? Like ~/.postgresql/ or
> something like
Hi all.
I have a maintenance PL/pgSQL function that needs to recreate a partial index
(not a REINDEX, though).
In the WHERE condition of the index I have one of the function arguments.
A plain "CREATE INDEX ... WHERE ..." will lead to a runtime error like this:
tmp2=# SELECT * FROM f_maint1( '200
On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote:
> In any case, I don't have admin permissions on the machine I'm trying to
> install it to.
At absolute minimum, you need PostgreSQL superuser privileges. If you
don't, you need to set up a new PostgreSQL instance (which you can do as
a norma
On Mon, 19 Jan 2009, Jeff Davis wrote:
On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote:
In any case, I don't have admin permissions on the machine I'm trying to
install it to.
At absolute minimum, you need PostgreSQL superuser privileges. If you
don't, you need to set up a new Postgre
Hi Jeff,
On Sun, 18 Jan 2009, Jeff Davis wrote:
On Sun, 2009-01-18 at 16:52 -0500, Faheem Mitha wrote:
Hi Jeff,
When I try to run array_agg.sql inside psql I get
btsnp_test=# \i '/tmp/array_agg/array_agg.sql'
BEGIN
psql:/tmp/array_agg/array_agg.sql:5: ERROR: could not access file
"$libdir/
In postgresql 8.2 ,how find it?
De: Richard Huxton
Para: Ivan Sergio Borgonovo
Cc: pgsql-general@postgresql.org
Enviadas: Segunda-feira, 19 de Janeiro de 2009 14:36:46
Assunto: Re: [GENERAL] How can I look at a recursive table dependency tree?
Ivan Sergio B
Ivan Sergio Borgonovo wrote:
> On Mon, 19 Jan 2009 14:41:12 +
> Richard Huxton wrote:
>
>> Ivan Sergio Borgonovo wrote:
>>> On Mon, 19 Jan 2009 14:19:51 +
>>> Richard Huxton wrote:
>>>
Igor Katson wrote:
> Is there a way to watch all dependencies recursively without
> doing
On Mon, Jan 19, 2009 at 12:10 PM, Rubén F. wrote:
> First of all, excuse my english...
>
> I have a doubt. I am designing a program for manage CV's. This program
> connect with a PostgresDB. This program will be used for 5,000 persons
> becaus it will be used in a University. Then, ¿how many activ
On Mon, Jan 19, 2009 at 09:48, Grzegorz Jaśkiewicz wrote:
> On Mon, Jan 19, 2009 at 4:43 PM, Tom Lane wrote:
>> But having said that: 8.4 will provide a standard trigger that
>> short-circuits vacuous updates, which you can apply to tables in which
>> you think vacuous updates are likely. It's y
Hi!
First of all, excuse my english...
I have a doubt. I am designing a program for manage CV's. This program
connect with a PostgresDB. This program will be used for 5,000 persons
becaus it will be used in a University. Then, ¿how many actives connection
could be postgres? ¿does it support a ver
On Mon, Jan 19, 2009 at 4:43 PM, Tom Lane wrote:
> But having said that: 8.4 will provide a standard trigger that
> short-circuits vacuous updates, which you can apply to tables in which
> you think vacuous updates are likely. It's your responsibility to place
> the trigger so that it doesn't int
"Scott Marlowe" writes:
> But seriously, it's doing what you told it to do. There might be
> corner cases where you need a trigger to fire for a row on change, and
> short-circuiting could cause things to fail in unexpected ways.
The other argument against doing this by default is that with
non-s
On Mon, 19 Jan 2009 14:41:12 +
Richard Huxton wrote:
> Ivan Sergio Borgonovo wrote:
> > On Mon, 19 Jan 2009 14:19:51 +
> > Richard Huxton wrote:
> >
> >> Igor Katson wrote:
> >>> Is there a way to watch all dependencies recursively without
> >>> doing a drop?
> >
> >> BEGIN;
> >> DROP
Ivan Sergio Borgonovo wrote:
> On Mon, 19 Jan 2009 14:19:51 +
> Richard Huxton wrote:
>
>> Igor Katson wrote:
>>> Is there a way to watch all dependencies recursively without
>>> doing a drop?
>
>> BEGIN;
>> DROP CASCADE...
>> -- check things
>> ROLLBACK;
>
> Isn't it going to be a pretty e
In response to Igor Katson :
> I want to DROP CASCADE a table, but I am afraid that amoung numerous
> recursive dependencies there will be smth, that I don't want to drop.
>
> Is there a way to watch all dependencies recursively without doing a drop?
You can walk through pg_depend.
Andreas
--
2009/1/19 Igor Katson
> I want to DROP CASCADE a table, but I am afraid that amoung numerous
> recursive dependencies there will be smth, that I don't want to drop.
>
> Is there a way to watch all dependencies recursively without doing a drop?
you could query the pg_depend system catalog:
http:
On Mon, 19 Jan 2009 14:19:51 +
Richard Huxton wrote:
> Igor Katson wrote:
> > I want to DROP CASCADE a table, but I am afraid that amoung
> > numerous recursive dependencies there will be smth, that I don't
> > want to drop.
> >
> > Is there a way to watch all dependencies recursively withou
Igor Katson wrote:
> I want to DROP CASCADE a table, but I am afraid that amoung numerous
> recursive dependencies there will be smth, that I don't want to drop.
>
> Is there a way to watch all dependencies recursively without doing a drop?
BEGIN;
DROP CASCADE...
-- check things
ROLLBACK;
--
In response to Thom Brown :
> Another reason to look forward to 8.4. :)
>
> Does that function return information in an identical way to selecting from
> pg_proc?
Apparently.
>
> 2009/1/19 A. Kretschmer
Please no fullquote below your text, thx.
Andreas
--
Andreas Kretschmer
Kontakt: He
Another reason to look forward to 8.4. :)
Does that function return information in an identical way to selecting from
pg_proc?
2009/1/19 A. Kretschmer
> In response to Thom Brown :
> > Thanks everyone! I looked around the user-defined functions section of
> the
> > documentation, but there was
In response to Thom Brown :
> Thanks everyone! I looked around the user-defined functions section of the
> documentation, but there wasn't any mention of this. I'm sure others would
> find it useful if it were included, or at least referenced to.
Just for info:
wait for the upcoming new release
Thom Brown wrote:
I would like to see what's in a function. I can do this if I use
pgAdmin III just by clicking on the function, and it appears in the
SQL pane opposite. But how is this done? Is there a command like
DESCRIBE FUNCTION logging.do_stuff; ? And if possible, doing this
without
I want to DROP CASCADE a table, but I am afraid that amoung numerous
recursive dependencies there will be smth, that I don't want to drop.
Is there a way to watch all dependencies recursively without doing a drop?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
Thanks everyone! I looked around the user-defined functions section of the
documentation, but there wasn't any mention of this. I'm sure others would
find it useful if it were included, or at least referenced to.
Thom
2009/1/19 A. Kretschmer
> In response to Thom Brown :
> > I would like to s
Thom Brown wrote:
I would like to see what's in a function. I can do this if I use
pgAdmin III just by clicking on the function, and it appears in the
SQL pane opposite. But how is this done? Is there a command like
DESCRIBE FUNCTION logging.do_stuff; ? And if possible, doing this
without
In response to Thom Brown :
> I would like to see what's in a function. I can do this if I use pgAdmin III
> just by clicking on the function, and it appears in the SQL pane opposite.
> But
> how is this done? Is there a command like DESCRIBE FUNCTION logging.do_stuff;
> ? And if possible, doi
Thom Brown a écrit :
> I would like to see what's in a function. I can do this if I use pgAdmin
> III just by clicking on the function, and it appears in the SQL pane
> opposite. But how is this done? Is there a command like DESCRIBE FUNCTION
> logging.do_stuff; ? And if possible, doing this wi
I would like to see what's in a function. I can do this if I use pgAdmin
III just by clicking on the function, and it appears in the SQL pane
opposite. But how is this done? Is there a command like DESCRIBE FUNCTION
logging.do_stuff; ? And if possible, doing this without psql.
Thanks
Thom
On Sun, 18 Jan 2009 19:44:40 -0700
"Scott Marlowe" wrote:
> You could update returning rowsupdated, so you could run that and
> get a list of all the rows that were updated. Then build a simple
> select where not in (those rows) to get the rest for inserting.
uh nice addition. I didn't check al
On Mon, 19 Jan 2009 01:18:35 -0700
"Scott Marlowe" wrote:
> On Mon, Jan 19, 2009 at 12:53 AM, Grzegorz Jaśkiewicz
> wrote:
> > 2009/1/19 Scott Marlowe :
> >> Submit a patch. :)
> >>
> >> But seriously, it's doing what you told it to do. There might be
> >> corner cases where you need a trigger t
2009/1/19 Scott Marlowe :
> Yes, but what about a table with an update trigger on it that does
> some interesting bit of housekeeping when rows are updated?
exactly, that's another one of reasons why I wouldn't write that patch :P
> It's a prime example of fixing a problem created by not knowing
On Mon, Jan 19, 2009 at 12:53 AM, Grzegorz Jaśkiewicz wrote:
> 2009/1/19 Scott Marlowe :
>> Submit a patch. :)
>>
>> But seriously, it's doing what you told it to do. There might be
>> corner cases where you need a trigger to fire for a row on change, and
>> short-circuiting could cause things to
40 matches
Mail list logo
