te file...
Thanks,
Moray
--
[EMAIL PROTECTED]
- Original Message -
From: Aaron J. Seigo <[EMAIL PROTECTED]>
To: Moray McConnachie
<[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <[EMAIL P
> > I can't find the bug report form on the WWW to submit a bug report
for
> > psql on this. The FAQ merely says
> >
> > 1.13) How do I submit a bug report?
> >
> > Fill out the "bug-template" file and send it to:
[EMAIL PROTECTED]
> >
> > No indication of how to get hold of the bug-template file
log attached contains all
references to one of them. Could someone maybe take a look, and see if
what is recorded in these logs explains the behaviour? It seems
particularly odd, because the final insert appears to have nothing
wrong with it!
UPDATE pg_proc SET prosrc='SQL statement' WHERE proname LIKE
'functionname';
seems to work for SQL queries at least. I doubt it's recommended,
though!
Moray
--
[EMAIL PROTECTED]
- Original Message -
Fro
With all this talk of rebuilding indices, the following script does it
for me:
#!/bin/sh
pg_dump -s databasename > filename
perl -pi -e 'unless (/CREATE.*INDEX/) {s/.*//;chomp;}' filename
perl -pi.create -e 's/CREATE.*?INDEX(.*?\s)ON.*/DROP INDEX$1\;/i;'
filename
mv filename filename.drop
psql -d
- Original Message -
From: Tatsuo Ishii <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, March 18, 2000 1:12 PM
Subject: Re: [GENERAL] what is the most appropriate way to shutdown the
postmaster?
> In 7.0 ther
e du programmeur. On me dit qu'il est plus "scalable" aussi, mais
franchement je ne sais pas.
Meilleurs voeux,
Moray McConnachie
- Original Message -
From: "chriqi abdelkarim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 24, 2000 1:16 PM
Subj
Try pgadmin, which is not web-based, but allows you to do all these things.
Only runs from MS platform, though.
http://www.vale-it.co.uk
Alternatively, it would be mind-numbingly simple to write (e.g.) a Perl CGI
interface to allow psql access . Have to make sure it was well-secured,
though.
Ind
Whoops, gave wrong URL: pgadmin should be
http://www.vale-it.demon.co.uk/freeware/pgadmin/
[EMAIL PROTECTED]
- Original Message -
From: "Stan Jacobs" <[EMAIL PROTECTED]>
To: "Egon Schmid" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
>> Now if you make pgsql user and postgresql analgous to
>> root and unix, the postgres user shouldn't need a passwd.
>My root users always have passwords. *shrug* But you're right, automated
>backup on password protected databases is next to impossible right now,
>especially when using pg_dump.
- Original Message -
From: Michael Black <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 02, 2000 9:17 PM
Subject: [GENERAL] Re: ODBC Interface questions
> I am using the Insight ODBC driver version 6.40.0009 on a Win98 box and
> Access 97.
> I set it up as a System DNS.
ong as I'm credited in the script itself.
You can find it at http://users.ox.ac.uk/~cerberus/psql.pl
Yours,
Moray
[EMAIL PROTECTED]
- Original Message -
From: "Philip Poles" <[EMAIL PROTECTED]>
To: "Moray
- Original Message -
From: "Fabrice Scemama" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 4:03 PM
Subject: [GENERAL] Accelerating subqueries
> Hi fellow PostgreSQL users.
>
> Here's a query:
>
> DELETE FROM Annonces WHERE Id_Ag IN
> (
> SELECT Id FROM In
- Original Message -
From: "Jeffrey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 12, 2000 10:05 AM
Subject: [GENERAL] Perl error: fetchrow_hashref failed
> Hi, I wonder if I might tap the vast knowledge here againg.
>
> I have a perl script that is looping through
ing $sth-finish should make the difference, but maybe if
you have already used $sth once there is a problem?
Try it anyway :->
[EMAIL PROTECTED]
- Original Message -
From: "Jeffrey" <[EMAIL PROTECTED]>
To: &q
15 matches
Mail list logo
