are actually already guaranteed by my application logic, so I'm
starting to wonder whether this is becoming more trouble to implement
than it's worth.
Too bad this isn't supported by PostgreSQL (yet).
--
Leon Mergen
http://www.solatis.com
--
Sent via pgsql-general mailing list (pgsql-general
to specifically iterate over all the child
tables, one child table at a time (which 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
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
Apparently a UNION all solved
)
- 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-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
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 (pgsql
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
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
that.
Thanks a lot for your response (Alban too) -- I can see table
partitioning solving my problem.
--
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
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
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
---(end of broadcast
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
---(end of broadcast
/suggestions ? Thanks in advance!
Regards,
Leon Mergen
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
identification number ?
--
Leon
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
identification number ?
--
Leon
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
identification number ?
--
Leon
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
identification number ?
--
Leon
/suggestions ? Thanks in advance!
Regards,
Leon Mergen
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
17 matches
Mail list logo