In article
,
"Jaiswal Dhaval Sudhirkumar" wrote:
> E-R data modeling
Couldn't find the E-R data modeling and Open System Architect doesn't
support Mac OS. Forgot to mention that latter in my original post.
dbwrench fails to connect to my database even though psql connects just
fine. go fi
Hi all,
Anyone have a suggestion for a graphical ER tool that can work with
Postgresql's domains and custom types?
I was using Mogwai designer but it can't reverse engineer a DB with the
above.
tia,
arturo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Hi all,
Is there currently anyway in 9.0 to use FTS to search for words that are
next to each other?
For example, I want to search for Abraham next to Lincoln and ignore
things like 'Abraham Johnson who lives in Lincoln Nebraska'.
tia,
arturo
--
Sent via pgsql-general mailing list (pgsql-gen
In article <1296066333.11513.364.camel@jdavis>,
Jeff Davis wrote:
> On Wed, 2011-01-26 at 09:27 -0500, Arturo Perez wrote:
> > > and yet when I do a select distinct with a join I get
> > >
> > > QueryLogger - *** error.
> > > org.postgresql.uti
In article ,
art...@pleeque.com (Arturo Perez) wrote:
> Hi all,
>
> I'm using the temporal contrib package that creates the period type and
> a bunch of operators in postgresql 8.4.5. I plan to use the same code
> against 9.0 so if anything differs between the two
Hi all,
I'm using the temporal contrib package that creates the period type and
a bunch of operators in postgresql 8.4.5. I plan to use the same code
against 9.0 so if anything differs between the two regarding this issue
please let me know.
In psql the \do command shows this
public | =|
Didn't someone make an iPod touch app version of pgadmin?
There's this
http://itunes.apple.com/us/app/dataglass-postgresql/id390298877?mt=8
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gener
On Thu, 22 Mar 2007 14:36:32 +0100, Andy Dale wrote:
>
> testdb=# SELECT film_name, xpath_list(description, 'year') FROM filminfo;
> film_name | xpath_list
> --- +
> Casablanca | 1942
> Rear Window | 1954
> The Godfather | 1972
> Test film | 1973,1972
On Wed, 21 Mar 2007 08:57:39 -0700, Benjamin Arai wrote:
> Hi Oleg,
>
> I am currently using GIST indexes because I receive about 10GB of new data
> a week (then again I am not deleting any information). The do not expect
> to be able to stop receiving text for about 5 years, so the data is not
On Feb 10, 2007, at 12:34 PM, Tom Lane wrote:
Arturo Perez <[EMAIL PROTECTED]> writes:
Saturday I changed a table to add a varchar(24) and a TEXT column.
You didn't actually say which of these tables you changed?
I'm not very good at reading these but it looks like sort me
On Feb 10, 2007, at 12:34 PM, Tom Lane wrote:
Arturo Perez <[EMAIL PROTECTED]> writes:
Saturday I changed a table to add a varchar(24) and a TEXT column.
You didn't actually say which of these tables you changed?
Sorry, I changed extended_user.
I'm not very good at read
On Feb 9, 2007, at 11:43 AM, Merlin Moncure wrote:
On 2/8/07, Arturo Perez <[EMAIL PROTECTED]> wrote:
Hi all,
Saturday I changed a table to add a varchar(24) and a TEXT column.
It's used for some reporting purposes (small potatoe stuff really)
and the TEXT column remains m
Hi all,
Saturday I changed a table to add a varchar(24) and a TEXT column.
It's used for some reporting purposes (small potatoe stuff really)
and the TEXT column remains mostly empty. However, this week
performance has gotten terrible. Queries joining against the
aforementioned table h
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Joshua D. Drake") wrote:
>
> I also have not been able to duplicate the problem from multiple yahoo
> and gmail tests. I did however note that postgresql.org will not let you
> subscribe as [EMAIL PROTECTED] . Is .not even a valid suffix?
>
>
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Jim C. Nasby") wrote:
> The problem is that you can't actually get
> a good n_distinct estimate if you're sampling less than a very large
> chunk of the table. Since our sampling maxes out at something like 30k
> pages, at some point the n_disti
Title: PostgreSQL slammed by PHP creator
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
"If you can
From: Alban Hertroys [mailto:[EMAIL PROTECTED]
>Arturo Perez wrote:
>> In any case, at this point in time it's looking like Cayenne doesn't honor
>> the rules of the sequence. It appears to (and is documented as) internally
>> incrementing rather than fetching the
From: Alban Hertroys [mailto:[EMAIL PROTECTED]
>Martijn van Oosterhout wrote:
>> On Thu, Sep 07, 2006 at 07:15:43AM -0400, Arturo Perez wrote:
>>> iht=> select max(article_id) from article;
>>> max
>>> --
>>> 4992
>>> (1 row
On Sep 7, 2006, at 5:35 AM, Alban Hertroys wrote:
Arturo Perez wrote:
What happens is that if I do a select nextval('seq') I get a number
that's lower than the
max primary key id. This is inspite of my doing
SELECT setval('seq', ((SELECT MAX(seq_ID) FROM table)+
On Sep 6, 2006, at 8:48 PM, Merlin Moncure wrote:
On 9/6/06, Arturo Perez <[EMAIL PROTECTED]> wrote:
What happens is that if I do a select nextval('seq') I get a number
that's lower than the
max primary key id. This is inspite of my doing
SELECT setval('seq&#
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Scott Marlowe) wrote:
> On Wed, 2006-09-06 at 16:56, Arturo Perez wrote:
> > Hi all,
> >
> > My environment is Tomcat5.0, Cayenne 1.2 and PostgreSQL 8.1.4 on a
> > RedHat ES3 machine.
> >
> > My w
Hi all,
My environment is Tomcat5.0, Cayenne 1.2 and PostgreSQL 8.1.4 on a
RedHat ES3 machine.
My webapplication is reusing sequence numbers and getting duplicate
primary key
failures because of it (error is "duplicate key violates unique
constraint"). The
columns are not defined as SERIAL for
In article <[EMAIL PROTECTED]>,
kleptog@svana.org (Martijn van Oosterhout) wrote:
> On Sat, Aug 26, 2006 at 03:51:06PM -0400, Perez wrote:
> > Hi all,
> >
> > Using 8.1.4 and contrib/xml2. When I do a
> >
> > select xpath_string(note, '//Thing') as note,
> >count(aDate) from theTable
> >
x the issue.Chris
On 8/21/06, Arturo
Perez <[EMAIL PROTECTED]>
wrote:
Hi all,
Using postgresql 8.1.4
I have a table with an column:
entry_date | timestamp with time zone| not null
And when I try to create an index on it like
so: c
On Aug 22, 2006, at 5:35 PM, Tom Lane wrote:
"Arturo Perez" <[EMAIL PROTECTED]> writes:
I have a table with an column:
entry_date | timestamp with time zone| not null
And when I try to create an index on it like so:
create index entry_date_idx on =
user_tr
Title: [8.1.4] Create index on timestamp fails
Hi all,
Using postgresql 8.1.4
I have a table with an column:
entry_date | timestamp with time zone| not null
And when I try to create an index on it like so:
create index entry_date_idx on user_tracking(date_part('yea
26 matches
Mail list logo
