[EMAIL PROTECTED] wrote:
> On Mon June 5 2006 1:31 am, Adam Witney wrote:
>> Tom Lane wrote:
>>> Adam Witney <[EMAIL PROTECTED]> writes:
bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
bioassay_id = 5153 group by bioassay_id;
bioassay_id | count
Chris Velevitch wrote:
Why doesn't explain work with create views? There's nothing in the
documentation saying it shouldn't.
>
No? The documentation for explain clearly states that the statement that follow the EXPLAIN
keyword is "Any SELECT, INSERT, UPDATE, DELETE, EXECUTE, or DECLARE statemen
Good morning to all. I have a problem during my installation of postgresql on windows
after it starts copying the files I come to this message:
" Internal account lookup failure: no correspondance between usernames and passwords account security ". After Internal account lookup failure message
Hi,
I'm happy to see that Postgres supports output parameters in 8.1. Now, to
actually use them
I would like to return multiple sets to my php program. So, questions:
1) I can return sets in output parameters, correct? The example's I've seen
use scalars.
2) Will this work with the ex
Hi all when i tried to install postgress on windows XP i encountered the error message:
"
internal account lookup failure:
No correspondance between usernames and passwords account security
"
the second part of the message is written in greek but i guess that is more or less the message in engl
On 6/5/06, Thomas Hallgren wrote:
Chris Velevitch wrote:
> Why doesn't explain work with create views? There's nothing in the
> documentation saying it shouldn't.
>
No? The documentation for explain clearly states that the statement that follow
the EXPLAIN
keyword is "Any SELECT, INSERT, UPDATE
Hi Harald,
I have tried to install the database silently, according to that document
you gave me http://pginstaller.projects.postgresql.org/silent.html but the
documentation seems to be out of date...
As the document specifies...
Normal none Normal interactive user installation
Reduced /qr No u
> Normal none Normal interactive user installation
> Reduced /qr No user interaction. "Full size" progress window including
> progress descriptions.
> Basic /qb No user interaction. Just a basic progressbar and not full
> descriptions.
> Silent /qn No user information at all.
>
>
> Yet, these
Greg,
did you try to start the installer like
postgresql814.msi /qb . ???
That is rather doomed to failure.
You should try the
msiexec
If you call msiexec without parms, it will give you a online help with
all the parms. Thoes /q are from Microsoft, not from Magnus
:)
best wishes,
Har
Chris Velevitch wrote:
> On 6/5/06, Berend Tober wrote:
>
>> Chris Velevitch wrote:
>> > What is the point of the create or replace view command if you can't
>> > change the column and data types ?
>>
>> You could have a calculated column and change the calcuation.
>>
>> You could change the sort
I am creating an email client that will contain email
messages. Now a message may have multiple large attachments.
1.)
Would the best way to store these large objects be in
an oid field?
2.)
I assume for performance reasons I should place these
large objects in a separate table
tried calling the '-int' MSI but I get an error telling me "The installer
has encountered an unexpected error installing this package. This may
indicate a problem with the package. The error code is 2711."
This is my command line
msiexec /i postgresql-8.1.msi /qr INTERNALLAUNCH=1 ADDLOCAL=server
> tried calling the '-int' MSI but I get an error telling me
> "The installer has encountered an unexpected error installing
> this package. This may indicate a problem with the package.
> The error code is 2711."
>
> This is my command line
>
> msiexec /i postgresql-8.1.msi /qr INTERNALLAUNC
Thanks, I got it working, in the log, it told me the 'docs' module could not
be found, so I removed it.
But now, further, in the installation, it tells me, invalid username
specified, Logon failure - unknown username or password.
Now my question, this installer will need to be installed on numerou
Greg wrote:
> I am creating an email client that will contain email messages. Now a
> message may have multiple large attachments.
>
>
>
> 1.)Would the best way to store these large objects be in an oid field?
>
> 2.)I assume for performance reasons I should place these large
Adam Witney <[EMAIL PROTECTED]> writes:
> I don't know, so posting your question to the list. I meant to ask last
> night in fact, should i be worried as to why this occurred?
Yeah, you should, but since you hadn't given us any context about the
problem I figured you only cared about a quick fix.
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> But, wouldn't you want to see the execution plan for the select
> statement that appears in the create?
Then give the EXPLAIN the select statement that appears in the create.
Logically, EXPLAIN of a DDL statement would tell you about the costs
of pe
Hi all,
let's assume that we keep Unicode text data in the column.
sometimes we want to sort it according to specific collation order.
how can we force collation when running a query?
ideal solution would be having SQL92 standard COLLATE clauses in
SELECT statements. I heard it's work in progres
Tom Lane wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> I don't know, so posting your question to the list. I meant to ask last
>> night in fact, should i be worried as to why this occurred?
>
> Yeah, you should, but since you hadn't given us any context about the
> problem I figured you on
# [EMAIL PROTECTED] / 2006-06-05 16:19:19 +1000:
> On 6/5/06, Joe Conway wrote:
> >Chris Velevitch wrote:
> >> But what about my original question?
> >>
> >> "What is the point of the create or replace view command if you
> >> can't change the
> >> column and data types?"
> >
> >-- create t
On Mon, Jun 05, 2006 at 05:04:25PM +0200, Filip Rembia??kowski wrote:
> Hi all,
>
> let's assume that we keep Unicode text data in the column.
> sometimes we want to sort it according to specific collation order.
> how can we force collation when running a query?
> ideal solution would be having
"Filip Rembiaâkowski" <[EMAIL PROTECTED]> writes:
> let's assume that we keep Unicode text data in the column.
> sometimes we want to sort it according to specific collation order.
> how can we force collation when running a query?
> ideal solution would be having SQL92 standard COLLATE clauses i
Just wondering if anyone has done this:
Change the user the DB runs under from postgres to apache on a
established server?
I would think I would just change ownership on all the data dir files
and modify the startup script in /etc/init.d/postgresql.
Reason is I need a plperlu procedure to gene
On Mon, 05 Jun 2006 13:21:48 -0500
Tony Caduto <[EMAIL PROTECTED]> wrote:
> Just wondering if anyone has done this:
> Change the user the DB runs under from postgres to apache on a
> established server?
> I would think I would just change ownership on all the data dir files
> and modify the star
could you just add the postgres user to the apache group?AlexOn 6/5/06, Tony Caduto <[EMAIL PROTECTED]
> wrote:Just wondering if anyone has done this:Change the user the DB runs under from postgres to apache on a
established server?I would think I would just change ownership on all the data dir fil
I am fighting with FreeBSD 5.4, Apache 1.3.36, php 5.1.4 and PostgreSQL
8.1.4 two days already. The PGSQL extention of php crashes everything.
Trying to go back to PostgreSQL 8.0.8 to see if the problem comes from
there.
Please, let me know if your case is similar.
Iv.
-
On Mon, 2006-06-05 at 14:18, [EMAIL PROTECTED] wrote:
> I am fighting with FreeBSD 5.4, Apache 1.3.36, php 5.1.4 and PostgreSQL
> 8.1.4 two days already. The PGSQL extention of php crashes everything.
> Trying to go back to PostgreSQL 8.0.8 to see if the problem comes from
> there.
>
> Please,
Most the time I've seen this, php and apache have been compiling against
different versions of the same or similar libs.
Last time, apache was hitting the netscape ldap libs, php was hitting
the ones for openldap.
Look for that kind of thing. Also, try compiling php with ONLY the
postgresql ext
The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL 8.1.4 -
but could not. The PGSQL extension kills the httpd (Apache 1.3.36).
Just went back to PostgreSQL 8.0.8 and all works fine.
No idea what it is - just decided to report.
Everything was build the usual way from ports on Free
[EMAIL PROTECTED] wrote:
> The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL
> 8.1.4 - but could not. The PGSQL extension kills the httpd (Apache
> 1.3.36).
>
> Just went back to PostgreSQL 8.0.8 and all works fine.
>
> No idea what it is - just decided to report.
>
> Everything
For what it's worth, I have no issue with PHP 5.1.4 and PostgreSQL
8.1.4 on Gentoo either.
Gavin
On Jun 5, 2006, at 2:40 PM, Larry Rosenman wrote:
[EMAIL PROTECTED] wrote:
The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL
8.1.4 - but could not. The PGSQL extension kills the h
On Mon, Jun 05, 2006 at 11:34:35PM +0200, [EMAIL PROTECTED] wrote:
> The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL 8.1.4 -
> but could not. The PGSQL extension kills the httpd (Apache 1.3.36).
>
> Just went back to PostgreSQL 8.0.8 and all works fine.
Maybe you should check th
Daniel's answer reflects our experience with large objects.
We recently switch our 50-or-so G of stored postscript documents from
large objects to bytea, but only because we're going to use Slony for
our "more-availability" setup and Slony doesn't replicate large
objects.
Hi, everybody !
First of all: Any help would be appreciated !!!
Yes, i know, we are using a jurassic version of postgresql and we
should try to upgrade first, but that is the next step. Now we've to
make sure that 7.3.3 will work with FC5.
The problem: We are chang
On Mon, Jun 05, 2006 at 07:03:59PM -0300, Daniel Henrique Alves Lima wrote:
> Hi, everybody !
>
> First of all: Any help would be appreciated !!!
>
> Yes, i know, we are using a jurassic version of postgresql and we
> should try to upgrade first, but that is the next step. Now we've to
> make sur
I am trying to upgrade my installation from 8.1.3 to 8.1.4, and when I try to upgrade the postgresql-docs package, I am getting the following error from 'rpm -Uvh':error: postgresql-docs-8.1.4-1PGDG.i686.rpm
: MD5 digest: BAD Expected(a6f3196317b296ef555f47f343a6871b) != (b9dcbf1533565efb9d629e25a4
36 matches
Mail list logo
