Hi
Sorry for this somewhat long email but I think it is relevant to most
people who run online databases. I am having trouble optimizing UPDATE
queries on a certain semi-large table that is only growing larger.
I've come across some very interesting thoughts from this list, so I
thought I'll post
On 6/17/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Having said that, the main gripes I would have with PHP are (i)
variables aren't strongly typed, which can bite you unless you're
careful, and (ii) you don't have to declare variables before using them,
which can also cause trouble - in VBS
On 6/17/07, PFC <[EMAIL PROTECTED]> wrote:
I either use pg_query_params() which automagically handles all quoting,
or an ORM which does the same.
There is no reason to include strings in SQL statements except laziness.
MySQL does not have a mysql_query_params() for PHP, so you have to write
on
Could you end the query with a "LIMIT 1"?
SELECT h.id AS host_id, MIN(r.start_date) AS reservation_start_date, r.id AS
reservation_id
FROM hosts h
LEFT OUTER JOIN reservation_hosts rh ON rh.host_id = h.id
LEFT OUTER JOIN reservation r ON r.id = rh.reservation_id AND
(r.start_date, r.end_date) OVE
Hi,
Some newbie questions that the archive search did not help me
with.
1. Will PGSQL work on CentOS? Should I download RH Enterprise
3.0 binaries? Or RedHat 9.0 binaries?
2. Is there a startup kit with 6-7 easy install steps for a
TOTAL NEWBIE? MySQL seems to be pretty easy to install (sorry
Hi,
Has anyone installed PostgreSQL 8.1RC on a Cpanel server? I have
root access to my dedicated server and would like to install it,
and then have it available in Cpanel interface to my domains.
Thanks for any tips or pointers.
.ep
__
Yahoo!
I am trying to configure the PGSQL 8.1RC and here is my error
log, I'd appreciate any ideas, thanks!
-shell$ ./configure
checking build system type... i686-pc-linux-gnulibc1
checking host system type... i686-pc-linux-gnulibc1
checking which template to use... linux
checking whether to build with
Thanks Thomas.
But:
- "psql" at the command says
> psql: FATAL: database "root" does not exist
- "psql -d postgres" at the command says
> psql: FATAL: role "root" does not exist
How should I create the first database, or the first user etc? The
links you suggested are all *after* I login t
Doesn't work:
- psql -U postgres
> psql: FATAL: Ident authentication failed for user "postgres"
- psql -U postgres -W
> psql: FATAL: Ident authentication failed for user "postgres"
Would appreciate some insights. Where's the step by step guide to make
this work? Cpanel/WHM and Plesk are TH
Please don't top-post, it disturbes the flow of the communication.
Interesting. I prefer getting to the point an author is making.
There's documentation about that too, at the end of the installation
instructions IIRC.
I did not see them. Please point me? I'd deeply appreciate it.
This
Where is pg_hba.conf?
I tried find and whereis commands, but could not find it.
Thanks for any pointers.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining colum
Correct. Also you will find nearly no stuff about using apt-get and rpm,
which are some of the most used package systems on Linux on postgresql.org .
And nothing about emerge, which is central to Gentoo Linux. And no real
documentation to ports, which is prevalent on FreeBsd.
PostgreSQL.org has e
Setting aside the fact that I don't even know what Cpanel is, I'm not
sure how this is practical. How many versions of Cpanel are there and
which versions of postgres do they ship? If Cpanel releases a new
version, do the postgresql docs needs to be updated?
Cpanel team takes care of all of thi
I think it's some sort of serum they inject into semi-skilled i.t.
workers that makes them arrogant and spout off random poorly
constructed off topic posts on professional mailing lists while asking
for help in the same breath. Fortunately, I never went to college and
missed my shot.
You clear
How would you like to use a database that has nuances like these --
http://forums.mysql.com/read.php?20,141120,141120#msg-141120
ep
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
rious difference?
Thanks.
On 2/22/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/21/07 18:09, Erick Papadakis wrote:
> How would you like to use a database that has nuances like these --
> http://forums.mysql.com/read.php?20,141120,
Hello:
I am working on Windows and Unix with Postgresql (newbie, so please be
kind). I use phppgadmin on both platforms. Windows is my local
machine. Linux (CentOS as usual) is the cpanel thing that my hosting
provider offers.
Basically this setup works well and I am learning the ropes. But the
On 4/2/07, Russell Smith <[EMAIL PROTECTED]> wrote:
Erick Papadakis wrote:
> Hello:
>
> I am working on Windows and Unix with Postgresql (newbie, so please be
> kind). I use phppgadmin on both platforms. Windows is my local
> machine. Linux (CentOS as usual) is the cpanel
Thanks Tom. I don't mind having to start it again and again at server
reboots, as I only intend to use it for testing for now.
So how can I execute it inside my own folder? Do I need to give any
special commands? Is there any FAQ for this?
Thanks,
Erick
__
Do
hello
is there a human readable tutorial on how to install postgresql on windows
platforms? i have no clue what cygwin is, but when i download it, it
downloads a bunch of other stuff on my machine! how do i know what i have to
choose in order to be able to install postgresql later?
thanks/erick
20 matches
Mail list logo
