On Tue, 11 Jul 2000, Jeff Waugh wrote:
> > J.R. Belding wrote:
> >
> > #mysql has much more activity than does #postgresql, and since I prefer
> > this method of communication over mailing-lists, I found this to be very
> > much in MySQL's favor.
>
>
> Hmm. So which server do most postgresql p
Ed Loehrwrote:
> I believe DBI/DBD does this for you:
>
> while ($row_href = $sth->fetchrow_hashref)
> {
>push( @taghash, $row_href);
> }
Don't do that! Each hashref in that array will point to the same hash in some
future version of the DBI. You should do this instead:
while($row=$sth->
On Tue, Jul 11, 2000 at 12:24:20AM +0200, Peter Eisentraut wrote:
> Is anyone else noticing this: Everytime this sort of thing comes up a
> number of people invariably tell that they are using MySQL because it's
> easier to install, and that PostgreSQL is difficult ("a pain") to install.
I've no
Hello.
I am new to Postgresql and want to know where databases are kept. I am using
RedHat 6.1.
Thank-you for your time.
Sean.
Hi,
Is there any way to disable transactions on some databases in postgreSQL ?
The reason I'm asking is because I need a very fast read only DB. So I'm
thinking of having the real DB fully functional, and once or twice a day
dump it into a non-transactional read-only one, for the read only side
I currently have postgres on a Linux 6.2 machine & I can access all of its
information from any windows machine using the proper odbc driver.
Now I want to go in the other direction - Is there a way for my postgres
server on the linux box to pull down information from a windows client that
is usi
I found out my answer...
Sean.
Sean <[EMAIL PROTECTED]> wrote in message
uyL95.6380$[EMAIL PROTECTED]">news:uyL95.6380$[EMAIL PROTECTED]...
> Hello.
> I am new to Postgresql and want to know where databases are kept. I am
using
> RedHat 6.1.
>
> Thank-you for your time.
>
> Sean.
>
>
Hi:
The documentation of Postgresql 7.0.2 says that the statement:
SET DATESTYLE TO 'Postgres';
would led to an output of the form:
Wed Dec 17 07:37:16 1997 PST
but I can't reproduce this behavior!!!
What am I doing wrong?
Saludos,
Roberto Andrade Fonseca
[EMAIL PROTECTED]
Hi,
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]Im
> Auftrag von Gabriel López Millán
> Gesendet am: Montag, 10. Juli 2000 12:34
> An: postgres; postgres-ayuda
> Betreff: [GENERAL] JDBC and LOB
>
> Hi, I try to run this example:
>
> Strin
> > > Justin Jaynes wrote:
> > > >
> > > > the line:
> > > >
> > > > Class.forName("org.postgresql.Driver");
>
> Try:
>
> Class.forName("postgresql.Driver");
>
In 7.02 the above is WRONG,
Class.forName("org.postgresql.Driver");
is right ...
(Drivername has changed in this version)
Hello,
I'm going to use PostgreSQL ODBC Driver + ODBCExpress Delphi components for
the client part of my PostgreSQL system (Yes, I tried WinZEOS but found them
to be too buggy). Unfortunately, ODBCExpress supports no locale settings, so
I will be able to keep my data only in Windows 1251 codepage
This simple test function fails.
--
drop function testit(text);
create function testit(text) returns text as '
DECLARE
myval text;
BEGIN
myval:= $1;
return myval;
END;
' language 'plpgsql';
select testit('testing');
select testit(''testing'
is it posiable to copy a table in postgress to the curent database? if so
how is that acomplished??
Mike
Once I ran into a guy who said that the postgres rpm was broken in Red Hat
5.2. This was when I was first getting into postgres. I spent some time
with it and realized that there were a number of things that had to be
done before it would work: creating the postgres users, initializing the
datab
Greetings.
Has anybody produced any benchmarks comparing PostgreSQL to MS SQL
Server? If not, can anybody point me to any sources for standardized
benchmarks that I could run myself on both? The only benchmarks I've
seen so far have been the outdated runs on the MySQL web page, and the
recent o
I'm trying to figure out how to do in Postgres what I already pretty well understand
in
DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
in a table using those args in a where clause, and then return a boolean result of
whether a matching row was found. Or pote
Travis Bauer <[EMAIL PROTECTED]> writes:
> Once I ran into a guy who said that the postgres rpm was broken in Red Hat
> 5.2. This was when I was first getting into postgres. I spent some time
> with it and realized that there were a number of things that had to be
> done before it would work: c
Simple question: Can the functions created via CREATE FUNCTION be invoked via the JDBC
driver?
On Tue, 11 Jul 2000, Randall Parker wrote:
> I'm trying to figure out how to do in Postgres what I already pretty well understand
>in
> DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
> in a table using those args in a where clause, and then return a boolean
Travis Bauer wrote:
>
> Once I ran into a guy who said that the postgres rpm was broken in Red Hat
> 5.2. This was when I was first getting into postgres. I spent some time
> with it and realized that there were a number of things that had to be
> done before it would work: creating the postgre
Hi,
> > 2) Is CREATE FUNCTION pretty much a logical equivalent to CREATE
> > PROCEDURE in other RDBMSs?
>
> I not sure how it is in other DBs, but a little differention is here; in
> current state is not available create routines that retuns tuple.
Stored procs can returns tuples... but I'd li
"Prasanth A. Kumar" wrote:
>
> Travis Bauer <[EMAIL PROTECTED]> writes:
>
> > Once I ran into a guy who said that the postgres rpm was broken in Red Hat
> > 5.2. This was when I was first getting into postgres. I spent some time
> > with it and realized that there were a number of things that
On Tue, 11 Jul 2000, Lamar Owen wrote:
> And, if most people's experience with the RedHat 5.2 RPM's is what
> they're going on, they need to get with the program -- RH 5.2 shipped
> PostgreSQL *6.3.2* which is absolutely ancient. Although, at the time,
> 6.3.2 was better than nothing.
Hello Lam
At 16:31 11/07/00 +0930, Stephen Davies wrote:
>You can in fact access an Access database from Linux.
>
>Just install the Universal ODBC stuff from OpenLink
URL please, neither openlink.com nor openlink.org seem to be the right places.
Thanks
Steve
--
thorNET - Internet Consultancy, Service
24 matches
Mail list logo
