PostgreSQL Database Forum

Hi! I have a trigger using a update but this doestn work into trigger but if I execute the update from pgadmin this works perfectely. This is the code select into registro * from t_pagos_comisiones where f_wholetipoagnivel = who and f_fecha = $4 for update; IF FOUND THEN IF ($5 >0) THEN t1:= registro.f_montopagado+$7;

hello everyone i am very new to postgresql 7.3.3 and am using it on my mac G4 OS X and i am having some trouble which i hope you can help me out with some answers to my questions: 1.) How can I get a list of users currently logged into the database? Is it possible? 2) I plan on using postgresql for a posting board database, how can I...

I curious about the benefits of a varchar over text. Is it speed, size? If so, how much speed, size? Is a varchar(64) and a text with 64 chars the same size? I'm inclined to make all my varchars into text so I don't have to worry about inserting something to big. TIA, Michael ---------------------------(end of...

In PostgreSql 7.2, i have written one stored procedure using CURSORS. CREATE FUNCTION reffunc3(refcursor) RETURNS refcursor AS ' BEGIN OPEN $1 FOR SELECT empName FROM tbl_employee; RETURN $1; END; ' LANGUAGE 'plpgsql';

I have found that the sort order is different on Windows and Linux (same version of Postgres). On Windows, it sorts in what appears to be normal ASCIIorder. On Linux, lowercase comes before uppercase, and all non-alphanumerics appear to come before all alphanumerics. I really need it to sort on Linux the same as it does on Windows. The docs seem...

I have a query that is asking me to GROUP a column, yet when I GROUP it it causes an error near GROUP. What is very strange about the following query is that the line list_size_active = COUNT(NEW.active) PROPERLY sets the value to the number of new items.

Hi, everybody! Here is a weird problem, I ran into... I have two huge (80 million rows each) tables (a and b), with id as a PK on both of them and also an FK from b referencing a. When I try to run a query like: select * from a, b where a.id >= 7901288 and a.id=b.id limit 1; The query takes *forever*.

Hi @ all, i'm sure there was a psql-function to transfere my Blob-Data to the server but I can't remember. I have a script like this : UPDATE xy SET z = lo_import('localpath_and_file'); but i want to execute this script from the client and so my blob-data is

Looks like for the first time in 6 years, I'm experienced some database table corruption. This was due to the space filling up on a server (you don't want to know how that happened). I have 3 tables corrupt and the others are fine (which I dumped to be safe). I have a backup which I could use but then I realized that maybe there might be...

Hi, everybody! I am trying to create a custom GiST index in 7.3, but getting an error, that I don't know how to interpret: testdb=# create table gist_test (field int8); CREATE TABLE testdb=# create index gist_idx on gist_test using gist (field); ERROR: data type bigint has no default operator class for access method "gist"

This may have been better posted in the advocacy list but I am not a subscriber. We recently purchased Dreamweaver MX and I was a little surprised to find that one of its pre-defined scripting systems is PHP + MySQL. I haven't done much exploring of what is actually offered but wondered whether any one had tried to convince Macromedia to...

Hello, As I'm in the middle of the migration process form mysql to pg I found that there is no CONCAT function which is available in mysql. Can anybody tell me how to implement this function using plPERL or plPGSQL language ? Best wishes, ML

I have been request to create a relational database map that can be place on the wall in my office. Generally I done these in the past by just manually typing the information into Access and then printing a map from there. However the database they want mapped has a couple dozen tables in it and I don't relish the idea of entering all that by...

Hoii!! I am creating my struct and I have the question : What I must use for character fields char or varchar? Which are the differences? and the better TIA *-------------------------------------------------------* *-Edwin Quijada *-Developer DataBase

Hi: Can anyone provide a rough guesstimate on how much memory does fully conigured, with all the services turned on pgSql database require? I'm trying to make an estimate on how much memory would be required in Flash and RAM to run pgSql database. Thanks.

Hello I am looking for something like visual database structure browser. I need to see all tables and relations beetween them. Something like "Relations" window in Microsoft database products (ex. msaccess). I have to work with complicated database and i need to understand fast how it works. Greetings,

Hi ... I'm sorry if this have been asked many times, but it just seem like a good approach to me, at least :-) Is it not possible to design the database files in PG in a way that they are extentible by nature, at least in one direction (upgrade). This have been done with taged files (tiff, asn1, amiga) before, and sounds like a nice way...

I have applied the recent tsearch2 patch and recompiled the tsearch2 module but I am still experiencing the same backend crashes as I previously described. Thanks for any help, Mat GDB output:

Before beginning i want to explain you i'm French and i hope you will excuse my poor english.... I'm working in a small entreprise and we are looking for a data base for one of our products. This data base must allow multi session and a very important data quantity. Someone has speak us about pgsql. I have some question i dont expect finding...

I have a trigger when I executed I get this error: WARNING: Error occurred while executing PL/pgSQL function actualizar_pagos_comisiones WARNING: line 19 at select into variables ERROR: Unable to identify an operator '=' for types 'character' and 'character varying' You will have to retype this query using an explicit cast who...

Hi, Red Hat 9.0 Professional appears to come with PostgreSQL included. I believe the version is 7.3.2 I would like to know if this is the complete functional PostgreSQL database or whether I need to download any binaries from the PostgreSQL site. Thanks,

Hi, I am faced to the following problem: .... conn.setAutoCommit(false); String val = new String {"one", "two", "two", "three" }; for (int i=0; i < nmax; i++) { try { PreparedStatement pst = conn.prepareStatement("INSERT INTO ATEST VALUES (?)"); pst.setString(1, val);

Have a table with fnumber and number, both text fnumber is a phone number, format "8005551212" number needs to be the same number but in the format "(800) 555-1212" we currently run the following each time the list is updated; update pnums set number='(' || substring(fnumber from 1 for 3) || ') ' || substring(fnumber from 4 for 3) || '-' ||...

I am starting to work with rules. I think I have them down but the folowing one is giving me grief. It tells me that it has rewritten 100 times and probably has looped. The columns ID and Location make up the primary key so I am sure that the result update should only effect one row. Anyone know what I am missing? CREATE OR REPLACE RULE...

hi, using postgresql 7.3.1: # select current_timestamp,date_part('timezone_hour',current_timestamp); timestamptz | date_part -------------------------------+----------- 2003-09-16 10:51:58.228489+03 | -3 (1 row)