Andre Lopes writes:
> I have a query that some values could be NULL, how can I deal with this
> problem?
PG 8.4 and up have a function quote_nullable() that would do what I
think you're looking for. On an older version, you could define such a
function for yourself.
rega
Howe, Jeffrey a écrit:
Due to increase in phishing attacks, we are currently working to improve on
the security of all Email Accounts as we periodically review certain
Vincenzo Romano writes:
It sounds either like phishing or like an automated response due to
some email forwarding ...
Anyw
On 7/05/2010 12:01 PM, Craig Ringer wrote:
craig=> create or replace function extract_salt(text) returns text as $$
craig$> select (regexp_matches($1, E'^(\\$[^\\$]+\\$[^\\$]+)\\$'))[1];
craig$> $$ language sql immutable;
Upon re-reading the pgcrypto documentation I see that this is unnecessar
On 7/05/2010 2:31 AM, akp geek wrote:
Dear all -
I am writing function to handle the passwords. Currently
the crypt is being used to store the password in the database. what I
need to do is, when the user wants to change the password, I need to
check if that password is not being
Hi
Null + 1=null.
and
null + 'a' = null.
I expect that pVAL_COMENT is null (as you say).
===
create test environment.
===
create table nulltest (col1 varchar(10),col2 varchar(10));
insert into nulltest (col1,col2) values ('A','B');
insert into nul
I'm running into this issue again:
psql --version
psql (PostgreSQL) 8.3.7
COPY items_extended TO '/dev/null';
ERROR: missing chunk number 0 for toast value 25693266 in pg_toast_25497233
Unfortunately, I do not know where these are coming from and I cannot
replicate the data in at least one of m
Hi,
I have a query that some values could be NULL, how can I deal with this
problem?
[code]
EXECUTE 'INSERT INTO '
|| quote_ident(pNOME_VIEW)
|| '('
|| quote_ident(pCHAVE_1)
|| ', DAT_INICIO, DAT_FIM, COMENT) values ('
|| quote_literal(pVAL_CHAVE_1)
The video archive for the 02/09 SFPUG meeting, "Hot Standby and
Streaming Replication," is now available:
http://thebuild.com/blog/2010/05/06/sfpug-hot-standby-and-streaming-replication/
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general
Guillaume Lelarge wrote:
And rather than checking the database name, I usually prefer to filter
with datallowconn.
It'll save template1 and postgres, but the script won't give me an error
on template0.
Template databases are labeled as such, so this excludes both template0
and template1 wit
On May 5, 6:16 pm, alvhe...@alvh.no-ip.org (Alvaro Herrera) wrote:
> Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010:
>
> > On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote:
>
> > > I looked at the pg_class table and noticed that its size is 1010Mb and
> > > index size is 1
Dear all -
I am writing function to handle the passwords. Currently the
crypt is being used to store the password in the database. what I need to do
is, when the user wants to change the password, I need to check if that
password is not being used before up to 5 times, If not then t
Le 06/05/2010 17:56, Thom Brown a écrit :
> On 6 May 2010 16:52, Scott Mead wrote:
>
>>
>> On Thu, May 6, 2010 at 11:30 AM, Thom Brown wrote:
>>
>>> On 6 May 2010 16:15, Andy Colson wrote:
>>>
On 5/6/2010 2:57 AM, Jaume Calm wrote:
> Hi! I was searching for a command like pg_dumpa
On Thu, May 6, 2010 at 11:30 AM, Thom Brown wrote:
> On 6 May 2010 16:15, Andy Colson wrote:
>
>> On 5/6/2010 2:57 AM, Jaume Calm wrote:
>>
>>> Hi! I was searching for a command like pg_dumpall but with the
>>> difference that I don’t want a single file for all databases, i would
>>> like to hav
On 6 May 2010 16:52, Scott Mead wrote:
>
> On Thu, May 6, 2010 at 11:30 AM, Thom Brown wrote:
>
>> On 6 May 2010 16:15, Andy Colson wrote:
>>
>>> On 5/6/2010 2:57 AM, Jaume Calm wrote:
>>>
Hi! I was searching for a command like pg_dumpall but with the
difference that I don’t want a si
On Thu, May 6, 2010 at 17:42, Alvaro Herrera wrote:
> Excerpts from Dave Vitek's message of jue may 06 10:44:34 -0400 2010:
>> Hi all,
>>
>> Yesterday I ran into two backend crashes and then an autovacuum launcher
>> process crash. The autovacuum log was:
>> LOG: database system is ready to acce
Excerpts from Dave Vitek's message of jue may 06 10:44:34 -0400 2010:
> Hi all,
>
> Yesterday I ran into two backend crashes and then an autovacuum launcher
> process crash. The autovacuum log was:
> LOG: database system is ready to accept connections
> LOG: autovacuum launcher process (PID 37
On 6 May 2010 16:15, Andy Colson wrote:
> On 5/6/2010 2:57 AM, Jaume Calm wrote:
>
>> Hi! I was searching for a command like pg_dumpall but with the
>> difference that I don’t want a single file for all databases, i would
>> like to have a file for each one.
>>
>> I couldn’t fins such command, so
On 5/6/2010 2:57 AM, Jaume Calm wrote:
Hi! I was searching for a command like pg_dumpall but with the
difference that I don’t want a single file for all databases, i would
like to have a file for each one.
I couldn’t fins such command, so the only option I see is to write a
shell script with a l
On Thu, May 6, 2010 at 3:57 AM, Jaume Calm wrote:
> Hi! I was searching for a command like pg_dumpall but with the difference
> that I don’t want a single file for all databases, i would like to have a
> file for each one.
>
>
>
> I couldn’t fins such command, so the only option I see is to writ
Hi all,
Yesterday I ran into two backend crashes and then an autovacuum launcher
process crash. The autovacuum log was:
LOG: database system is ready to accept connections
LOG: autovacuum launcher process (PID 3788) was terminated by exception
0xC142
HINT: See C include file "ntstatus.
On 6 May 2010 08:57, Jaume Calm wrote:
> Hi! I was searching for a command like pg_dumpall but with the difference
> that I don’t want a single file for all databases, i would like to have a
> file for each one.
>
>
>
> I couldn’t fins such command, so the only option I see is to write a shell
>
On 6 May 2010 15:52, Nicholas I wrote:
>
>
> -- Forwarded message --
> From: Nicholas I
> Date: Wed, May 5, 2010 at 8:35 AM
> Subject: help
> To: pgsql-...@postgresql.org
>
>
> Hi,
>
> I have a table in which the data's are entered like,
>
> Example:
>
> One (1)
> Two (2)
> Three
-- Forwarded message --
From: Nicholas I
Date: Thu, May 6, 2010 at 8:18 PM
Subject: Need a help in regexp
To: pgsql-...@postgresql.org
Hi,
Need a help in regexp!
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the dat
-- Forwarded message --
From: Nicholas I
Date: Wed, May 5, 2010 at 8:35 AM
Subject: help
To: pgsql-...@postgresql.org
Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the data which is only within the parentheses.
Hi! I was searching for a command like pg_dumpall but with the difference
that I don't want a single file for all databases, i would like to have a
file for each one.
I couldn't fins such command, so the only option I see is to write a shell
script with a loop for all the DBs. The problem is t
pgsql writes:
> Tom Lane wrote:
>> Um, that's not too helpful, we want to see the string it's pointing at.
> Sorry about that. All statements are calling one of two pl/pgsql
> functions. While that information already helps me a lot, it'll take me
> a while to step through the code. Those funct
> I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
> SSL support.
>
> I am facing problem in lob object replication. I found that lobj_lock_table
> is required.
>
> What should be the structure of lobj_lock_table?
>From the pgpool-II doc:
On Thu, May 6, 2010 at 10:00 PM, AI Rumman wrote:
> I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
> SSL support.
>
> I am facing problem in lob object replication. I found that lobj_lock_table
> is required.
>
> What should be the structure of lobj_lock_table?
>
This
I'm sorry I have to come back at this, but the solution the list gave helped,
but didn't fully solved my problems...
To sum up:
I have a simple table that has indexes on 2 integer columns.
Data is inserted very often (no updates, no deletes, just inserts): at
least 4000/5000 rows per second. The
I am using Pgpool II 2.3.3 with Postgresql 8.3.8 in replication mode with
SSL support.
I am facing problem in lob object replication. I found that lobj_lock_table
is required.
What should be the structure of lobj_lock_table?
30 matches
Mail list logo
