I simply calls configure and make, then I got syntax errors on print*.c (I
forgot the file name). The more precise errors come from a header included
on line 19 (libpq.h).
MinGW 4.2.1-dw2
--
View this message in context:
http://www.nabble.com/Compilation-failed-on-MinGW-tp19968096p19968096.htm
On Tue, Oct 14, 2008 at 3:55 AM, Darren Weber
<[EMAIL PROTECTED]> wrote:
>
> Have you seen anything like this before? I have no idea what this means:
> "CFPreferences: user home directory at /Library/PostgreSQL/8.3 is
> unavailable"
> It looks like a hangover from using a binary installer and I ha
On Mon, 13 Oct 2008 20:45:39 -0600
"Joshua Tolley" <[EMAIL PROTECTED]> wrote:
Premise:
I'm not sustaining that the "default" answers are wrong, but they are
inadequate.
BTW the OP made a direct comparison of pgsql and mysql running
drupal. That's a bit different than just asking: how can I improve
On 14/10/2008, at 11.40, Ivan Sergio Borgonovo wrote:
On Mon, 13 Oct 2008 20:45:39 -0600
"Joshua Tolley" <[EMAIL PROTECTED]> wrote:
PostgreSQL ships with a very conservative default configuration
because (among other things, perhaps) 1) it's a configuration
that's very unlikely to fail miserab
Mikkel Høgh wrote:
On 14/10/2008, at 11.40, Ivan Sergio Borgonovo wrote:
That might be true, if the only demographic you are looking for are
professional DBAs, but if you're looking to attract more developers, not
having sensible defaults is not really a good thing.
While I'll probably take t
On Tue, Oct 14, 2008 at 8:56 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 14, 2008 at 3:40 AM, Ivan Sergio Borgonovo
> <[EMAIL PROTECTED]> wrote:
>> On Mon, 13 Oct 2008 20:45:39 -0600
>> "Joshua Tolley" <[EMAIL PROTECTED]> wrote:
>>
>> Premise:
>> I'm not sustaining that the "default"
On Tue, 14 Oct 2008, Mikkel H?gh wrote:
You are targetting DBAs using servers with less than 512 MB RAM. Is
PostgreSQL supposed to be used by professional DBAs on enterprise
systems or is it supposed to run out of the box on my old Pentium 3?
Take a look at http://bugzilla.kernel.org/show_bug
On Mon, Oct 13, 2008 at 2:57 AM, justin <[EMAIL PROTECTED]> wrote:
> [...] Also you want to split out the debit and credits instead of
> using one column. Example one column accounting table to track values
> entered how do you handle Crediting a Credit Account Type. is it a negative
> or positi
MG>comments prefixed with MG>
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Drupal and PostgreSQL - performance issues?
> CC: [EMAIL PROTECTED]; pgsql-general@postgresql.org
>
> On Tue, Oct 14, 2008 at 8:56 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > On Tue, Oct
It gives me the following error:
ERROR: invalid input syntax for type date: "infinity"
I thought I could use it anywhere in my sql.
I have to add a cast to timestamp in order for this to work. I thought
I wouldn't need to use a case.
Am I missing something?
Thanks in advance.
--
Regards,
On Mon, Oct 13, 2008 at 3:56 PM, Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
> Hi Merlin,
>
>> Stored procedure support is a pretty complicated feature. They differ
>> with functions in two major areas:
>>
>> *) input/output syntax. this is what you are dealing with
>> *) manual transaction man
On Tue, Oct 14, 2008 at 12:58 PM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> It gives me the following error:
>
> ERROR: invalid input syntax for type date: "infinity"
>
> I thought I could use it anywhere in my sql.
>
> I have to add a cast to timestamp in order for this to work. I tho
2008/10/14 Merlin Moncure <[EMAIL PROTECTED]>:
> On Mon, Oct 13, 2008 at 3:56 PM, Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
>> Hi Merlin,
>>
>>> Stored procedure support is a pretty complicated feature. They differ
>>> with functions in two major areas:
>>>
>>> *) input/output syntax. this is
I've got a table with repeated records that I want to make unique by
adding a sequence code of 0,1,2,...,n for each set of repeated records.
Basically, I want to turn:
field_id | seq
--+-
1 | 0
2 | 0
3 | 0
3 | 0
3 | 0
4 | 0
alter table foo add newid sequencial;
alter table foo drop field_id;
alter table foo rename newid to field_id;
Untested ideas (beware):
Use an insert trigger that:
curr_seq := select max(seq) from foo where field_id = NEW.field_id
if curr_seq is null then NEW.seq := 0
else NEW.seq := curr_seq + 1
(You have to figure out how to build the trigger infrastructure...)
If you need to do it on a t
On Oct 14, 2008, at 9:04 AM, Bill Thoen wrote:
I've got a table with repeated records that I want to make unique by
adding a sequence code of 0,1,2,...,n for each set of repeated
records. Basically, I want to turn:
field_id | seq
--+-
1 | 0
2 | 0
3 | 0
2008/10/7 Alvaro Herrera <[EMAIL PROTECTED]>
> Bruce Momjian escribió:
>
> > Well, I posted about this in August with no one replying:
> >
> > http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php
> >
> > Basically, there is a mismatch between what libpq and the backend think
> > i
Hmm, those are interesting numbers. Did you use a real, logged in,
drupal session ID (anonymous users also get one, which still gives
them cached pages).
They are in the form of
"SESS6df8919ff2bffc5de8bcf0ad65f9dc0f=59f68e60a120de47c2cb5c98b010"
Note how the thoughput stays in the 30-
--
Med venlig hilsen,
Mikkel Høgh <[EMAIL PROTECTED]>
On 14/10/2008, at 17.28, Ang Chin Han wrote:
On Tue, Oct 14, 2008 at 10:05 PM, Martin Gainty
<[EMAIL PROTECTED]> wrote:
Yes, it's rather braindead. I'd rather not worry about why, but how'd
we make Drupal use the PostgreSQL more effectiv
* Tom Lane ([EMAIL PROTECTED]) wrote:
> We do have a TODO item to allow type date to do that too. It's been asked
> for often enough, not sure why it hasn't happened. Seems easy enough,
> maybe I'll go do it.
It's certainly be useful for us..
Thanks,
Stephen
signature
On Tue, Oct 14, 2008 at 7:47 AM, Ang Chin Han <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 14, 2008 at 8:56 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> On Tue, Oct 14, 2008 at 3:40 AM, Ivan Sergio Borgonovo
>> <[EMAIL PROTECTED]> wrote:
>>> On Mon, 13 Oct 2008 20:45:39 -0600
>>> "Joshua Tolley" <[E
Isak Hansen wrote:
On Mon, Oct 13, 2008 at 2:57 AM, justin <[EMAIL PROTECTED]> wrote:
[...] Also you want to split out the debit and credits instead of
using one column. Example one column accounting table to track values
entered how do you handle Crediting a Credit Account Type. is it a n
On Oct 13, 2008, at 2:08 AM, admin wrote:
Can anyone recommend an alternative CMS with the features and
flexibility of Drupal that supports PostgreSQL 100%? What about the
Python world, what is Plone like with PostgreSQL support?
Look at using either Pylons or Turbogears with SQLAlchemy if
Mikkel Høgh wrote:
In any case, if anyone has any tips, input, etc. on how best to
configure PostgreSQL for Drupal, or can find a way to poke holes in
my
analysis, I would love to hear your insights :)
I'm a recent Drupal user with postgres.
What I've noticed on drupal-6.4 with Ub
The table exists already; all I need to do is update the sequence code
to make the records unique, but also I need each repeating set numbered
from 0 (Zero) so I can select a list of unique farm field records where
seq = 0.
I think that the suggestion to use a cursor sounds good, but I'm
conc
inside psql turn \o file
then \l
2008/10/9 Jeff Ross <[EMAIL PROTECTED]>:
> Joao Ferreira gmail wrote:
>>
>> Hello all,
>>
>> I need to print to a file a simple list of all the databases on my
>> postgresql.
>>
>> I need to do this from a shell script to be executed without human
>> intervention
On 14/10/2008, at 20.23, Daniel Verite wrote:
What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default
postgresql.conf has:
ssl=true
and since drupal doesn't allow connecting to pgsql with unix socket
paths [1], what you get by default is probably TCP + SSL encryption.
A crude tes
On Tue, Oct 14, 2008 at 12:39 PM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> On 14/10/2008, at 20.23, Daniel Verite wrote:
>>
>> What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default
>> postgresql.conf has:
>> ssl=true
>> and since drupal doesn't allow connecting to pgsql with unix soc
On Tue, Oct 14, 2008 at 08:23:47PM +0200, Daniel Verite wrote:
> [1] A patch has been posted here: http://drupal.org/node/26836 , but it
> seems to have gotten nowhere. The comments about pg_connect() are
> depressingly lame, apparently nobody had a clue how unix socket files
> should be specifi
On Tue, 14 Oct 2008 06:56:02 -0600
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> >> This is a useful question, but there are reasonable answers to
> >> it. The key underlying principle is that it's impossible to
> >> know what will work well in a given situation until that
> >> situation is tested.
Mikkel Høgh wrote:
> On 14/10/2008, at 20.23, Daniel Verite wrote:
>> What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default
>> postgresql.conf has:
>> ssl=true
>> and since drupal doesn't allow connecting to pgsql with unix socket
>> paths [1], what you get by default is probably TCP
postgres Emanuel CALVO FRANCO wrote:
inside psql turn \o file
then \l
I need to print to a file a simple list of all the databases on my
postgresql.
I need to do this from a shell script to be executed without human
intervention...
...
but I don't know exactly to what extent I can format
On Tue, 14 Oct 2008, Ivan Sergio Borgonovo wrote:
The fact that out of the box on common hardware PostgreSQL under-perform
MySQL with default config would matter if few paragraph below you
wouldn't say that integrity has a *big* performance cost even on
read-only operation.
If you want a mor
On Oct 14, 2008, at 11:36 AM, Bill Thoen wrote:
The table exists already; all I need to do is update the sequence
code to make the records unique, but also I need each repeating set
numbered from 0 (Zero) so I can select a list of unique farm field
records where seq = 0.
"select distinct
Hi guys,
Ugh, why is it so hard to let go of this topic ;)
I want to tell you why I find stored procedures useful and summarise my
understanding on how they differ from functions. I hope this user
perspective would be helpful to a future Postgres implementation.
So what is my use of stored pr
"Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
>> ERROR: invalid input syntax for type date: "infinity"
>> I thought I could use it anywhere in my sql.
No, only timestamps support infinity.
We do have a TODO item to allow type date to do that too. It's been asked
for often enough, not s
On 14/10/2008, at 16.05, Martin Gainty wrote:
> The benchmark is a mostly read-only Drupal site -- a few admins,
but a
> lot of readers. Drupal as a benchmark is skewed towards lots and
lots
> of small, simple queries, which MyISAM excels at. The long term fix
> ought to be to help the Drupal
I would probably do that in plpgsql, as a cursor
I installed the 8.3 postgres
the amount of giving the command:
bash-3.2$ /usr/local/postgres_8.3/bin/initdb -D /base/data
the result is:
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initial
On Tue, Oct 14, 2008 at 3:45 PM, Vladimir Dzhuvinov <[EMAIL PROTECTED]> wrote:
>
> I want to tell you why I find stored procedures useful and summarise my
> understanding on how they differ from functions. I hope this user
> perspective would be helpful to a future Postgres implementation.
>
>
> So
Greg Smith wrote:
On Tue, 14 Oct 2008, Mikkel H�gh wrote:
You are targetting DBAs using servers with less than 512 MB RAM. Is
PostgreSQL supposed to be used by professional DBAs on enterprise
systems or is it supposed to run out of the box on my old Pentium 3?
you'll discover that the Linux
oh, sorry - you want something else. blah.
After disabling SSL for localhost, I ran the tests again, and the
performance gap is reduced to about 30%.
--
Kind regards,
Mikkel Høgh <[EMAIL PROTECTED]>
On 14/10/2008, at 21.17, Magnus Hagander wrote:
Mikkel Høgh wrote:
On 14/10/2008, at 20.23, Daniel Verite wrote:
What I've noticed on
On Tue, Oct 14, 2008 at 5:04 PM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> After disabling SSL for localhost, I ran the tests again, and the
> performance gap is reduced to about 30%.
ok, now consider you are on a read only load, with lots (if I read the
thread correctly) repetitive queries. mysql
On Mon, Oct 13, 2008 at 04:29:45PM +, Matthew Wilson wrote:
> I track employee qualifications in one table and I track job
> requirements in another table. A job requires zero-to-many
> qualifications, and for an employee to be qualified for that job, the
> employee must have ALL the requireme
On Tue, Oct 14, 2008 at 5:07 PM, justin <[EMAIL PROTECTED]> wrote:
> because a credit account is a liability account aka a negative account so
> credit a credit account causes it to go UP not down.
As you say, "a negative account". Our liability accounts go further
down when credited. I work with
Steve Atkins wrote:
On Oct 14, 2008, at 9:04 AM, Bill Thoen wrote:
I've got a table with repeated records that I want to make unique by
adding a sequence code of 0,1,2,...,n for each set of repeated
records. Basically, I want to turn:
field_id | seq
--+-
1 | 0
2 |
On Tue, 14 Oct 2008 16:51:29 -0400
"Merlin Moncure" <[EMAIL PROTECTED]> wrote:
> Functions are limited in the sense that it is awkward to return
> multiple sets, but are much more flexible how they can be
> integrated into queries -- you can call a function anywhere a
> scalar or a set is allowed
On Tue, 14 Oct 2008 06:42:33 -0700
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Mikkel Høgh wrote:
> > On 14/10/2008, at 11.40, Ivan Sergio Borgonovo wrote:
>
> > That might be true, if the only demographic you are looking for
> > are professional DBAs, but if you're looking to attract more
> >
On Tue, Oct 14, 2008 at 3:40 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> On Mon, 13 Oct 2008 20:45:39 -0600
> "Joshua Tolley" <[EMAIL PROTECTED]> wrote:
>
> Premise:
> I'm not sustaining that the "default" answers are wrong, but they are
> inadequate.
> BTW the OP made a direct compariso
On 14/10/2008, at 23.22, Merlin Moncure wrote:
On Tue, Oct 14, 2008 at 5:04 PM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
After disabling SSL for localhost, I ran the tests again, and the
performance gap is reduced to about 30%.
ok, now consider you are on a read only load, with lots (if I read
forwarding here too cos I just got the copy sent to my personal
address and just much later the one from pg list... + adding some
more siege run.
On Tue, 14 Oct 2008 19:05:42 +0200
Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> Hmm, those are interesting numbers. Did you use a real, logged
> in, drupal
Grzegorz Jas'kiewicz wrote:
alter table foo add newid sequencial;
alter table foo drop field_id;
alter table foo rename newid to field_id;
I can't do that; I need to preserve the field_id values.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
because a credit account is a liability account aka a negative account
so credit a credit account causes it to go UP not down. Look a your
bank statement it says Credit you $500 when you make a deposit its a
debit to you a credit to the bank in a credit account as its a liability
to the bank.
On Tue, Oct 14, 2008 at 1:18 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
>>> ERROR: invalid input syntax for type date: "infinity"
>>> I thought I could use it anywhere in my sql.
>
> No, only timestamps support infinity.
>
> We do have a TODO i
In article <[EMAIL PROTECTED]>,
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am Tue, dem 14.10.2008, um 8:33:21 +0200 mailte Luca Ferrari folgendes:
>> Hi all,
>> I've got a query with a long (>50) list of ORs, like the following:
>>
>> SELECT colB, colC FROM table WHERE colA=X OR colA=Y OR co
On Tue, 14 Oct 2008, Kevin Murphy wrote:
One thing that might help people swallow the off-putting default "toy
mode" performance of PostgreSQL would be an explanation of why
PostgreSQL uses its shared memory architecture in the first place.
I doubt popularizing the boring technical details be
On Tue, Oct 14, 2008 at 10:05 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> MG>comments prefixed with MG>
> MG>What about INNODB is Drupal forgetting the default engine for 5.x?
I don't use MySQL for drupal myself except for testing, but Drupal
just uses the default storage engine for MySQL, whi
Note this comment:
/*
* Queries sent to Drupal should wrap all table names in curly brackets. This
* function searches for this syntax and adds Drupal's table prefix to all
* tables, allowing Drupal to coexist with other systems in the same database if
* necessary.
*/
That's an MySQL-ism for
Fernando Moreno wrote:
> Thanks for the answers, I wasn't aware of the conflict between md5-auth and
> db_user_namespace, but it seems highly related to my problem.
>
> Could you suggest me another way to handle this? Managing users in the usual
> way is likely to work fine most of the time, but n
On Tue, Oct 14, 2008 at 4:35 PM, Chris <[EMAIL PROTECTED]> wrote:
>
>> Note this comment:
>> /*
>> * Queries sent to Drupal should wrap all table names in curly brackets.
>> This
>> * function searches for this syntax and adds Drupal's table prefix to all
>> * tables, allowing Drupal to coexist
Are you saying you have to reconnect to change schemas? In Oracle and
PostgreSQL both you can change the current schema (or schemas for
postgresql) with a single inline command.
No I meant you have to change the schema after connecting.
Some hosts only give you one db & one user. Yeh it suck
On Mon, Oct 13, 2008 at 3:44 AM, Laurent Wandrebeck
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> According to the documentation (
> http://www.postgresql.org/docs/8.3/interactive/sql-createtrigger.html
> ), the feaure "SQL allows triggers to fire on updates to specific
> columns (e.g., AFTER UPDATE OF col1
On Tue, Oct 14, 2008 at 6:15 PM, Chris <[EMAIL PROTECTED]> wrote:
>
>> Are you saying you have to reconnect to change schemas? In Oracle and
>> PostgreSQL both you can change the current schema (or schemas for
>> postgresql) with a single inline command.
>
> No I meant you have to change the schem
On Fri, Oct 10, 2008 at 3:38 AM, gorsa <[EMAIL PROTECTED]> wrote:
> hi all
> is there a way to get a unique identifier for a client? something like
> a machine id. session_user does not seem to work since a user can log
> on to many workstations. been through the list so i'm not searching
> for get
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> Since you can check which columns have changed, it's pretty easy to
> write a trigger that just skips its logic when none of the trigger
> columns have changed.
... which is pretty much the same thing a built-in implementation would
have to do, too. S
Martin Gainty <[EMAIL PROTECTED]> writes:
> MG>comments prefixed with MG>
Incidentally that's a good way to make sure people don't see your comments.
There are a few variations but the common denominator is that things prefixed
with "foo>" are quotations from earlier messages. Many mailers hide
Greg Smith <[EMAIL PROTECTED]> writes:
> DB2 has automatically updated the "shmmax" kernel
> parameter from "33554432" to the recommended value "268435456".
This seems like a bogus thing for an application to do though. The Redhat
people seem happy with the idea but I'm pretty sure
Gregory Stark <[EMAIL PROTECTED]> writes:
> Greg Smith <[EMAIL PROTECTED]> writes:
>> DB2 has automatically updated the "shmmax" kernel
>> parameter from "33554432" to the recommended value "268435456".
> This seems like a bogus thing for an application to do though. The Redhat
> people seem happy
Bill Thoen wrote:
Steve Atkins wrote:
On Oct 14, 2008, at 9:04 AM, Bill Thoen wrote:
I've got a table with repeated records that I want to make unique by
adding a sequence code of 0,1,2,...,n for each set of repeated
records. Basically, I want to turn:
field_id | seq
--+-
On Tue, Oct 14, 2008 at 6:47 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> Since you can check which columns have changed, it's pretty easy to
>> write a trigger that just skips its logic when none of the trigger
>> columns have changed.
>
> ... which is p
hi! unfortunately the unique identifier must not change from
connection to connection, so that there can be a meaningful review of
the usage table. is there a similar problem that you've encountered in
the past that has this requirement?
--
Sent via pgsql-general mailing list (pgsql-general@postg
On Wed, 15 Oct 2008, Gregory Stark wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
DB2 has automatically updated the "shmmax" kernel
parameter from "33554432" to the recommended value "268435456".
This seems like a bogus thing for an application to do though.
It happens when y
Well, it could make some sense to extend the semantics when you have
explicit "REFERENCES" to tables in the JOINs.Or at least warn or notice the
user that the "NATURAL (INNER) JOIN" has actuallt been converted into a
CROSS one.
It would not be standard but helpful for developers.
Thanks.
2008/10/
75 matches
Mail list logo
