Re: [HACKERS]
Hi Agustin, I want to know if exists a postgres function or some easy way to know if a PK in a table is already referenced in another table/tables. Unfortunately, this is not the correct mailing list. Instead you should ask these types of questions on either NOVICE or GENERAL. http://www.postgresql.org/community/lists/ HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! Please don't get rid of the MCM and MCA programshttps://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2013/9/6 Agustin Larreinegabe alarre...@gmail.com Hi everyone: I want to know if exists a postgres function or some easy way to know if a PK in a table is already referenced in another table/tables. e.g. I want to delete a row but first I've got to change or delete in the table/tables where is referenced, and I have many table where could be referenced.
Re: [HACKERS] PGCluster-II Progress
I had the same question a while a go. After a lot of googling I found http://www.cybertec.at/english/start_e.html This seems to be an active replacement for the dead? pg-cluster HTH Regards, Serge Fonville On Tue, Sep 15, 2009 at 1:29 PM, Marcos Luis Ortiz Valmaseda mlor...@uci.cu wrote: I was searching info about PgCluster-II yesterday and there is not much information about it. Do can give to me any report of this? Because I need to know the progress of the project. On PgFoundry, only it talks about PgCluster-1.9, but not of the 2.x versions. Who is the PgCluster-II´s developer? Regards The hurry is enemy of the success: for that reason...Be patient Ing. Marcos L. Ortiz Valmaseda Línea Soporte y Despliegue Centro de Tecnologías de Almacenamiento y Análisis de Datos (CENTALAD) Linux User # 418229 PostgreSQL User http://www.postgresql.org http://www.planetpostgresql.org/ http://www.postgresql-es.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] psql password passing problem
Hi, I'd like to inform you about the issue of using psql in a dos batch file on windows vista. On linux all is very simple, you can easily write in your script psql -d mydb -U myuser -f myqry.sql passw.txt On windows however, psql does not seem to work like this, nor does type passwd.txt | psql -d mydb -U myuser -f myqry.sql work So I tried using psql -d mydb -U myuser -f myqry.sql -u PGPASSWORD=xx But this does not work either, so I turned to the pgpass.conf file and it seemed like that didn't work either because I wrote 127.0.0.1:5432:mydb:myuser:xx so I experimented and the hostname command in my dosbox gave me mistral, so I tried mistral:5432:mydb:myuser:xx And this did not work either so at last I tried localhost:5432:mydb:myuser:xx And this worked. I also noticed that PGadmin also displayed my machine as server 8.3 (localhost:5432). Maybe this can be fixed in the future, that an ip-address or name of machine is accepted too ? The first thing that comes to mind is, what is you; listen_address set to? HTH. Regards, Serge Fonville
Re: [HACKERS] navigation menu for documents
All, For a very long time I have thought that it would be useful to have some sort of navigation menu for the docs Oh yes, pretty please :) Navigating the docs requires far too much use of the back button and up links, IMNSHO. A menu frame would make them far more usable. No, please, no frame! Really... Yes, really. What you suggest here is just not adequate, IMNSHO. I don't want to have to scroll to the top or bottom of the page to get navigation, and I want to be able to see the navigation and go where I want directly. I know some people have a violent aversion to frames, but I don't. They have legitimate uses. Frames are (imho) very difficult to maintain. An easy alternative is use of floating divs, possibly combined with javascript to make it fit nicely to the window size. That way, 'breadcrumb' is always visible. And I believe it is a lot easier to set up and maintain (generate) Just my 2ct HTH Regards, Serge Fonville -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
