John R Pierce, 06.05.2009 07:33:
I use postgres database server 8.2.12 with my java
application. I was wondering if postgres supports transactions by
default or do i have to turn some parameter on to enable transaction
support ?
Postgres supports transactions by default.
Actually
CM J wrote:
Hi ,
I use postgres database server 8.2.12 with my java
application. I was wondering if postgres supports transactions by
default or do i have to turn some parameter on to enable transaction
support ?
Postgres supports transactions by default.
Postgres JDBC drivers
Hi ,
I use postgres database server 8.2.12 with my java application. I
was wondering if postgres supports transactions by default or do i have to
turn some parameter on to enable transaction support ?
Thanks.
Dan Armbrust escribió:
> My particular disk-full condition was on ext2. Nothing exotic. Also,
> the process that filled the disk was postgres - if that makes any
> difference - I had left a debug level turned up in the postgres config
> file, and it was logging every single db query. Since it w
On Tue, 2009-05-05 at 00:10 -0700, DaNieL..! wrote:
> But still i have some trouble to understand the functionality of the
> orders example.
> My first goal is to retrieve every order, the customer name, and the
> total of the idems per order.. so (from my point of view) i *dont*
> need and *dont*
DaNieL..! wrote:
Hi guyst.. thanks for the replies, really, them make me suppose that
all what i've learned of sql from mysql can be wrong..
But still i have some trouble to understand the functionality of the
orders example.
My first goal is to retrieve every order, the customer name, and the
t
On Tue, May 5, 2009 at 9:10 AM, DaNieL..! wrote:
> Hi guyst.. thanks for the replies, really, them make me suppose that
> all what i've learned of sql from mysql can be wrong..
Replace "all" with "much" and you pretty much got the problem with
using MySQL for your first database experience. (Not
It sounds like you want a crosstab query. There is probably (I don't know
what version of postgres you're using) a contrib package called "tablefunc"
that includes the crosstab functions you're looking for.
_
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgre
Hello!
I'd like to dynamically prepare and execute a certain statement in
PL/perl, i.e. I don't know at the time of calling my trigger function
how many arguments I need to pass for this queries and which types they
have. The command string is assembled dynamically, as is the list of
type-identifi
Joshua Berry wrote:
> Greetings all,
>
> I know that this is an elementary question, so I'm just asking for a pointer
> in
> the right direction.
>
> I have a query like this that tries to link Retail shops (from the table
> aliased as 'a') to sales reps (from the table aliased as 'e') that se
Joshua Berry wrote:
> Greetings all,
>
> I know that this is an elementary question, so I'm just asking for a pointer
> in
> the right direction.
>
> I have a query like this that tries to link Retail shops (from the table
> aliased as 'a') to sales reps (from the table aliased as 'e') that se
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua Berry
> Sent: Tuesday, May 05, 2009 10:39 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Converting Rows to Columns
>
> Greetings all,
>
> I know
2009/5/5 Joshua Berry :
> Greetings all,
> I know that this is an elementary question, so I'm just asking for a pointer
> in the right direction.
> I have a query like this that tries to link Retail shops (from the table
> aliased as 'a') to sales reps (from the table aliased as 'e') that service
>
Greetings all,
I know that this is an elementary question, so I'm just asking for a
pointer in the right direction.
I have a query like this that tries to link Retail shops (from the
table aliased as 'a') to sales reps (from the table aliased as 'e')
that service the given Retail shop:
On Tue, 2009-05-05 at 10:04 +, Glyn Astill wrote:
> Can anyone point me at interesting tools they've used?
You may want to contact Greenplum -- their product has the
specifications that you asked.
http://www.greenplum.com/
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, dev
daniel
what happens when you implement the INNER JOIN statement and remove group by
?
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de
déni et de confidentialité
This message is confidential. If you should n
On May 4, 9:27 am, DaNieL wrote:
> Sorry, i know that this maybe is a basically problem, but i come from
> mysql.. and in mysql that query works...
if there's only one name per order, just put a min or max around the
second col. as you know by now, all columns that are not GROUPed BY
must be in
On Tue, May 05, 2009 at 10:04:15AM +, Glyn Astill wrote:
> I'm looking at building an olap reporting environment and I came across this
> project on pgfoundry. However it was last updated over 3 years ago, am I
> correct in assuming that this probably isn't something I should be looking at?
I'
Hi guyst.. thanks for the replies, really, them make me suppose that
all what i've learned of sql from mysql can be wrong..
But still i have some trouble to understand the functionality of the
orders example.
My first goal is to retrieve every order, the customer name, and the
total of the idems p
Hi chaps,
I'm looking at building an olap reporting environment and I came across this
project on pgfoundry. However it was last updated over 3 years ago, am I
correct in assuming that this probably isn't something I should be looking at?
Can anyone point me at interesting tools they've used?
20 matches
Mail list logo
