On Fri, Oct 21, 2011 at 1:02 PM, Henry Drexler wrote:
>
> On Fri, Oct 21, 2011 at 6:10 AM, Raymond O'Donnell wrote:
>
>>
>> Glad you got sorted. What was the problem in the end?
>>
>> Ray.
>>
>> apart from the solution I sent earlier I have n
I realize I have sent a lot of messages on this thread so this will be the
last one unless I come up with a solution, then I will post that.
The idea behind this is to take a string and remove one character from it
successively and try to match that against any of the nodes in the query.
So for
On Fri, Oct 21, 2011 at 2:57 PM, Henry Drexler wrote:
> I realize I have sent a lot of messages on this thread so this will be the
> last one unless I come up with a solution, then I will post that.
>
>
Resolved.
Ray - thanks again for your help.
The pattern was it was only matchin
I am thinking there is a better/simpler way, though this is what I have
working:
(postgres 9.1)
I would like to have the list of colors for each type of clothing to be
comma seperated in the end result.
like this:
typeorganized_by_type
pants red, blue, orange
shirt black, gra
On Thu, Nov 10, 2011 at 8:34 AM, Thomas Kellerer wrote:
>
>>
> SELECT type,
> string_agg(color, ',') as organized_by_type
> FROM clothes
> GROUP BY type;
>
>
>
wow, yes that is cleaner.
Thank you for taking the time - obviously I need to read through the string
functions again.
google 'weeks of supply'
On Mon, Nov 21, 2011 at 1:18 PM, Jason Long
wrote:
> I have a custom inventory system that runs on PG 9.1. I realize this is
> not a postgres specify question, but I respect the skills of the members of
> this list and was hoping for some general advice.
>
> The system i
On Fri, Dec 9, 2011 at 5:48 PM, Jack Christensen wrote:
> CREATE TABLE people(
> id serial PRIMARY KEY,
> name varchar NOT NULL
> );
>
> INSERT INTO people(name) VALUES('Adam'), ('Adam'), ('Adam'), ('Bill'),
> ('Sam'), ('Joe'), ('Joe');
>
> SELECT name, count(*), random()
> FROM people
> GROUP B
I am looking for a mac platform installer for what I was told I
needed, pgcrypto.
Assistance finding this would be appreciated...
Steve Henry
San Diego Mac IT
http://www.sdmacit.com
760.751.4292 Office - 760.546.8863 Cell
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Hola a todos
necesito ayuda como configurar mi base de datos como aceptar conexiones ssl
desde cualquier ip, mi base de datos esta instalada en Windows:
En donde tengo que hacerlo:
pg_hba.conf
postgresql.conf
Gracias
Henry Interiano
San Pedro Sula, Honduras
Last week, I tried to arrange for you to receive a slightly
damaged copy of Derek Gehl's "Internet Millionaire's Protégé
Bootcamp" videos... but I don't think you got them?
Since these copies are available for a DEEP discount, I
didn't think you'd care about a couple of scuff marks on
the pack
works fine - the index is used. However, extend the where
clause with an extra line (say, col1 = 9) and the index is no longer used.
Is there a parameter I can SET to extend the number of items allowed for
index usage?
Any pointers would be appreciated.
; queries are pessimized the other direction, but some experimentation
> comparing the real times and estimated costs of queries with and without
> enable_seqscan=off may help.
Thanks for the detailed response! Your suggestion was spot-on.
Regards
Henry
---
> "Henry Combrinck" <[EMAIL PROTECTED]> writes:
>
>> The above works fine - the index is used. However, extend the where
>> clause with an extra line (say, col1 = 9) and the index is no longer used.
>
> Do
>
> explain analyze select ...
>
>
nother schema is not what they're after either.
1. If it is possible to remove the public schema, what are the
ramifications to existing databases in our system (ie, will a dump/restore
be required, etc)?
2. If it's not possible, can it be done
..and miss out on the nourishing goodness of 7.4? I don't think so!
Thanks anyway.
Regards
Henry
This message was sent using MetroWEB's AirMail service.
http://www.metroweb.co.za/ - full access for only R73.
Free Web Accelerat
e information.
Regards
Henry
This message was sent using MetroWEB's AirMail service.
http://www.metroweb.co.za/ - full access for only R73.
Free Web Accelerator, WebMail, Calendar, Anti-Virus,
Anti-Spam, 10 emails, 100MB personal w
nction "myfunc" line 2 at SQL statement
Thanks for you help!
--
Henry Molina
R&D
CMN Consulting
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
I'm trying to craft a query that will determine what column(s) are the
primary key for a given table. I have succeeded but the query is so
ugly that it borders on silly and cannot work for an arbitrary number of
tables since indkey is an int2vect and the ANY keyword does not work on
it.
Ple
#x27;ve just inserted.
Thanks for any tip
--
Florence HENRY
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
temprec row to func2() */
...
end loop;
end;
Then call with:
SELECT FUNC1();
Is this possible? The docs only speak about RECORD type being used to
*return* rows, but not to pass it.
Any pointers would be appreciated.
Regards
Henry
This me
> "Henry Combrinck" <[EMAIL PROTECTED]> writes:
>> Essentially, I would like to pass a RECORD variable from one function to
>> another using plpgsql:
>
>> func2(record)
>
> You can't declare a plpgsql function that accepts RECORD; this is simp
Hello,
I have a table with 29268 odd records. Deleting records is VERY slow,
and I don't know why.
I explained analysed the following query:
delete from people where id < '2000'
Index Scan using people_pkey on people (cost=0.00..71.68 rows=2792
width=6) (actual time=1.361..5.657 rows=2000 loop
Hi Tom,
Thanks for your help. I checked types and indexes, to no avail. Vacuum
didn't help. but vacuum full did, it's now fast again.
Cheers,
Brock
On Mon, 11 Oct 2004 23:38:49 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brock Henry <[EMAIL PROTECTED]> writes:
>
Peter Eisentraut wrote:
>
> Orion Henry writes:
>
> > The indexes will be
> > int8 (primary key)
> > int4 (group number)
> > timestamp (creation date)
> > int4 (customer id)
>
> Since one query can only use one index per table, you should only ne
Richard H wrote:
>
> On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote
> regarding [GENERAL] Fast Inserts and Hardware Questions:
>
> Please bear in mind that you are operating well above anything I do, so
> I'm not speaking from experience.
I ap
On Feb 23, 2007, at 1:24 PM, Joshua D. Drake wrote:
Henry Hotz: GSSAPI (with Magnus)
Progressing. Had hoped to have alpha patches by March 1, but I just
got handed a proposal that I have to do by then. I trust it's OK to
send the first version in next week?
No real issues, exc
avoid memory problems." from section 37.8 in the
manual?
Regards
Henry
--
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, June 13, 2008 7:05 pm, Tom Lane wrote:
> How soon is "bang"?
I'll run it again and post back.
> The memory overhead per subtransaction is
> not zero, though I think it's fairly small if you don't have any
> triggers pending as a result of the insert.
Two triggers are fired for each inser
www.slony.info/) a try - the initial replication of the
entire DB takes a while, thereafter it only replicates changes (as they
happen).
We've been using it successfully (it has it's occasional problems like all
things) for over a year now replicating across a cluster (DB is also about
ce this happened yesterday as we're
preparing for the month-end billing run (and getting things back online
was critical) :-(
Regards
Henry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the TEXT column
almost immediately.
Weird. Anyway, I'm just relieved the solution was fixing my stupid SQL.
Regards
Henry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, June 30, 2008 9:45 pm, Tom Lane wrote:
> "Henry - Zen Search SA" <[EMAIL PROTECTED]> writes:
>> The problem was this: a silly SQL error (misuse of OR and missing
>> parentheses) resulted in a massive result set which resulted in OOM - if
>> the sel
as an email to the site, or something) the fact
that the download site *didn't* have a link with the latest changes - I
hated having to download the entire ball of wax just so I could read the
changelog...
good times.
Cheers
Henry
--
Sent via pgsql-general mailing list (pgsql-general@po
r to use and to manage (eg, when things go wrong [they do]).
Regards
Henry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Danny wrote:
> - Hello
> - I had previous experience with Access and MySQL.
>
> -Situation
>
> - I am trying to create the equvilant of the following which is a mysql
> command.
>
> - Queston
> - But I cannot figure out how to do this is postgresql
>
> "mysql -u root -p mydb < mydb.dump"
>
I thi
101 - 135 of 135 matches
Mail list logo
