On 24/12/2009 6:10 AM, Jamie Kahgee wrote:
what would be considered best practice for my situation?
I have a table *member*, with column *name *that I want to put an index
on, because it is searched quiet frequently. When I create my sql search
string, the name will consist only of
Hi Everyone,
In a web application running in Tomcat and Postgres 8.3 as DB, i need to
know whether my given task is feasible or not.
All the db operation which is done by that web application must
be rollback at the end(session dies) and the DB data must be same as the
starting
Patrick M. Rutkowski wrote:
Is the query
UPDATE my_table SET colname = NULL WHERE colname ~ '^\s*$'
already all correct and standard conforming. Such that all I need to
do is turn on standard_conforming_strings to have it stop complaining
at me?
Precisely.
In other words: I'm already
On 23 Dec 2009, at 22:58, Patrick M. Rutkowski wrote:
In that case, let me put it this way:
Is the query
UPDATE my_table SET colname = NULL WHERE colname ~ '^\s*$'
already all correct and standard conforming. Such that all I need to
do is turn on standard_conforming_strings to have it
Hi,
S Arvind schrieb:
Hi Everyone,
In a web application running in Tomcat and Postgres 8.3 as DB, i need to
know whether my given task is feasible or not.
All the db operation which is done by that web application
must be rollback at the end(session dies) and the DB data must be
Hello -Yes I need to find out the column value like '%Volt%' in any
column of data_type (character varying) of any table. Basically what I
need to do is go thro each columns of all tables and find any entries
that have Voltage followed by some number e.g. 'Voltage 4.8000'.Then I
need to use
On Dec 23, 3:44 pm, r...@iol.ie (Raymond O'Donnell) wrote:
On 23/12/2009 02:56, Thomas wrote:
And could you give me some info about postgres internals? Such as
ebooks or online articles.
There's quite a bit in the manual:
http://www.postgresql.org/docs/8.4/interactive/internals.html
I guess PID 19045 write data to the log file first when I insert data
into table ,but why did writer process also access the log file ?
Could some guy tell me some details ?
FYI:
postgres: writer process's PID is 18848 .
postgres test [local] idle's PID is 19045 .
[r...@localhost tmp]# lsof
On Dec 21, 2009, at 9:34 AM, Pavel Stehule wrote:
2009/12/21 Israel Brewster isr...@frontierflying.com:
On Dec 19, 2009, at 2:59 AM, Filip Rembiałkowski wrote:
2009/12/18 Gauthier, Dave dave.gauth...@intel.com
Can you define your own commands in PG.
In psql, yes:
\set sel 'SELECT *
Is there a way to modify or delete an element of an array with knowledge only
of the element's value? Maybe an array index finder would help?
For example
create table foo (name,text, arr text[]);
insert into foo (name,arr) values ('joe',ARRAY['a','b','c']);
update foo set
On Thu, Dec 24, 2009 at 10:01 AM, Gauthier, Dave
dave.gauth...@intel.com wrote:
Is there a way to modify or delete an element of an array with knowledge
only of the element’s value? Maybe an array index finder would help?
I haven't tried it myself, but would the array contains operator work
I was hoping to finally get the servers updated from 8.2 to 8.4 over the
festive season, but by now I think I've left things too tight.
Is it necessary to update the (Windows) ODBC driver as well? I've got a
couple of app servers still on NT4 with ODBC 8.02.0100 which I'm trying
to be careful
Hello! I have problems with installation PostgreSQL 8.4.2 on Windows7x64.
Installation passes normally, but in the end there is an error message of
the following maintenance: Problem running post-instal step. Installation
may not complete correctly. The database cluster initialisation failed. In
Hi,
I have to summarize some data to be queried and there are about 5 million raw
records a day I need to summarize. In a nutshell I don't think I'm laying it
out in an optimal fashion, or not taking advantage of some postgres features
perhaps, I'm looking for feedback.
The raw incoming data
I have some SPI C functions which dispatch to a selected PostgreSQL
function based on the the first argument value. I have 3 questions
and am very open to any other advise you might have:
1. If any of the arguments are bigger than a word, e.g. text or arrays,
do I need to copy them into upper
On Thursday 24 December 2009 11:20:35 am Mark Morgan Lloyd wrote:
I was hoping to finally get the servers updated from 8.2 to 8.4 over the
festive season, but by now I think I've left things too tight.
Is it necessary to update the (Windows) ODBC driver as well? I've got a
couple of app
This is sort of a PostgreSQL question/sort of a general SQL question, so I apologize if this isn't the best place to ask. At any rate, I know in PostgreSQL you can issue a command like 'SELECT "time"(timestamp_column) from table_name' to get the time part of a timestamp. The problem is that this
On Thursday 24 December 2009 5:35:10 am Rajan, Pavithra wrote:
Hello -Yes I need to find out the column value like '%Volt%' in any
column of data_type (character varying) of any table. Basically what I
need to do is go thro each columns of all tables and find any entries
that have Voltage
Poi
Uyploiyuhytrwqwddhg grgrr.
Sent from my iPhone
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
This is sort of a PostgreSQL question/sort of a general SQL question,
so I apologize if this isn't the best place to ask. At any rate, I
know in PostgreSQL you can issue a command like 'SELECT
time(timestamp_column) from
On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
This is sort of a PostgreSQL question/sort of a general SQL question,
so I apologize if this isn't the best place to ask. At any rate, I
know in PostgreSQL you can issue a command like 'SELECT
time(timestamp_column) from
On Thu, Dec 24, 2009 at 1:01 PM, Doug El doug...@yahoo.com wrote:
Hi,
I have to summarize some data to be queried and there are about 5 million raw
records a day I need to summarize. In a nutshell I don't think I'm laying it
out in an optimal fashion, or not taking advantage of some
Scott,
You can use the regex I posted to get rid of the data easily, then go
back to the substr one for a check constraint after that.
regex is non-standard.
How to implement this in standard SQL ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Thursday 24 December 2009 3:47:23 pm Andrus wrote:
Scott,
You can use the regex I posted to get rid of the data easily, then go
back to the substr one for a check constraint after that.
regex is non-standard.
How to implement this in standard SQL ?
Andrus.
Why should it matter? The
I'm trying to create an index on the month and year of a date field (in
8.3), and I'm getting the functions in index expression must be marked
IMMUTABLE error message.
I thought dates were immutable, and didn't think that DATE_TRUNC did
anything to change that. These all fail:
create index
On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
kian.wri...@senioreducators.com wrote:
I'm trying to create an index on the month and year of a date field (in
8.3), and I'm getting the functions in index expression must be marked
IMMUTABLE error message.
If applied to a timestamp, it is
On Thu, Dec 24, 2009 at 4:47 PM, Andrus kobrule...@hot.ee wrote:
Scott,
You can use the regex I posted to get rid of the data easily, then go
back to the substr one for a check constraint after that.
regex is non-standard.
How to implement this in standard SQL ?
I take it you need a way
On Fri, Dec 25, 2009 at 12:56 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
kian.wri...@senioreducators.com wrote:
I'm trying to create an index on the month and year of a date field (in
8.3), and I'm getting the functions in index expression
On Thu, Dec 24, 2009 at 6:47 PM, Greg Stark gsst...@mit.edu wrote:
On Fri, Dec 25, 2009 at 12:56 AM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
kian.wri...@senioreducators.com wrote:
I'm trying to create an index on the month and year of a date
29 matches
Mail list logo