PostgreSQL Database Forum

hi I have menu table: id | integer | not null default nextval('public.menu_id_seq'::text) parent_id | integer | description | text | I do select: test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~') t(id

Hi Is it possible to implement Queuing automatically in PostgreSQL thru' a package or something or it has to be coded ? Just fyi.. -> This feature is available with Oracle 8i. Thanks Parul

hello, it is possible to write something similar??? create function get_count(varchar(32)) RETURNS int4 AS ' DECLARE tmp int4; BEGIN SELECT COUNT(*) INTO tmp FROM $1; RETURN tmp;

Ladies and Gentlemen, Please, enlighten me, if you can, in the following matter: I made a type: create type my_type as ( a integer, b integer );

Hi, I created a simple table (name char200, zip char10, city char200, street char200, id int) and filled some data, appr. 250 000 records, in it. I tested accessing some rows (select id from address where id = 44444;, select * from address where id between 33333, 333444) with an unique index on id and without an index. EXPLAIN tells me in both...

Hello there, I have quite problem with PG 7.3 & 7.4b5 I create tables using pgAdmin3 v-1.0.1 I created a table "xType". Pay attention to capital "T" letter. Than I tryed to insert data to it using psql tool. But I have error: 'ERROR: relation "xtype" does not exist' In error all chars are small! If I create table in pgAdmin using all...

I have a job-processing backend written in perl, talking to a (of course) postgres database. The perl app has a master process that checks the database periodically for jobs that need processed. When there are available jobs, it grabs some number of them (up a few hundred), and fork()'s to create job processing processes, one per job, again...

running - (PostgreSQL) 7.1.3 I have loaded a table with stock market data. - - - ZRAN |2003-09-29| 20030929| 731487| 20.81| 20. ZRAN |2003-09-30| 20030930| 731488| 19.43| 20.1 ZRAN |2003-10-01| 20031001| 731489| 19.82| 19.9

Hi All, I've a problem using PGAdmin III. When I click on one of my functions the definition pane shows an empty function (with the correct header and footer but with no body). Pg_dump shows everything correctly. What can be the problem. My other problem is that PGAdmin won't handle '?' (euro) sign. It shows the previously correctly enterd...

I am in the process of adding PostgreSQL support for an application, in addition to Oracle and MS SQL. I am using PostgreSQL version 7.3.2, Red Hat 9.0 on Intel Pentium III board. I have a query that generally looks like this: SELECT t1.col1, t2.col1 FROM t1, t2 WHERE t1.x=t2.y AND t2.p='string' AND t2.q=1 This query is strikingly...

Here's the basic issue: PostgreSQL doesn't use indexes unless a query criterion is of exactly the same type as the index type. This occurs even when a cast would enable the use of an index and greatly improve performance. I understand that casting is needed to use an index and will therefore affect performance -- the part I don't understand is...

I have this notorious problem: at some point pgsql simply hangs up and requires a restart. --------------------------------------------------------------------------- ------- homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart Restarting PostgreSQL database: postmaster Stopped /usr/lib/postgresql/bin/postmaster (pid...

Hi Everyone, I'm on just about all the postgres lists, except the advocacy one... I'm not sure if this has been posted before, but this story has an amusing quote: <quote> MySQL is also upsetting the entire database market. Charles Garry, an analyst at Meta Group, hails it as "a disruptive technology" that's commoditizing databases --...

On small productions systems, single disk, etc, how do you guys like to partition the system? Postgres dirs also? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Generates: Can't locate object method "get_message" when I try to execute certain prepared statements. Other prepared statement executions seem to work fine. Am running ActiveState Perl and Cygwin on an XP machine. Saw a similar message posted to the list but no follow-on thread and archive search didn't return any results. --

Hi All, Where can I find minor release information between versions: 7.3.1 and 7.3.4. And when is 7.4 expected, and should I hold off before upgrading to 7.3.4? I looked around but was unable to find this information.

Howdy. I looked around for an answer to this, but I was unable to find one that seemed to match my situation. (Incidentally, now I cannot get archives.postgresql.org to respond to my search query...) I'm trying to build 7.3.4 on Libranet2.8.1 (debian). I've built PostgreSQL many times in the past on stock RedHat distros and had no...

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 Any idea what this might be? -Dan

Hi, Is there any performance diference between the following SQL commands: SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1&word2|word3'); SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1') AND content_ix @@ to_tsquery('word2') OR content_ix @@ to_tsquery('word3'); I'm having to do this on some complex querys...

I have a table that II am constantly inserting into (around 10 times a second right now but hope to increase latter). I hold these rows for a week then summarize and delete them. During that week I need to access ranges of these rows based on a timestamp in each row set to now() when I insert them. I have this column indexed but if I let...

Hello! Oracle has the option with the SQL CONECT BY statement to run through a hierarchical database with a single SQl-statement: <!--SQL SELECT ms_id,ms_parent FROM messages CONNECT BY PRIOR ms_id = ms_parent START WITH ms_id = 1 --> Result-set (example): ms_id parent_id 1 1.1 1 1.1.1 1.1 1.1.2 1.1 1.1.3 1.1 1.2 1 1.2.1 1.2

Please CC me, I am not subscribed. An imaginary SQL statement INSERT INTO table FETCH ... FROM cursor; looks almost the same as currently available INSERT INTO table SELECT ...; I tried it because I needed to insert a row in a table after I DELETEd a set of rows, something like this:

I posted this to 'questions' yesterday instead of 'general' by mistake. Sorry if anyone received duplicates. ---------------------------------------------------- Mandatories: Ver 7.3.4, Redhat Linux 8.0, P4, 2GB RAM I want to add a 'nullable' foreign key to a column in a table. I have tables "company" and "project" which may be related by...

Is it possible to do something like: select 1 as a, a*a; in postgres?

please unsubscribe me from this list ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org