PostgreSQL Database Forum

Hi, When I Try to write Functions I always become the error That the language plpgsql doesn't exist. I tried it this way: createlang plpgsql template1 createlang -l template1 Procedural languages Name | Trusted? ---------+----------

Hi, I am a Postgres newbie who worked until now with Oracle. Now I want to know if it is possible (when yes the how?) in Postgresql To set dynamically the Localization? For example in Oracle you can set the Localization for dates like this Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America This example would set the...

Hi, Does anyone have any packages for 7.3.4 for debian woody? Thanks in advance, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > "All that is needed for the forces of evil to triumph is for enough good > men to do nothing." - Edmond Burke > "The penalty good people pay for not being interested in politics...

The subject says it really. Is there a way to query the value of $libdir, and I don't mean the dynamic_library_path GUC? I ask because, I have scripts to create databases and I've come to make adjustments to load tsearch2. Now contrib/tsearch2 installs itself into $libdir with tsearch2.sql installed as $libdir/contrib/tsearch2.sql. So my...

Hi All, I've noticed that in the pg_type system table, there is a data type called "name", would that represent the definition of the table name space, including the max length a talbe name space could be? If so where would I find the same definition for the max name space for a sequence, or index... -- Chris Bowlby <excalibur@hub.org>

I'm having a problem with the backend occasionally crashing. I have interfaces with the database in two different applications -- a web viewer using JDBC and an insertion routine written using the c libraries. It makes fairly heavy use of the tsearch protocol. (I haven't been able to figure out anything repetitious, it happens at...

I understand that ObjID of LOCKtag recognizes each individual row locked by a row level lock. BUt i have noticed that if i lock 2 different rows of the same table they have the same blkno. is this deduction ok? thanks jenny _________________________________________________________________ Get MSN 8 and help protect your children with...

I find I often want to be able to do joins against views where the view are aggregates on a column that has an index. Ie, something like SELECT a.*, v.n FROM a JOIN (select a_id,count(*) as n group by a_id) as v USING (a_id) where there's an index on b.a_id. assume there are other tables being joined so I can't just move the aggregate to...

hi all, i am planning to build a database (a dictionary in fact) that i will eventually want to distribute on a cd (or downloadable iso). what i would like to know is if this is technically possible with postgresql. and how exactly would it be done? would i have to make postgresql run off the cd, or should it first be installed to the hard...

Hi, I have tables that have default records that must not be deleted or modified. Is there an easy way to do this. Like setting a trigger on the Primary key value ? Alex

Hi, I have a problem with permissions for SELECT. Here is what I did: test=> GRANT SELECT ON "poi"."fondsstamm" TO "flex"; GRANT test=> \dp fondsstamm; Access privileges for database "test"

Hi, I would like to know if there is a Function in Postgres Like the add_months Function in Oracle?? Thanxx Schoeib 4Tek Gesellschaft für angewandte Informationstechnologien mbH Schoeib Amin

Hi to all ... I'm looking to a way to auto update some fields of a row when other fileds are updated. the table structure are simple, CREATE TABLE param ( id int4 PRIMARY KEY, val int4,

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

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

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,...

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

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

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, 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 :-) ---------------------------------------

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

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

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 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

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...