PostgreSQL Database Forum

> I can't get a rest for a min guys. > > I go away for the weekend and my server is getting this error. > > Fatal error: Call to undefined function: pg_connect() in > /var/www/html/crohns/phpBB2/db/postgres7.php on line 79 Your PHP doesn't have support for PostgreSQL. Look at phpinfo();

Hi, I use a data formatting in views (to_char(last_update, 'YYYY-MM-DD HH:MM:SS') as last_update and noticed that the last update returned is the creation date of the view or not the actual value of the last_update.(last _update is a timestamp). What do I need to do to display the actuall value? Thanks Alex

Is it possible to deferr a trigger until commit, Or to have the trigger not occur if the transaction is rolled back? Like transaction. I think its possible since constraints use triggers and if so why is this a standard feature. Also is there anyway of seeing what triggers exsist and what they do? (psql \<somthing> or the like) Peter...

Hello all, I am interested in know if anyone has set up clustering for performance and fail over using PostgreSQL. We are currently using Oracle for a distribution application and would like to use PostgreSQL with multiple application and database servers. Regards Stan. --------------------------------- Post your free ad now! Yahoo!...

Hi, i'm getting the following error when updating a view : ERROR: Multiple assignments to same attribute "send_sco" When doing the same query directly on the table i'm not getting any error. Any ideas ??

I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the pgReplication project (and made the simple modification as listed in their mailing lists), but was not able to build the environment needed for Redhat 7.3. My question is: is anyone doing this type of...

Hi all, I'm running Postgres 7.2.1 and I need to return multiple row sets from plpgsql function. I'm new in plpgsql but according documentation and everything I could find in the mailing list I need to switch to 7.3 to get at least SETOF rows as a result. I can't really upgrade Postgres now. Is there is any a workaround idea to ...

Hi all, I sent this message to the jdbc list and received no response there and so am posting to this list hoping I could get some help here. Thanks in advance. ---------- Forwarded message ---------- Date: Fri, 17 Oct 2003 11:54:19 -0300 (ADT) From: Ashwin Kutty <akutty@dal.ca>

I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). I need to be able to move the database files, as normal user-visible files, between machines....

Hi, I was an oracle dev/admin and I'm quite new to postgresql. Postgresql is great, but something bothers me. It seems that there's no concept of PACKAGE in PL/pgSQL as in Oracle PL/SQL. Is is definitely that? or did I missed something? or is it planned for a future version? I've searched in the mailing lists archives, read many lines...

Hello !!! I have store some attrybutes to database. Attrybutes are set of integer values. {1,5,7} is valid set, but {1,3,1} is not valid set I have to build compare relation i.e. {1,5,7} is equivalent to {5,7,1} or {1,7,5} etc. but {1,5,7} is not equivalent to {5,1} or {1,4,2} What's best solution: arrays, master detail relation,...

On Oct 3rd, we released beta4 in the hopes that it would be the final beta before going into the "Release" phase of development ... due to several bug fixes over the past 3 weeks, we've decided to release a Beta5 in order to flesh out any bugs that may have been introduced ... Beta5 contains several fixes that require an initdb from Beta4,...

Does anyone know the exact definition of a Prepared Statement? String sql = "SELECT count(id) FROM customer"; executeQuery(sql); I assume the sql string is a prepared statement? Semantic debate here. - Thx ---------------------------(end of broadcast)---------------------------

I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). My first requirement is that I need to be able to add new columns to any database table on the...

Hello list, I have a table with an index in a foreing key field (int4), if I do select from pedido where prvdfk=3, explain says is using seq scan to access it. I noticed all my querys runs in that way, except in the querys where the PK field (unique type index) is included in the where clause. Is this the rigth way that postgresql works...

Hi, Certainly a stupid question : What is the max length for identifiers. A test shows me 63 for a table name. I just imagine it's the same for constraint name, view name etc ... but I'm not sure. Or where can I get this info, because it's not in the Postgresl docs ! Thanks

Hi, I wonder if there is a way to do setArray() through JDBC api ?? The one described in PreparedStatement.setArray(int, java.sql.Array) looks pretty complicated to build. thanks, kathy ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

djee Bcc: Subject: Re: Redhat RPMs Reply-To: Andrew Overholt <overholt@redhat.com> In-Reply-To: <200310141315.18492.lowen@pari.edu> Lamar Owen once said: > On Friday 10 October 2003 08:52 pm, Christopher Browne wrote: > > Oops! nandrews@investsystems.co.uk ("Nigel J. Andrews") was seen > spray-painting on a wall:

Hey all I am trying to extract the epoch from a timestamp variable in plpgsql. The function is as follows: create or replace function test() returns integer as ' declare _test timestamp with time zone; _f integer; begin

Folks, I’m hoping someone can give me some pointers to resolving an issue with postgres and it’s ability to utilize multiple CPUs effectively. The issue is that no matter how much query load we throw at our server it seems almost impossible to get it to utilize more than 50% cpu on a dual-cpu box. For a single connection we can use...

I have recently come across an unusual behavior with Postgres 7.3.4 on a Linux RH 9 system. My database has encoding set to "UNICODE", and the table includes Japanese text. I'm trying to issue a query like this: SELECT * FROM sales WHERE name='ja-text'; This query ignores all japanese characters in the comparison text. It matches...

is there a table or view whose name is "pg_views" in this system ?? I can not find it in the catalog, but in source code i find the following clause: sprintf(buf, "SELECT definition FROM pg_views WHERE viewname = '%s'", name); result = PSQLexec(buf); __________________________________________________ Do You Yahoo!?

Hi I'm having serious problems with a mission critical app that runs on postgres (and has been running for the past 3 years). It's rather large, and lately things are not going well. The planner is getting 'nuts', choosing ways that never end and completly stops the database. The strange thing is that running the same query with the...

We had one of our databases suddenly try to reference a pg_clog file that didn't exist whenever we attempted to select from a certain table. Anyone know of a way to recover from this? Is there a way to reset the transaction logs and just use whatever data is actually stored in the system? -- Adam Haberlach | "We spent the 90's...