[SQL] [pgmail] - I have problems with pgmail
I install language and all codes ... but I have problems with text in french with accents "ééé èèè" The datas are correct in database but tcl does not recognize the format and trnasform accents when I send mail ! ... What could I do ? ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [SQL] Recursive request ...
I see connect by in Oracle ??? is there an equivalent in PostgreSQL or not ?? Rajesh Kumar Mallah a écrit: Dear Bournon, There are already good implementation of Tree structures in databases ranging from using pure SQL to PostgreSQL specfic methods , less point in revinting wheel unless u really need. Some Pointers: "Tree-structure functions" http://www.brasileiro.net:8080/postgres/cookbook/ Gist Based: contrib/ltree Joe Celko's Article on "Nested Sets & Adjacency Lists" http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=adjacency+list+%2B+tree+%2B+joe On Wednesday 09 Jul 2003 8:57 pm, Benoît Bournon wrote: I have to make a function that returns a tree with title and link of a table. Recursively, a information depends on a parent information. It is to organise a menu with parent dependance. How is it possible and faster ? in C ? pl/pgsql or other ? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] Is it possible to connect to another database
Hi, I try to find how is it possible to connect 2 databases, with a symbolic link. I have to use tables in another database to test user or other information. Ben ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[SQL] Books in french
For all french people in this list : I search books about postgresql in French with explanations of tree structure functions, optimisation of install not novice books Thx a lot ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
I have to duplicate a table to save different instances of datas.
Structure de la table "spectacle"
*/
CREATE TABLE "spectacle" (
id_spectacle SERIAL,
"id_membre_adherent" INTEGER NOT NULL,
"id_genre_festival" INTEGER,
"id_festival" INTEGER,
"nom" VARCHAR(255),
"compagnie_interprete" VARCHAR(255),
"vitaculture" INTEGER NOT NULL,
"regionales" INTEGER NOT NULL,
"presentation" TEXT,
"genre_precision" VARCHAR(255),
"duree" VARCHAR(255),
"photo1" VARCHAR(255),
"photo1_credit" VARCHAR(255),
"photo2" VARCHAR(255),
"photo2_credit" VARCHAR(255),
"salle" TEXT,
"tarifs" TEXT,
"id_traitement" INTEGER DEFAULT 1,
"distribution" TEXT,
"type_public" VARCHAR(255),
PRIMARY KEY("id_spectacle"),
FOREIGN KEY ("id_festival") REFERENCES "festival"("id_festival")
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE,
FOREIGN KEY ("id_genre_festival") REFERENCES
"genre_festival"("id_genre_festival")
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE,
FOREIGN KEY ("id_membre_adherent") REFERENCES
"membre_adherent"("id_membre_adherent")
ON DELETE CASCADE
ON UPDATE RESTRICT
NOT DEFERRABLE,
FOREIGN KEY ("id_traitement") REFERENCES "traitement"("id_traitement")
ON DELETE RESTRICT
ON UPDATE RESTRICT
NOT DEFERRABLE
) WITH OIDS;
CREATE INDEX "adherant_spectacle_fk" ON "spectacle"
USING btree ("id_membre_adherent");
CREATE INDEX "genre_spectacle_fk" ON "spectacle"
USING btree ("id_genre_festival");
CREATE INDEX "spectacle_au_festival_fk" ON "spectacle"
USING btree ("id_festival");
When I duplicate this code in an other table named spectacle_v without
Foreygn key ... all is running.
But when I try to delete a spectacle_membre, linked value in spectacle
are correctly deleted, but I have an error for spectacle_v which is not
linked :
(ERROR: referential integrity violation - key in membre_adherent still
referenced from spectacle_v )
I do not understand this message error, because any foreign key is
referenced with this table.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
No trigger Just triggers for foreign key in spectacle and none in spectacle_v How is it possible to verify triggers for foreign keys ? Stephan Szabo a écrit: On Fri, 8 Aug 2003, BenLaKnet wrote: When I duplicate this code in an other table named spectacle_v without Foreygn key ... all is running. But when I try to delete a spectacle_membre, linked value in spectacle are correctly deleted, but I have an error for spectacle_v which is not linked : (ERROR: referential integrity violation - key in membre_adherent still referenced from spectacle_v ) What triggers are defined on membre_adherent? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
we make a dump before ... and with a product pgmanager (ems tech) we do not show any foreign keys. But I think all of triggers of referenced table are not deleted. We recreate the schemas ... and now it's running. How is it possible to identify Triggers with no referenced tables ? Stephan Szabo a écrit: On Mon, 11 Aug 2003, BenLaKnet wrote: How could I do a pg_dump -s ?? on local server ?? Yes. I figured you wouldn't want to send your backups with data (I assume you have pg_dump generated backups ;) ). You can use pg_dump locally or remotely (using -h and -p options). Locally, log in as the postgres user and run pg_dump -s , remotely do pg_dump -s -h -p I believe.
Re: [SQL] Insert a description while creating a table
create table test ( id serial , name varchar(50) ); COMMENT ON TABLE "test" IS 'MySQL table id_training_form ... id_form_unique'; comment on COLUMN "test"."id" is 'greigjreoigjreigjore iojrjiogre' ; Doc postgresql comment Rod Taylor wrote: On Wed, 2003-08-13 at 07:56, [EMAIL PROTECTED] wrote: Hi, I want to insert descriptions at the columns of my tables but without using the command COMMENT ON. I want to do it together with the table creation. Is that possible? I wanna do something like this: create table test ( id serial 'Descripitions about ID', name varchar(50) 'Descriptions about NAME' ); Probably not going to happen in the backend. However, you should be able to accomplish that with a little bit of Perl to pre-process the SQL.
Re: [SQL] [ZODB-Dev] What are the ZopeDB limit?
just one question You use zope with postgresql ?? No problem of connection ? Michele Bendazzoli wrote: On Mon, 2003-08-25 at 09:12, Michele Bendazzoli wrote: ops ... apologies for the message. Michele ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[SQL] [pg-sql] Character encoding
How is it possible to convert a database in SQL_ASCII to UNICODE ? Thx a lot Regards Ben ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [SQL] connectby
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
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
integer, parent_id integer, level int, branch text);
id | parent_id | level | branch
+---+---+-
2 | | 0 | 2
4 | 2 | 1 | 2~4
7 | 4 | 2 | 2~4~7
10 | 7 | 3 | 2~4~7~10
16 |10 | 4 | 2~4~7~10~16
9 | 4 | 2 | 2~4~9
How am I able to select description file from menu table, not only id,
parent_id, level, branch fields?
--
WBR, sector119
Try a join with the original table:
SELECT t.*, description FROM connectby('menu','id','parent_id','2',0,'~')
AS t(id integer, parent_id integer, level int, branch text), menu
WHERE t.id = menu.id
George Essig
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [SQL] postgresql and ColdFusion
Benoît BOURNON wrote: Oh dear a man using CF with postgresql ! ... OH YES ! ... try to use jdbc pilot to connect to postgresql with CFMX ... maybe you can use cfstoredproc with cfprocparam and cfprocrsult Roberto Mello wrote: On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote: Hi, How to call PostgreSql function from ColdFusion, if that function returns result set using cursor? Through ODBC. Don't know it they have native access now. -Roberto
Re: [SQL] Triggers
I try pgmail and that is well running ... fo security, do not use attachment files with your mail ... try pgmail, you need to use pl/tclu ... Ben Sai Hertz And Control Systems wrote: Dear Uzo , Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? http://pgmail.sourceforge.net/ is what you need. Regards, Vishal Kashyap ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] designer tool connect to PostgreSQL
Rekall ... http://www.totalrekall.co.uk/ (commercial website) http://www.rekallrevealed.org/ (free sources) for designing different RDBMS like mysql, postgresl, oracle and other ... free with sources ... but packages for windows or linux are not free. Ben Yasir Malik a écrit : Well, there's phpPgAdmin. It's available at http://phppgadmin.sourceforge.net/ Yasir On Mon, 8 Mar 2004 [EMAIL PROTECTED] wrote: Date: Mon, 8 Mar 2004 10:13:53 +0800 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [SQL] designer tool connect to PostgreSQL Hi, i use postgresql as my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools can handle design task like create table , etc . appreciate if u can give the specific URL. thanks in advance. ---(end of broadcast)--- TIP 8: explain analyze is your friend
