Re: [ADMIN] problem with foreign key

the point. Did you check that the key is present in trade? IOW, is there a row in trade with tradeid equal to 8415? If not, you cannot create the foreign key because the item in porder1 cannot point to it. -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] Firebird To postgresql migration help needed

application servers such as Tomcat or various Java EE products, and handling applications' build and deployment phases. YMMV. They might represent overkill for some folks. I enjoy the convenience of having everything under one roof. -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin

Re: [ADMIN] Bug introduced in 8.0

properly assess risks and manage them accordingly. -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Regarding access to a user

and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file. Did you perform that step? -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org

Re: [ADMIN] performance cost for varchar(20), varchar(255), and text

. You cannot use them equivalently. I recommend searching the docs as a first approach to finding such answers. -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Resolved - LAN connection to server only after restart server

nice 'sleep 10' in postgresql startup script and now all work well. Thank you so very much, molto grazie, for sharing the solution with us. -- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] high-availability on MS Windows cluster -- need insights

companies to use them, so that they invalidate all their confidentiality markups and are forced to reveal all their secrets to the world. This will benefit the free and open interchange of information. -- Lew ---(end of broadcast)--- TIP 3: Have you

Re: [ADMIN] Error while compiling PostgreSQL with Java

was made an external project instead of bundled with the server source code. The JDBC driver is available from http://jdbc.postgresql.org/download.html Cross-posted to correct the OP's multi-post, so that pgsql.admin will also contain the response(s). -- Lew ---(end

Re: [ADMIN] Error while compiling PostgreSQL with Java

/tutorial/jdbc/index.html SunIYF, PGIYF (in this case, jdbc.postgresql.org IYF) and GIYF. -- Lew ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] Error while compiling PostgreSQL with Java

be looking for the JDBC driver. If so, see http://jdbc.postgresql.org/. Yes, this answer has been provided to the OP already. -- Lew ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Downloading PostgreSQL source code version 7.1 through CVS

that is not a reply. -- Lew ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] varchar vs text columns

or character varying should be used instead. Note that varchar(n) will have a performance effect, because on insert or update you have to check to make sure the input doesn't exceed the specified length. See also Peter Koczan's reply in the '_ in a serach pattern' thread. -- Lew

[ADMIN] Re: My mails to the forum get garbled, and a new line is being inserted. Why? How?

. -- Lew ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq