m running PG 9.6.1, built from source.
On Mon, Nov 14, 2016 at 2:51 AM, Tom Lane wrote:
> Oleg Bartunov writes:
>> On Sun, Nov 13, 2016 at 6:05 PM, Aaron Lewis
>>> It takes 500ms with 10m rows, could it be faster?
>
>> sure. Recheck with function call is pretty exp
x27;'::tsquery)
Planning time: 0.144 ms
Execution time: 537.212 ms
(9 rows)
On Sun, Nov 13, 2016 at 10:33 PM, Julien Rouhaud
wrote:
> On 13/11/2016 15:26, Aaron Lewis wrote:
>> Hi Oleg,
>>
>> Can you elaborate on the title column? I don't get it.
>>
>
>&
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 wrote:
>
>
> On Sun, Nov 13, 2016 at 2:50 PM, Aaron Lewis
> wrote:
>>
>> I have a simple table, and a gin index,
>>
>> create table
lanning time: 1.168 ms
Execution time: 1755.944 ms
On Sun, Nov 13, 2016 at 10:04 PM, Oleg Bartunov wrote:
>
>
> On Sun, Nov 13, 2016 at 2:54 PM, Aaron Lewis
> wrote:
>>
>> I have a simple table with Trigram index,
>>
>> create table mytable(hash char(4
ws)
Any ideas to speed things 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
onfig, (title)::text) @@
'''abc'' | ''def'''::tsquery)
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
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 > wrote:
>
>> On 02/27/2016 09:19 PM, Aaron Christensen wrote:
>>
>>> There is somewhat a method to this madness
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver
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 values that I
>> assign.
&g
f goal and size
which will be foreign keyed to table User. How exactly does the user
submit/store his goal/size and be assigned an outcome if the User table is
using FKs for goal/size? It seems backwards to me.
On Feb 27, 2016 7:04 PM, "Adrian Klaver" wrote:
> On 02/27/2016 03:12
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
nal because 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.
Tha
correctly?
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 messa
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 wrote:
> Aaron Carlisle wrote:
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. Pure
al mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
**
Aaron Abreu, Systems Consultant
Bay District Schools, Panama City, FL
Office
Thanks Steve,
Answers are inserted below:
On 5/18/12 11:09 AM, "Steve Crawford"
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
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
int
Thanks, Tom. That was exactly it.
Best Regards
On 4/10/12 2:50 PM, "Tom Lane" wrote:
>Aaron Burnett writes:
>> 9.1.3 is just not decrypting nor throwing errors.
>
>> 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'
rkMRWpnnbjaFoHyLmCD/bg==
(1 row)
9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '',
'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
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 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 users
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 wrote:
> Hello.
>
> Is there any doc or wiki page that describes what filesystems that are
> r
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 as
only 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?"
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
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: [G
Depending on the details, I'd love to attend. Any more specifics, by chance?
On 7/11/09, Richard Broersma 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 dinner and drinks with Postg
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
'SELECT content FROM
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 greatl
ce they are meaningless search terms.
Is there an easy way 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 Pat
ut itself down -- 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-general
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
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" wrote:
> Aaron Burnett writes:
>> Hopefully a quick answer. Went to drop a table:
>
>> drop table t
:
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
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
2
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]>
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 &l
--Original 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
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
>>
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
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
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 th
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
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
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 h
ql.org/pgsql-hackers-win32/2004-12/msg00039.php
--
======
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==
n SQL beautifier? I wasn't able to find a
reference to this feature in the documentation.
Thanks,
--
----
Aaron Bingham
Senior Software Engineer
Cenix BioSc
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
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 Postg
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 wrot
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 sometab
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?
27;kill -9' the postmaster-- +----| Aaron Koning| Information Technologist| Prince George, BC, Canada.
+| http://datashare.gis.unbc.ca/fist/| http://datashare.gis.unbc.ca/gctp-js/
+
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
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 R
of these but you have to be careful
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 Bing
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 war
in
select slaveid from replicationslaves
loop
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)
is causing the execution time to balloon.
Thanks,
--
----
Aaron Bingham
Senior Software Engineer
Cenix BioScience GmbH
---(e
with the 'comment
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
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 o
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
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 a
required me to know what the field names were to generate 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
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 sen
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-8&fm=on&st=20&dt=back&q=blob+bytea
AaronOn 1/5/06, Ketema Harr
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 ();
Aaron
On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]
If you are using a Linux system then you can make a partition of xGB and place PGDATA there. This may work for other OS as well.
Aaron
On 12/5/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
here is a question
say i have a database and all the files(data files) indexes etc must be go
>
> *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 broa
On 10/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Check it out.
>
http://developers.slashdot.org/developers/05/10/05/1344254.shtml?tid=221&tid=218
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
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 cop
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, 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 thin
.
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
> 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
oes it seem reasonable that oid reuse could cause the constraint 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 broadca
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
"pagesrc"
!--!
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:
H
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');
>&
;
"woof"
(2 rows)
Is this a known issue? Has it been fixed?
Thanks,
--
Aaron Bingham
Software Engineer
Cenix BioScience GmbH
---(end of broadcast)---
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, s
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?
nt_price(retail, discount) AS price, tax FROM foo) AS bar;
--
----
Aaron Bingham
Application Developer
Cenix BioScience GmbH
---(end of bro
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:
he ordinary. Can't say that I know what I 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
wing:
# ./pg_filedump data-corrupt/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
.uid AND
n.nid = l.nid AND " . node_access_where_sql() . ' ORDER 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 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 fragme
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?
/**
* @file
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():
l.last_comment_timestamp DESC LIMIT 1 OFFSET 0
in /Library/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)
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 to
ning
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 Ph
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,
a
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 c
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 1
1 - 100 of 128 matches
Mail list logo
