of
the 'RI_ConstraintTrigger_' trigger and recreate the foreign keys.
George Essig
and PostgreSQL. For more on drupal,
see http://drupal.org.
George Essig
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
restoration very slow, but it makes the archives more portable
to other SQL database packages.
George Essig
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
'\! [ command ]' to execute shell commands within psql.
This may not be what you want though.
George Essig
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
On Fri, 11 Mar 2005 13:26:07 +0100, Steven Verhoeven
[EMAIL PROTECTED] wrote:
My table definition :
id | fref | mref
--+---+--
1 | 23| 25
2 | 24| 28
3 | 25| 31
4 | 26| 34
i need a query that results in
that the deletion or update would create
a foreign key constraint violation. This is the same as NO ACTION
except that the check is not deferrable.
George Essig
---(end of broadcast)---
TIP 8: explain analyze is your friend
to include the new schema
to avoid explicit
references. The only problem is that the search_path is stored in the catalog
and not outputted
in pg_dump files. You have to remember to set the search_path after restoring
the database.
George Essig
---(end of broadcast
/autodoc/output-graphviz.html
George Essig
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
of a database
at a
specific point in time. I didn't read this part as closely and haven't implemented
these ideas.
Hope this helps,
George Essig
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
--- Eric D. Nielsen [EMAIL PROTECTED] wrote:
Thanks for the Snodgrass reference, it is rather similar and pre-dates
the book I was looking at. (Same notion of valid/transaction times,
but Date's non-SQL approach) From a quick skim it doesn't address the
distinction Date et al draw
/postgres/gist/tsearch/V2/docs/oscon_tsearch2/readme_detail_01.html
There's a typo on this page 'pg_configure --configure' should be 'pg_config
--configure'.
George Essig
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
/docs/tsearch-V2-intro.html
Install the file regprocedure_7.4.patch.gz, then load the following into your database.
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql
George Essig
---(end of broadcast)---
TIP 1: subscribe
hi all
Are there any other docs about tsearch2 except for the 3 docs in
\contrib\tsearch2\docs
i want some tech docs on tsearch2 thank all
See http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
George Essig
---(end of broadcast)---
TIP
/developer/ez_publish_3
George Essig
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--- Oleg Bartunov [EMAIL PROTECTED] wrote:
On Thu, 6 Nov 2003, George Essig wrote:
Thanks for the reply. For this project, I can update the data and reindex during
off-peak
hours.
I was just surprised to see the size of the index double after heavy write
activity
and there was no contrib/tablefunc
directory.
You'll have to upgrade.
George Essig
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
WHERE t.id = menu.id
George Essig
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
17 matches
Mail list logo