On Sat, 21 Feb 2004, Simon Windsor wrote:
Hi
I am using the standard debian testing release of postgres(7.3.4) and was
wondering how to produce and md5 string.
I had thought
Select md5('joe');
Would be sufficient?
Doesn't that work? It works for me in 7.4. I
On Mon, 1 Mar 2004, Alexander Cohen wrote:
What sql query can i use to get all relative data to the types of
fields that a table contains?
select column_name,data_type from information_schema.columns where
table_name='test';
works in 7.4
---(end of
On Mon, 1 Mar 2004, Ron St-Pierre wrote:
You're right I am getting the same results. I created the same table with:
create table category (
category_id serial not null primary key,
category_name character varying(100) not null
);
alter table category alter column
Have you tested it with regular pg_connects instead of pg_pconnect? while
many people expect pconnects to be faster, often, when they result in the
database having lots of open idle connections, they actually make the
system slower than just using plain connects.
You might want to look into
On 12 Feb 2004, Greg Stark wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Now, if you don't mind using the ODBC connector, you're scott free. but
you WILL be bound by the GPL, and the GPL (not MySQL's interpretation,
just the GPL in general) being applied to connect libs seriously
On Wed, 12 May 2004, Dirk Försterling wrote:
Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes:
Do people think linux 2.6.5 is stable enough yet for a production
PostgreSQL server?
i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux
version 10)
I'd
On Wed, 12 May 2004, Peter Eisentraut wrote:
Am Montag, 9. Februar 2004 06:06 schrieb David Garamond:
SQL Server only allow one NULL in a unique constraint column (it's the
unique index that does that, so the unique constraint behaves like that
too). The question is, what is the best way
upgrading to 7.4
Thanks for any input.
Dias
scott.marlowe wrote:
On Sun, 11 Apr 2004, Jerry McBride wrote:
T. Relyea wrote:
Mike Cox wrote:
Has anyone created something like that for Postgresql? It would be
really handy to encrypt credit card numbers and other
.public.tables SELECT * FROM db2.public.table1
Thanks,
Thomas
From: scott.marlowe [EMAIL PROTECTED]
To: Thomas LeBlanc [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] How to move data from 1 database to another?
Date: Tue, 11 May 2004 10:13:22 -0600 (MDT)
On Tue, 11 May
On Tue, 11 May 2004, Thomas LeBlanc wrote:
I have 2 databases. I want to move data from table table1 in database db1 to
table2 in db2.
When I query 1 table from another database, I get a cross-database
references are not implemented.
server1% psql db1
emdata=# select * from
On Tue, 11 May 2004, [EMAIL PROTECTED] wrote:
hello,
i'm very new to postgres and have a fundamental question.
how do i make a pg-db most secure?
i feel, that pg_user e.g. ist something very dangerous - isn't it? if
someone hacks into a db, then he has lots of information at his/her
On Mon, 10 May 2004, Jack Orenstein wrote:
scott.marlowe wrote:
shared_buffers is the amount of space postgresql can use as temp memory
space to put together result sets. It is not intended as a cache, and
once the last backend holding open a buffer space shuts down
On Fri, 30 Apr 2004, CS Wagner wrote:
I assume this issue has been solved repeatedly, but I cannot find any
information on it...
I have a website that runs reports on data from a postgres database. An
average report takes about 10 minutes. I'd like to load balance it so I
can have
On Fri, 23 Apr 2004, Jerry Robertson wrote:
We have been running Postgre for over a year and are very pleased with its ease of
use and performance.
We have encountered one problem that has been minor until today and that is:
Occasionally a row in a table get populated with #Deleted
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
On Tue, Apr 20, 2004 at 14:36:57 +0100,
csysi [EMAIL PROTECTED] wrote:
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
the databases are incompatible.
Can i convert the databases ?
You need to do a dump and
On Mon, 19 Apr 2004, Gregory S. Williamson wrote:
FWIW, this site gives:
404 - File Not Found
These aren't the droids files you're looking for.
Sorry, but that file could not be found. And believe you me, we looked! We checked
all the likely directories, then all the unlikely
I'm not sure why you're doing it the exact way you are, but you basically
just call the same commands within a pg_query as you would on the psql
command line to make it work:
begin
declare mycurs cursor as select * from table
fetch 10
rollback / commit
---(end of
Maybe natural join is what you want?
On Wed, 14 Apr 2004, Dennis Gearon wrote:
I will have a table with, among other things, two time columns.
As per my last post, I will be using a variable time for the day-to-day
boundary, versus the traditional 12pm.
What I want to be able to do upon
On Mon, 12 Apr 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
On Fri, 9 Apr 2004, Christopher Browne wrote:
See the pgcrypto contrib module in the source tree.
It is not typically compiled into what gets distributed with the
typical Linux/BSD distribution because
On Tue, 6 Apr 2004, Bernhard Ankenbrand wrote:
Hi,
we have a table width about 60.000.000 entrys and about 4GB storage size.
When creating an index on this table the whole linux box freezes and the
reiser-fs file system is corrupted on not recoverable.
Does anybody have experience with
On Mon, 5 Apr 2004, C G wrote:
Dear All,
What's the best way to store jpgs in postgresql to use in a web page?
I tried to use large objects, but how would you extract them from a table to
be viewed in a web-page without having to write them to a scratch file
somewhere first?
There are
On Wed, 31 Mar 2004, Tom Lane wrote:
John Liu [EMAIL PROTECTED] writes:
The original simple SQL -
select distinct atcode from TMP order by torder;
This is not simple, it is broken SQL with an undefined result.
If DISTINCT merges multiple rows with the same atcode, how are we
supposed
On Mon, 29 Mar 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
And while we're at it, maybe we should have a setting somewhere should
someone execute the famous update pg_shadow set usesuper = false that
someone did a while back to be able to force an account
On Mon, 22 Mar 2004, marian wrote:
When I do this,
INSERT INTO orgdata ( name, fax, contact, email, phone, address,
preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]',
'987654321', 'wally way', 'f' )
I get
ERROR: query rewritten 100 times, may contain cycles
:
On Fri, 19 Mar 2004, Robert11 wrote:
Hello:
Am about to sign up for an on-line database course (introductory)
Apparently, one must have on their PC for the course either
Access
postgre
mysql
Am really new at this.
Access is a problem, as the package costs is $200.00 Wow !
I
On Fri, 26 Mar 2004, Guy Rouillier wrote:
(Resurrecting a subject I found searching the archives...)
Newbie. We're investigating replacing our Oracle databases with
PostgreSQL. Our largest database is currently 25 GB and growing. It
contains time sequenced data. Under Oracle, we use a
On 25 Mar 2004, Roger Dahl wrote:
To find out which boxes contain a specific item, I would write a query
like this:
select b.name,
from boxes b
inner join item_box_maps m on m.box_id = b.id
inner join items i on m.id = m.item_id
where i.name = 'hammer';
Is this the actual query? You're
On Tue, 23 Mar 2004, Tom Lane wrote:
Bill Moran [EMAIL PROTECTED] writes:
Was this true for some previous version? I could have swore I read somewhere
that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean
everything up (aside from anything locked in transactions).
On Tue, 16 Mar 2004, Tom Lane wrote:
Keith C. Perry [EMAIL PROTECTED] writes:
I've read threads like this before and because I've never lost data on
servers with IDE drives after doing some basic torture tests
(e.g. pulling the plug in the middle of an update et al), I don't
think I've
On Wed, 17 Mar 2004, Robin 'Sparky' Kopetzky wrote:
Good Morning!!
I'm repairing a series of scripts in PHP that use the 'datetime' of MySQL
and converting them to Postgres. Question is this: The datetime format used
in the script is 'MMDDHHMMSS' as a text string. Do I have to
On Wed, 10 Mar 2004, Christopher Petrilli wrote:
On Mar 10, 2004, at 3:14 PM, Steve Wolfe wrote:
Before I shell out the $15k on the 4-way Opteron, I'm going to spend
some long, hard time looking for ways to make the system more
efficient.
However, after all that's already been
On Wed, 3 Mar 2004, satish satish wrote:
Hi,
I am trying to do some reliability tests on postgre SQL. I have
use-case where the power can go off abruptly. I initiated 10,000 insert
operations and pulled out the cable in the middle. I had auto-commit
option turned on. I observed 2 out
Have you run this update query again and again with vacuuming?
http://www.postgresql.org/docs/7.4/static/maintenance.html#ROUTINE-VACUUMING
If so, you might have millions and millions of dead tuples taking up
space and slowing things down. If you're running 7.4, install the
autovacuum daemon
On Tue, 9 Mar 2004, Sally Sally wrote:
I wanted to do some quick load testing on a postgres database. Does anyone
have any tips on how to go about doing this?
Thanks much.
If you just wanna beat the database a bit to test for reliability etc,
look at contrib/pgbench in the distro.
If you
On Wed, 3 Mar 2004, Bricklen wrote:
Hi all,
I've scoured the net for a simple way to set AUTOCOMMIT off in psql, for
the duration of a session (not simply a transaction). The only real
reference that I can find says that \set autocommit off will do what I
want. It doesn't though. For
On Wed, 3 Mar 2004, Gunjeet Singh wrote:
Hi,
I could only find support for defining functions in pl/pgsql.
With a function I can have only one return value. What if I need
to have multiple OUT parameters (i.e multiple return values) ?
Is there any support for something that is similar to
On 3 Mar 2004, Eric wrote:
Hello.
After I have performed several queries by an external program on the
database, an error message appeared:
hard limit on result handles reached is not a valid query result
May I know how to solve the problem?
Sounds like an application issue, not
On Tue, 2 Mar 2004, Ara Anjargolian wrote:
I've been searching the list archives and the web for a while about which
locale is best used with PostgreSQL and I did not find a satisfactory answer
so I
thought I would ask the list.
Right now my locale is en_US, but with this you can not use
On Fri, 5 Mar 2004 [EMAIL PROTECTED] wrote:
Hey all,
I'm using PostgreSQL 7.3.4.
I have a query that isn't using a particular index, and I'm wondering why.
The query is:
select i.ItemID, d.Extension from ITEM i, SHARING s, DOCUMENT d where
i.ItemID = d.ItemID AND s.ItemID =
On Mon, 8 Mar 2004, javier garcia - CEBAS wrote:
Hi;
Is it possible to directly create postgres tables with a timestamp column
with some specific interval and within a specific range.
For example every 5 minutes and between the beginning of 1999 and the end of
2003?
I just need this
On Thu, 4 Mar 2004, phil campaigne wrote:
Hello,
when I login to linux and check the env's I see:
PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin
On Wed, 3 Mar 2004, [iso-8859-15] Hervé Piedvache wrote:
Hi,
I have may be a stupid question, but I'm a little surprised with some explains
I have, using date fields ...
I would like to understand exactly when index are used ...
I'm using PostgresQL 7.4.1
I have a table with 351 000
On Wed, 3 Mar 2004, [UTF-8] Paulovič Michal wrote:
Yes I know,
But how you do this at PgSQL
OK, I just read the response where someone showed me how to make such a
table in mysql. What an odd, and non-intuitive behaviour that is.
Anyway, first off, upgrade your version of postgresql
On Mon, 1 Mar 2004, Phil Campaigne wrote:
Hello,
I originally installed postgresql as root user and now I am setting up a
development environment with cvs and a java ide and tomcat. I have
everything with the exception of postgresql integreted using a non-root
user.
THe process I am
On Fri, 27 Feb 2004, Shane Wegner wrote:
On Fri, Feb 27, 2004 at 06:00:36PM -0500, Sean Shanny wrote:
Shane,
Can you give an example of a query that has gotten slower due to the
increasing size of the urls table with an explain analyze?
The database is a simple traffic monitoring
On Sat, 28 Feb 2004, Rajat Katyal wrote:
Hi:
Whenever i try to insert the data, size of which is greater than that of column
datatype size, I got the exception value too long for.
However this was not in postgresql7.2.
Can anyone please tell me, is there any way so that i wont
On Fri, 27 Feb 2004, Bill Moran wrote:
Hey all.
I've hit an SQL problem that I'm a bit mystified by. I have two different
questions regarding this problem: why? and how do I work around it?
The following query:
SELECTGCP.id,
GCP.Name
FROMGov_Capital_Project
On Fri, 20 Feb 2004, twosk wrote:
Hi,
I have a question, because i cannot find any information in online docs
(maybe i'm just blind :P).
I'm want to build application with embedded database, but i also need a
possibility to have one global database, which can be accessed from internet
On Fri, 20 Feb 2004, Sally Sally wrote:
Thank you all for replying. I appreciate the tips. Apologies to those who
were offended by the html formating.
Scott, quick question. The reason I assumed insert would be safer than
copy is because the docs say that in the case of copy it fails on a
On Tue, 17 Feb 2004, Chris Browne wrote:
[EMAIL PROTECTED] (Jan Wieck) writes:
P.S. For example MySQL Databse have the commercial license for that.
P.P.S. BSE is Bovine Spongiform Encephalopathy, also known as Mad Cow
Disease. Even if MySQL has a few features that might be described this
On Tue, 17 Feb 2004, Linh Luong wrote:
Hi All,
1. I have been reading and the max size of a tuple is 8K.
I have also read that I can it to a larger size in some config file. Where is
this file? is it called pg_config.h and is the variable called BLKSZ??
You'd have to set the way back
On Thu, 19 Feb 2004, Alex wrote:
Hi,
just a few questions on the Vaccum
I run a vacuum analyze on the database every night as part of a
maintenance job.
During the day I have a job that loads 30-70,000 records into two tables
(each 30-70k).
This job runs 2-3 times a day; the first time
On Thu, 19 Feb 2004, Ed L. wrote:
On Thursday February 19 2004 9:13, Bruce Momjian wrote:
The 7.3.4 doc (doc/html/runtime-config.html) does say the
log_connections option can only be set at server start or in the
postgresql.conf configuration file. That seems a little ambiguous on
On Thu, 19 Feb 2004, Sally Sally wrote:
I had a few questions concerning the backup/restore process for pg.
1) Is it possible to dump data onto an existing database that contains data
(assumning the schema of
both are the same). Has anyone done this? I am thinking of this in order to
On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:
The problem is that on fire time, the load go to 1 and stay long
time. But with top (i use top -d 1 to have real load average) i can
see that the CPU is more than 50% idling.
For exemple, i have this kind of stat :
0s - load 1.5 -
On Tue, 17 Feb 2004, Tom Lane wrote:
Brendan Jurd [EMAIL PROTECTED] writes:
I'm not objecting to the incompatibility itself, but I do think more
information needs to be provided to the user. I humbly suggest that if
psql is not going to be fully backwards-compatible with previous
On Thu, 12 Feb 2004, Bas Scheffers wrote:
Hi Scot,
As unrealistic as it should be, I need 1 before Postgres takes the
bait. Initialy 0.7, to be exact, but later It also worked at a little
higher setting of 1. I have given PG 96Mb of memory to play with, so
likely all my data will be in
On Thu, 12 Feb 2004, Jason Tesser wrote:
I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20
On Thu, 12 Feb 2004, Jason Tesser wrote:
Hi
I have the below query written. I have removed a lot from the
select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is
On Wed, 11 Feb 2004, NTPT wrote:
Take 1900 ms.. In this case i try to increase effective_cache_size step
by step 64,128,256,512,1024 but increase effective_cache_size up from
512 have no dramatic impact on performance.
Note that effective_cache_size ONLY affects the query plan chosen. It
On Wed, 11 Feb 2004, C G wrote:
Dear All,
Could anyone explain why this function does will not work? The error message
is
DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
CREATE FUNCTION testing() RETURNS trigger AS'
plan=plpy.prepare(''INSERT INTO t1 values
On Wed, 11 Feb 2004, C G wrote:
Dear All,
Could anyone explain why this function does will not work? The error
message
is
DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
CREATE FUNCTION testing() RETURNS trigger AS'
plan=plpy.prepare(''INSERT INTO
On Tue, 10 Feb 2004, Andrew Sullivan wrote:
On Tue, Feb 10, 2004 at 12:06:43PM -0700, scott.marlowe wrote:
simple. They GPL'd their connection libs. So, if you write code that has
their connection libs in it, it's gotta be GPL'd.
Yes. But you could fork from their old libs (which were
On Tue, 10 Feb 2004, Jeff Bohmer wrote:
I have a table in a PG 7.4.1 database with 380 duplicate rows,
including duplicate oid and primary key values. Looking through our
backups, the duplicates did not exist before Friday, 02/06/2004. I'm
assuming neither pg_dumpall nor restoring from
On Tue, 10 Feb 2004, CSN wrote:
I have a pretty simple select query that joins a table
(p) with 125K rows with another table (pc) with almost
one million rows:
select p.*
from product_categories pc
inner join products p
on pc.product_id = p.id
where pc.category_id = $category_id
order
On Tue, 10 Feb 2004, CSN wrote:
2. Vacuum analyze the tables concerned and post the
output of EXPLAIN ANALYSE
with your query.
= explain analyze;
results in:
ERROR: syntax error at or near ; at character 16
No silly. you do:
explain analyze select ... (rest of the query...)
On Tue, 10 Feb 2004, CSN wrote:
I think that probably improves things (lower cost? -
see my other post):
explain select p.* from products p where p.id in (
select product_id from product_categories pc where
pc.category_id = 1016) order by p.title limit 25
offset 0;
On Wed, 21 Jan 2004, Alex Madon wrote:
Hello,
I am testing a web application (using the DBX PHP function to call a
Postgresql backend).
I'm not familiar with DBX. Is that connection pooling or what?
I have 375Mb RAM on my test home box.
I ran ab (apache benchmark) to test the behaviour
On Wed, 21 Jan 2004, Alex Madon wrote:
One can see that at the maximum feeling of swap (74700k free swap), the
full picture is:
22:51:54 up 3:58, 6 users, load average: 47.38, 18.53, 7.79
131 processes: 130 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 5.3% user 3.0%
On Wed, 21 Jan 2004, Kragen Sitaker wrote:
I'd like to be able to do queries like select count(*), fromline from
message where subject like 'Couldn%' quickly. I see that, in current
Postgres, I can do this with an index like create index message_subject
on message using btree(subject
Is it possible to institute phrase searching with that system?
I.e.:
create unique index
select distinct
etc...
???
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
Hello,
Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
documentation
all searchable using OpenFTS and
On Sat, 17 Jan 2004, Joshua D. Drake wrote:
Hello,
Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
reinitdb which means you do
You may have missed where bill said he wanted to change a default limit
for plpgsql function args from 16 to something else. that will
On Fri, 16 Jan 2004 [EMAIL PROTECTED] wrote:
I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make make install and all was well.
I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I
On Tue, 13 Jan 2004, Harry Jackson wrote:
David Teran wrote:
The real question was: are there open known bugs where a select
statement does not return a correct result, meaning a wrong number of
rows? Were there a lot of errors like this?
We are asking this because this makes trouble
On Thu, 15 Jan 2004, Julio Misael Gutierrez wrote:
Good day,
I´m testing PostGresql,
I would like to Know why when I create a new table,
postgresql create a new type with the same name of the table.
Where I can find more information about this?.
To add to what Tom said, this allows you to
On Mon, 19 Jan 2004, Joshua D. Drake wrote:
scott.marlowe wrote:
Is it possible to institute phrase searching with that system?
It seems to work fine???
Sincerely,
Joshua D. Drake
Not really. with htdig, I can do select distinct on the 7.3 docs and I
get exactly 7 responses
On Tue, 13 Jan 2004, Joshua D. Drake wrote:
The real question was: are there open known bugs where a select
statement does not return a correct result, meaning a wrong number of
rows? Were there a lot of errors like this?
We are asking this because this makes trouble with the database
On Tue, 13 Jan 2004, Keith G. Murphy wrote:
I'm trying to get a feel for what most people are doing or consider best
practice.
Given a mod_perl application talking to a PostgreSQL database on the
same host, where different users are logging onto the web server using
LDAP for
On Sat, 10 Jan 2004, Eric Freeman wrote:
Is there any way in Postgres to SELECT a list of table names from inside of
a C program using ECPG?
Something similar to SELECT current_user that will give you all of the
tables in the database you are connected to.
If you are running 7.4 and have
On Mon, 12 Jan 2004, Richard Huxton wrote:
On Sunday 11 January 2004 09:29, Dario Ottaviano wrote:
I use postgres on a window server (IIS 5.1)
Is there anybody that knows if is possible to make postgres no case
sensitive in the manipulating data into tables/views?
There's no general
On Mon, 5 Jan 2004 [EMAIL PROTECTED] wrote:
Hello,
I am new in PostgreSQL world coming from Oracle.
I have created two databases using command line as manual has suggested.
For instance I have done like the following:
createdb tanya
createdb eps
Now I would like to stop my tanya database
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
Right! Thus my quandry.
Re inodes, how can I check this? But why would this be? Is Postgres
sucking up inodes just sitting there as a read-only DB?
If you are out of inodes, I seriously doubt it is Postgresql's fault, as
you seem to be
Another good way to handle this is to put a trigger on the table that
diverts inserts that would fail to a holding table. While this will slow
down the inserts, it will allow you to insert large lists of dubious
quality and worry about the bad rows later.
My preference is to fix the data
On Wed, 7 Jan 2004, John Sidney-Woollett wrote:
Is it possible to (automatically) force the reparse of a stored PL/pgSQL
function following the deletion and recreation of an object that was
referenced within the function (for example a table or another function)?
Would
CREATE OR REPLACE
On Thu, 11 Dec 2003, Netto wrote:
The way PostgreSQL deals with the date format is confusing me...
I need PostgreSQL to return dates from selects at this format: dd/mm/,
but it insists in returning it as -mm-dd. I say insists cause I had
already set datestyle to European (in
You're gonna have a hard time getting support for a version that old
(we've since seen 7.1, 7.2, 7.3, and 7.4 come out and 7.5 is in the cooker
right now.
If it's possible to backup your database, I'd highly recommend upgrading
postgresql on a test machine or something. It sounds like you
On 16 Dec 2003, claudia wrote:
Hi, I developing a program using postgres and linux like operating
system. My problem is this:
I have a quite complicated view with roughly 1 record. When I
execute a simple query like this
select * from myview
postgres respond after 50 - 55 minutes
On Mon, 15 Dec 2003, Johnson, Shaunn wrote:
Howdy:
Silly questions -
Is it possible (or, has anyone got brave enough) to run
PostgreSQL on Windows Server 2003?
If so, what does it entail and how do I start?
The best and easiest way for normal folks is likely gonna be to use
cygwin,
On Fri, 12 Dec 2003, Josué Maldonado wrote:
Hello list,
What's the right way to uninstall postgres 7.4 in Linux (RH 8)?.
That really depends on how it was installed. If installed via RPM, then
you do 'rpm -e postgrespackagenameshere'. If it was installed from
source, 'make uninstall'. or
On Tue, 2 Dec 2003, Randolf Richardson wrote:
In dealing with web applications and frontends to database or
even just a dynamic web site PHP has every bit the power and ability that
Java does and the development time is way down.
Uh, how about threads. I know that you don't need them
On Tue, 2 Dec 2003, Jan Wieck wrote:
scott.marlowe wrote:
On Mon, 1 Dec 2003, Jan Wieck wrote:
Jason Tesser wrote:
Quoted as gospel by various people:
MySQL cannot even handle sub-queries yet.
BTW, is that really still true? I thought they had at least some
support
On Wed, 19 Nov 2003, Randolf Richardson, DevNet SysOp 29 wrote:
An ISP I belong to uses Majordomo for their mailing list system. I'd like
to encourage them to move to a system that uses a database, preferably
psql which they already run on their server. Anything out there in Php?
On 1 Dec 2003, Randal L. Schwartz wrote:
scott == scott marlowe [EMAIL PROTECTED] writes:
scott This is simply not true. PHP comes in both a web ready
scott embedded version, as well as a CLI version, and is quite
scott capable, even of handling things like streams and such, and can
On Mon, 1 Dec 2003, Jan Wieck wrote:
Jason Tesser wrote:
Quoted as gospel by various people:
MySQL cannot even handle sub-queries yet.
BTW, is that really still true? I thought they had at least some
support for subqueries by now.
yes sub queries in 4.1 which is still alpha
On 1 Dec 2003, Greg Stark wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Again, show me an area where PHP is actually deficient here. Something
Perl or Ruby does better that would pertain to a mailing list. Don't just
wave your hands around, give us a concrete example of its short
None to begin with. You have to tell it to. Then you have to tell it to
allow connections on that port. PostgreSQL comes configured to NOT let
outside computers connect until you change things, enhancing security.
You want to read the admin guide located here:
On Wed, 12 Nov 2003, Rick Gigger wrote:
Is this correct?
vacuum by itself just cleans out the old extraneous tuples so that they
aren't in the way anymore
vacuum analyze rebuilds indexes. If you add an index to a table it won't be
used until you vacuum analyze it
vacuum full actually
On Thu, 13 Nov 2003, jini us wrote:
Hi,
I am starting a new project where I intend to use
embedded database server in my win32 application.
I intend to use VC++ microsoft studio 6.0 as my
development environment.
The postgres.org website seems to be catering for
people with all sorts
On Wed, 12 Nov 2003, Reece Hart wrote:
On Wed, 2003-11-12 at 09:04, jake johnson wrote:
I also posted about the performance increase of 7.4, but I think that
much of the difference you're seeing (because it's such a large
difference) is probably due to the cleanliness of a newly
On Thu, 13 Nov 2003, jini us wrote:
if libpq.dll contains the server and I can call the functions
to start and stop programmatically.
Then I could use Postgres as an embedded database sever in my application.
That way I include libpq.dll in my software package for deployment
with
1 - 100 of 211 matches
Mail list logo