On Thu, Sep 09, 2010 at 11:16:36AM -0400, Tom Lane wrote:
> Henk van Lingen writes:
> > On Thu, Sep 09, 2010 at 10:50:52AM -0400, Tom Lane wrote:
> Well, there's your problem: the planner is off by a factor of about 500
> on its estimate of the number of rows matching this query,
Maybe you can extract stuff like IP addresses and words like 'error'
and put it in a separate column in the table. Full text search is not
a solution for data that is in a wrong format.
On Fri, Sep 10, 2010 at 10:27 AM, Henk van Lingen wrote:
> On Thu, Sep 09, 2010 at 11:16:36AM -0400, Tom Lane w
Hi,
Yes, you're right! I found out a functional index using this function and
ANALYZE also cancels.
Is there a way to code this function in a way VACUUM/ANALYZE does not
cancel?
Thank you!
brasil=# analyze "BRASIL".tt_tit;
ERROR: invalid type name "TT_TIT.SEQCAN%TYPE"
CONTEXT: compile of PL/p
Hello, I have a table defined as:
CREATE TABLE demo AS
(
id serial PRIMARY KEY,
start_time timestamp without timezone,
duration integer
)
A sample data set I am working with is:
start_time | duration | end_time
-+--+---
Have you checked the OVERLAPS operator in the documentation?
http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html
--
Jorge Godoy
On Fri, Sep 10, 2010 at 10:03, Ketema Harris wrote:
> Hello, I have a table defined as:
>
> CREATE TABLE demo AS
> (
>id serial PR
On Sep 10, 9:08 am, jgo...@gmail.com (Jorge Godoy) wrote:
> Have you checked the OVERLAPS operator in the documentation?
>
> http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html
>
> --
> Jorge Godoy
>
>
>
> On Fri, Sep 10, 2010 at 10:03, Ketema Harris wrote:
> > Hello, I ha
Carlos Henrique Reimer writes:
> Yes, you're right! I found out a functional index using this function and
> ANALYZE also cancels.
> Is there a way to code this function in a way VACUUM/ANALYZE does not
> cancel?
I think your problem is probably a search_path issue, ie vacuumdb is not
running wi
I am brand new to PostgreSQL and coming from MySQL. My question is
does anyone know after I install PostgreSQL on my Linux server, is
there a script that secures the database like MySQL offers in most
Linux distributions? I think the script for MySQL is
"/usr/bin/mysql_secure_installation". I check
On Fri, Sep 10, 2010 at 8:12 AM, Carlos Mennens
wrote:
> Do you guys know if this exist for PostgreSQL and or do you have any
> suggestions for a fresh installation of PostgreSQL on Linux?
I don't believe there is a script like this. However, I would say
that out of the box, PostgreSQL is so se
Ok I have been flailing at trying to understand both syntax and concepts...I
think I am moving forward as I have a query that returns a result...its just
the wrong result
SELECT count(*) OVER w as max_concurrency,
start_time::date as "interval"
FROM demo
GROUP BY start_time::date,
Carlos Mennens writes:
> I am brand new to PostgreSQL and coming from MySQL. My question is
> does anyone know after I install PostgreSQL on my Linux server, is
> there a script that secures the database like MySQL offers in most
> Linux distributions? I think the script for MySQL is
> "/usr/bin/m
On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
wrote:
> I don't believe there is a script like this. However, I would say
> that out of the box, PostgreSQL is so secure that some people cannot
> figure out how to log in. :)
I agree and I am just now learning this. I can't seem to find out ho
On Fri, Sep 10, 2010 at 11:53:12AM -0400, Carlos Mennens wrote:
> On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
> wrote:
> > I don't believe there is a script like this. However, I would say
> > that out of the box, PostgreSQL is so secure that some people
> > cannot figure out how to log in
8.3.4 on Linux
Is there a way to regexp match on a null value? Or is it necessary to OR in a
"or x is null"?
Thanks in Advance !
Hey Dave,
Did you consider to use coalesce() ?
Regards,
Dmitriy
2010/9/10 Gauthier, Dave
> 8.3.4 on Linux
>
>
>
> Is there a way to regexp match on a null value? Or is it necessary to OR
> in a "or x is null"?
>
>
>
> Thanks in Advance !
>
On Fri, Sep 10, 2010 at 9:00 AM, Gauthier, Dave wrote:
> Is there a way to regexp match on a null value?
I would say no.
> Or is it necessary to OR in a "or x is null"?
you could use a
COALESCE( text_column, '') ~ E'MyRegEx';
Or perhaps:
( text_column ~ E'MyRegEx' ) IS UNKNOWN
might
Ya, I kinda knew about these approaches. The problem ahs to do with novice
users who don't know about coalesce or or;ing a check ofr nulls. I was hoping
there was some special regexp expression that would match to a null.
Thanks for the quick response, and have a great weekend !
-Original
As someone famous once said:
The documentation I've found on \copy says to see the docs on copy ;)
It's *supposed* to match the backend syntax, but seems a few bricks
shy of a load at the moment. Anyone feel like fixing it? See
parse_slash_copy() in src/bin/psql/copy.c.
Th
On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave wrote:
> Ya, I kinda knew about these approaches. The problem ahs to do with novice
> users who don't know about coalesce or or;ing a check ofr nulls. I was
> hoping there was some special regexp expression that would match to a null.
Perhaps t
On Sep 9, 2010, at 8:31 PM, Jeff Davis wrote:
> On Thu, 2010-09-09 at 17:07 -0400, A.M. wrote:
>> Is there a technical limitation which prevents DO from being used in rules
>> or am I missing something with this?
>>
>> CREATE RULE test_update AS ON UPDATE TO test DO INSTEAD DO $$
> su - postgres
> psql -l
If you didn't set a password for the postgres user it's actually:
sudo su - postgres
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Sep 10, 2010 at 1:30 PM, A.M. wrote:
> On Sep 9, 2010, at 8:31 PM, Jeff Davis wrote:
>> On Thu, 2010-09-09 at 17:07 -0400, A.M. wrote:
>>> Is there a technical limitation which prevents DO from being used in rules
>>> or am I missing something with this?
>>>
>>> CREATE RULE test_update AS
On Fri, 2010-09-10 at 13:39 -0400, Merlin Moncure wrote:
> IDK...functions do everything 'DO' does, and support returning data,
> which is necessary to support RETURNING. Rules are already fairly
> capricious and problematic and I doubt any proposal that doesn't fix
> or work around their basic f
Ralph Smith writes:
> I have a one column .txt file on Ubuntu that I'm trying to upload, and
> \copy new_coupons '/home/rsmith/testfile.txt'
I think you need
\copy new_coupons from '...'
Like it says, it's supposed to match the backend syntax, modulo needing
a starting backsl
"Joshua D. Drake" writes:
> On Fri, 2010-09-10 at 13:39 -0400, Merlin Moncure wrote:
>> IDK...functions do everything 'DO' does, and support returning data,
>> which is necessary to support RETURNING. Rules are already fairly
>> capricious and problematic and I doubt any proposal that doesn't fix
On Fri, Sep 10, 2010 at 10:25:52AM -0700, Ralph Smith wrote:
> Yes, we are planning to upgrade to 8.3, but now I'm stuck w/ 7.4.
Don't stay stuck there too long. It's about to end its life, as are
8.0 and 8.1, later this year.
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
>
On Fri, Sep 10, 2010 at 10:25:55AM -0700, Richard Broersma wrote:
> On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave
> wrote:
> > Ya, I kinda knew about these approaches. The problem ahs to do
> > with novice users who don't know about coalesce or or;ing a check
> > ofr nulls. I was hoping there
>I can't seem to find out how
> to login to the database. I am using 'psql -U root' however during my
> installation there may have been a default password used which I am
> not aware of. I need to read the docs and see how to login to the
> database.
I usually do like this on a new box
sudo su -
Carlos Mennens wrote on 10.09.2010 17:53:
On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
wrote:
I don't believe there is a script like this. However, I would say
that out of the box, PostgreSQL is so secure that some people cannot
figure out how to log in. :)
I agree and I am just now l
Agree with David.
Regards,
Dmitriy
2010/9/10 David Fetter
> On Fri, Sep 10, 2010 at 10:25:55AM -0700, Richard Broersma wrote:
> > On Fri, Sep 10, 2010 at 9:56 AM, Gauthier, Dave
> wrote:
> > > Ya, I kinda knew about these approaches. The problem ahs to do
> > > with novice users who don't kno
What would be the regexp_split_to_table pattern that splits a comma
separated string into a table? Im having trouble when a string
contains commas or there are commas at the beginning or end
String
',one,two,''three,four'',five,six,'
Should return
,one
two
three,four
five
six,
--
Sent via pgsql
On Fri, Sep 10, 2010 at 3:43 PM, Nick wrote:
> What would be the regexp_split_to_table pattern that splits a comma
> separated string into a table? Im having trouble when a string
> contains commas or there are commas at the beginning or end
>
> String
> ',one,two,''three,four'',five,six,'
>
> Sho
On 09/11/2010 01:39 AM, Arjen Nienhuis wrote:
su - postgres
psql -l
If you didn't set a password for the postgres user it's actually:
sudo su - postgres
Better written, and less prone to being broken by odd shell setups, as:
sudo -u postgres psql
--
Craig Ringer
--
Sent via pgsq
Yes, that gets down to the root of my question... what is the
expression that would properly split the values? -Nick
On Sep 10, 4:43 pm, brick...@gmail.com (bricklen) wrote:
> On Fri, Sep 10, 2010 at 3:43 PM, Nick wrote:
> > What would be the regexp_split_to_table pattern that splits a comma
> >
Excerpts from Nick's message of vie sep 10 20:36:24 -0400 2010:
> Yes, that gets down to the root of my question... what is the
> expression that would properly split the values? -Nick
The only idea that comes to mind right now is to remove them before
processing the rest of the string, and put th
I dont mind if the commas are at the beginning and end, im more
concerned about "three,four" staying in one row because its surrounded
by quotes. -Nick
On Sep 10, 6:03 pm, alvhe...@commandprompt.com (Alvaro Herrera) wrote:
> Excerpts from Nick's message of vie sep 10 20:36:24 -0400 2010:
>
> > Yes
Coming from 25 years of programming applications based on dBASE and FoxPro
tables, I have a question about how to deal with a programming task.
I have a situation where I receive a file with transactions that have a
unique key from a vendor. These transactions should only be imported into
my syste
On 09/10/2010 08:07 PM, t...@exquisiteimages.com wrote:
I have a situation where I receive a file with transactions that have a
unique key from a vendor. These transactions should only be imported into
my system once, but the vendor system will occasionally resend a
transaction by mistake.
The w
On 09/10/10 8:07 PM, t...@exquisiteimages.com wrote:
Coming from 25 years of programming applications based on dBASE and FoxPro
tables, I have a question about how to deal with a programming task.
I have a situation where I receive a file with transactions that have a
unique key from a vendor.
39 matches
Mail list logo