On Oct 3, 2005, at 1:05 AM, Jeff Davis wrote:
What pg_dump backup modes do people usually use for a backup of an
entire database cluster? I usually use plaintext and pipe it through
gzip, however, that doesn't allow you to restore single objects from a
complete backup.
Is there a way to back u
am 03.10.2005, um 18:48:03 +0530 mailte Aman Tur folgendes:
>
>
> I have installed PostgreSQL 8 and latest pgODBC and ADO drivers but still I
> am not able to connect to it from access or VB 6. Kindly help me.
Instead HTML-mail with a picture you should better post a detailed
error-message and
I thought it might be of interest to some to post steps to using
PostgreSQL on
Windows with the Dev-Cpp/MINGW IDE/compiler.This example is C, but the
steps for configuring the IDE/Project to use the PostgreSQL libs/headers
should be the same or very similar for C++/ecpg.
Install PostgreSQL for W
I have installed PostgreSQL 8 and latest
pgODBC and ADO
drivers but still I am not able to connect to it from access or VB 6. Kindly
help me.
Aman Tur
"Chris St Denis" <[EMAIL PROTECTED]> writes:
> Does postgres support in-memory only tables like the mysql HASH table type?
No, and it doesn't seem particularly necessary: a table that is being
hit heavily will stay in cache buffers anyhow. You don't need any
special mechanism.
On Oct 3, 2005, at 5:38 PM, Chris St Denis wrote:
Can anyone suggest good forums software to use with postgresql? I
want to
integrate the forums users into my website's user base with a view.
Drupal has a forums module and works well with PostgreSQL.
http://drupal.org
John DeSoi, Ph.D.
h
Perfect, thanks!
On Oct 3, 2005, at 4:29 PM, Michael Fuhr wrote:
On Mon, Oct 03, 2005 at 12:37:30PM -0700, Ben wrote:
I'm making a query to return an int and a bytea as two columns in my
query, so I set up my PQExecParams call like so:
res = PQexecParams(conn,q,0,0,0,0,0,1)
I can view the b
Does postgres support in-memory only tables like the mysql HASH table type?
I want to store some session data which I need quick access of, but don't
care of it's lost on server stop/start
---(end of broadcast)---
TIP 9: In versions below 8.0, the
On 10/3/2005 12:12 AM, Tom Lane wrote:
Samik Raychaudhuri <[EMAIL PROTECTED]> writes:
... What I wanted is a no-trace (or minimal trace), no-admin required
kind of installation (I won't be able to create a non-admin user in the
comp), which, when I am done, I can just delete the installatio
On 10/3/05, Dann Corbit <[EMAIL PROTECTED]> wrote:
> Using SQL*Server, and OLEDB or ODBC data source can be connected as a
> linked server. Then, TSQL queries can go against PostgreSQL tables as
> though they were ordinary SQL*Server tables (but they have 4 part names
> instead of 3 part names).
On Mon, Oct 03, 2005 at 12:37:30PM -0700, Ben wrote:
> I'm making a query to return an int and a bytea as two columns in my
> query, so I set up my PQExecParams call like so:
>
> res = PQexecParams(conn,q,0,0,0,0,0,1)
>
> I can view the binary data just fine, but not the int. How do I do that?
On Mon, 2005-10-03 at 16:38, Chris St Denis wrote:
> Can anyone suggest good forums software to use with postgresql? I want to
> integrate the forums users into my website's user base with a view.
>
> I know of FudForums but it doesn't work well with views (the upgrade script
> in particular chok
On Wed, 2005-09-28 at 09:07 +0200, hubert depesz lubaczewski wrote:
> database has quite huge load of updates, but i thought that vacum will
> guard me from database bloat, but from what i observed it means that
> vacuuming of b-tree indices is somewhat faulty.
No, thats perfectly normal.
Indices
Can anyone suggest good forums software to use with postgresql? I want to
integrate the forums users into my website's user base with a view.
I know of FudForums but it doesn't work well with views (the upgrade script
in particular chokes very badly on them) and seems kinda buggy in general.
The
Yes! That did it, thanks for the help
On 10/3/05, Tony Wasson <[EMAIL PROTECTED]> wrote:
> On 10/3/05, Giovanni M. <[EMAIL PROTECTED]> wrote:
> > Round and trunc dont provide the functionality I need.
> >
> > Say for example I have two values in a column of type numeric as follows:
> > 23.455
> >
I'm making a query to return an int and a bytea as two columns in my
query, so I set up my PQExecParams call like so:
res = PQexecParams(conn,q,0,0,0,0,0,1)
I can view the binary data just fine, but not the int. How do I do that?
---(end of broadcast)---
Thank you very much Mike. I will do just that.
FernandoOn 9/30/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> User1 starts order and takes the last two units. User2 starts order 1 minut=> e> after and checks inventory. He sees 2 units left and adds them to the his> order. User1 commits his order. No
On 10/3/05, Giovanni M. <[EMAIL PROTECTED]> wrote:
> Round and trunc dont provide the functionality I need.
>
> Say for example I have two values in a column of type numeric as follows:
> 23.455
> 12.300
>
> What I need to happen is stripping the "useless" zeros in the
> fractional part of numbers
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the "useless" zeros in the
fractional part of numbers so 12.300 would become 12.3 and 23.455
would stay the same
Round
Did you look at the round function?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Giovanni M.
> Sent: Monday, October 03, 2005 11:45 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] strip zeros from fractional part
>
> Hi
Using SQL*Server, and OLEDB or ODBC data source can be connected as a
linked server. Then, TSQL queries can go against PostgreSQL tables as
though they were ordinary SQL*Server tables (but they have 4 part names
instead of 3 part names).
> -Original Message-
> From: [EMAIL PROTECTED] [mai
Hi guys,
I am searching for a function that enables me to strip the trailing
zeros in the fractional part of a number (numeric type). For example a
number saved in a column of type numeric as such: 23.45000 would be
returned as 23.45
I can't find any function that does this in the documentation,
Guys,
We have an in-house application that absolutely has to run against MS
Sql Server. We also have an application that doesn't, but that needs
to integrate with that MSSQL database.
I'm considering any options, including using application code as an
integration point. I'd prefer to somehow mir
On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
> Hi,
>
> I recently stumbled uppon the following thing:
> If I compare a field of type "numeric" to a small decimal constant like
> "3.6", the constant is interpreted as a "double precision" value and the
> comparison fails wi
OK..change another thing and try again.
1> Increase "Timeout" value in the file "/etc/httpd/conf/httpd.conf".
2> Restart http server by "/sbin/service httpd restart" command.
3> Now run your PHP script again.
I think the problem is not in PostgreSQL, the problem is somewhere
in PHP or http se
"Daniel Schregenberger" <[EMAIL PROTECTED]> writes:
> If I compare a field of type "numeric" to a small decimal constant like
> "3.6", the constant is interpreted as a "double precision" value and the
> comparison fails with the following message:
> # SELECT * FROM tr_table_okpx WHERE prating >= 3.
Firebird is a nice, small, ACID compliant database that embeds well.
firebird.sourceforge.net
- Original Message -
From: "Nirmalya Lahiri" <[EMAIL PROTECTED]>
To:
Sent: Sunday, October 02, 2005 7:34 PM
Subject: Re: [GENERAL] Broken pipe
Hi all,
I am not expert in PHP, so my assumption may not correct
Can we solve this problem by increasing the "max_execution_time"
value at
- Original Message -
From: "Tino Wildenhain" <[EMAIL PROTECTED]>
To: "Ben-Nes Yonatan" <[EMAIL PROTECTED]>
Cc: "Martijn van Oosterhout" ;
Sent: Sunday, October 02, 2005 4:26 PM
Subject: Re: [GENERAL] Broken pipe
Am Sonntag, den 02.10.2005, 16:39 +0200 schrieb Ben-Nes Yonatan:
Marti
Hi,
I recently stumbled uppon the following thing:
If I compare a field of type "numeric" to a small decimal constant like
"3.6", the constant is interpreted as a "double precision" value and the
comparison fails with the following message:
# SELECT * FROM tr_table_okpx WHERE prating >= 3.6;
Una
On Mon, Oct 03, 2005 at 12:01:02PM -, Denis G Dudhia wrote:
> I would like to know the limitations of PostgreSQL.
>
> Also, I would like to know, whether there is any limitations for the
> number of records or the size of the tables or database in
> PostgreSQL?
See PostgreSQL FAQ.
Section 4.
Hello There...
I am new to PostgreSQL.
I usually check out negative sides of any software or system, before implementing it or using it.
I would like to know the limitations of PostgreSQL.
Also, I would like to know, whether there is any limitations for the number of records or the size of the
> Hi Magnus, thanks for the reply. My inquiry was whether any
> other person was experiencing difficulties with a download
> and was aimed at trying to figure out for myself what might
> be happening. It was not a help request or any form of
> criticism. However, in answer to your first questio
Hi Magnus, thanks for the reply. My inquiry was whether any other person was
experiencing difficulties with a download and was aimed at trying to figure out
for myself what might be happening. It was not a help request or any form of
criticism. However, in answer to your first questions
1 No err
> Hello all, Is anyone having trouble downloading the Win 32
> binary announced on September 18? I am in Australia and
> cannot download from any of the Australian or US mirrors.
> Would like to receive confirmation whether or not I am the
> stupid one!!!
So what error msg do you get? Do you g
Hello all, Is anyone having trouble downloading the Win 32 binary
announced on September 18? I am in Australia and cannot download from
any of the Australian or US mirrors. Would like to receive confirmation
whether or not I am the stupid one!!!
Regards
John Craddock
P.S hope at least to receive
36 matches
Mail list logo
