Re: [GENERAL] postgres under Suse linux

Antonios Katsikadamos wrote: Hi all I am a new linux and postgres user and i don't know how i canconfigure the postgres on suse linux in order to make it run. I would be thankful for any tip. Antonios, Finally I have installed successfully PostgreSQL 8.1.5 under a clean OpenSUSE 10.0 64-bit

[GENERAL] User-interfaces with transaction support

Hello, I'm looking for a UI concept for my model-driven development tool which works with Python and PostgreSQL, and a thin ORM layer between. On the application and database layer it supports transactions (just wrapped the PostgreSQL features). Now I want to add also UI support to the proto

[GENERAL] Self-referencing and inherited table

Hello! I want to realize some kind of parent-child relation with-in a table, but have problems with foreign key / references. Probably this issue occurs because I use inheritance (as implied by some pages, I found). In the mailing list archive I couldn't find appropriate solutions, but maybe I

[GENERAL] Debugging SQL queries

I have sometimes very long queries, for example in setup-purposed sql file where plenty of tables of a new database are created in a single transaction. 600 lines of code or more is common. Sometimes, while developing, an error may appear after submitting such a query for testing purposes via

Re: [GENERAL] Debugging SQL queries

Douglas McNaught wrote: Emacs has the "goto-char" function and runs on Windows, so you could use that (there are probably other editors with this feature as well).. Doug, thank you. I will use it. - Ha, I never thought I will ever use legendary Emacs. Probably I will even become an entry-clas

Re: [GENERAL] Announce: GPL Framework centered on Postgres

Kenneth Downs wrote: My company has developed an application development framework that targets PostgreSQL as its back-end, with PHP in the web layer. Is this product somehow related to AndroMDA (which is usually pronounced 'Andromeda')? http://www.andromda.org/ Greetings, Anastasios ---

[GENERAL] Difference between function and procedure?

Hi, I'm diving more into depth of the features outside the typical table stuff, which I usually need. I wrote a trigger that fires a function written in PL/Python, both works fine so far. But as I browsed my database via pgAdmin3 I recognized that there is also 'Procedures' under 'public'

Re: [GENERAL] Difference between function and procedure?

Merlin Moncure wrote: there are differences. PostgreSQL only really supports functions and on the lists they are used interchangably. on the -hacker list about a year back there was a good discussion about implementing true SP and why they would be needed. mainly, SP are not externally transact

[GENERAL] Duplicating rows in one table but with one column value different

Hi folks, I have multiple tables where some of the rows need sometimes to be duplicated, but where the copy record has in one column a different value. I have an idea how I could realize this via functions, but probably you have another suggestion? Example table: CREATE TABLE "FooHolding" (

Re: [GENERAL] Duplicating rows in one table but with one column value

Anastasios Hatzis wrote: rows = plpy.execute("""SELECT "FooHolding" WHERE "CoosOfFoo_vid" = ORIGINALVALUE;""") for row in rows: for col in row: plpy.execute("""INSERT INTO "FooHolding" ("CoosOfFoo_eid&