On Mon, Jan 23, 2006 at 02:23:15AM +, frank church wrote:
> I want to use pg_dump in a php program. Does pg_dump have specific error
> codes?
>
> Does use the normal shell result codes to indicate success or failure ?
A quick look through the pg_dump source code finds exit codes of 0
(succes
I want to use pg_dump in a php program. Does pg_dump have specific error codes?
Does use the normal shell result codes to indicate success or failure ?
This message was sent using IMP, the Internet Messaging Program.
---
On Sunday 22 January 2006 02:47 pm, Bob Pawley wrote:
> Hi Tom
>
> I found a datatype called 'interval' which seems to separate time from its
> unit.
>
> Is that what you were thinking of??
>
> Bob
> - Original Message -
> From: "Tom Lane" <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROT
On Sun, Jan 22, 2006 at 02:47:51PM -0800, Bob Pawley wrote:
> I found a datatype called 'interval' which seems to separate time from its
> unit.
>
> Is that what you were thinking of??
I think Tom might be referring to Martijn van Oosterhout's tagged
types:
http://archives.postgresql.org/pgsql-
Hi Tom
I found a datatype called 'interval' which seems to separate time from its
unit.
Is that what you were thinking of??
Bob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Sunday, January 22, 2006 11:25 AM
Su
On Sun, Jan 22, 2006 at 12:53:57PM +, frank church wrote:
> I am trying to work out how much space is taken up by a given
> database in the file system.
On Unix-like systems a simplistic way is to use "du" on the database
directory, which is generally $PGDATA/base/database_oid. You can
find t
Bob Pawley <[EMAIL PROTECTED]> writes:
> My initial tables have columns containing values such as 12 feet.
> I want to perform calculations.
> Is there a method in Postgresql to separate the 12 from the unit feet or
> am I forced to make two columns to separate the feet from the 12?
Are you stor
My initial tables have columns containing values
such as 12 feet.
I want to perform calculations.
Is there a method in Postgresql to separate the 12
from the unit feet or am I forced to make two columns to separate the feet from
the 12?
Bob Pawley
I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename > tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" fail
Zlatko Matić <[EMAIL PROTECTED]> writes:
> So, it seems that numeric without parameters (precision, scale) behave
> similar to float, but is much exact. Am I right or I missunderstood?
Right. It's also considerably slower, since floating point
calculations can use the hardware. Unless you're do
I am trying to work out how much space is taken up by a given database in the
file system.
I have googled the archives and found the stuff there looks dated.
Is there some script or query that can work it all out?
My current version is 7.4. Knowing abut 8.x.x will be fine too?
--
Thanks for answer, but in documentation I found that Numeric can be without
scale and precision defined:
"Specifying
NUMERICwithout any precision or scale creates a column in which numeric
values of any precision and scale can be stored, up to the implementation
limit on precision. A column of
Tony Caduto schrieb:
> I think a client that tells me the columns are a, b, c but then
>
>> gives me an error on "insert into table values (aval, bval, cval)"
>> because
>> the actual logical order is different is probably fairly broken.
>
>
> I guess that could be a problem, I was thinking in
13 matches
Mail list logo
