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 programs<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table> 2013/9/6 Agustin Larreinegabe > 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 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
