# [EMAIL PROTECTED] / 2005-08-06 13:37:45 +0530:
> errors while loading in redhat8.0 linux
> [EMAIL PROTECTED] postgrep]# ls
> postgresql-8.0.3 postgresql-8.0.3.tar.bz2
> [EMAIL PROTECTED] postgrep]# cd postgresql-8.0.3
> [EMAIL PROTECTED] postgresql-8.0.3]# ./configure
> checking build system ty
E'' is more a marker than a type. I realize making E a type might work,
but it seems unusual.
What we could do is backpatch E'' to 8.0.X as a no-op like it will be in
8.1.
---
Jeff Davis wrote:
> >From what I've read, it l
On Monday 08 August 2005 08:02 pm, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The
> > only problem I have run into is that a plpythonu function that returns
> > void will not run under 8.03. The error message
> "Google" == Google Mike <[EMAIL PROTECTED]> writes:
Google> As a PostgreSQL admin or developer, you may be asked to deploy a Linux
Google> Apache PHP PostgreSQL application.
Not me. I'll be deploying an OpenBSD, Apache, PostgreSQL, Perl server.
o/~ you down with O-A-P-P? (yeah you know me
Scott and I were discussing NOTIFY/LISTEN using a PHP
script here:
http://phpbuilder.com/board/showthread.php?t=10302693
Basically:
PHP Code:
#!/usr/bin/php -q
And the sql code:
CREATE TABLE ntest ( id serial primary key, path text
);
create table naudit ( id int primary key, path text );
Hi,
To get rid of the automatic output, turn PrintError off.
For example:
$dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=${dbserver};", $dbuser,
"",{PrintError => 0}) or
errexit( "Unable to connect to dbname $dbname, err: $DBI::errstr");
See the "perldoc DBI" documentation for full informati
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
>> Yeah, you can store the pg_class OID of the table,
> Maybe it is possible to use a column of type regclass to store it. Not
> sure exactly what advantage that would give, but it's an idea.
H
chiranjeevi.i wrote:
> Hi Team Members,
>
> Is it possible to write jobs in postgresql & if possible how
> should I write .please help me.
See pgjob in pgfoundry: http://pgfoundry.org/projects/pgjob/. It's in
the planning stages.
--
Guy Rouillier
---(end of broadc
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
> "TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> > I guess what I'm asking is: Is there a better way to keep track of a
> > table once it's registered in my master table than just to put its
> > name in my master table? Some system oid type t
"TJ O'Donnell" <[EMAIL PROTECTED]> writes:
> I guess what I'm asking is: Is there a better way to keep track of a
> table once it's registered in my master table than just to put its
> name in my master table? Some system oid type thing that stays fixed
> in spite of renames or other tables mods?
Firebird has MVCC also (they call it multi-generational record architecture
--- MGRA), and may have at least a good test plan, though it may not cover
effects of rules, triggers, functions, and constraints. Those are the
killer test cases. I don't have time to look.
http://firebird.sourceforge.n
Chris.
> >If it's a Linux-Apache-PHP-PostgreSQL web app you only need one user, the
> >one your PHP script logs in as.
> Who says? I sometimes require that the PHP app logs into the database
> with the username/password suppled by the user. This makes it easier to
> manage permissions. Of
> Matt Miller <[EMAIL PROTECTED]> writes:
> > I want to write some regression tests that confirm the behavior of
> > multiple connections simultaneously going at the same tables/rows. Is
> > there something like this already, e.g. in src/test/regress?
>
> No. You should consult the pghackers arc
> TJ O'Donnell wrote:
>> I have many different tables that I want to keep track of.
>> So, I thought of a master table with those table names in it.
>> But, to maintain this (suppose a table changes
>> its name, gets dropped) I want to have some kind of referential
>> integrity - the way foreign ke
[EMAIL PROTECTED] wrote:
Mike.
If I can improve this process, then a developer can download my web app,
try it out rapidly, comparing it against others, and hopefully decide on
mine because I have made it easy to get started and easy to customize to
their tastes.
If it's a Linux-
Tom Lane <[EMAIL PROTECTED]> writes:
> "Salem Berhanu" <[EMAIL PROTECTED]> writes:
> > What exactly is the SQL_ASCII encoding in postgres?
>
> SQL_ASCII isn't so much an encoding as the declaration that you don't
> care about encodings.
It's too late to consider renaming this SQL_RAW or someth
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> The problem only shows up when you have mixed data -- say, you have two
> applications, one website in PHP which inserts data in Latin-1, and a
> Windows app which inserts in UTF-8. In this case your data will be a
> mess to fix, and there's no way a si
On Sat, Aug 06, 2005 at 07:59:06PM -0700, Google Mike wrote:
> As a PostgreSQL admin or developer, you may be asked to deploy a Linux
> Apache PHP PostgreSQL application. As you know, and simplifying things
> a great deal here, the pg_hba.conf file can be edited in approximately
> 7 different ways:
On Tue, Aug 09, 2005 at 12:56:37PM -0400, Joel Fradkin wrote:
> Not that I am an expert or anything, but my initial data base was SQLASCII
> and I did have to convert it to Unicode.
> My reasons were we store French characters in our database and the newer
> odbc driver was not displaying them corr
Jan Wieck wrote:
On 8/9/2005 12:21 PM, Tom Lane wrote:
This reminds me I've forgot to ask, is there any other way of getting
rid of those ghost entries than via big load ?
Not at the moment. It might be worth teaching the pgstats code to
cross-check the activity list every so often, but th
Mike.
> If I can improve this process, then a developer can download my web app,
> try it out rapidly, comparing it against others, and hopefully decide on
> mine because I have made it easy to get started and easy to customize to
> their tastes.
If it's a Linux-Apache-PHP-PostgreSQL web app
At 05:59 PM 8/9/2005 +0200, Martijn van Oosterhout wrote:
SQL_ASCII means that the database does no locale specific or language
specific encoding ever. It won't check what you send it either. If
you're content to let clients deal with any encoding issues, this may
be what you want.
But anything
Not that I am an expert or anything, but my initial data base was SQLASCII
and I did have to convert it to Unicode.
My reasons were we store French characters in our database and the newer
odbc driver was not displaying them correctly coming from SQLASCII, but was
from UNICODE.
I also think that it
Jan Wieck <[EMAIL PROTECTED]> writes:
>> Jan, any thoughts?
> The reset call is supposed to throw away everything. If it leaves crap
> behind, I'd call that a bug.
resetcounters only thinks it is supposed to zero the counters for the
current database. That seems considerably different from "thr
Martijn van Oosterhout writes:
> SQL_ASCII means that the database does no locale specific or language
> specific encoding ever. It won't check what you send it either. If
> you're content to let clients deal with any encoding issues, this may
> be what you want.
> But anything to do with lower()
On 8/9/2005 12:21 PM, Tom Lane wrote:
Csaba Nagy <[EMAIL PROTECTED]> writes:
I've executed a "select pg_stat_reset();" as superuser, and all went
away except the offending row...
That only resets the I/O counts (and only for one database), not the
backend activity info.
This reminds me I'v
On Sat, Aug 06, 2005 at 04:02:05PM -0400, Ana Mandiola wrote:
Hola,
>Me gustaría saber si poseen un tutorial de postgresql con PHP,
> ya que me encuentro estudiando en la Universidad, y por un ramo tengo
> q desarrollar un sistema basado en postgresql con PHP, he encontrado
> muy poca inf
Csaba Nagy <[EMAIL PROTECTED]> writes:
>>> I've executed a "select pg_stat_reset();" as superuser, and all went
>>> away except the offending row...
>>
>> That only resets the I/O counts (and only for one database), not the
>> backend activity info.
> This reminds me I've forgot to ask, is there
Jeff Boes <[EMAIL PROTECTED]> writes:
> I'm trying to write a general-purpose trigger that will disallow updates
> on certain fields (I could probably do this in other ways, but I have a
> stubborn streak ...).
I think it's pretty much impossible to do this in plpgsql. You could do
it in the othe
On Tue, Aug 09, 2005 at 11:02:47AM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Another option would be to create a new datatype 'itext' which works
> > like text except it compares case insensetively. PostgreSQL is flexible
> > like that. Here's something to get you started, see be
On Mon, Aug 08, 2005 at 04:10:50PM +, Salem Berhanu wrote:
> What exactly is the SQL_ASCII encoding in postgres? I have a pg
> installation with an SQL_ASCII server encoding and my database (also
> SQL_ASCII) seems to be able to handle all types of encodings? how is this
> possible? is this
"Salem Berhanu" <[EMAIL PROTECTED]> writes:
> What exactly is the SQL_ASCII encoding in postgres?
SQL_ASCII isn't so much an encoding as the declaration that you don't
care about encodings. That setting simply disables encoding validity
checks and encoding conversions. The server will take any b
Jeff Boes wrote:
I'm trying to write a general-purpose trigger that will disallow updates
on certain fields (I could probably do this in other ways, but I have a
stubborn streak ...).
Given a table, I want to define a trigger on that table that will
"write-protect" one column by name:
CREATE TR
Piotr Sulecki <[EMAIL PROTECTED]> writes:
> I have two really big tables, the problem is with one of them. The table
> looks as follows:
> ...
> Indexes:
> "pakiety_pkey" PRIMARY KEY, btree (pktid)
> "pakiety_stid_received_idx" UNIQUE, btree (stid, received)
> "pakiety_measured_idx" btr
Richard Huxton writes:
> Alban Hertroys wrote:
>> I'm not sure how we got the "content" column from "description" to
>> reference "localization" back in version 7.3. Fact is, we can't seem to
>> do this anymore since version 7.4:
> I don't have 7.3.x to hand any more, but if you could create su
Csaba Nagy <[EMAIL PROTECTED]> writes:
> On our first test run everything went fine, the only strange thing is a
> row in the pg_stat_activity, which has a row about a query which is long
> gone, the process pointed by the procpid field is not existing.
This is not totally surprising, since the pg
TJ O'Donnell wrote:
I have many different tables that I want to keep track of.
So, I thought of a master table with those table names in it.
But, to maintain this (suppose a table changes
its name, gets dropped) I want to have some kind of referential
integrity - the way foreign keys and constrai
[snip]
> > I've executed a "select pg_stat_reset();" as superuser, and all went
> > away except the offending row...
>
> That only resets the I/O counts (and only for one database), not the
> backend activity info.
>
> regards, tom lane
This reminds me I've forgot to ask, i
Tom Lane wrote:
Having just tried it, I can say that the last version that would take
that without complaint is 7.0. 7.1 and later give variants of
ERROR: UNIQUE constraint matching given keys for referenced table
"localization" not found
So I'm not sure what Alban actually did.
Neither am
[EMAIL PROTECTED] wrote:
What is the most effective method for syncronizing a database from a main
to a backup machine? I am now running 8.0. Is it necessary to drop the
database from the secondary machine and restore it from a dump of the
primary?
Depends on how often/up-to-date you want t
Hi All,
I was wondering if there is way to suppress the error messages on the stdout
from a perl dbi execute command, basically if I do a
sth->execute() on a command and say the row cannot be updated then
I get a err msg to stdout if there is foreign key violation, I want this error
message
As a PostgreSQL admin or developer, you may be asked to deploy a Linux
Apache PHP PostgreSQL application. As you know, and simplifying things
a great deal here, the pg_hba.conf file can be edited in approximately
7 different ways:
* locked down -- no access at all (usually the default)
* trust loc
Thank you both for the replies. I obviously have some things wrong,
and I'll have to masticate on the answers.
AIUI, the foreign key references are not an issue for me since I always
specify the column name.
Thanks again,
Jim
---(end of broadcast)--
Dear Sir,
We are planning to develope CRM package with Postgresql database software.
We are planning to load postgresql package. we are getting following
errors while loading in redhat8.0 linux.Please give solution for the same
error message.
[EMAIL PROTECTED] postgrep]# ls
postgresql-8.0.3 pos
Srs:
Me gustaría saber si poseen un tutorial de postgresql con PHP,
ya que me encuentro estudiando en la Universidad, y por un ramo tengo
q desarrollar un sistema basado en postgresql con PHP, he encontrado
muy poca informacion referente a este tema, y al programar tengo
algunos problemas d
Ave!
Yesterday I noticed a problem with my PostgreSQL installation. I have
three database clusters, one using version 7.4.6 and the rest using
version 8.0.1. The problem manifests itself in all three installations.
(The three databases are copies of -- more or less -- the same data; now
I'm writin
What exactly is the SQL_ASCII encoding in postgres? I have a pg installation
with an SQL_ASCII server encoding and my database (also SQL_ASCII) seems to
be able to handle all types of encodings? how is this possible? is this what
the server & db encoding needs to be set to in order to handle var
Well what I mean at getting stuck is that some rows can be deleted fast
when you delete them with their specific id while there are rows which
when I tried to delete them it just didnt respond (seems like working
endlessly so i stop it after an hour or so).
Interesting that this morning I was ab
Martijn van Oosterhout writes:
> Another option would be to create a new datatype 'itext' which works
> like text except it compares case insensetively. PostgreSQL is flexible
> like that. Here's something to get you started, see below for example.
> http://svana.org/kleptog/pgsql/type_itext.sql
[EMAIL PROTECTED] wrote:
Hi
Suppose I have two databases on one server (lets call them DB_A and DB_B)
and I was to write a cross database query. How do I do this in PostgreSQL?
Either use the dblink module from contrib/ or merge them into one
database but different schemas.
--
Richard Hux
On 8/9/05 10:31 AM, "TJ O'Donnell" <[EMAIL PROTECTED]> wrote:
> I have many different tables that I want to keep track of.
> So, I thought of a master table with those table names in it.
> But, to maintain this (suppose a table changes
> its name, gets dropped) I want to have some kind of referent
I'm trying to write a general-purpose trigger that will disallow updates
on certain fields (I could probably do this in other ways, but I have a
stubborn streak ...).
Given a table, I want to define a trigger on that table that will
"write-protect" one column by name:
CREATE TRIGGER tbl_nomod_cre
I have many different tables that I want to keep track of.
So, I thought of a master table with those table names in it.
But, to maintain this (suppose a table changes
its name, gets dropped) I want to have some kind of referential
integrity - the way foreign keys and constraints do.
What could I
On Tue, Aug 09, 2005 at 04:25:30PM +0200, Csaba Nagy wrote:
> The logs don't show the "statistics buffer is full" message as suggested
> by Tom, but ITOH "log_min_messages = info", and that message might be a
> debug level one.
The message is in src/backend/postmaster/pgstat.c:
if (!overflow)
On 8/9/05 10:21 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> Hi
>
> Suppose I have two databases on one server (lets call them DB_A and DB_B)
> and I was to write a cross database query. How do I do this in PostgreSQL?
>
> On MS-SQL I would do something like:
>
> SELECT ta.Field1, ta.Fi
Michael,
I've read the message you referred, and it's probably what happens.
In fact the original row I've complained about is gone, and I have now
10 other dead processes listed in pg_stat_activity... one of the queries
is a "", still running after 25 minutes, and the associated
process is gone,
What is the most effective method for
syncronizing a database from a main to a backup machine? I am now
running 8.0. Is it necessary to drop the database from the secondary
machine and restore it from a dump of the primary?
Hi
Suppose I have two databases on one server (lets call them DB_A and DB_B)
and I was to write a cross database query. How do I do this in PostgreSQL?
On MS-SQL I would do something like:
SELECT ta.Field1, ta.Field2, tb.Field2
FROM DB_A.dbo.SomeTable ta
JOIN DB_B.dbo.SomeOtherTable tb
ON ta.F
Anyone done it? Is it possible? Currently running the free SQLAnywhere version
included with CQ.
I suspect my hopes will be extinguished shortly :-(
Cheers,
Rob
--
08:11:07 up 26 days, 11:46, 5 users, load average: 2.52, 2.19, 2.20
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
pgpT
I posted the following to the performance mailing list on 8/2/2005, but have
not heard any replies. Maybe this should just be a general question. Would
someone be able to help me get pb_dump to run faster for bytea data?
++
Dumping a database which c
Martijn van Oosterhout wrote:
On Tue, Aug 09, 2005 at 02:31:16PM +0200, Alban Hertroys wrote:
Hi all,
We migrated a database from version 7.3 something to 7.4.7 a while ago,
and ever since that time we can't make new foreign keys to a particular
table. The problem is that the primary key on
On Tue, Aug 09, 2005 at 03:19:46PM +0200, Csaba Nagy wrote:
> I have a postgres system where we just migrated a fairly big data set.
> The application accessing it is a cluster of servers which do burst-like
> processing, i.e. when they have some work to do, it will be distributed
> in the cluster
Oh, I've forgot to mention that the DB is version 8.0.3 running on
linux.
Cheers,
Csaba.
On Tue, 2005-08-09 at 15:19, Csaba Nagy wrote:
> Hi all,
>
> I have a postgres system where we just migrated a fairly big data set.
> The application accessing it is a cluster of servers which do burst-like
On Tue, Aug 09, 2005 at 02:31:16PM +0200, Alban Hertroys wrote:
> Hi all,
>
> We migrated a database from version 7.3 something to 7.4.7 a while ago,
> and ever since that time we can't make new foreign keys to a particular
> table. The problem is that the primary key on that table is on two
>
Hi all,
I have a postgres system where we just migrated a fairly big data set.
The application accessing it is a cluster of servers which do burst-like
processing, i.e. when they have some work to do, it will be distributed
in the cluster and the data base will be under fairly high load.
On our fi
Alban Hertroys wrote:
Hi all,
We migrated a database from version 7.3 something to 7.4.7 a while ago,
and ever since that time we can't make new foreign keys to a particular
table.
You shouldn't have been able to before.
> The problem is that the primary key on that table is on two
columns
Hi all,
We migrated a database from version 7.3 something to 7.4.7 a while ago,
and ever since that time we can't make new foreign keys to a particular
table. The problem is that the primary key on that table is on two
columns that are unique together, but that only one of them should be
refe
Frank Millman wrote:
Frank Millman wrote:
Hi all
Is there an LC_COLLATE setting, or any other method, which allows all
data in a database to be treated in a case-insensitive manner?
I was hoping to stimulate some discussion on this topic, but it seems I will
have to kick-start it myself a
On Tue, Aug 09, 2005 at 11:57:48AM +0200, Martijn van Oosterhout wrote:
> Another option would be to create a new datatype 'itext' which works
> like text except it compares case insensetively. PostgreSQL is flexible
> like that. Here's something to get you started, see below for example.
>
> htt
> Hi,
>
> I will appreciate it if anyone can educate me on the cost of
> using SET search_path TO for schemas at runtime.
AFAIK, that's quite cheap. Shouldn't be a problem.
> In
> particular, for .NET data operations where there may be high
> rate of connection/disconnection and reconnection
On Tue, Aug 09, 2005 at 09:35:25AM +0200, Frank Millman wrote:
> Frank Millman wrote:
>
> > Hi all
> >
> > Is there an LC_COLLATE setting, or any other method, which allows all
> > data in a database to be treated in a case-insensitive manner?
>
> I was hoping to stimulate some discussion on th
Hi,
I will appreciate it if anyone can educate me on the cost of using SET
search_path TO for schemas at runtime. In particular, for .NET data
operations where there may be high rate of connection/disconnection and
reconnection for initial data fetching and subsequent updating.
Best regards
Top
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Sander,
On Tue, 9 Aug 2005, Sander Steffann wrote:
If you can succeed building the RPMs as Joshua guided, please
let me know and we can upload the binaries to FTP site.
As promised: I put them on http://opensource.nederland.net/PostgreSQL/
Hi,
> I double-checked and realized that we have no servers to
> build 64-bits RPMs for RHEL 4. I've built ones for RHEL 3.0,
> but they may not work for you.
>
> If you can succeed building the RPMs as Joshua guided, please
> let me know and we can upload the binaries to FTP site.
As promised
Frank Millman wrote:
> Hi all
>
> Is there an LC_COLLATE setting, or any other method, which allows all
> data in a database to be treated in a case-insensitive manner?
I was hoping to stimulate some discussion on this topic, but it seems I will
have to kick-start it myself and see if anyone re
use contrib/ltree
Oleg
On Tue, 9 Aug 2005, Ben wrote:
Hi
This question is not specific to PostgreSQL but I would like to know
what is the best way to count the number of items in each node from
the leaf to the root? Something like this:
Computers (100)
76 matches
Mail list logo
