PostgreSQL Database Forum

Hi, For my supprise I found that functions have 32 parameter limit. Where to find more info about this limitation or similar limitations ? I need at least 50, 100 would be ok. Real life function below:

I've created two PL/pgSQL functions with the same name and different signatures: CREATE FUNCTION ABC(CHAR) ... CREATE FUNCTION ABC(TEXT) .... I intended to call the CHAR-signature function like this: SELECT ABC('R'); And the TEXT-signature function like this:

Downloaded the eRServer 1.2 source (thanks, guys) and installed, and am having a problem. Anyone else dug into this yet? Situation: PG 7.3.4 on linux (master) Its been tried with 3 slaves, all 7.3.4, 2 on OS X and one on Linux. It builds fine. It installs fine. I go through the setup with no problems (calling createlang, doing the...

Hi, i've a speed problem withe the following statement: SELECT DISTINCT pz.l1_id, pz.l2_id, pz.l3_id, pz.l4_id FROM ot_adresse AS a, ot_produkt AS p LEFT OUTER JOIN ot_kat_prod AS pz ON ( p.p_id = pz.p_id ) WHERE p.a_id = a.id AND a.id = '105391105424941' AND a.m_id = '37'; This is terrible slow compared to the inner join: SELECT...

I am using Delphi7 and PostgeSQL 7.3.2 My DB table is as such Create Table files ( emalid varchar(80), memocolumn text, savedfile oid ); I cannot post Blobs to the DB that are larger than a typical icon. If the Blob is small, it goes through just fine. When I try to send a larger objectto the DB, I get a Postgres error:

following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Finally if this is a tuple level lock (we...

I am using Delphi7 and PostgeSQL 7.3 My DB table is as such Create Table files ( emalid varchar(80), memocolumn text, savedfile OID ); I cannot post Blobs to the DB that are larger than a typical icon. If the Blob is small, it goes through just fine. When I try to send a larger objectto the DB, I get a Postgres error:

How do I view the arguments and details of a user defined function?

Hello Sometimes i need to drop one of my tables. DROP TABLE removes all foreign keys connected with that table. After this i need to recreate FK. It is not easy to find dropped keys, so i have script to create all keys in database (ALTER TABLE ... ). It works good, but when FK exists, it will create another (exacly the same).

Hi, I have had two times problem with pg database corruption. My system: Dual athlon 2.4 1 GB RAM, linux red hat 7.3 reiserFS Also on the system I have cron that every 3 h. make dump and every 24 h.

Hi. I sent this bug to the bugs mailing list. But the email never turned up on the list. Could somebody here tell me what I'm doing wrong, and why the email won't show up? Am I breaking some unwritten rule of the bugs list? I would really like to see an answer to this. Thanks a lot! -w ---

If I give psql the -A option, does it still wait for all the data to come in before starting output? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Hello all, I have been trying to find some information about exporting data from postgresql on linux to ms-sqlserver 2000 on windows but have not been able to get hold of any information. I would really appreciate if someone can point me to some source of information. Thanks in advance, Nishy

Hm, here's a query where the optimizer is choosing the wrong plan by far. I think it boils down to it guessing wrong on how selective an rtree index is, which I guess would be hard to predict. Except if it guesses wrong by assuming it isn't selective it would be maybe 50% slower doing lots of index lookups instead of a more efficient full...

Hi, I have some problems with creating a query that will replace values in one table from another one. Table 1: userName : refCode1 : refCode2 ------------------------------ alex : 12 : 24

Given this table: CREATE TABLE test ( id SERIAL, example TEXT ); An implicit sequence is created as show in this message: NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for SERIAL column 'test.id' How do I retrieve the last 'id' that was inserted? I have a process

Hi, I need to form a query where i can add some columns based on the result. Table A ColA, ColB ---------- 1 A 2 B

suppose I've got two table: laser_uni=# \d t1 Table "public.t1" Column | Type | Modifiers --------+------+----------- name | text | addr | text | laser_uni=# \d t2

Hello, Where is the tool to migrate a mysql db to a PostgreSQL db ? The only thing I can find is an empty projet in the Gborg http://gborg.postgresql.org/project/mysql2psql/projdisplay.php Thanks in advance :-) ---------------------------------------

Hello list, First of all, excuse me if this is not the right site to ask my question. Is there a way in postgresql to loop to all the fields of a given table and compare the OLD and NEW value for each field. I need to make an audit table that must contain only the fields changed after and insert/update. Thanks in advance

Hello list, First of all, excuse me if this is not the right place to ask my question. Is there a way in postgresql to loop to all the fields of a given table and compare the OLD and NEW value for each field. I need to make an audit table that must contain only the fields changed after and insert/update. Thanks in advance

Is there a way to sort results as follows? Acme The Acme Company Beer A Boat Company Boats Cars ....

Is there a possibility to export Btrieve DB files into postgres ?? Any links with information on the respect? -- 10:17:02 up 8 days, 2:07, 4 users, load average: 1.83, 1.13, 0.84 ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador,...

Hi, I'm really happy to see that pgadmin3 will run on Linux! I tried to build it on Gentoo but got errors. Was anybody of you able to build it for Gentoo or will there be an emerge file? Regards, Christian

After install PostgreSQL 7.3.4, I got a 7.3.3 version no? $ psql template1 Welcome to psql 7.3.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit