ade.
You missed 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
or popular Java 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 maili
f not
upgrading, so they can 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
tart-up 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 (
differ.
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
yet.
So I added 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.pos
using pg_dump?
You can specify with -n and -t an arbitrary table and with -s you get
only the DDL, not the data.
The "-s" option has come up as an answer to both multi-posted instances of
this question.
--
Lew
---(end of broadcast)---
protect.
We should encourage all 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)
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
---(e
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
;http://java.sun.com/docs/books/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
ad by sending a post that is not a reply.
--
Lew
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
for Usenet posts.
--
Lew
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
14 matches
Mail list logo
