Re: [GENERAL] pg_class and relfilenode

e.g. pg_shadow_usename_index pg_stat_activity pg_stat_database They are system views and correspond to no file. See PostgreSQL's documents. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[GENERAL] EXECUTE + transaction = unexpected error -8

Hi, It seems that there is a problem when executing a dynamic commands containing a transaction... Here's a simple example... CREATE OR REPLACE FUNCTION fct_trig2() RETURNS TRIGGER AS ' BEGIN EXECUTE ''BEGIN;'' || ''CREATE TABLE t2_'' || NEW.id::TEXT || ''('' || '' CONSTRAINT pkt2_''

[GENERAL] Best replication options

What is the best replication option out there today for postgresql. Have been trying to get rserv working and that hasn't been the easiest. Would like to run 7.4.1. Any suggestions? -Steve ---(end of broadcast)--- TIP 3: if posting/reading

[GENERAL] Pg + perl + apache

I'm having some odd issues, but I'm not sure exactly the cause of them, but postgres is the component in the system that is throwing the errors, so I thought I'd start here. I have built a web application that uses postgres (7.3.2) as its backend, with the front being an Apache2/mod_perl

Re: [GENERAL] Pg + perl + apache

On Sat, Feb 14, 2004 at 04:35:58PM -0500, Michael L. Artz wrote: I'm having some odd issues, but I'm not sure exactly the cause of them, but postgres is the component in the system that is throwing the errors, so I thought I'd start here. snip with the corresponding postgresql.log entry

Re: [GENERAL] Confused newbie (to PG not DB's)

On Tue, 10 Feb 2004, mike wrote: I have setup a database that I am the owner of, and I am trying to setup constraints and it doesn't seem to be working Example - Table: public.Invoice_Header -- DROP TABLE public.Invoice_Header; CREATE TABLE public.Invoice_Header ( Inv_ID int4 NOT

Re: [GENERAL] PostgreSQL License

Nope. PostgreSQL is BSD licensed. On Feb 10, 2004, at 11:40 AM, Artemy wrote: What about the PostgreSQL License. If I use the database for the commercial purpose, Do I have to purchase the license?. P.S. For example MySQL Databse have the commercial license for that. Best Regards Artjom

Re: [GENERAL] PostgreSQL License

PostgreSQL has BSD license. Tha means do what do you want :) Oleg On Tue, 10 Feb 2004, Artemy wrote: What about the PostgreSQL License. If I use the database for the commercial purpose, Do I have to purchase the license?. P.S. For example MySQL Databse have the commercial license

Re: [GENERAL] Pg + perl + apache

Michael L. Artz [EMAIL PROTECTED] writes: Anway, DBD::Pg throws random errors into my logs, along the lines of what is below (the lines beginning with SQL are debug statements from the script, and are the lines references by the DBD error. LOG: statement: SELECT session_key

Re: [GENERAL] Pg + perl + apache

On Saturday 14 February 2004 22:35, Michael L. Artz wrote: (...) If anyone has seen anything like this before (i.e. random errors in a similar apache/mod_perl) situation, or might have any pointers as to where to look next, let me know. What would cause postgres to return an error for a

Re: [GENERAL] PostgreSQL Indexing versus MySQL

I had this same problem not long ago, and it caused me go with PostgreSQL over MySQL on a project. The problem you're describing does not exist in PostgreSQL. Creating a new index on a table does not require recreating the other indexes. MySQL also has the same problem if you add or drop

Re: [GENERAL] nonblocking libpq large object access?

On 15. feb 2004, at 18:18, Tom Lane wrote: A workaround you could think about is invoking the LO functions via ordinary SELECT commands, ignoring libpq's LO API altogether. This would have been rather painful in pre-7.4 releases since you'd have to be willing to deal with quoting and dequoting