n single-user mode
instead of the entire service.
What I'm in now is some kind of loop of being unable to get postgres
back up -- anyone has any idea what I can do to find out what the
problem is, and what I can do to solve it ?
Thanks in advance!
Regards,
Leon Mergen
n single-user mode
instead of the entire service.
What I'm in now is some kind of loop of being unable to get postgres
back up -- anyone has any idea what I can do to find out what the
problem is, and what I can do to solve it ?
Thanks in advance!
Regards,
Leon Mergen
27;t be an issue.
>
.. which is a good idea anyway when you're dealing with data which cannot
easily be verified as 'safe' (such as text data) -- it's a great way to
prevent all SQL injections, even when you're not expecting quotes.
--
Leon Mergen
http://www.solatis.com
t
my database design is flawed) ?
Regards,
Leon Mergen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ve this
problem, which can be my problem -- am I missing some technique how
table partitioning can be used to extend a base table with several
extra tables that provide extra information ?
--
Leon Mergen
http://www.solatis.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
llow entries
> with foo='some_type2', and both children have extra fields that
> weren't present in the parent.
Ah, silly that I failed to understand that.
Thanks a lot for your response (Alban too) -- I can see table
partitioning solving my problem.
--
Leon Mergen
http:/
will probably result in even
worse performance, since the 'parent' table is huge).
Am I misunderstanding something here, or is there simple no solution
for what I want ?
Regards,
Leon Mergen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 3/19/08, Leon Mergen <[EMAIL PROTECTED]> wrote:
> Excuse me for bumping this up again, but I still don't understand how
> to use this approach to sequentially walk through all different child
> tables in one select, without having to JOIN these tables all the time
Ap
he child tables together this way.
The EXPLAIN of this query:
Append (cost=0.00..2169.52 rows=34376 width=94)
-> Seq Scan ON child1 (cost=0.00..1824.71 rows=34371 width=94)
-> Seq Scan ON child2 (cost=0.00..1.05 rows=5 width=56)
Regards,
Leon Mergen
--
Sent via pgsql-gener
Hello,
I was wondering, I'm reading that there is no support for foreign keys
to inherited (child) tables -- are there any plans on supporting these
in the (near) future, and/or are there any practical workarounds for
this ?
Regards,
Leon Mergen
--
Sent via pgsql-general mailing list (
Yeah I was thinking about a bunch of triggers too, but was wondering
whether there were any other "elegant" solutions for this. The foreign
keys are actually already guaranteed by my application logic, so I'm
starting to wonder whether this is becoming more trouble to implement
than
be
supported in my use case.
Any ideas/suggestions ? Thanks in advance!
Regards,
Leon Mergen
---(end of broadcast)---
TIP 6: explain analyze is your friend
sion happens
between hashes ? I noticed that the function only returns a 32 bit
number, so I figure it must be at least once in the 4 billion values.
If this approach is not recommended (using hashes as keys), any other
suggestions on how to make the subtable name derivable from an
identificati
sion happens
between hashes ? I noticed that the function only returns a 32 bit
number, so I figure it must be at least once in the 4 billion values.
If this approach is not recommended (using hashes as keys), any other
suggestions on how to make the subtable name derivable from an
identificati
sion happens
between hashes ? I noticed that the function only returns a 32 bit
number, so I figure it must be at least once in the 4 billion values.
If this approach is not recommended (using hashes as keys), any other
suggestions on how to make the subtable name derivable from an
identificati
sion happens
between hashes ? I noticed that the function only returns a 32 bit
number, so I figure it must be at least once in the 4 billion values.
If this approach is not recommended (using hashes as keys), any other
suggestions on how to make the subtable name derivable from an
identificatio
be
supported in my use case.
Any ideas/suggestions ? Thanks in advance!
Regards,
Leon Mergen
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
be
supported in my use case.
Any ideas/suggestions ? Thanks in advance!
Regards,
Leon Mergen
---(end of broadcast)---
TIP 6: explain analyze is your friend
18 matches
Mail list logo
