on of PostgreSQL and drop all of
the 'RI_ConstraintTrigger_' trigger and recreate the foreign keys.
George Essig
MySQL 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
data as INSERT commands (rather than COPY). This will make
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
o the bash script?
You can use '\! [ 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
(
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
l says the following about RESTRICT:
"Produce an error indicating 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
ently as possible, I update the search_path 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
-
mple.html
http://www.rbt.ca/autodoc/output-graphviz.html
George Essig
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--- "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 dra
eriods. Transaction time periods can be used to reconstruct the state 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)
su.su/~megera/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/
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/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
> 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
---(e
r own content types. See:
http://ez.no/developer/ez_publish_22
http://ez.no/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 doubl
QL 7.2.3 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
in with the original table:
SELECT t.*, description FROM connectby('menu','id','parent_id','2',0,'~')
AS t(id integer, parent_id integer, level int, branch text), menu
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
