-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> "Permission to use, copy, modify, and distribute this software and its
> documentation for any purpose, WITHOUT FEE, and without a written
> agreement is hereby granted, provided that the above copyright notice
> and this paragraph and the follow
> Well, I have used Perl for a couple of thousand-lines-projects and while
> I can't say it's wonderful, it's usable as far as one is strict (i.e.
> code for strict and warnings), and use implicit things as less as
> possible. If you abstract things the right way it's not the nightmare
Actually,
On Nov 30, 2003, at 21:01, Tom Lane wrote:
The only other idea I can think of is he's editing the wrong
pg_hba.conf
file; we've seen a couple of people make that mistake. (David, the
right pg_hba.conf file is the one in the $PGDATA directory. If you
don't see a postmaster.pid file in the same d
> python that you can't do in PHP?
Python is an immensely powerful language. It is essentially the successor
to both LISP and Smalltalk. It has things like closures (well, not
complete, but pretty close), generators, a huge OO library, easy-to-use
exceptions (i.e. - in comparison to Java), and I
> "Jay" == Jay O'Connor <[EMAIL PROTECTED]> writes:
Jay> Python also reads more obviously, in that it doesn't have a lot of
Jay> 'default context' ($_) and 'scalar context versus array context' and
Jay> cute shortcuts and stuff floating around, which makes it easier to
Jay> read, and more impo
On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
> is ther a way to pass a password to the pg_dump command to avoid being
> prompted for it.
> I want to execute the dump from a perl or shell script and dont want to
> open accees for the user in the pg_hba.conf
Use the ~/.pgpass file. It w
On Mon, Dec 01, 2003 at 05:18:17PM -0700, Jay O'Connor wrote:
> Personally, I would never use Perl for anything over about one hundred
> lines and about one developer if I had any say in the matter. Takeing
> Perl and mixing Presentation (HTML) with Business Logic (embedded
> scripts) wihich s
Here is a link to the sql for smarties book:
http://www.amazon.com/exec/obidos/tg/detail/-/1558603239/102-3995931-726?v=glance
by Joe Celko
Has some cool ways of handling trees in sql
- Original Message -
From: "Chris Travers" <[EMAIL PROTECTED]>
To: "Tony" <[EMAIL PROTECTED]>
Cc:
Hi,
is ther a way to pass a password to the pg_dump command to avoid being
prompted for it.
I want to execute the dump from a perl or shell script and dont want to
open accees for the user in the pg_hba.conf
I tried
PGUSER=userid PGPASSWD=passwd pg_dump -Fc -f dump.db mydb;
Thanks
Alex
---
> >If you need more power IMO Python is the way to go.
> I am not that familiar with pything, not to get off topic here but
what you
>can do in python that you can't do in PHP?
Well if they are both Turing complete, arguably not much :)
It's not the 'what' it's the 'how' I'm equating Perl with
Is there a way to retrieve the name of the server in a query? something akin to
@@SERVERNAME on mssql.
toby
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I am getting this error:
fmgr_info: function 7390843: cache lookup failed
when trying to insert some data into a table using the tsearch2 contrib
module (this is postgresql 7.3). I have the following trigger defined:
BEGIN
NEW.search_vector :=
setweight(to_tsvector(coalesce(NEW.d
Note: I am a php developer and I love it, but...
>In dealing with web applications and frontends to database or
>even just a dynamic web site PHP has every bit the power and ability that
>Java does and the development time is way down.
Uh, how about threads. I know that you don't need them much
I used it first because
1) someone suggested it and I didn't know any better
2) install, setup, maintanance and using it is easier than breathing. You'd
be surprised how much of a difference it makes to a newbie to not have to do
things like vacuum regularly and the ability to change a column typ
This was perfect. I also had to set the DBI_* envs. See test results
below. I then installed and successfully ran my own test.
Thanks to all who replied!
Barb
Test Results:
$ make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')"
At 04:03 PM 12/01/2003 -0500, you wrote:
> and I believe the the OOP features available in PHP 5, will easily
leapfrog over Perl.
As my daddy used to say "twice zero is still a small number" I'm a
pretty big OO fan but when I use Perl I don't bother with the OO
features once I had looked at th
Patch applied. Thanks.
---
Brian Hirt wrote:
> here's a patch that joins on pg_class.oid instead of
> pg_class.relfilenode, also i have renamed the table structure from
> relfilenode to relid.
>
[ Attachment, skipping
Also applied to 7.4.X.
---
Brian Hirt wrote:
> here's a patch that joins on pg_class.oid instead of
> pg_class.relfilenode, also i have renamed the table structure from
> relfilenode to relid.
>
[ Attachment, skipping..
Roderick A. Anderson writes:
> Any pointers as to why (really) I'm getting this error when I try to
> install Pg 7.4 from a SRPM build?
>
> perl(Pg) is needed by postgresql-contrib-7.4-0.2PGDG
As the message says, one package requires the other.
> I only disabled tcl, tkpkg, pltcl, and pyt
On 1 Dec 2003, Greg Stark wrote:
>
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > Again, show me an area where PHP is actually deficient here. Something
> > Perl or Ruby does better that would pertain to a mailing list. Don't just
> > wave your hands around, give us a concrete example o
Any pointers as to why (really) I'm getting this error when I try to
install Pg 7.4 from a SRPM build?
perl(Pg) is needed by postgresql-contrib-7.4-0.2PGDG
I only disabled tcl, tkpkg, pltcl, and python in the SPEC file. I could
not install the contrib stuff but I really want the plperl
Tom Lane wrote:
Greg Stark <[EMAIL PROTECTED]> writes:
I just dropped a column that I wish I hadn't. Is there some simple update i
could do to the pg_* tables that would undrop it?
You could rsync the database back from your live off-site backup, or
rifle through the piles of backups to recover f
Thanks! This is exactly what I wanted to know when I first asked the
question. And it is the only response that seems to make sense. Does
anyone else have experiecne with this?
rg
<
Here's a quick list of my experiences with BLOB's and such.
Performance is just fine, I get
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Again, show me an area where PHP is actually deficient here. Something
> Perl or Ruby does better that would pertain to a mailing list. Don't just
> wave your hands around, give us a concrete example of its short comings.
Error handling. The lack
On Sun, Nov 30, 2003 at 12:19:34AM -0500, Arturo Pérez wrote:
> Does postgreSQL offer anything similar? And please don't
> say use cron. Cron has issues that I'd like to avoid.
Huh, just curious: what issues does cron have?
--
Alvaro Herrera ()
"Saca el libro que tu religión considere como el
Arturo Pérez <[EMAIL PROTECTED]> wrote:
> Oracle has a kind of cron built-in called DBMS_JOB. You can use it
> to run SQL or stored procedures at certain times of day, etc.
>
> Does postgreSQL offer anything similar? And please don't say use
> cron.
Why not?
> Cron has issues that I'd like to
On Mon, Dec 01, 2003 at 04:03:02PM -0500, Ericson Smith wrote:
> PHP has long ago caught up with Perl, and I believe the the OOP features
> available in PHP 5, will easily leapfrog over Perl. Having said that, we
> still code a lot of Perl, simply because of inertia and an existing
> codebase.
On Mon, 1 Dec 2003, Jan Wieck wrote:
> Jason Tesser wrote:
>
> > Quoted as gospel by various people:
> >>> MySQL cannot even handle sub-queries yet.
> >
> >> BTW, is that really still true? I thought they had at least some
> >> support for subqueries by now.
> >
> > yes sub queries in 4.1 whic
On 1 Dec 2003, Randal L. Schwartz wrote:
> > "scott" == scott marlowe <[EMAIL PROTECTED]> writes:
>
> scott> This is simply not true. PHP comes in both a web ready
> scott> embedded version, as well as a CLI version, and is quite
> scott> capable, even of handling things like streams and suc
On Mon, Dec 01, 2003 at 12:42:39PM -0800, Randal L. Schwartz wrote:
> > "scott" == scott marlowe <[EMAIL PROTECTED]> writes:
>
> scott> This is simply not true. PHP comes in both a web ready
> scott> embedded version, as well as a CLI version, and is quite
> scott> capable, even of handling t
Jonathan Bartlett wrote:
> > WAL with ext3's data journaling is quite unnecessary because the WAL
> > sort of IS the database's journal.
>
> I believe you are mistaken. ext3 data journalling only does the
> filesystem. It has no concept of the structure of the database itself.
> WAL is still nec
Christopher Browne wrote:
A long time ago, in a galaxy far, far away, Randolf Richardson <[EMAIL PROTECTED]> wrote:
[sNip]
the difference is that with mysql, nothing pushes the table out of
memory; it always stays in memory. in postgresql, a big query on
another tables, or perhaps a vacuum, or ot
Greg Stark <[EMAIL PROTECTED]> writes:
> I just dropped a column that I wish I hadn't. Is there some simple update i
> could do to the pg_* tables that would undrop it? I haven't done any other
> updates though autovacuum may have run.
Ok, I seem to have done it with this:
update pg_attribute se
The problem here is really on the PHP side, because the docs of PHP don't
tell you how to create a connect string that works for local Postgres
installs (well, the docs exist, but they are hard to find).
For PEAR, it's
$db = DB::connect('pgsql://[EMAIL PROTECTED](/tmp)/DBNAME');
Jon
On Mon, 1 D
"Rick Gigger" <[EMAIL PROTECTED]> writes:
>> This is only a problem for ext2. Ext3, Reiser, XFS, JFS are all fine,
>> though you get better performance from them by mounting them
>> 'writeback'.
>
> What does 'writeback' do exactly?
AFAIK 'writeback' only applies to ext3. The 'data=writeback' s
I just dropped a column that I wish I hadn't. Is there some simple update i
could do to the pg_* tables that would undrop it? I haven't done any other
updates though autovacuum may have run.
Even if I just manage to extract the data then have to restore from a backup
to get an uncorrupted data di
> This is only a problem for ext2. Ext3, Reiser, XFS, JFS are all fine,
> though you get better performance from them by mounting them
> 'writeback'.
What does 'writeback' do exactly?
---(end of broadcast)---
TIP 6: Have you searched our list archi
On Mon, 2003-12-01 at 17:50, B. van Ouwerkerk wrote:
> This is the error I got in my errorlog:
> Unable to connect to PostgreSQL server: could not connect to server:
> Connection refused
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/5432"
On Wed, 19 Nov 2003, Randolf Richardson, DevNet SysOp 29 wrote:
> > An ISP I belong to uses Majordomo for their mailing list system. I'd like
> > to encourage them to move to a system that uses a database, preferably
> > psql which they already run on their server. Anything out there in Php?
>
Hi all-
I'm migrating to postgres from the MS SQL Server land, as I can see
a great potential with postgres, I was wondering if anyone has
experimented or started a project with XML inside user defined
functions?
I've seen the contrib/xml shipped with the distro, as I see it's
usefulness, it's no
> I couldn't without modifying either postgresql.conf or start PostgreSQL
> with --i
There must be something wrong. PHP should be able to connect via
Unix-domain sockets.
I'll be the first to admit that I might have made a mistake. This is on a
box I use for testing only.. so nothing bad will ha
On Tue, 25 Nov 2003, Lamar Owen wrote:
> Hmmm The lines of error in question:
> make[2]: Entering directory `/usr/src/redhat/BUILD/postgresql-7.4/src/port'
> gcc -O2 -march=i386 -mcpu=i686 -Wall -Wmissing-prototypes
> -Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE -c -o path.
On Dec 1, 2003, at 10:15 AM, Graham Leggett wrote:
Hi all,
I am trying to do a query that returns all rows that are _not_ part of
a join, and so far I cannot seem to find a query that doesn't take 30
minutes or more to run.
The basic query is "select * from tableA where tableA_id NOT IN (select
> [sNip]
> >> In summary, you could be charging them for some very expensive courier
> >> services, if for which they don't pay then you won't deliver. =)
> >
> > Of course a competitor could purchase a copy or get it from a customer
> > and set up shop right away selling it too.
>
> Ah, so ev
Same error as before
Toby Doig
Software Development Manager
Vibrant Media
[EMAIL PROTECTED]
0207 239 0134
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gianni Mariani
Sent: 01 December 2003 16:37
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] UNICODE pro
A suggestion is to use a left outer join and then test for rows with a
right-hand null value (ones where the join failed).
The following example creates 2 tables, t1 and t2.
t1 has related records in t2 and the relation is indicated by
t1.rel->t2.id
create table t1 (
id integer,
rel integer,
labe
Hello
If you can, use PostgreSQL version 7.4. There is some optimalisation for
this questions. You can change your query from select .. IN (select) to
select .. exists (select). More about it you can find in FAQ.
regards
Pavel
On Mon, 1 Dec 2003, Graham Leggett wrote:
> Hi all,
>
> I am tryi
> Graham Leggett
>
> Hi all,
>
> I am trying to do a query that returns all rows that are
> _not_ part of a join, and so far I cannot seem to find a
> query that doesn't take 30 minutes or more to run.
>
> The basic query is "select * from tableA where tableA_id NOT
> IN (select tableA_id fro
Hello
On Mon, 1 Dec 2003, Graham Leggett wrote:
> Hi all,
>
> I am trying to do a query that returns all rows that are _not_ part of
> a join, and so far I cannot seem to find a query that doesn't take 30
> minutes or more to run.
>
> The basic query is "select * from tableA where tableA_id
Hi all,
I am trying to do a query that returns all rows that are _not_ part of
a join, and so far I cannot seem to find a query that doesn't take 30
minutes or more to run.
The basic query is "select * from tableA where tableA_id NOT IN (select
tableA_id from tableB)".
Is there a more efficient w
Toby Doig wrote:
...
So, what is going wrong? Why can't I import this very simple unicode file?
I've searched the archives and google, but to no avail.
try converting the file to utf-8.
iconv -t utf-8 -f utf-16 < unicode-file.txt > utf-8-file.txt
---(end of broadcast)
> Here I find myself behind a Linux box that can't connect via PHP.. solved
> that one too.. Found the solution quicker on PHP.net then on
> postgresql.org.. even searched for postmaster -i (and other keywords I
> could think of) on postgresql.org.. no results.. FWIW.. seaching for the
> keyword p
B. van Ouwerkerk writes:
> >Would you care to tell us what you had to do? Because using the standard
> >installation I can connect via PHP just fine.
>
> I couldn't without modifying either postgresql.conf or start PostgreSQL
> with --i
There must be something wrong. PHP should be able to conne
Chris Travers writes:
> The easiest way of furthering the development of asynchronous replication
> proxies would be to break off the server-side network protocol handler into
> a library which would contain functions to bind to ports, listen, and pass
> messages back to the calling program. The
When I try to import data from a unicode file into PostgreSQL 7.4 under FreeBSD it
appears to now understand the Unicode file format.
To demonstrate I export a set of Integers into a Unicode file from MSSQL 2000. I samba
the file to a FreeBSD box and try to import from psql with COPY. It fails.
I think you are right!
I originally went to the Perl Module list on CPAN and looked for DBD and Pg.
It gave me the pgsql_perl5.1.9.0 link
However, when I searched for DBD Pg on Google, it led me to a DBD-Pg-1.22
I think that is what I was looking for. Will give it a try tonight.
Thanks!
Barb
Alex
Hi all;
I have been looking into how to ensure that synchronous replication, etc.
could best be implimented. To date, I see only two options: incorporate
the replication code into the database backend or have a separate "proxy"
which handles the replication.
The main problem with incorporating
> Here I find myself behind a Linux box that can't connect via PHP.. solved
> that one too.. Found the solution quicker on PHP.net then on
> postgresql.org.. even searched for postmaster -i (and other keywords I
> could think of) on postgresql.org.. no results.. FWIW.. seaching for the
> keyword p
B. van Ouwerkerk writes:
> Installation went fine. I decided to read the long version.. at some point
> I was told to create a user postgres.
> I didn't find recommended settings for this user like if it needs a shell
> and where the users homedir is supposed to be.. I mean.. I can understand
> th
Jason Tesser wrote:
Please post a comprehensive description of what you're trying to do
together with the configuration files you use.
I thought I did that sorry. I am trying to get Postgres to authenticate through Pam so I can authenticate to Active
Directory on our network. All the steps I took
I'd agree that this is probably laziness, or to be fairer, a ROI issue,
and again comes down to MySql having more mindshare.
I was mainly saying that the statement "Ahh just run different instances
for each customer." doesn't sit very well with me, and I doubt it would
for any ISP.
I can't see mu
New to PostgreSQL.. not to databases.. or Linux in general..
Let's asume I got convinced by your advocacy and decided to install and
play a bit with PostgreSQL to discover it's features and how I can use them.
Installation went fine. I decided to read the long version.. at some point
I was told
I've asked them to put up PostgreSQL as an alternative, but they just
say
"too hard" and don't want to talk about it.
---(end of
broadcast)---
TIP 7: don't forget to increase your free space map settings
I think we may translate 'too hard' into
Hiya,
As I've mentioned before, we happilly run and offer PostgreSQL and
MySQL hosting to our customers. We also offer shell access which
simplifies things a little. I'm a little confused as to why people
find having auth control from pg_hba.conf a problem? We never use the
same passwords o
64 matches
Mail list logo
