Sweet Savings
it is really best place for online shopping
i had try , it is truth and service is very good
fast ship and best quality
hope you can try too
here is the site : :
sure you will like it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On Thu, Mar 5, 2009 at 10:34 AM, Tom Lane wrote:
> Pat Maddox writes:
>> I have an ubuntu intrepid server running postgres 8.3.6. The server
>> is able to accept connections via SSL.
>
>> We have another host that is unable to connect via ssl for some
>> reason.
I have an ubuntu intrepid server running postgres 8.3.6. The server
is able to accept connections via SSL.
We have another host that is unable to connect via ssl for some
reason. Trying to connect results in
psql:
and quitting. The server log says
"could not accept SSL connection: EOF detected"
On 10/26/07, brian <[EMAIL PROTECTED]> wrote:
>
>
> Pat Maddox wrote:
> > On 10/26/07, brian <[EMAIL PROTECTED]> wrote:
> >
> >>>
> >>
> >>
> >>SELECT * FROM posts ORDER BY root_id, id;
> >>
> >>brian
> &g
On 10/26/07, brian <[EMAIL PROTECTED]> wrote:
> Pat Maddox wrote:
> > Right now my table looks like this:
> >
> > posts
> > id
> > body
> > parent_id
> > root_id
> > created_at
> >
> > so if I've got the rec
On 10/26/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 26, 2007, at 10:56 , Pat Maddox wrote:
>
> > A bunch of options so far...but there's really no way to do this with
> > standard SQL?
>
> What do you mean by "standard SQL"? Trees a
On 10/26/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 26, 2007, at 4:19 , Gregory Stark wrote:
>
> > "D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> >
> >> You need to look at the connectby function which is part of contrib.
> >
> > Or ltree. Depending on how static your data is an
I'd like to store some tree data in my database. I want to be able to
sort the data but maintain a tree structure. So for example, if I
order by a timestamp, I should get
- parent1
* child1
* child2
* child3
- parent2
* child4
* child5
and if I reverse the sort order, I get
- pare
I've got a bunch of companies that are associated with several videos.
The videos have different statuses. I want to select all the
companies in the database, and order them by videos that have a
complete status.
Here's what I have so far
SELECT
companies.id,
companies.name,
companies.nic
I'd like any advice you have on my postgres.conf. The machine in
question is a 2.4 Ghz Xeon with 2 gigs of ram running freebsd 6.2 and
postgres 8.2. There are 16 concurrent users. This machine is used
only for the database. Usage is split out pretty evenly between reads
and writes.
Thanks,
Pa
On 7/18/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Jul 18, 2007, at 16:48 , Pat Maddox wrote:
> For some reason the functions you wrote are giving me trouble (there's
> a BIGINT involved, I tried changing the functions around but kept
> having issues).
You might
On 7/18/07, Pat Maddox <[EMAIL PROTECTED]> wrote:
On 7/18/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Jul 18, 2007, at 16:12 , Pat Maddox wrote:
>
> > ERROR: invalid reference to FROM-clause entry for table "video_views"
> > LINE 20: JOI
On 7/18/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Jul 18, 2007, at 16:12 , Pat Maddox wrote:
> ERROR: invalid reference to FROM-clause entry for table "video_views"
> LINE 20: JOIN assets ON (video_views.video_id=videos.id)
> ^
>
On 7/18/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On 7/18/07, Pat Maddox <[EMAIL PROTECTED]> wrote:
> I've got a query that's taking forever (as will be obvious when you
> see it and the explain output). I can't figure out what indexes to
> add to m
On 7/18/07, Pat Maddox <[EMAIL PROTECTED]> wrote:
I've got a query that's taking forever (as will be obvious when you
see it and the explain output). I can't figure out what indexes to
add to make this run faster. I'd appreciate any help.
Pat
SELECT
SUM(
I've got a query that's taking forever (as will be obvious when you
see it and the explain output). I can't figure out what indexes to
add to make this run faster. I'd appreciate any help.
Pat
SELECT
SUM(CASE WHEN (hit IS TRUE AND logged_in IS TRUE) THEN 1 ELSE 0 END)
AS count_hits_console,
My databases all have the default SQL_ASCII encoding. I read the docs
and it says that you shouldn't use it if you're going to have any
non-ASCII data. I need to start supporting UTF-8, so it seems I need
to convert my database. Can I just convert it, or do I need to dump
it, drop it, recreate
On 4/24/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Pat Maddox wrote:
> I want to start using slony for replication, and have a question about
> setting table IDs when creating replication sets. The docs say that
> you have to be careful in what IDs you assign to the tables -
I want to start using slony for replication, and have a question about
setting table IDs when creating replication sets. The docs say that
you have to be careful in what IDs you assign to the tables - if
there's a relationship between two tables, the parent needs to have a
lower ID.
So let's tak
I end up calling this query quite often, so I need a way to speed it
up. Don't know if I can take advantage of indexes or better joins or
something (I don't even know if there are better joins), I'm really a
newbie to DB stuff. Hoping somebody can help me make this much
quicker.
EXPLAIN ANALYZ
On 6/13/06, Chris <[EMAIL PROTECTED]> wrote:
Pat Maddox wrote:
> Here's my SQL query. I don't think it's too gigantic, but it is kind
> of beastly:
>
> SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
> trainer_scenario_stats stats WHERE r.u
Here's my SQL query. I don't think it's too gigantic, but it is kind
of beastly:
SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
trainer_scenario_stats stats WHERE r.user_id=1 AND
r.trainer_scenario_id=s.id AND s.id=stats.trainer_scenario_id AND
r.action=stats.correct_action;
I've got a table with that has 5 fields. Nearly every query I make to
this table is of the form
SELECT * FROM table1 WHERE field1='foo' AND field2=7;
It's always those two exact fields. How should I index this to get
the best performance?
Also, how can I find what other parts of my app would b
23 matches
Mail list logo
