Re: [GENERAL] find a string contained in an attribute

2010/3/24 Szymon Guz : > 2010/3/24 Karina Guardado >> >> Hi, >> >> I want to know if it is possible to search for a string of characters >> inside an attribute for example I have the following table and values >> >> cod_unidad | nombre_uni >> +--

[GENERAL] Side effect of synchronous_commit = off

I was wondering whether setting synchronous_commit = off will have the following side effect. (1) Process A issues UPDATE command on row x, from false to true. (2) After that, Process B READ from row x. Is it possible that when Process B start to read row x, the "true" value is not being "flush

Re: [GENERAL] Revoking CREATE TABLE

On Wednesday 24 March 2010 17.28:37 Tony Webb wrote: > #revoke create on schema public from public; > REVOKE Note that this will *only* revoke the create right from "PUBLIC" and not from any individual role that may have the right. PostgreSQL unfortunately does not have a "revoke ... from ALL".

Re: [GENERAL] Side effect of synchronous_commit = off

Le 25/03/2010 08:49, Yan Cheng CHEOK a écrit : > I was wondering whether setting synchronous_commit = off will have the > following side effect. > > (1) Process A issues UPDATE command on row x, from false to true. > (2) After that, Process B READ from row x. > > Is it possible that when Process

[GENERAL] Get the list of permissions/privileges on schema

Hi, Could any one please tell me how to get list of all the permissions on the schema (or any postgresql objects), stored them somewhere before executing stored procedure and then restore them? Thanks, Dipti

Re: [GENERAL] Get the list of permissions/privileges on schema

You should look into the pg_class table : relacl attribute for the permissions on any object. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Thu, Mar 25, 2010 at 2:37 PM, dipti shah wrote: > Hi, > > Could any one please tell me

Re: [GENERAL] Get the list of permissions/privileges on schema

On 25 March 2010 12:14, Ashesh Vashi wrote: > You should look into the pg_class table : relacl attribute for the > permissions on any object. Is it correct to set it directly? > On Thu, Mar 25, 2010 at 2:37 PM, dipti shah wrote: >> Could any one please tell me how to get list of all the permiss

Re: [GENERAL] Get the list of permissions/privileges on schema

On Thu, Mar 25, 2010 at 2:54 PM, Sergey Konoplev wrote: > On 25 March 2010 12:14, Ashesh Vashi > wrote: > > You should look into the pg_class table : relacl attribute for the > > permissions on any object. > > Is it correct to set it directly? > Of course not... This is just way to fetch the li

Re: [GENERAL] Get the list of permissions/privileges on schema

Thanks a lot guys but I am not looking for security definer function. I know it. My requirements are very complicated and I have to nailed down the stuffs by storing schema permissions somewhere, execute my store procedure, and restored the stored schema permissions. Like this I would make sure tha

[GENERAL] What datatype should I use to store an IP Address?

Hi, I'm using Varchar(16) to store an IP Address. PostgreSQL offers another datatypes to store IP's or it is OK to store in Varchar(16)? Best Regards,

Re: [GENERAL] What datatype should I use to store an IP Address?

>On Thu, Mar 25, 2010 at 11:25 AM, Andre Lopes wrote: > Hi, > > I'm using Varchar(16) to store an IP Address. PostgreSQL offers another > datatypes to store IP's or it is OK to store in Varchar(16)? > > Best Regards, > Yes, just look here: http://www.postgresql.org/docs/8.4/static/datatype-net-ty

Re: [GENERAL] What datatype should I use to store an IP Address?

On Thu, 2010-03-25 at 11:28 +0100, Michał Pawlikowski wrote: > > I'm using Varchar(16) to store an IP Address. PostgreSQL offers > > another datatypes to store IP's or it is OK to store in Varchar(16)? > > > Yes, just look here: > http://www.postgresql.org/docs/8.4/static/datatype-net-types.html A

[GENERAL] Achieving ordered update

Hi, A classic problem. I would like to assign integer values (from a sequence) to records in a table based on the order (of contents) of other field(s) in the same table. I come across the solution before but I simply may not recall and a search returns no clues. Please point me to a resource with

Re: [GENERAL] Achieving ordered update

On 25 March 2010 12:02, Allan Kamau wrote: > Hi, > A classic problem. I would like to assign integer values (from a > sequence) to records in a table based on the order (of contents) of > other field(s) in the same table. > I come across the solution before but I simply may not recall and a > sea

[GENERAL] pgfoundry registration

Hello, Is registration to pgFoundry closed on purpose? I get confirmation emails but am greeted with: Access denied Credentials you entered do not correspond to valid account. Could you help or advise, please? Best regards, Krzysztof

[GENERAL] How many Mandatory Process are there in Postgres

Hi All, When we start the postgres server, the writer process, wal process, postmaster, autovacuum ( if autovacuum is on), stats collector will come into picture as mandotory process. My question is, is there any processes apart from these process, what are the mandotory process come along with th

Re: [GENERAL] How many Mandatory Process are there in Postgres

> Hi All, > > When we start the postgres server, the writer process, wal process, > postmaster, autovacuum ( if autovacuum is on), stats collector will come > into picture as mandotory process. My question is, is there any processes > apart from these process, what are the mandotory process come al

Re: [GENERAL] data type to store a lot of text and tables of data

Thank you very much for your help and so soon answears. I will try using the solutions you suggest. best regards, karina On Wed, Mar 24, 2010 at 4:44 PM, Raymond O'Donnell wrote: > On 24/03/2010 22:39, Karina Guardado wrote: > > You know I need to design a table where some attributes have a d

Re: [GENERAL] find a string contained in an attribute

Do you have a link where I can read more about this because is not easy to understand. Thanks for your help, karina On Thu, Mar 25, 2010 at 1:34 AM, Pavel Stehule wrote: > 2010/3/24 Szymon Guz : > > 2010/3/24 Karina Guardado > >> > >> Hi, > >> > >> I want to know if it is possible to search fo

Re: [GENERAL] find a string contained in an attribute

http://www.postgresql.org/docs/8.4/static/textsearch.html Regards Pavel Stehule 2010/3/25 Karina Guardado : > Do you have a link where I can read more about this because is not easy to > understand. > > Thanks for your help, > > karina > > On Thu, Mar 25, 2010 at 1:34 AM, Pavel Stehule > wrote:

Re: [GENERAL] How many Mandatory Process are there in Postgres

Hi Tomas, Thank you for the reply. > Well, there is a bunch of processes started at the beginning, and then > there is one backend process for each connection (see the postgresql.conf > how many connections are allowed in your case). > I do agree with you, that there would be bunch of process.

Re: [GENERAL] How many Mandatory Process are there in Postgres

> Hi Tomas, > > Thank you for the reply. > > >> Well, there is a bunch of processes started at the beginning, and then >> there is one backend process for each connection (see the >> postgresql.conf >> how many connections are allowed in your case). >> > I do agree with you, that there would be bu

Re: [GENERAL] tables getting bloated

Thanks for the help 2010/3/18 Craig Ringer > On 18/03/2010 9:48 PM, akp geek wrote: > >> I have job that does the vacuum full every day for those 2 tables and >> also for the database. By the end of the day, the get bloated. >> > > > http://wiki.postgresql.org/wiki/Introduction_to_VACUUM%2C_ANAL

Re: [GENERAL] How many Mandatory Process are there in Postgres

2010/3/25 > >> Oracle uses a completely different implementation of MVCC architecture. > >> It > >> overwrites the data and then uses rollback segments to provide 'previous > >> versions' to running transactions etc. > >> > >> PostgreSQL does not overwrite the data - it just creates a copy of

[GENERAL] Does anyone use in ram postgres database?

We are testing in memory postgres database and have questions about configuring the ram mount point and whether there is great gains in setting it up this way? Are there any considerations for postgres? If you have experience, can you please give us some ideas on how you have acco

Re: [GENERAL] Large index operation crashes postgres

Tom, ran a CREATE INDEX to the gdb operated postmaster. Nothing new due to missing debugging libraries, so this might not help: Reading symbols from /usr/bin/postmaster...(no debugging symbols found)...done. Missing separate debuginfos, use: debuginfo-install postgresql-server-8.3.9-1PGDG.f12.x86

Re: [GENERAL] Does anyone use in ram postgres database?

On Thu, Mar 25, 2010 at 2:42 PM, Chris Barnes wrote: >   We are testing in memory postgres database and have questions about > configuring the ram mount point and whether there is great gains in setting > it up this way? Are there any considerations for postgres? There is very little reason to do

Re: [GENERAL] Does anyone use in ram postgres database?

On Thu, Mar 25, 2010 at 12:42 PM, Chris Barnes wrote: > > >   We are testing in memory postgres database and have questions about > configuring the ram mount point and whether there is great gains in setting > it up this way? Are there any considerations for postgres? > >   If you have experience,

Re: [GENERAL] Large index operation crashes postgres

Paul, I have started the operation right now after a fresh reboot of the machine. Please give me some time to collect the results... Thanks & regards Frans 2010/3/25 Paul Ramsey : > If you build an index, or try to update a column, using just the > > ST_X(ST_Centroid()) > > without all the ext

[GENERAL] Performing FETCH ALL from a SCROLL CURSOR failing to return results

This issue is on PostgreSQL 8.4.1 under CentOS 5.3 x86_64. I have a scroll cursor defined like so: source_host SCROLL CURSOR IS SELECT ; Inside my PL/PGSQL stored procedure, I am opening the cursor like so: OPEN source_host; FETCH source_host INTO src_host; result.source_host_refcur

Re: [GENERAL] Performing FETCH ALL from a SCROLL CURSOR failing to return results

Eliot Gable writes: > Inside my PL/PGSQL stored procedure, I am opening the cursor like so: > OPEN source_host; > FETCH source_host INTO src_host; So you already fetched the one row in the cursor. FETCH ALL really means "fetch all the rest of the rows", which is why it returns nothing. The othe

Re: [GENERAL] Get the list of permissions/privileges on schema

dipti shah wrote: Thanks a lot guys but I am not looking for security definer function. I know it. My requirements are very complicated and I have to nailed down the stuffs by storing schema permissions somewhere, execute my store procedure, and restored the stored schema permissions. Like this

[GENERAL] Geoffrey Gowey wants to stay in touch on LinkedIn

LinkedIn Geoffrey Gowey requested to add you as a connection on LinkedIn: -- Andrew, I'd like to add you to my professional network on LinkedIn. - Geoffrey Gowey Accept invitation from Geoffrey Gowey http://www.linkedin.com/e/ATaEtqAFKHyclb4ya

[GENERAL] Problem with Memory Leak

Hi I am having memory leaking problem and here is the result shown from valgrind: ==1706== 1,270 bytes in 5 blocks are still reachable in loss record 353 of 426 ==1706==at 0x4C20809: malloc (vg_replace_malloc.c:149) ==1706==by 0x5D3F431: strdup (in /lib64/libc-2.5.so) ==1706==by 0x10

Re: [GENERAL] Problem with Memory Leak

Pete Kay writes: > I am having memory leaking problem and here is the result shown from valgrind: > ==1706== 1,270 bytes in 5 blocks are still reachable in loss record 353 of 426 > ==1706==at 0x4C20809: malloc (vg_replace_malloc.c:149) > ==1706==by 0x5D3F431: strdup (in /lib64/libc-2.5.so

Re: [GENERAL] How many Mandatory Process are there in Postgres

> > Hi Scott, Thomas, Thank you for the update. > >> Oracle uses a completely different implementation of MVCC > architecture. > >> It > >> overwrites the data and then uses rollback segments to provide 'previous > >> versions' to running transactions etc. > >> > >> PostgreSQL does not overwrit

Re: [GENERAL] How many Mandatory Process are there in Postgres

On Thu, Mar 25, 2010 at 9:03 PM, Tadipathri Raghu wrote: > Hi Scott, Thomas, > > Thank you for the update. > >> >> >> Oracle uses a completely different implementation of MVCC architecture. >> >> It >> >> overwrites the data and then uses rollback segments to provide >> >> 'previous >> >> versions

Re: [GENERAL] Problem with Memory Leak

Hi, I am setting up a connection pooling obj to pool a bunch of PGConnection object. That is why I am not closing the PGConn object when the query is done. Is that the right way to do it? thanks, Pete On Fri, Mar 26, 2010 at 10:54 AM, Tom Lane wrote: > Pete Kay writes: >> I am having memory l

Re: [GENERAL] How to retrieve List of Tables in a Database using...

Hello, Thanks everyone for your help. I really appreciate it. Yogi Yang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Problem with Memory Leak

Pete Kay writes: > I am setting up a connection pooling obj to pool a bunch of > PGConnection object. That is why I am not closing the PGConn object > when the query is done. > Is that the right way to do it? Well, that's fine, but you should not be complaining about some memory associated with