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 alpha-numer
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 stage(of
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 alrea
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
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 mu
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 rege
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/interna
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 /var/
On Dec 21, 2009, at 9:34 AM, Pavel Stehule wrote:
2009/12/21 Israel Brewster :
On Dec 19, 2009, at 2:59 AM, Filip Rembiałkowski wrote:
2009/12/18 Gauthier, Dave
Can you define your own commands in PG.
In psql, yes:
\set sel 'SELECT * FROM'
:sel clients;
\set desc '\\d'
:desc table
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 arr[indexfinder('b')
On Thu, Dec 24, 2009 at 10:01 AM, Gauthier, Dave
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 for you?
http://www.p
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
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 mem
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 s
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 co
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 table
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 table
On Thu, Dec 24, 2009 at 1:01 PM, Doug El 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 postgres features
>
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 changes
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 mat
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 en
On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
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 immutable. If it's a timestamp with
On Thu, Dec 24, 2009 at 4:47 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 ?
I take it you need a way to scrub y
On Fri, Dec 25, 2009 at 12:56 AM, Scott Marlowe wrote:
> On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
> 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
On Thu, Dec 24, 2009 at 6:47 PM, Greg Stark wrote:
> On Fri, Dec 25, 2009 at 12:56 AM, Scott Marlowe
> wrote:
>> On Thu, Dec 24, 2009 at 4:36 PM, Kian Wright
>> 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 e
29 matches
Mail list logo
