Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote on 01/04/2009
06:53:07:
chris.el...@shropshire.gov.uk wrote:
Scott Marlowe scott.marl...@gmail.com wrote on 31/03/2009 15:53:34:
On Tue, Mar 31, 2009 at 8:21 AM, chris.el...@shropshire.gov.uk
wrote:
Scott Marlowe
Hi,
I would like to know is there any perf differences between
case 1: when i use ( ...where validate=FALSE) [validate as Boolean]
case 2: when i use ( ... where validate=1) [validate as int(1)]
Thanks
DEVI.G
hey all,
I have a stored procedure that updates a couple of tables within my
database.
org.postgresql.util.PSQLException : ERROR: deadlock detected
Detail: Process 31580 waits for AccessExclusiveLock on relation
289553 of database 285107; blocked by process 16024.
Process 16024 waits for
Hi,
First of all, excuse my poor english :)
I'm working on a fulltext database with tsearch2, which contains french
historical writings.
I'm using the fr_ispell dictionnary that can be found here :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
(ispell-french.tar.gz
Greg Maitrallain greg.maitrall...@evodia.fr writes:
The problem is the writings contains many names of personnalities. For
example : Churchill (the database covers WWII). But when I try to search
for these names, nothing is found.
I tried many things, like this introduction :
On Tue, Mar 31, 2009 at 05:08:45PM +0100, Greg Stark wrote:
Both interpretations are clearly consistent but it depends on whether
you think it's a bunch of text strings concatenated together or if
it's a list of objects.
The example of string_to_array('',',')::int[] is relevant to this
Hi,
I did not run the initdb.exe and thats why i could not start the
server.Here is what i did:
1. Executed initdb.exe as follows:
runas /user:postgres D:\pgsql\bin\initdb.exe -D:\pgsql\data
2.Started the server by executing the following cmd:
runas /user:postgres
Hello,
Is there any way to get some attributes values of the first object
involved in a delete on cascade group inside a trigger definition?
I wish I could fire a trigger after a delete on cascade has been done
but I need some informations which are linked to the first element deleted.
Using
On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark st...@enterprisedb.com wrote:
On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason s...@samason.me.uk wrote:
string_to_array('',',')::INT[] = invalid input syntax for integer:
Oof. That's a good point.
+1. I find this argument much more compelling than
I am using rsyslog (a syslog to database application) to connect to my
postgresql database. It then executes Insert after Insert 100s a
minute I have been reading about the PREPARE statement and think
that could dramatically increase my insert speed. The problem is, as
you all know, that
I am using rsyslog (a syslog to database application) to connect to my
postgresql database. It then executes Insert after Insert 100s a
minute I have been reading about the PREPARE statement and think
that could dramatically increase my insert speed. The problem is, as
you all know, that
Believe it or not, this morning I found that the IT departement has
installed Trend Micro Office Scan on the server. I will contact them to
remove it. Do I still need to dump everything thing and load back or this
will solve the problem? If I need to dump, what type of dump do you
recommend?
On
On Wed, Apr 1, 2009 at 6:37 AM, Patrick Desjardins
mrdesjard...@gmail.com wrote:
Believe it or not, this morning I found that the IT departement has
installed Trend Micro Office Scan on the server. I will contact them to
remove it. Do I still need to dump everything thing and load back or this
2009/3/31 Patrick Desjardins mrdesjard...@gmail.com:
Hi,
I have the error ERROR: XX001: could not read block 2354 of relation
1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when trying
to Insert data into a table. I would say that 99% of Insert works and 100%
of read works.
2009/4/1 Patrick Desjardins mrdesjard...@gmail.com:
We are using EnterpriseDB PostGresql 8.3. I can't simply take a good backup
because weeks have pass since the first error occurs.
I will try to Vacumm Full first, if nothing is fixed, I will try to pg_dump
like you suggest.
In 7.x
2009/4/1 Emanuel Calvo Franco postgres@gmail.com:
2009/4/1 Patrick Desjardins mrdesjard...@gmail.com:
Did you try to make a reindex?
If you get an error with that, try to drop indexes and create
again.
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org
Robert Haas robertmh...@gmail.com writes:
On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark st...@enterprisedb.com wrote:
On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason s...@samason.me.uk wrote:
string_to_array('',',')::INT[] = invalid input syntax for integer:
Oof. That's a good point.
+1. I
hola
Tengo una interfase web, para ejecutar consultas a una base de datos, pero
tiene millones de campos, es el contenido de las trazas de los cisco de la red
, la
consulta la acoto por fecha, este es mi trabajo de grado , y no me queda mucho
tiempo,
si alguien pudiera decirme como puedo
On Apr 1, 2009, at 9:02 AM, Tom Lane wrote:
+1. I find this argument much more compelling than anything else
that's been offered up so far.
Yeah. It seems to me that if you consider only the case where the
array
elements are text, there's a weak preference for considering '' to
be a
I have not reindexes. I will try to use the Reindex command (
http://www.postgresql.org/docs/8.3/interactive/sql-reindex.html). If I get
error I will try to drop them. If it doesn't solve I will pg_dump. I still
need to wait the IT to remove the Anti-virus. Will give you more news later.
On Wed,
We are using EnterpriseDB PostGresql 8.3. I can't simply take a good backup
because weeks have pass since the first error occurs.
I will try to Vacumm Full first, if nothing is fixed, I will try to pg_dump
like you suggest.
On Wed, Apr 1, 2009 at 11:49 AM, Emanuel Calvo Franco
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark st...@enterprisedb.com wrote:
On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason s...@samason.me.uk wrote:
string_to_array('',',')::INT[] = invalid
On Wed, Apr 1, 2009 at 10:32 AM, Patrick Desjardins
mrdesjard...@gmail.com wrote:
I have not reindexes. I will try to use the Reindex command
(http://www.postgresql.org/docs/8.3/interactive/sql-reindex.html). If I get
error I will try to drop them. If it doesn't solve I will pg_dump. I still
David E. Wheeler da...@kineticode.com writes:
Well, I'd just point out that the return value of string_to_array() is
text[].
True...
Thus, this is not a problem with string_to_array(), but a
casting problem from text[] to int[].
Nonsense. The question is whether string_to_array is
As far as I know we do not have the paying support. Once I will try
everything suggested here, I will try to go in that direction. For the
moment, I think all your suggestions might solve the problem. I just need
the ok from the IT to start applying some of your suggestions guys.
On Wed, Apr 1,
If you are using the EnterpriseDB release, and paying for support, you can
always take this to them.
Sent from my mobile device
-Original Message-
From: Patrick Desjardins mrdesjard...@gmail.com
Date: Wed, 1 Apr 2009 11:53:59
To: Emanuel Calvo Francopostgres@gmail.com
Cc:
On Apr 1, 2009, at 10:09 AM, Tom Lane wrote:
Thus, this is not a problem with string_to_array(), but a
casting problem from text[] to int[].
Nonsense. The question is whether string_to_array is meant to be
useful
for lists of anything except text. I agree you could argue that it
isn't.
On Apr 1, 2009, at 10:05 AM, justin wrote:
string_to_array('',',')::INT[] works as proposed
But
string_to_array(',,,', ',' )::INT[] Fails
or
string_to_array('1,2,,4', ',' )::INT[] Fails .
I'm trying to understand the difference between a empty string to a
string with many blank entries
Dear Tom,
Thanks for your reply and insight! I much appreciate it. I certainly look
forward to getting off FC6! In the meantime, I did get it to work -
I remembered SELinux protects /home directories especially.
So I moved postgres user's home directory from /home/postgres
to /data/postgres,
On Wed, Apr 01, 2009 at 10:23:18AM -0700, David E. Wheeler wrote:
On Apr 1, 2009, at 10:05 AM, justin wrote:
string_to_array('',',')::INT[] works as proposed
But
string_to_array(',,,', ',' )::INT[] Fails
or
string_to_array('1,2,,4', ',' )::INT[] Fails .
I'm trying to understand the
On Wed, Apr 1, 2009 at 6:23 PM, David E. Wheeler da...@kineticode.com wrote:
Right, it's making a special case of '', which does seem rather inconsistent
to me.
David E. Wheeler da...@kineticode.com writes:
On Apr 1, 2009, at 10:05 AM, justin wrote:
string_to_array('',',')::INT[] works as
Hola,
En primer lugar esta es un lista en ingles, más gente podrá ayudarte
si escribes en ese idioma. También deberías darnos mas información
para poder ayudarte. Un esquema de la BD, que datos quieres obtener,
etc.
This is an english list, more people can help if you write in english.
Scott
the problem is that the memory gets higher and higher each PL/SQL procedure
call.
Some “I don’t know what” is not been freed(released) from the memory after
execution.
There’s any way that I can see what is allocated and released when the
PL/SQL procedure is called or finished ?
On Wed, Apr 1, 2009 at 12:59 PM, Anderson Valadares
anderva...@gmail.com wrote:
Scott
the problem is that the memory gets higher and higher each PL/SQL procedure
call.
Some “I don’t know what” is not been freed(released) from the memory after
execution.
There’s any way that I can see
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where can I find it?
in what file?? I even created a DB that I haven't used yet so I am
On Wed, Apr 01, 2009 at 07:40:16PM +0100, Greg Stark wrote:
The existing behaviour of returning NULL is the only consistent
choice since the correct value is unknown. And one could argue that
it's easier to replace NULL with the correct value if the programmer
knows using coalesce than it is
On Wed, Apr 1, 2009 at 12:52 PM, David E. Wheeler da...@kineticode.com wrote:
Well, I'd just point out that the return value of string_to_array() is
text[]. Thus, this is not a problem with string_to_array(), but a casting
problem from text[] to int[]. Making string_to_array() return a NULL for
On Wed, Apr 1, 2009 at 1:05 PM, justin jus...@emproshunts.com wrote:
I'm still a hold out, We are taking a string putting it into a array based
on a delimiter. That is very simple and straight forward. Yet many argue
if we want to cast this into another data type the function should deal
Hi,
Please allow me to rephrase a question I asked on this list some time
ago. Could somebody shine some light on what exactly influences the
value of the %r parameter in the restore_command (as used in
recovery.conf)? I'm using this in a hot-standby-configuration in
combination with
It is still stored..and I got hold of it.. I used it and it is not workin!?
What could be the problem? How should I log in?
See the picture I attached...
On Wed, Apr 1, 2009 at 10:16 PM, Jennifer Trey jennifer.t...@gmail.comwrote:
I even wrote down the password when I installed the DB and now
On Wed, Apr 1, 2009 at 3:16 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
I even wrote down the password when I installed the DB and now it doesn't
work!
I have logged in once to the DB through pgAdmin, and choose to store the
password and it said that it was stored in plain text.. where
On 01/04/2009 20:16, Jennifer Trey wrote:
Most importantly, where can I find the password if it was stored?
It's in a file called pgpass.conf - on Windows, this is stored in the
Application Data\postgresql directory under your profile.
Ray.
On 01/04/2009 20:38, Jennifer Trey wrote:
It is still stored..and I got hold of it.. I used it and it is not workin!?
What could be the problem? How should I log in?
See the picture I attached...
Well, the error message says that the role under which you;re trying to
log in doesn't exist,
Yes, I found it.. but I cannot log in?
Is there any simple way just to scratch the server and add a new one? thru
pgAdmin please?
I tried to Add Server but it requires a password too!? and thats not
working either.. why does a new server require a new password?
To Raymonds last,
I am using
If someone can show me a real world example this logic simplifies the
code and has more uses I'll bite
I just presently can't see how this works better.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Sorry, for the confusion.. just want to make something I wrote more clear:
I tried to add a server and it required the use of a password and not to add
a password.. upon the creation and connection, it says that it failed. The
Server gets created but I cannot log in to it, even though its new...
By the way, yesterday I used the TuningWizard too, could it have changed
some of these things? It does create a new config file.. is it possible?
On Wed, Apr 1, 2009 at 10:50 PM, Jennifer Trey jennifer.t...@gmail.comwrote:
Sorry, for the confusion.. just want to make something I wrote more
On 01/04/2009 20:52, Jennifer Trey wrote:
By the way, yesterday I used the TuningWizard too, could it have changed
some of these things? It does create a new config file.. is it possible?
On Wed, Apr 1, 2009 at 10:50 PM, Jennifer Trey jennifer.t...@gmail.comwrote:
Sorry, for the
chris.el...@shropshire.gov.uk wrote:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote on 01/04/2009 06:53:07:
chris.el...@shropshire.gov.uk wrote:
Scott Marlowe scott.marl...@gmail.com wrote on 31/03/2009 15:53:34:
On Tue, Mar 31, 2009 at 8:21 AM,
On Wed, Apr 1, 2009 at 3:50 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Sorry, for the confusion.. just want to make something I wrote more clear:
I tried to add a server and it required the use of a password and not to add
a password.. upon the creation and connection, it says that it
On Wed, Apr 1, 2009 at 2:01 PM, Stefan Kaltenbrunner
ste...@kaltenbrunner.cc wrote:
also test with different IO schedulers(especially deadline and noop).
But wasn't the OP getting something like 6 tps? I mean, something is
so horrifically wrong a simple change like the io scheduler can't hope
Split strings into array elements using provided delimiter
string_to_array('xx~^~yy~^~zz', '~^~')
output: {xx,yy,zz}
http://www.postgresql.org/docs/8.3/interactive/functions-array.html
?
Martin
__
Disclaimer and confidentiality note
This
Martin Gainty wrote:
Split strings into array elements using provided
delimiter
string_to_array('xx~^~yy~^~zz', '~^~')
output: {xx,yy,zz}
http://www.postgresql.org/docs/8.3/interactive/functions-array.html
Sorry thats not the question i'm asking.
We are debating if it makes
Robert Haas robertmh...@gmail.com writes:
If you take 0 items of any type whatsoever and join them together with
commas, you will get the empty string. It is also true that if you
join 1 item together with commas, you will get that item back, and if
that item is the empty string, you will now
On Wed, Apr 1, 2009 at 5:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Or we could stick to the current behavior and say use COALESCE() to
resolve the ambiguity, if you need to.
If there's no consensus on changing the behavior, it's probably better
to be backward compatible than not.
...Robert
--
Tom Lane wrote:
I'm starting to vacillate again. It's clear that for the purposes
of string_to_array, an empty input string is fundamentally ambiguous:
it could mean a list of no things, or a list of one empty thing.
Agreed. Of the two, a list of one empty thing makes string_to_array
On Thursday 2. April 2009, Steve Crawford wrote:
Currently string_to_array(null, ',') yields a null result -
indistinguishable from string_to_array('',','). Wrapping in coalesce
does not help distinguish true null input from empty-string input. I'm
not sure at the moment what other cases exist
Hi. We're trying to implement two-phase commit and did not find a
complete working example in the manual. We found examples of the
separate pieces, but not the sequence in which to put them together.
Then we found this text,
PREPARE TRANSACTION is used in place of regular COMMIT to perform
58 matches
Mail list logo