"D. Jay Newman" <[EMAIL PROTECTED]> writes:
> I would like to create a standard deviation function using the basic
> SQL statements "CREATE AGGREGATE" and "CREATE FUNCTION" using Postgres 7.0.2.
> I can't find a way to return a modified array.
It's possible to do this in pltcl but I don't think
There is mention on Slashdot of an article about Interbase:
http://www.technocrat.net/966470710/
Seems there are problems in getting the Interbase support company and
internet developers started. The situation is very confusing.
--
Bruce Momjian| http://cand
Barry Hill <[EMAIL PROTECTED]> writes:
> Does anyone know how long a PostGRES SQL statement can be? In the near
> future, my above-mentioned query will grow to a few hundred SELECTS
> (Phorum) and I'm wondering how it will cope (but too lazy to
> experiment) ???
As of 7.0 there's no hard upper li
"Darrin Ladd" <[EMAIL PROTECTED]> writes:
> I have been having serious problems with upgrading from 6.5.3 to 7.0.2. I
> currently have 6.5.3 running in what was the default locations for the RPMS
> (I am running it on an Alpha box with Red Hat Linux 6.2).
Darrin, I think your questions were al
"Jason J. Czerak" <[EMAIL PROTECTED]> writes:
> what i'm confused about now is the best way to interface with the server.
> there's ODBC, DBI, and others.
> My main tools are Perl and PHP.
If you're using Perl I think it's a no-brainer: DBI is the standard way.
(Not sure why we don't include a DB
Hello,
I'm new to the whole linux + DB stuff. And I reading the various news articles
and looking into what DB stupported what. and Picked PostgreSQL (mainly cuz if
it's transaction stupport).
what i'm confused about now is the best way to interface with the server.
there's ODBC, DBI, and othe
Martin Christensen <[EMAIL PROTECTED]> writes:
> I've heard some rumours off Slashdot that PostgreSQL databases tend to
> corrupt more than, say, MySQL, and that disaster recovery is more
> difficult.
The MySQL people assert that, but their objectivity is, um, suspect.
I don't think I've heard an
"Steve Wolfe" <[EMAIL PROTECTED]> writes:
>While I don't mind disk cache, I feel that we could get better
> performance by letting postgres use another hundred megs or so, especially
> since our entire /usr/local/pgsql/base directory has only 134 megs of data.
> We're currently starting the po
[EMAIL PROTECTED] writes:
> This is with regards to Postgres 6.5.
> While trying to ALTER RENAME a large table (203MB data file), an error
> occured.
Table RENAME is pretty risky under 6.5 :-(. 7.0 is a little better,
but RENAME will never be trustworthy until we abandon the linkage
between fil
"Keith, Bruce" <[EMAIL PROTECTED]> writes:
> Is anyone aware of a downloadable PostgreSQL/Linux implementation of
> the AS3AP database benchmark? I've
> searched the web but was not successful. I'd like to run AS3AP but I'm not
> interested in having to buy a tool (e.g., Benchmark Factory) f
Eugene Lee <[EMAIL PROTECTED]> writes:
> Note, no "-i" option. Instead, I added the line "tcpip_socket = yes"
> in the file /usr/local/pgsql/data/postgresql.conf to enable TCP/IP
> socket access. But the line in the config file doesn't work.
There is no such config file in 7.0.*. You must be r
Ross,
I am not so sure that ALTER family is used for development
purposes only...
Consider data warehousing where typically each day the administrator
would :
1Extract data from source database(s) - usually in ascii file
format, as these dbs may be connection unfriendly, not controlled by
Simon Brooke <[EMAIL PROTECTED]> writes:
> curr_conn = result->conn;
> if ((curr_conn == NULL) && (pgTypeRes==0)) {
Get rid of curr_conn and the ensuing test on same, is my advice.
This code should never have been reaching inside PGresult to begin
with...
Lamar Owen <[EMAIL PROTECTED]> writes:
> At 6.4, there was a protocol change that renders clients for libpq
> version 1 incapable of connecting or using servers using protocol
> version 2. Thus, unless you want to do surgery on PHP/FI 2, you will
> have to stick with PostgreSQL 6.3.2 or earlier.
Ok, so I'm an idiot...sorry.
While running the *correct* rpm (SRPM: postgresql-7_0_2-1_src.rpm), it keeps
failing. It appears to be trying to implement the python interface, but the
required config directory with the make file is missing off the file system.
The following is the standard ou
I have a sequential file on my work system (OS/390). This file contains
multiple record types which I want to load into multiple tables in a
PostgreSQL database. I have written a program which runs on the OS/390
system. This program reads the sequential file and reformats it. What I do
is reformat
I've installed 7.0.2 from the tarball (not the RPM) on a Redhat 6.1
system. The server starts up and runs, but it ignores postgresql.conf
and pg_hba.conf. I have a "postgres" user set up, default location
"/usr/local/pgsql", conf files located in the "data" subdirectory, added
the paths to $PATH
On Fri, 18 Aug 2000, Webmaster MuraNet wrote:
> Hi all !
> I'm from Brazil, so sorry for my bad english!!
> My Problem: I installed PostgreSQL 7.0.2, but, always than I try acess
> the server of Postgre with ODBC driver (for Win95) it give me the error:
>
> General SQL error
> Could not connect
> "Carl" == "Carl Alexander" <[EMAIL PROTECTED]> writes:
Carl> I assume there's a emacs mode for interacting with PostgreSQL
Carl> from within emacs?
M-x sql-postgres, provided you've the right stuff installed. To my
best of memory the proper package is available from the GNU ftp
server, if y
Hi:
I would like to create a standard deviation function using the basic
SQL statements "CREATE AGGREGATE" and "CREATE FUNCTION" using Postgres 7.0.2.
I can't find a way to return a modified array.
I've tried things like:
CREATE function x (_float8, float8) RETURNS _float8 AS
'SELECT {$1[1] +
Hi all !
I'm from Brazil, so sorry for my bad english!!
My Problem: I installed PostgreSQL 7.0.2, but, always than I try acess
the server of Postgre with ODBC driver (for Win95) it give me the error:
General SQL error
Could not connect to the server;
Could not connect to remote sockets
What I do
"Darrin Ladd" <[EMAIL PROTECTED]> writes:
> I am trying to install 7.0.2 on an alpha box running Red Hat Linux 6.2. I
> was told that the 7.0.2 rpm's have an alpha patch in them and that would be
> the best bet for success. Yet, I have run into a little problem. When I
> try to install the
Hi,
I am trying to install 7.0.2 on an alpha box running Red Hat Linux 6.2. I
was told that the 7.0.2 rpm's have an alpha patch in them and that would be
the best bet for success. Yet, I have run into a little problem. When I
try to install the rpm (rpm -i postgresql-7_0_2-2_i386.rpm) I get
try this :
select attname from pg_attribute where attrelid = (select oid from pg_class
where relname
= 'your table name') order by attnum;
you can further develop a query from this...
HTH
At 12:14 PM 8/18/00 -0700, Mitch Vincent wrote:
>I know this has been asked and answered before but I c
Hello Alan,
>From /usr/doc/postgresql-7.0.2/README.rpm it says...;-)
NOTE: The 7.0 RPMs are only being built under RedHat 6.2! They
may or may not work under RedHat 6.0 or 6.1.
But like you, I have come across the exact same thing...;-) _IF_ you
don't have any real data and are willing to sta
25 matches
Mail list logo
