On Tue, Nov 11, 2003 at 04:03:44PM -0800, Rich Shepard wrote:
> On Tue, 11 Nov 2003, Adam Haberlach wrote:
>
> > On that note, does anyone have suggestions for which version of the
> > server I should run? I see that there are seperate binary RPMS for
> > diffe
and contributing
one, or is this not necessary?
--
Adam Haberlach | "We spent the 90's all trying to figure out
[EMAIL PROTECTED] | how to get email and the 00's trying to
http://mediariffic.com | figure out how to not get email."
|
init__
self.handle()
File "./zipcode.py", line 197, in handle
messages = self.selected_folder.fetch_by_uids(begin, end)
File "./datastore.py", line 18, in fetch_by_uids
res = self.db.query(q)
_pg.error: pqReadData() -- read() failed: errno=2
No such file or directory
at PostgreSQL could
emit a URL like this when it fails for what I would expect to be a common
reason for those of us that are used to out-of-the-box Linux installs
and are becoming more and more frustrated with Sun's silly defaults?
--
Adam Haberlach|
[EMAIL PROTECTED] | http
pent an
afternoon dealing with the breakage (we had some greater-then-8k tuples
that I had to sort out).
Other options, as people have mentioned, would be ODBC, but we found
that this worked better. And that FileMaker sucks.
--
Adam Haberlach|
[EMAIL PROTECTED] | http:/
as I should, but
as of the first betas of 7.1, it would corrupt your database horribly
if you ran out of space.
I think this has been fixed, but you might wanna check with hackers or
release nots.
--
Adam Haberlach|
[EMAIL PROTECTED] | http://youlook.org
http://www.ne
lly=> grant insert on foo to group posthackers;
CHANGE
jolly=>
/***/
--
Adam Haberlach|
[EMAIL PROTECTED] | http://youlook.org
http://www.newsnipple.com |
'88 EX500'00 >^< |
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Anyone know the max username/password length for Postgres?
--
Adam Haberlach|
[EMAIL PROTECTED] | http://youlook.org
http://www.newsnipple.com |
'88 EX500'00 >^< |
---(end of broadcast)---
On Sat, Feb 24, 2001 at 11:16:49AM +, Richard Huxton wrote:
> Adam Haberlach wrote:
> >
> > One of the rocket scientests working on this project has
> > created a system in which /either/ a description or a build
> > number is stored in a text field.
On Thu, Feb 01, 2001 at 07:59:16PM -0500, wrote:
> I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
> be the problem?
Your database is too purple.
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, pass
Perl.
Well, they are both turing complete and extensible enough to be able
to execute arbitrary functions via plug-ins. I studied computer engineering
and not computer science, but I'm pretty sure this makes them functionally
equivalent, so you are both right.
--
Adam Haberlach
On Wed, Jan 31, 2001 at 11:27:18PM +, Oliver Elphick wrote:
> Adam Haberlach wrote:
> >I'm trying to back up a database, including the user records. If
> >I use pg_dump, I can get the table, but I cannot seem to be the user
> >information.
>
the interpreter
engine upon which PHP is based, and it seems pretty well done. If anything,
it might be interesting to adopt some of the ideas of PHP and create our
own language or sub-PHP. I am, however, in no way volunteering for such
a project.
--
Adam Haberlach|A cat
wrong?)
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.
KE '%marley';
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.
p dbs
with lobjs, or should I write my own dang script?
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500
On Wed, Jan 17, 2001 at 01:03:05PM +0100, Mirko Zeibig wrote:
> On Tue, Jan 16, 2001 at 12:22:28PM -0800, Adam Haberlach wrote:
> > On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote:
> > > On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote:
> > &g
On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote:
> On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote:
> > I've got the following procedure...
> >
> > DROP FUNCTION "blank_referring_devices" ();
> > CREATE FUNCTION &quo
that
those unlinks never happened.
Is there any simple way for me to get a list of all large objects
in a database, so I can see if there are actually rows referring to them
and delete the ones that were not unlinked earlier?
--
Adam Haberlach|A cat spends her life conflicted betwee
ssword ." )";
echo $data->client_id.">";
}
You can blame the PHP people for having wildly dissimilar systems
for iterating through result sets...
> In mysql there was no need to count rows.
Let's not start the MySQL vs. Postgre
;t seem to work.
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.
; >
> >---
> >Now, I want to join table a of database a and table a of database b.
> >How?
> According to my knowledge this cant yet be achieved in postgresql..
> I sincerly hope i am wrong..
I'm pretty sure you are right. If your data is related enough
On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote:
> Somebody knows how to get a sql "schema" of a Postgresql database??
pg_dump -s -d
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profou
in 7.1. Beta Real Soon Now.
Out of curiosity, what is the advantage, other then simplification
of the query itself, of using a view over a straight select?
--
Adam Haberlach |A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and
t hard to migrate to a
different database system should you need to do that for some reason...
--
Adam Haberlach|ASCII /~\
[EMAIL PROTECTED] | Ribbon \ / Against
http://www.newsnipple.com | CampaignX HTML
'88 EX500 |/ \ E-mail
this whinging about "corperate direction" is really meaningless
unless you are prepared to jump ship or split off in a clone of the
original one. The code is what you do with it. We are all lucky that
it is as good and useful as it is right now.
--
Adam Haberlach| A bil
lps
avoid a few problems: Red Hat may suddenly upgrade to a newly incompatible
version, or may just change a configuration.
At a guess, I would say that you are probably missing an .rpm for the
postgres-client or pgsql-client, but that is based on my view dealings with
Red Hat.
--
Adam Haberl
We have had some problems with tar silently truncated some > 2Gb files
during a backup. We also had to move the perforce server from Linux to
BSD because some checkpoint files were truncating at 2Gb (not a perforce
problem, but a Linux one).
Be careful, test frequently, etc...
--
Adam
converted much of his stuff to use Postgres,
but there are some semi-remote machines using MySQL. With PHP, even though
there is almost no consistency between database interfaces, it isn't too
hard to use both systems.
I still reccommend going with one database solution, though. Muc
t during
backdate inserts or with later updates...
--
Adam Haberlach| A billion hours ago, human life appeared on
[EMAIL PROTECTED] | earth. A billion minutes ago, Christianity
http://www.newsnipple.com | emerged. A billion Coca-Colas ago was
'88 EX500 | yesterday morning. -1996 Coca-Cola Ann. Rpt.
Sometime in the past year, someone mentioned a database that
contained zipcode, lat/long, and city information--does anyone else
remember this, or should I check into a drug clinic?
I'm pretty much looking for a way to correlate zip, city,
and/or geographic locations.
--
lem is (I'm not a web
hacker, I just play one for QA database purposes), but it would
be nice, for image purposes, if the page rendered correctly on
at least Opera 4.0 if not NetPositive 2.0
--
Adam Haberlach |"Your stdio isn't very std.
[EMAIL PROTECTED]| Your
On Fri, Jun 25, 1999 at 05:01:29PM +0100, Mario Jorge Nunes Filipe wrote:
> Thomas Reinke wrote:
> >
> > You have already started a transaction and haven't yet
> > finished it.
> >
> > E.g.
> >
> > psql template;
> > BEGIN;
> > BEGIN;
>
> Not that i don't believe you but i think that in
I am going to be working with a database with a lot of rather
large text fields in it. To do some profiling, I have hacked up an
IRC bot to submit messages into a database. I cannot seem to get any
of my queries to use the indexes I create on the msg field--is there
something specific I
Has anyone out there done any work getting data from
a FileMaker database into postgres? I have about 16000 fairly
large records that I need to move from a crufty MacOS machine
to a Linux box. I also have Filemaker for NT handy, as well
as Lasso. At least four of the fields in the datab
On Sat, Jan 30, 1999 at 09:08:14PM -0800, Felix Morley Finch wrote:
> Q 1: Does anyone have experience with Postgres in a threaded program?
I have done a bit of this under BeOS (where each window gets
its own event loop and thread). My first program turned out to have
problems in my ini
36 matches
Mail list logo
