6.1, built from source.
On Mon, Nov 14, 2016 at 2:51 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Oleg Bartunov <obartu...@gmail.com> writes:
>> On Sun, Nov 13, 2016 at 6:05 PM, Aaron Lewis <the.warl0ck.1...@gmail.com>
>>> It takes 500ms with 10m rows, could it be
:33 PM, Julien Rouhaud
<julien.rouh...@dalibo.com> wrote:
> On 13/11/2016 15:26, Aaron Lewis wrote:
>> Hi Oleg,
>>
>> Can you elaborate on the title column? I don't get it.
>>
>
>>>> create table mytable(hash char(40), title varchar(500));
>>>&g
Hi Oleg,
Can you elaborate on the title column? I don't get it.
On Sun, Nov 13, 2016 at 10:10 PM, Oleg Bartunov <obartu...@gmail.com> wrote:
>
>
> On Sun, Nov 13, 2016 at 2:50 PM, Aaron Lewis <the.warl0ck.1...@gmail.com>
> wrote:
>>
>> I have a simple table,
ime: 1755.944 ms
On Sun, Nov 13, 2016 at 10:04 PM, Oleg Bartunov <obartu...@gmail.com> wrote:
>
>
> On Sun, Nov 13, 2016 at 2:54 PM, Aaron Lewis <the.warl0ck.1...@gmail.com>
> wrote:
>>
>> I have a simple table with Trigram index,
>>
>> create table
up?
--
Best Regards,
Aaron Lewis - PGP: 0x13714D33 - http://pgp.mit.edu/
Finger Print: 9F67 391B B770 8FF6 99DC D92D 87F6 2602 1371 4D33
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ery)
Rows Removed by Filter: 10221
Planning time: 0.176 ms
Execution time: 75.564 ms
(6 rows)
Any ideas?
--
Best Regards,
Aaron Lewis - PGP: 0x13714D33 - http://pgp.mit.edu/
Finger Print: 9F67 391B B770 8FF6 99DC D92D 87F6 2602 1371 4D33
--
Sent via pgsql-general mailing list (pg
On Sun, Feb 28, 2016 at 1:15 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver <adrian.kla...@aklaver.com
> > wrote:
>
>> On 02/27/2016 09:19 PM, Aaron Christensen wrote:
>>
>>> There is somewhat
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 02/27/2016 09:19 PM, Aaron Christensen wrote:
>
>> There is somewhat a method to this madness :). There isn't a formula
>> that determines outcome. They will just be arbitrary
02/27/2016 03:12 PM, Aaron Christensen wrote:
>
>> Hi Adrian,
>>
>> Thank you for responding with the SQL code. However, outcome cannot be
>> a primary key because outcome values will be duplicates in some
>> instances. I am not sure how else to have a lookup t
Hi Adrian,
Thank you for responding with the SQL code. However, outcome cannot be a
primary key because outcome values will be duplicates in some instances. I
am not sure how else to have a lookup table that stores static values.
Thanks!
Aaron
On Sat, Feb 27, 2016 at 5:15 PM, Adrian Klaver
ecause table Final
is supposed to serve as a lookup or reference table (I am not sure of the
correct terminology).
Please advise if I am on the right track or if I should follow a different
design. I intend to have a few other lookup/reference tables that will
serve a similar purpose.
Thank yo
?
Thanking you in advance,
Aaron
dunnhumby limited is a limited company registered in England and Wales with
registered number 02388853 and VAT registered number 927 5871 83. Our
registered office is at Aurora House, 71-75 Uxbridge Road, London W5 5SL. The
contents of this message and any
function?
I hope that¹s clear.
Thanking you in advance for any help.
Aaron
The contents of this message and any attachments to it are confidential and may
be legally privileged.
If you have received this message in error you should delete it from your
system immediately and advise the sender
No particular effort; I saw a talk on the topic. I said it's academic
because I can't think of any real world example where this would matter
(the other definition of the word academic).
On Thu, Sep 19, 2013 at 12:44 AM, Kevin Grittner kgri...@ymail.com wrote:
Aaron Carlisle aaron.carli
The documentation states that concurrent execution of a set of
Serializable transactions is guaranteed to produce the same effect as
running them one at a time in some order.
I'm not sure how the following behavior fits that definition. (Note that
this is just an experiment, not a use case.
subscription:
http://www.postgresql.org/**mailpref/pgsql-generalhttp://www.postgresql.org/mailpref/pgsql-general
--
**
Aaron Abreu, Systems Consultant
Bay District Schools, Panama City, FL
Office: * (850) 767-4288
*FOCUS Student system support
IRIS phone alert system support
abre...@bay.k12.fl.us
Greetings,
I run a handful of queries overnight when traffic is at it's lowest on our
system. One particular query will run perfectly fine (around 5 seconds)
for several weeks, then suddenly decide to hang indefinitely and never
finish. It needs to be killed manually after several hours (I've
Thanks Steve,
Answers are inserted below:
On 5/18/12 11:09 AM, Steve Crawford scrawf...@pinpointresearch.com
wrote:
On 05/18/2012 09:17 AM, Aaron Burnett wrote:
Greetings,
I run a handful of queries overnight when traffic is at it's lowest on
our
system. One particular query will run
',
'aes-cbc');
decrypt_iv
--
\x48656c6c6f205468657265
(1 row)
Thanking you in advance,
Aaron
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks, Tom. That was exactly it.
Best Regards
On 4/10/12 2:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Aaron Burnett aburn...@bzzagent.com writes:
9.1.3 is just not decrypting nor throwing errors.
9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode
Using the security definer
Think if is like sudo for a db.
Aaron Thul
http://www.chasingnuts.com
On Wed, Apr 4, 2012 at 8:39 AM, leaf_yxj leaf_...@163.com wrote:
Hi Guys. I got one problem. I need to give some of the non-super users( kind
of dba) to get the privileges
to can cancel other
Some more current numbers can be found here:
http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide
Aaron Thul
http://www.chasingnuts.com
On Tue, Sep 14, 2010 at 4:00 AM, A B gentosa...@gmail.com wrote:
Hello.
Is there any doc or wiki page that describes what filesystems
Greetings,
I hope this is the proper list for this, but I am a loss on how to achieve
one particular set of results.
I have a table which is a list of users who entered a contest. They can
enter as many times as they want, but only 5 will count. So some users have
one entry, some have as many
interface to the open source jena technology, which fails to
scale to larger data sets as it tries to read huge chunks of data into
memory.
We would prefer to go with an open source option, but can't. Do you
know of a software package that can efficiently connect RDF to
PostgreSQL?
Aaron Thul
http
Ubuntu never shipped with selinux, it is available by installing the
selinux meta-package. Ubuntu does ship with AppArmor and loaded by
default in Hardy 8.04 and beyond but I don't believe there are any
PotgreSQL profiles.
Aaron Thul
http://www.chasingnuts.com
On Fri, Jan 15, 2010 at 10:51
this is how I do it if this helps:
column_name timestamp without time zone NOT NULL DEFAULT
('now'::text)::timestamp(6) without time zone
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of Thom Brown
Sent: Sun 11/22/2009 2:50 PM
To: PGSQL Mailing List
Subject:
Depending on the details, I'd love to attend. Any more specifics, by chance?
On 7/11/09, Richard Broersma richard.broer...@gmail.com wrote:
Josh Berkus and David Fetter will be in West Los Angeles area the
beginning of next week. This would be a good opportunity to get
together to enjoy
profile_images_fulltext');
count
241071
(1 row)
CREATE INDEX profile_images_fulltext_gin ON profile_images_fulltext
USING gin(content);
CREATE INDEX profile_images_fulltext_gist ON profile_images_fulltext
USING gist(content);
Any and all thoughts would be greatly appreciated,
Aaron Thul
http
Tom,
Our maintenance_work_mem is 1024MB so there should have been plenty of
memory for INDEX creation. I happened to be watching top when we
created the GiN INDEX and the process used about 500MB of non-shared
memory.
Aaron Thul
http://www.chasingnuts.com
On Wed, Jun 17, 2009 at 11:30 AM
to accomplish this? I read through the text search
sections of the documentation and this website:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html
Is there an easier way?
Thanks in advance.
--
Aaron Patterson
http://tenderlovemaking.com/
--
Sent via pgsql-general
-- if
there is one?
apologies for the admittedly amateur questions but I haven't been able
to find much for the situation I'm in.
thanks,
aaron
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Greetings,
I've gotten myself in a pickle and had a postgresql (8.2) instance
fill its disk completely and shutdown itself down. I've moved the
entire data directory to a new, larger slice however postmaster never
finishes starting. Despite configuring postgresql.conf for excessive
'verboseness'
anyone like to suggest other options?
Has anyone had any problems with those vendors? Anyone like to share a
glowing review or success story?
Aaron Thul
http://www.chasingnuts.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
:
BEGIN;
drop table table_foo CASCADE;
DROP TABLE
ROLLBACK;
Am I overlooking a step to actually seeing the dependant objects?
Thanking you in advance,
Aaron
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Thanks Tom,
It was not supressed for notice, so I changed it to 'debug1' and it gave me
the answers I was looking for.
On 2/22/09 6:07 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Aaron Burnett aburn...@bzzagent.com writes:
Hopefully a quick answer. Went to drop a table:
drop table table_foo
Hi,
I think I am experiencing the forest through the trees type of scenario
here.
In a nightly cron I have a shell script that executes a couple of things for
our data warehouse.
I call it like this from the cron:
/home/postgres/DB1/sys/createDB1.sh /home/postgres/DB1/logs/createDB1.log
21
I too have used a symlink for some time (years) to put temp onto
dedicated disks without any problems. I am not sure if 8.3 is
different but I symlink the directory: base/pgsql_tmp
Aaron Thul
http://www.chasingnuts.com
On Fri, Oct 31, 2008 at 8:11 AM, Sam Mason [EMAIL PROTECTED] wrote
You may want to look at this article for some ideas:
http://www.varlena.com/GeneralBits/110.php
The article talks about doing dynamic schema design for online
surveys... it's pretty interesting.
Aaron Thul
http://www.chasingnuts.com
On Wed, Oct 22, 2008 at 10:59 AM, Thom Brown [EMAIL PROTECTED
Message-
From: Greg Smith [mailto:[EMAIL PROTECTED]
Sent: Sat 9/6/2008 4:45 AM
To: Tom Lane
Cc: Aaron Burnett; Sam Mason; pgsql-general@postgresql.org
Subject: Re: [GENERAL] large inserts and fsync
On Fri, 5 Sep 2008, Tom Lane wrote:
The trouble with turning fsync off is that a system crash
, then restart fsync once the insert
is complete.
Am I opening myself up to any dangers that aren¹t obvious by doing this? Any
advice to the contrary? And of course, if I am out of my mind for doing
this, please let me know.
Thanks in advance
Aaron
Yes, the developer already made sure of that and I verified.
On 9/5/08 11:10 AM, Sam Mason [EMAIL PROTECTED] wrote:
On Fri, Sep 05, 2008 at 09:16:41AM -0400, Aaron Burnett wrote:
For an upcoming release there is a 16 million row insert that on our test
cluster takes about 2.5 hours
Thank you.
I was making it way too over-complicated.
Works perfectly
On 9/1/08 3:39 AM, hubert depesz lubaczewski [EMAIL PROTECTED] wrote:
On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote:
table1 has 25 columns
table2 is a subset of table1 (create table2 as select
id,field1
Hi,
I¹m hoping someone can help me out on this one.
Two tables
table1 has 25 columns
table2 is a subset of table1 (create table2 as select
id,field1,field2,field3,field4,field5,field6 from table1) with just 7
columns
There is a primary key on ID
table2 was exported to a CSV, truncated, then
On Thu, Apr 17, 2008 at 11:29 AM, Joshua D. Drake [EMAIL PROTECTED] wrote:
Hello,
I am currently chilling at MySQLCon. If any other Elephant riders who
are doing a little Dolphin hunting are about... I am in Ballroom E
about to give a talk on what Mysql can learn from PostgreSQL.
is there
On Jan 29, 2008 6:30 PM, Chander Ganesan [EMAIL PROTECTED] wrote:
Is it possible to point two servers running PGPool at the same two
database servers? If so, I seem to recall reading about being able to
use some kind of virtual IP address to split the traffic to both.
CARP...I've never
Note: The meat and potatoes of my request is in the What I would like
section. Everything else is just explanation.
Currently my company is using software that really isn't meeting our needs.
We have tried to get the 3rd party to allow us to help with their source,
but they won't allow us to
/pgsql-hackers-win32/2004-12/msg00039.php
--
==
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==
beautifier? I wasn't able to find a
reference to this feature in the documentation.
Thanks,
--
Aaron Bingham
Senior Software Engineer
Cenix BioScience GmbH
I'm curious if anyone on the list has any hands on performance
experience with running PostgreSQL on 3PAR appliances (big and small).
If you do, please contact me offlist - I'll be happy to summarize for
the list archives.
Thanks,
Aaron
---(end of broadcast
On 7/26/06, aurora [EMAIL PROTECTED] wrote:
From your experience do you expect the database would run into this from
time to time that requires DBA's interventions? Is so it would become a
problem for our customers because our product is a standalone system. We
don't intend to expose the
sorry to nitpick, but I think that to get this query to do exactly
what you want you'll need to add ordering over EventTime on your sub-
selects to assure that you get the next event and not just some event
later event on the given day.
-ae
On Jun 20, 2006, at 11:12 AM, Gurjeet Singh
CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable
Que? Si!On 6/20/06, Worky Workerson [EMAIL PROTECTED] wrote:
On 6/20/06, Aaron Koning [EMAIL PROTECTED] wrote: google pg_dumpReally?What command do you use?I've tried the following:pg_dump -t
copyable, importable... into Excel or another postgres db?On 6/20/06, Martijn van Oosterhout kleptog@svana.org
wrote:On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote: CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname DROP TABLE sometable Que? Si!Eh
David Fetter wrote:
On Fri, Jun 09, 2006 at 03:55:04PM +0200, Aaron Bingham wrote:
[EMAIL PROTECTED] wrote:
I'm reading, and enjoying immensely, Fabial Pascal's book Practical Issues in
Database Management.
If you're interested in the theory of RDBMSs, you can start
Aaron Bingham wrote:
David Fetter wrote:
In SQL, you can do this (this example condensed from Libkin's
Expressive Power of SQL on the page above):
SELECT
(SELECT count(*) FROM table_1)
(SELECT count(*) FROM table_2)
AS Can't compare cardinalities in first order logic;
Note
to avoid them, and sometimes you can't). One feature of RM PostgreSQL
lacks are nested relations (a bad idea for base table design but useful
in query results).
Regards,
--
Aaron Bingham
Senior Software Engineer
Cenix BioScience
try:
select tax_code from warehouse.sec_trans group by tax_code
there was a discussion about this on the pgsql-performance a while back:
http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php
-ae
On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote:
select DISTINCT tax_code from
insert into replicationentries values(default, slaves.slaveid,
TG_OP, TG_RELNAME , NEW.oid, default);
end loop;
return NULL;
end;$$
language 'plpgsql';
Aaron
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
on' statement. It can also generate graphical representations of your
schema using various tools, including Graphviz.
Regards,
--
Aaron Bingham
Senior Software Engineer
Cenix BioScience GmbH
Tatzberg 47 phone: +49 (351
the execution time to balloon.
Thanks,
--
Aaron Bingham
Senior Software Engineer
Cenix BioScience GmbH
---(end of broadcast
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that even slightly holds definitive resource-type status.
Feel free to reply
I have two large
databases of addresses (street name and number, postal code and
municipality). I need to match the addresses to varify that they actually
do exist. has anyone done this before with pgAdmin?
Sincerely,
Aaron
Griffin
GIS Data Acquisition
Technician
DMTI Spatial Inc
the final
query anyway, so they don't really gain me anything.
Thanks,
Aaron C.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Bruno Wolff III wrote:
On Fri, Jan 27, 2006 at 10:25:00 -0600,
Aaron Colflesh [EMAIL PROTECTED] wrote:
#2 would seem to be the simplest except I'm really not too keen on the
idea of manipulating a table like that on the fly (even though I did
proof of concept it and it seems
BYTEA is the easiest from my point of view. I like being able to treat
my binary data more like any other field (e.g. date, text, etc). Heres
some light reading on the BLOB/BYTEA debate:
http://search.postgresql.org/www.search?cs=utf-8fm=onst=20dt=backq=blob+bytea
AaronOn 1/5/06, Ketema Harris
Are you trying to create a primary key composed of 6 fields? What is
the result you want to achieve with the constraint? If you just want
UNIQUE, NOT NULL values in a field, you can achieve that without
creating a primary key.
AaronOn 1/5/06, Daniel Kunkel [EMAIL PROTECTED] wrote:
HiIt makes
This might be easier to use this SQL:
UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3);
The following might work for Cocoon (never used it):
UPDATE message_table SET status = 'A' WHERE
mid IN (xsp-request:get-parameter name=approved/);
Aaron
On 12/13/05, Daniel Hertz [EMAIL
*Sun backs open-source database PostgreSQL*
This is going to make PostgreSQL a much easier sell to PHB's (at
least, in my experience)
aaron.glenn
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
hi,
i would like to use lo_import() on the client side to insert images
into postgresql version 8.0.1 on a remote server using psql as follows:
psql -h my.db.host.com -U user -c insert into binblob (binary_blob)
values(lo_import('/path/on/client/machine/ks.jpg')) -d mydb
i'm getting the
On 10/24/05, CSN [EMAIL PROTECTED] wrote:
nice comes to mind:
nice pg_dump ...
as mentioned earlier...nice isn't going to do anything for I/O. PITR
(point in time recovery) would be, in my opinion, the best solution to
this problem.
aaron.glenn
---(end of
.
Aaron
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
On 10/4/05, Richmond Dyes [EMAIL PROTECTED] wrote:
From my understanding of the license for Postgresql, there is no
licensing fees as long as you are not selling it yourself for a profit.
Completely incorrect. You can do whatever you like with PostgreSQL;
you just can't sue anyone when things
we were completely sunk until we moved everything over to .Net.
Thanks again!
Aaron
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 10/4/05, Welty, Richard [EMAIL PROTECTED] wrote:
Aaron Glenn wrote:
Completely incorrect. You can do whatever you like with PostgreSQL;
you just can't sue anyone when things go south.
_and_ you need to preserve the copyright notices.
excellent point.
---(end
violations?
Does it seem likely that this would fix the problem? Is there an easier way to
solve the problem?
Thanks in advance
--
Aaron Harsh
[EMAIL PROTECTED]
503-284-7581 x347
---(end of broadcast)---
TIP 4: Have you searched our list archives
Tom Lane [EMAIL PROTECTED] 08/03/05 1:33 PM
Aaron Harsh [EMAIL PROTECTED] writes:
We've just recently started seeing sporadic constraint violations on system
tables. For example:
duplicate key violates unique constraint pg_class_oid_index [for
Statement CREATE TEMPORARY TABLE
Hi,
I hope someone can help me out... I read some research a little while
ago about someone using TSearch2 but searching using phonemes; but I
cannot find that article anymore.
Does anyone remember it can point me to a link of the article?
Thanks in advance.
---(end
!--!
thoughts?
thanks,
aaron
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
i'm having the same problem running pg8.0.1 on redhat enterprise linux
AS 3 (2.4.21-27.0.4.ELsmp).
shutting off my firewall via 'service iptables stop' solves the
problem... what needs to be modified in the iptables to allow remote pg
connections?
Richard Huxton wrote:
Michael Korotun wrote:
,
--
Aaron Bingham
Software Engineer
Cenix BioScience GmbH
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
Kevin Murphy [EMAIL PROTECTED] writes:
On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
create table a (foo varchar);
insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '' || foo || '' as foo
from (select foo from a) as bar
On 4/18/05, Christopher Nelson [EMAIL PROTECTED] wrote:
This isn't a high-priority question.
and if I can latch on to this non-priority question with another in a
similar vain: what sort of RDBMS do huge transactional systems like
Tandy's use? I've read that everything is a database,
On Tue, 8 Feb 2005 14:29:08 -0500, Robert Treat
[EMAIL PROTECTED] wrote:
Slony
Yes.
High Availability
Yes.
If you have other ideas please feel free to chime in, we'd really like to see
an uptick in postgresql attendees.
Will Bruce and Tom be attending this year like they did in 2002?
foo) AS bar;
--
Aaron Bingham
Application Developer
Cenix BioScience GmbH
---(end of broadcast)---
TIP 4: Don't
BY
l.last_comment_timestamp DESC', $forum-tid, 0, 1));
thanks for all the support!
aaron
On Jan 6, 2005, at 10:25 PM, Bruno Wolff III wrote:
On Thu, Jan 06, 2005 at 17:32:30 -0800,
Aaron Steele [EMAIL PROTECTED] wrote:
hi bruno,
turns out that l.last_comment_uid and l.last_comment_name are integer
and char var
/base/1/1259
(See results below)
Am I headed in the right direction? Any chance of recovering some/all of
the data?
Thanks,
Aaron
*
* PostgreSQL File/Block Formatted Dump Utility - Version 1.1
*
* File: /Applications/altona/data
was looking for, though.
Any ideas on what I can try to potentially fix this problem and/or recover
any of this data?
Thanks,
Aaron
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http
Unfortunately, I can't seem to connect to any other database. I only had
one non-system database so I tried that, and that I was thinking there was a
template0, so I tried that as well.
Thanks in advance for any help you can provide!
Aaron
From: Tom Lane [EMAIL PROTECTED]
To: Aaron Mark [EMAIL
hi bruno,
turns out that l.last_comment_uid and l.last_comment_name are integer
and char var respectively. since i'm using 7.4.1 with strict boolean
casting, is there a better alternative to instantiating a different
version of pgsql on my server?
In the php code you showed the following
/WebServer/Documents/dmap/includes/database.pgsql.inc on
line 121.
any ideas?
here's my system:
- drupal v4.5.1
- mac os x server v10.3.5
- postgresql v7.4.2
- php v4.3.6
thanks,
aaron
---(end of broadcast)---
TIP 9: the planner will ignore your desire
hi bruno,
would it be useful to see the IF PLSQL function, or would you recommend
a modification to the database.pgsql.inc file?
On Jan 5, 2005, at 10:52 AM, Bruno Wolff III wrote:
On Wed, Jan 05, 2005 at 10:17:39 -0800,
Aaron Steele [EMAIL PROTECTED] wrote:
hi,
warning: pg_query(): Query
hi steven,
here's another file where the actual SQL query (the one in the error
message) is defined. it's in the forum_get_forums() function. bruno
noticed that the IF (via pl/pgsql) might not like the boolean casting
to 2 since 7.4 is more strict about casting? does this help?
?php
// $Id:
I am attempting to connect to a PostgreSQL database via C# or VB.net
using the Npgsql .Net data provider, but I get the following error when
I attempt to open the connection:
***
An unhandled exception of type 'System.IO.IOException' occurred in
npgsql.dll
Additional information: Unable
Registration is required, and space is limited. The location is
Malvern, PA (suburb of Philadelphia) and it's on Saturday Oct 30. For
more information or to register, see
http://chariotsolutions.com/postgresql.jsp
Thanks,
Aaron
P.S. If you're planning to take the train (from Philly, NYC, etc
On Tue, 19 Oct 2004 16:24:06 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Internet explorer.
That would be your problem right there. IE's handling of FTP sessions
is notoriously quirky. Do yourself a favor and download a shareware
FTP program, or open up a DOS prompt.
Regards,
Google slony
Regards,
aaron.glenn
On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao
[EMAIL PROTECTED] wrote:
Hi,
We would like use Postgresql as our database. For high availability is it
possible to cluster DB in Postgresql. Appreciate if you can let me know how
this can be
What is the PostgreSQL project's official stance/view/comment on this?
aaron.glenn
On Thu, 14 Oct 2004 10:48:26 +0900 (JST), Tatsuo Ishii
[EMAIL PROTECTED] wrote:
Hi all,
We, Software Research Associates, Inc., have started PostgreSQL CE
(PostgreSQL Certificated Engineer), on Oct 1st.
On Aug 1, 2004, at 6:26 PM, Christopher Browne wrote:
Measuring it as binary installs:
- Installing PostgreSQL on Debian requires adding a 9.8MB package.
- Installing MySQL on Debian requires adding several packages adding
up to (+ 8.7 0.2 1.0 0.6), or roughly 10.3MB.
- Installing FireBird2
Thanks, that worked!
Aaron Burghardt
[EMAIL PROTECTED]
On Jun 26, 2004, at 4:01 PM, Keary Suska wrote:
on 6/26/04 11:21 AM, [EMAIL PROTECTED] purportedly said:
I attempted to compile 7.4.3 with enable-thread-safety but it fails
and
says it's not supported. My configure command
Hi,
Can anyone out there point me to an inexpensive web hosting solution
that offers postgres database support???
Thanks
Aaron
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
1 - 100 of 122 matches
Mail list logo