Jeff, this is *exactly* the kind of feedback I was hoping to get.
Thanks so much for the link and the explanation.
Matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I don't see that working using arrays here. Can you elaborate please ?
knee deep in a schema design myself ..curious as to which advice did jeff offer
for schema design?
thanks
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This
Hello
2008/10/12 Grzegorz Jaśkiewicz [EMAIL PROTECTED]:
I don't see that working using arrays here. Can you elaborate please ?
select * from foo where a = any ($1)
postgres=# select 1 = any(array[1,2,3]);
?column?
--
t
(1 row)
regards
Pavel Stehule
--
Sent via pgsql-general
Dear All,
I have just started experimenting with PGSQL, with a view to migrate from the
SQL server I use currently. I am trying to implement an intelligent Chart of
Accounts for an accounting program. The following is long-winded but please
bear with me:
I have a table coa (chart of
On Oct 11, 2008, at 6:41 PM, Joshua Tolley wrote:
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire
[EMAIL PROTECTED] wrote:
Hi all!
I would like to run all my databases in a readonly mode just for a
few
hours (migration plan).
Is it a way to tell the postgresql engine to run in
On Sun, 2008-10-12 at 09:25 +0530, Raj K wrote:
Since it is in windows - I could not find any specific file permission
mechanisms similar to linux. (This is my first foray in windows - so I
am a newbie there too )
The computer is not in a network. So, through googling, I found that
to share
On Sat, Oct 11, 2008 at 05:10:26PM +, Matthew Wilson wrote:
I need to track employees and their preferred locations, shifts, and
stations.
As always there's a trade off between general EAV style designs and
more specific ones (as noted by Jeff). One, more EAV style, design that
sprung to
On Sun, Oct 12, 2008 at 08:12:40PM +0100, I wrote:
As always, it's a trade off between what you're optimizing for. If
you're adding more preference types then go for a EAV style design, if
you're going to want to add more details about the preferences (this
does seem to be the common case,
On 12/10/2008 04:55, Raj K wrote:
Since it is in windows - I could not find any specific file
permission mechanisms similar to linux.
To see the file permissions, right-click on the file and look at the
Security tab - it lists users and their permissions on the file.
Ray.
Hi,
Released new sets:
http://people.planetpostgresql.org/devrim/index.php?/archives/124-New-shapshot-RPMs-Oct-11-2008-are-ready-for-testing.html
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
that would be a type mismatch, heh.
admin wrote:
Sorry folks, a perennial one I'm sure ...
I have read the manual and Googled for a couple of hours but still can't
connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date
CentOS 5.2).
I continually get this message:
psql: could not connect to server: No such
could you provide a brief explanation of EAV ?
thx
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does
You are making this far to complicated.
I just redid the accounting side of an application we have access to
source code, so been here and done this.
If i was not for the rest of the application i would have completely
redone the accounting table layout something like this
3 Accounting
On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
could you provide a brief explanation of EAV ?
Instead of:
create table vehicles
(
kind text primary key,
wheels int
);
insert into vehicles (kind, wheels) values ('car',4);
insert into vehicles (kind, wheels) values
On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot [EMAIL PROTECTED] wrote:
On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
could you provide a brief explanation of EAV ?
(...) in an EAV model you would do something like:
create table eav
(
kind text primary key,
attr text,
value text
);
Hi there,
I've been toying with using PostgreSQL for some of my Drupal sites for
some time, and after his session at OpenSourceDays in Copenhagen last
weekend, Magnus Hagander told me that there a quite a few in the
PostgreSQL community using Drupal.
I have been testing it a bit
On Oct 12, 2008, at 11:57 PM, Mikkel Høgh wrote:
In any case, if anyone has any tips, input, etc. on how best to
configure PostgreSQL for Drupal, or can find a way to poke holes in
my analysis, I would love to hear your insights :)
I just came across this article about moving Drupal from
On Sun, Oct 12, 2008 at 9:57 PM, Mikkel Høgh [EMAIL PROTECTED] wrote:
Hi there,
I've been toying with using PostgreSQL for some of my Drupal sites for some
time, and after his session at OpenSourceDays in Copenhagen last weekend,
Magnus Hagander told me that there a quite a few in the
* Mikkel Høgh ([EMAIL PROTECTED]) wrote:
I have been testing it a bit performance-wise, and the numbers are
worrying. In my test, MySQL (using InnoDB) had a 40% lead in
performance, but I'm unsure whether this is indicative for PostgreSQL
performance in general or perhaps a
I have been testing it a bit performance-wise, and the numbers are
worrying. In my test, MySQL (using InnoDB) had a 40% lead in
performance, but I'm unsure whether this is indicative for PostgreSQL
performance in general or perhaps a misconfiguration on my part.
In my experience the numbers
22 matches
Mail list logo