Hi all,
I know that it's also related to PHP but sadly no one knew anything there so
I try here... :)
At the PHP manual of
PDOStatement::closeCursorhttp://il.php.net/manual/en/function.pdostatement-closecursor.phpit's
written that This method is useful for database drivers that do not
support
On 12/17/06, Tom Lane [EMAIL PROTECTED] wrote:
But having said all that, I think there are bits of SQL2003 that do some
of what you're after. I don't think anyone has looked hard at what
would be involved in merging those new SQL features with historical
Postgres behaviors.
I've been looking
It's always good to close your cursors once you don't need them anymore,
but PostgreSQL doesn't force you to or blocks if you don't.
I really wonder why people use senseless things like PDO. Ah yes.. it's
all about design patterns, right. Let's write a wrapper for the sole
purpose of having
ben would something like this work in your situation?
SELECT customer.id, customer.name, deliveries.calendar_day,
deliveries.delivered
FROM ben_customers as customer, ben_deliveries as deliveries
WHERE customer.id = deliveries.customers_id
and deliveries.calendar_day in (Select day
Hello all-
I'm working with a poorly-designed schema and need to do a lookup in
one table who's name I have to pull from a second table. I'm wondering
if its possible to do something like this in PostgreSQL:
Say I have three tables:
CREATE TABLE audio (id int4, name varchar(32));
CREATE
I need to allow non-superusers to create and restore databases containing
plpgsql language procedures.
template0 and template1 do not have any languages installed.
During restore they receive error:
pg_restore: [archiver (db)] could not execute query: ERROR: must be
superuser to create
Tom,
Here is the sole plpgsql function that was called when the error
occurred. This function is intended to be called from a shell script in
order to cluster tables in parallel processes. One calls it with
from_perc and to_perc - the % of statements that are run (e.g. 0% to
14%). (This concept
Hi
I want to combine a PostgreSQL project with my host interface software to make
an installable, c/w the PostgreSQL server.
Can someone please point to the document that explains how this is
accomplished??
I am using Delphi's version of InstallShield on Win XP.
Bob Pawley
Angva [EMAIL PROTECTED] writes:
Here is the sole plpgsql function that was called when the error
occurred. This function is intended to be called from a shell script in
order to cluster tables in parallel processes.
OK, I played around with this for a bit, and what I find is that in 8.1,
that
I'm having some trouble installing postgresql 8.2 on fedora core 6.
This is my first time running fedora, I used to not have any problems
getting postgresql 8.1 started under gentoo. The RPMs are all
installed, it installed the init.d script and can su - postgres and do
a pg_ctl start
Gene wrote:
I'm having some trouble installing postgresql 8.2 on fedora core 6.
Check your logs - something *must* be recorded in /var/log. The first
thing I'd guess is it's something to do with selinux though.
--
Richard Huxton
Archonet Ltd
---(end of
Andrus wrote:
How to allow non-superusres to create database with language ?
You can't. If they can install a language-handler, they can install code
that can do anything, including take control of the server and the unix
account it runs as.
--
Richard Huxton
Archonet Ltd
Steve Castellotti wrote:
SELECT name FROM (SELECT table_name FROM media WHERE media_id=1);
You can try something like:
SELECT name FROM audio JOIN media ON id
WHERE table_name='audio' AND media_id=1
UNION ALL
SELECT name FROM video JOIN media ON id
WHERE table_name='video' AND media_id=1
;
Thanks for the suggestion, this is my first experience with SELinux. I
disabled selinux postgresql daemon protection, and then had to
reinitdb and then it worked! Greatly appreciated!
On 12/18/06, Richard Huxton dev@archonet.com wrote:
Gene wrote:
I'm having some trouble installing postgresql
Hello list,
I'm trying to install tsearch2 on a freshly created database in 8.2
but I get these NOTICES when doing so.
Is this something to be concerned about?
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
pg_ts_dict_pkey for table pg_ts_dict
NOTICE: CREATE TABLE /
15 matches
Mail list logo