Sorry, yes you need 6.5 for the general numeric type.
H.P.
On 25-Jun-99 Herbert Liechti wrote:
> Hans Peter Würmli wrote:
>
>> Try:
>>
>> dbhpw=> create table therbert (num numeric(9,2));
>
> Is not working. I got the following error:
>
> db=> create table therbert (num numeric(9,2));
> ERROR
On Sat, 26 Jun 1999, Robert Chalmers wrote:
> Is there a definitive list of types in 6.5 ? Not just the new ones, but all
> types? Or do I just wade through the documentation as usual - assuming that
> the latest docs are indeed the latest docs :-)
in psql monitor, \dT.
}John
On Sat, 26 Jun 1999, M Simms wrote:
> >
> > after installing pgsql-6.5 ( on a machine with pgsql-6.4.2 installed and
> > running ), initdb creates a PG_VERSION file that still reports 6.4;
> > subsequent psql connections fail to connect, complaining about "no
> > compatible version of postgres fo
>
> after installing pgsql-6.5 ( on a machine with pgsql-6.4.2 installed and
> running ), initdb creates a PG_VERSION file that still reports 6.4;
> subsequent psql connections fail to connect, complaining about "no
> compatible version of postgres found".
>
> before you ask:
> yes, ive made sure
Hello All,
I was wondering if anyone would find a Wizard/GUI based administration tool
useful. It would be similar to the System Adminstration Wizard facility in
NT. I was planning to use Qt/KDE as the basis for the project.
I was thinking of tasks like add/delete users, databases, dumps and t
On Fri, 25 Jun 1999, Dan Wilson wrote:
> I ran into the same problem and it turned out to be an outdated version of
> psql. Check your path to see if you are accessing the correct version of
> psql, pg_dump etc..
it is; ive made sure of that. stripped all the permissions off of the
entire 6.4.
I ran into the same problem and it turned out to be an outdated version of
psql. Check your path to see if you are accessing the correct version of
psql, pg_dump etc..
-Dan Wilson
- Original Message -
From: Howie <[EMAIL PROTECTED]>
To: postgres <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTE
What information is kept in the system tables concerning primary keys?
How is it accessible?
Is there any means of specifying primary key information for views?
Cheers,
Brook
Is there a definitive list of types in 6.5 ? Not just the new ones, but all
types? Or do I just wade through the documentation as usual - assuming that
the latest docs are indeed the latest docs :-)
cheers
bc
--- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum
after installing pgsql-6.5 ( on a machine with pgsql-6.4.2 installed and
running ), initdb creates a PG_VERSION file that still reports 6.4;
subsequent psql connections fail to connect, complaining about "no
compatible version of postgres found".
before you ask:
yes, ive made sure that im usin
Not only legacy apps, but data warehousing. Frequently in a production
environment you use two sets of tables -- production and data
warehousing...One (production) with "bare bones" indicies to maximize
transaction performance, and one (a replicate in the data warehouse) that
you "index the living
Hans Peter Würmli wrote:
> Try:
>
> dbhpw=> create table therbert (num numeric(9,2));
Is not working. I got the following error:
db=> create table therbert (num numeric(9,2));
ERROR: NUMERIC scale 2 must be zero
I use PostgreSQL 6.4.0 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.6
Any oth
What version of PostgreSQL? Version 6.5 is needed for complete decimal and
number support.
> -Original Message-
> From: Herbert Liechti [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 25, 1999 10:59 AM
> To: postgres
> Subject: [GENERAL] decimal(9.2)
>
> Hello
>
> How do I defin
Try:
dbhpw=> create table therbert (num numeric(9,2));
H.P.
On 25-Jun-99 Herbert Liechti wrote:
> Hello
>
> How do I define the datatype decimal(9.2). I searched the documentation
> but the only thing I found was the money data type which is in my case
> not very usefull.
>
> Is there a way t
Hello
How do I define the datatype decimal(9.2). I searched the documentation
but the only thing I found was the money data type which is in my case
not very usefull.
Is there a way to declare a datatype with 2 decimal places and with a fixed
precision? Thanks for your help
Herbie
--
~
> I really need help here, because i really need this thing working with
> transactions. Just in case here is the code:
>
> pg_Exec($conn, "abort");
> $result = @pg_Exec($conn, "begin");
> if (!$result);
> $msg ="sac-pcgra (2):".addslashes(pg_ErrorMessage($conn));
> $msg = chop($msg);
>
> Date: Fri, 25 Jun 1999 23:00:25 +0800 (PHT)
> From: Richi Plana <[EMAIL PROTECTED]>
> Content-Type: TEXT/PLAIN; charset=US-ASCII
> Sender: [EMAIL PROTECTED]
> Precedence: bulk
>
> Hi,
>
> I'm trying to use PostgreSQL data type oid and I have a couple of
> questions about it:
>
>
Thomas Reinke wrote:
>
> You have already started a transaction and haven't yet
> finished it.
>
> E.g.
>
> psql template;
> BEGIN;
> BEGIN;
Not that i don't believe you but i think that in my case that is a tid
bit impossible. The error comes from a php script. On that script i open
t
Richi Plana wrote:
> I'm trying to use PostgreSQL data type oid and I have a couple
> 2) Can it be used together with NOT NULL or PRIMARY KEY?
oid data type is a 4 byte integer and as far as I know can be used
pretty much the same way.
You have already started a transaction and haven't yet
finished it.
E.g.
psql template;
BEGIN;
BEGIN;
Mario Jorge Nunes Filipe wrote:
>
> Hi
>
> I am receiving this message when doing a begin:
>
> NOTICE: BeginTransactionBlock and not in default state.
>
> What does this mean ?
> --
>
Hi,
I'm trying to use PostgreSQL data type oid and I have a couple of
questions about it:
1) (Most important) Where can I find documentation covering the use of
OIDs in PostgreSQL? The only doc which discusses it somewhat that I've
seen is the FAQ (and it just tells people what OIDs are)
2) Can
Hi
I am receiving this message when doing a begin:
NOTICE: BeginTransactionBlock and not in default state.
What does this mean ?
--
Mario Filipe
[EMAIL PROTECTED]
http://neptuno.sc.uevora.pt/~mjnf
S/MIME Cryptographic Signature
Bruce Momjian writes:
> > > That's a good one. There is a data/PG_VERSION file in the install
> > > directory that should contain the version, though there was one release
> > > where we forgot to update that. That may help. I assume you don't have
> > > the source code, because the HI
> Bruce Momjian writes:
>
> > > database_name=> select version();
> > > WARN:parser: Syntax error at or near "version"
> > >
> > > What else can I do? I can see from the dates of the files that it was
> > > installed sometime in mid-1997. What else can I use to find the
> > > version?
> >
> Hi!
>
> I read in the FAQ that in order to find out the version of PostgreSQL
> I'm running I have to so "select version();" from psql. I have a very
> old installation of PostgreSQL that I need to upgrade, so I need to
> find out its version, but this trick doesn't work:
>
> database_name=> s
Bruce Momjian writes:
> > database_name=> select version();
> > WARN:parser: Syntax error at or near "version"
> >
> > What else can I do? I can see from the dates of the files that it was
> > installed sometime in mid-1997. What else can I use to find the
> > version?
>
> That's a good
> Hi!
>
> I read in the FAQ that in order to find out the version of PostgreSQL
> I'm running I have to so "select version();" from psql. I have a very
> old installation of PostgreSQL that I need to upgrade, so I need to
> find out its version, but this trick doesn't work:
>
> database_name=> s
> Legacy apps, Bruce. Sometimes you come across tables with ten fields in the
> index. I'm working on a (fairly specialised) system now where the primary
> key of one of the tables has twenty-four fields in it. It is a summary
> table, and probably not the best design, but that's the way it is,
Hi!
I read in the FAQ that in order to find out the version of PostgreSQL
I'm running I have to so "select version();" from psql. I have a very
old installation of PostgreSQL that I need to upgrade, so I need to
find out its version, but this trick doesn't work:
database_name=> select version();
> So lets have a look at everything again. Consider it a users wish list for
> 7.0
>
> 1. The 7 field index limit. Doubtless someone made a decision back in the
> dark ages that no-one would ever need
> more than that.
>
> 2. Ruleplan overflows. maybe fixing this is just changing a #define to
>
> >>> > I've been attempting to port applications from Pervasive SQL to PG.
> >>> > Pervasive is interesting because it runs on top of btrieve. This
allow
> >>> > legacy apps
> >>> > and SQL systems to co-exist. It's quirky and buggy, but it's better
than PG
> >>> > because it can do the following
31 matches
Mail list logo
