Please note that natural joins may be dangerous in production code. See
the following thread for more detailed information...
http://forums.oracle.com/forums/thread.jspa?threadID=440287
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi there,
I am trying to find if importing a very large text file is
faster with postgresql or mysql (with mysqlimport).
Each night the transaction system we used dumps
a very large text file which must be loaded into a database,
the speed is very important, mysqlimport takes less than
an hour. I
Each record has an oid, which is assured to be unique in that
database. Thus you can use it for your purpose, I believe. To fine
the oid with any record, just:
SELECT oid,* from mytable;
The OID is always there, and you don't have to add it - you just don't
see it uless you specifically ask
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, 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
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
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:
>
>
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:
>
> > > 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
> 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,
> 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
Hi
I have just installed 6.5, and I have a couple of questions that I cannot find
the answer to in the documentation.
Firstly, I am using temporary tables for a number of operations. Is
there a way to direct postgresql to keep these in memory for fast
access, or will it do this anyway?
Secondly
I am trying to insert both the date and the time into a datetime field.
If the field datetime in table v1 is dt, then the following successfully
inserts the date into the datetime field:
insert into v1 (date) values ('19990401') ;
However, if I also wanted to retain the time of day, the follow
I've read many postings of people having this same problem, which I am now
having since I've updated to LinuxPPC R5. At this point I've compiled a
completely NEW database from scratch (with no problems) and, following right
along in the install docs, run %initdb, %createdb, %psql (and then the
"se
"Matt Magoffin (Borders Online)" wrote:
>
> I've read many postings of people having this same problem, which I am now
> having since I've updated to LinuxPPC R5. At this point I've compiled a
> completely NEW database from scratch (with no problems) and, following right
> along in the install do
On Wed, 23 Jun 1999, abdelkrim wrote:
> it is possible to insert into a view ?
if its a single-table view, yes -- you'd want to create a DO INSTEAD rule.
consult the manual/html pages to get the proper syntax for CREATE RULE.
if its a multitable view, maybe... i dont think this can be done with
it is possible to insert into a view ?
thanks
Constantin Teodorescu
FLEX Consulting Braila,ROMANIA
In JDBC2 you do have the notion of arrays, but I've yet to get to them.
The only real way is to convert the Double[] to a string using
PostgreSQL's array syntax (which I can't remember what it looks like at
the moment), then store it using PreparedStatement.setString()
Peter
Peter
--
Peter Mou
Like, I think this got lost somehow, 'cuz it never showed up as far as I saw...
Otherwise, sorry for the repost.
Well, I decided to go ahead and install 6.4.2 after hitting a wall with
6.3.2 (6.5 wasn't out when I downloaded) and am running into a different
compilation error:
gmake[3]: Leaving
Hi,
since I have serious problems with some of the features of the JDBC
driver I am searching for a different way to store the following
structure efficiently in the PostgreSQL database.
How can I store an array of double numbers and retrieve it without
creating a row for each entry? I read some
The large object code has been working for some time now, however not
all of the stream methods work fully.
The best thing is to look at the blobtest and ImageViewer examples in
the src/interfaces/jdbc/example directory, as they show what methods are
currently supported.
Peter
--
Peter Mount
E
Hi,
I am trying to store some Java objects in the PostgreSQL database
system. The version of PostgreSQL is 6.4.2 running on a linux sparc
machine. The JDBC driver is the one I found in the src/interfaces/jdbc
directory.
First of all I tried to use the example provided on page 167 of the JDCB
int
I recently upgraded my LinuxPPC system, and to make a long story short I had
to re-compile Postgres. Unfortunately I could did not dump my databases out
(via pg_dump) to files before I had to recompile Postgres. After Postgres
was compiled and restarted, I can access the DATA (mostly) but pg_dump
At 17:41 +0300 on 22/06/1999, Jeff MacDonald wrote:
> When I do a large select , the results all zip past the screen
> . How do I make it go page by page ? I figure this has to do
> with a term setting, my default term setting is 'linux' .
> I tried vt100 and vt220 .
>
> Perhaps this is a linux-
> Do a '\g | more' instead of the ';' at the end of the query. Much easier:
>
> select * from table \g | more
>
>
Define PAGER, and it is automatically invoked if the data is more than
the size of the screen.
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PR
Jeff MacDonald wrote:
>
> When I do a large select , the results all zip past the screen
> . How do I make it go page by page ? I figure this has to do
> with a term setting, my default term setting is 'linux' .
> I tried vt100 and vt220 .
>
> Perhaps this is a linux-ism ?
>
> Thanks
>Jeff
Do a '\g | more' instead of the ';' at the end of the query. Much easier:
select * from table \g | more
--
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email: [EMAIL PROTECTED]
"It's not broken, it just lacks duct ta
When I do a large select , the results all zip past the screen
. How do I make it go page by page ? I figure this has to do
with a term setting, my default term setting is 'linux' .
I tried vt100 and vt220 .
Perhaps this is a linux-ism ?
Thanks
Jeff
Hello,
I have some problems with view:
ERROR: RelationCatalogInformation: Relation 482442 not found
thanks for your help
Well, I decided to go ahead and install 6.4.2 after hitting a wall with
6.3.2 (6.5 wasn't out when I downloaded) and am running into a different
compilation error:
gmake[3]: Leaving directory '/usr/src/pgsql/src/backend/optimizer/geqo'
for i in path plan prep util geqo; do gmake -C $i util/SUBSYS
> Hi,
>
> I'm a newbie and have some questions:
>
> A regression test agaist a new installed 6.5 failed on
> items int2, int4 and geometry. It was in Linux 2.0.35.
> The posgresql was compiled by:
>
> $ gcc -v
> Reading specs from /usr/lib/gcc-lib/i386-pc-linux-gnulibc1/egcs-2.91.66/specs
Hi,
I'm a newbie and have some questions:
A regression test agaist a new installed 6.5 failed on
items int2, int4 and geometry. It was in Linux 2.0.35.
The posgresql was compiled by:
$ gcc -v
Reading specs from /usr/lib/gcc-lib/i386-pc-linux-gnulibc1/egcs-2.91.66/specs
gcc version egcs-2
Hi everybody,
Did anyone ever use the possibility of the JDBC driver to store Java
objects in the database?
--
Best Regards,
Steffen Zimmert
Steffen Zimmert
Fraunhofer Center for Research in Computer Graphics
Providence, Rhode Island, USA
email: [EMAIL PROTECTED]
I've got this simple query...
SELECT id, title, summary, datetime, datetime::date AS date FROM poll
WHERE id = ?
which works from psql but fails with "bad parameter" from perl. If I
take out the "datetime::date AS date" bit it starts working.
Why would a query work in psql but not perl?
--
C
Hello all,
I have two questions about PostgreSQL 6.5:
1. CLUSTER does not work on indexes with more than one field. Is this
correct?
2. In the distribution tarball, the top-level directory is
"postgresl-6.5". Isn't there a 'q' missing?
--
Christian Ullrich
Does anyone know a product called DBMaker from a company called
CASEMaker and would like to tell me about its good and bad points?
I have filled and sent bug report about SELECT with LIKE in 6.5
which don't use realy index scaning, but don't see any reaction,
even if somebody get my report. Can anybody explain me how can I get
information about my bug report?
Thanks.
Alexander N Shulyak
Hi everybody,
I have just installed PostgreSQL 6.5 and encountered problems with
PL/pgsql: On an insert into a table which has a before-insert trigger
I get the following error message:
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed:
/usr/local/pgsql/lib/plpgsql.so:
un
psql database
drop index table_pkey;
create unique index table_pkey on table (field1, fiel2);
\q
Tim Perdue wrote:
>
> How in the world do you rebuild the primary key table in Postgres?
>
> I've sent a few messages to hackers and don't get much response, but in a
> nutshell, there is a pro
I want to configure my new laptop to have the same versions of software as
my ISP has, which would mean PostgreSQL 6.3.2
Alas, my attempts to locate a PostgreSQL 6.3.2 gz have been futile.
I found a PostgreSQL 6.3.2 diff file, but not knowing what it diffs
against, much less actually having the
How in the world do you rebuild the primary key table in Postgres?
I've sent a few messages to hackers and don't get much response, but in a
nutshell, there is a problem with pgsql in that sometimes you can get
duplication in the primary key.
I eliminated the duplicates from the table today, but
On Thu, 17 Jun 1999, Robert Chalmers wrote:
> Thats what I thought but when I tried to run the backend to test it with
> postmaster -i
> It complained that the database 'postgres' didnt exist... I know., use
> postmaster -i template1 I suppose?
actually, start postmaster as usual.
by default, i
Thats what I thought but when I tried to run the backend to test it with
postmaster -i
It complained that the database 'postgres' didnt exist... I know., use
postmaster -i template1 I suppose?
thanks
Bob
- Original Message -
From: John M. Flinchbaugh <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Hi there,
I'd like to thank everyone who made the new release happen for the
beautiful new features, and above all, for delivering those without
stomping on my cherished extended types ;)
I'm back in business after a very short downtime. The tables loaded
almost twice as fast as they did with 6
On Wed, 16 Jun 1999, John M. Flinchbaugh wrote:
> On Wed, 16 Jun 1999, Robert Chalmers wrote:
> > Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> > creat the database 'postgres' ...
> > whats happening here ?
>
> initdb only creates `template1'. you have to `creat
On Wed, 16 Jun 1999, Robert Chalmers wrote:
> Just installed 6.5, all seems well, but it wont start - claims initdb didn't
> creat the database 'postgres' ...
> whats happening here ?
initdb only creates `template1'. you have to `createdb postgres' for
yourself if you even want the postgres user
Bob Kruger wrote:
>
> A quick question -
>
> Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
> key would allow me to easily edit my previous command. In working out a
> quick query, I always thought this was a nice feature that MySQL had and
> Postgres did not.
>
> I
>
> A quick question -
>
> Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
> key would allow me to easily edit my previous command. In working out a
> quick query, I always thought this was a nice feature that MySQL had and
> Postgres did not.
>
> I have since downlo
Hi,
here is a new version of the bitmask type. It supports hash-indices as
well now, and fixes a bug in the definition of the <> operator.
I would appreciate it if somebody more knowledgable than myself would
look over the index definitions. They seem to work and are used by
postgres, so
A quick question -
Last week I compiled and ran ver 6.5 beta2. I noticed that the "up arrow"
key would allow me to easily edit my previous command. In working out a
quick query, I always thought this was a nice feature that MySQL had and
Postgres did not.
I have since downloaded and compiled
joel reed wrote:
> try configure --host=i686-pc-linux-gnu
>
> change i686 as needed
OK, cool, that worked ... but ... here's what happened next.
$ ./configure --host=i586-pc-linux
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking echo setting...
checking sett
Hi!
On Wed, 16 Jun 1999, Ming-Hung Eng wrote:
> I have a problem to copy datas from unix file, I get the following message
> when I try to import
> a file with more 20 lines :
>
> pgReadData() -- backend closed the channel unexpectedly
> This probably means the backend terminated abnorma
Hi
I have a problem to copy datas from unix file, I get the following message
when I try to import
a file with more 20 lines :
pgReadData() -- backend closed the channel unexpectedly
This probably means the backend terminated abnormally before or while
processing the request.
We have los
> Dear SGI friends,
> Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
>
> Due to a problem in the generation of the code of semaphors and other
> structs, any PgSQL binary produced with gcc will be buggy.
> More information on this subject at
> http://reality.sgi.com/
Dear SGI friends,
Please try NOT to compile PostgreSQL (any version) with gcc on Irix.
Due to a problem in the generation of the code of semaphors and other
structs, any PgSQL binary produced with gcc will be buggy.
More information on this subject at
http://reality.sgi.com/ariel/freeware
At 01:32 +0300 on 16/06/1999, Dan Wilson wrote:
> I even tried to specify the template with --with-template=linux_i386, but I
> get the same exact error message:
> ./configure --with-template=linux_i386
> loading cache ./config.cache
> checking host system type... configure: error: can not gues
Hi,
I need the row oid of an insert in an PL/pgSQL function.
For explanation: After an insert I call a PL/pgSQL function (by a
trigger) and I like to insert into an other table the row oid of the
first insert. But I don't know how to get the oid.
Thank you for helping,
Peter
--
CREATE FUNCTION fu
Just installed 6.5, all seems well, but it wont start - claims initdb didn't
creat the database 'postgres' ...
whats happening here ?
thanks
Bob
--- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
t
M Simms wrote on Tue, 15 Jun 1999 19:58:28 BST
>> Dear Folks,
>>
>> We have been running 6.4.2 under Linux on a dual Xeon box
>> with mostly good success. Our current dataset is 20 million records
>> of mostly numerical data (56 fields of floats [70%], ints [20%] and
>> a few text fields [10%])
I can't even get ./configure to work.
I just reformatted my Linux box and installed Redhat Linux 6.0. I had 6.0
installed for a while but had installed another distribution (Mandrake) over
the top of it. I downloaded pg 6.5 last night and installed it. Everything
went fine.
So after I reforma
Check AIX faq on the web site. It may help.
> Hi! I can't compile postgres 6.5/6.4 on RS6000 (CPU:PowerPC 604
> 333Mhz, AIX4.3, egcs). I have installed bison and flex.
>
> I'm configuring it with "./configure --with-template=aix_gcc".
> gmake all fails with dynloader.c:
>
>
Hi! I can't compile postgres 6.5/6.4 on RS6000 (CPU:PowerPC 604
333Mhz, AIX4.3, egcs). I have installed bison and flex.
I'm configuring it with "./configure --with-template=aix_gcc".
gmake all fails with dynloader.c:
gmake[2]: Entering directory
`/usr/local/src/postgresql-6
> Dear Folks,
>
> We have been running 6.4.2 under Linux on a dual Xeon box
> with mostly good success. Our current dataset is 20 million records
> of mostly numerical data (56 fields of floats [70%], ints [20%] and
> a few text fields [10%]). The performance is acceptable, the only
> problem
Hi.
Im trying to access prostrgeres (on redhat linux 6.0) via pg's LO python
interface.
With pg 6.4.2 & 6.5b1 everything works fine, but since 6.5b2 (6.5 final
incl) following errors occour:
[lauri@liha lauri]$ python
Python 1.5.2 (#2, Jun 12 1999, 02:51:28) [GCC egcs-2.91.66
19990314/Linux
Hi everybody!
I tried to install the new version of PostgreSQL an everything worked
really fine until I typed in the "postmaster -i" command for the first
time. The following error message occured:
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=1073152, permission=600
FATAL
Make sure your perl DBD-Pg and DBI are compiled with the correct version
of postgres.
> Erik Colson wrote:
>
> Hi!
>
> I installed (compiled) latest versions of Perl, Postgres.
>
> I can access the database via 'psql' but allways get an error when
> trying to connect from a perl-script :
>
>
79 matches
Mail list logo
