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
===x
the path expanded by a distance
| | A |
| | |
---x=x===x--- C
| | |
B | | |
the points A and B are inside and the point C are outside .
Suggestions are welcome.
Thanks in advance,
Josi Perez
use this
regular expression
~
regular expression - case insensitive
~*
example
SELECT name FROM table1 where name
~* '*Ã*'
check here
http://www.postgresql.org/docs/current/static/functions-matching.html
--- El lun 23-jun-08, Ian Meyer
--- El lun 23-jun-08, Daniel Futerman <[EMAIL PROTECTED]> escribió:
De: Daniel Futerman <[EMAIL PROTECTED]>
Asunto: [GENERAL] Update Join Query
A: pgsql-general@postgresql.org
Fecha: lunes, 23 junio, 2008, 4:43 pm
Hi,
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.
--- El lun 23-jun-08, Daniel Futerman <[EMAIL PROTECTED]> escribió:
De: Daniel Futerman <[EMAIL PROTECTED]>
Asunto: [GENERAL] Update Join Query
A: pgsql-general@postgresql.org
Fecha: lunes, 23 junio, 2008, 4:43 pm
Hi,
Looking for the correct syntax for an UPDATE LEFT JOIN query in PostgreSQL.
ive account...
I would like to keep an demonstration database in this external hard drive
and would like to attach this HD in different Windows PCs. Start manually
without change the user machine it is a better solution for me and
generally, the user is in an administrative account.
Any ideas?
Thank you.
Josi Perez
I'm trying install postgreSQL in an external HD, but I don't know how to
change the root directory.
By default the installation uses drive C:
Is it possible to change to F: (for example)?
Thanks in advance,
Josi Perez
rmatted in NTFS.
NTFS is a default on Format Window and I did not change this.
Driver properties show that is an NTFS filesystem: Windows Explorer and
Control Panel/Administrative Tools.
What can be wrong?
Thanks in advance,
Josi Perez
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&
Hi all,
Using 8.1.4 and contrib/xml2. When I do a
select xpath_string(note, '//Thing') as note,
count(aDate) from theTable
group by lower(xpath_string(note, '//Thing'))
order by 2 desc;
I get an error:
GROUP BY must contain note.
But I can do that for a plain text/varchar field. Adding t
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
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Tom Lane) wrote:
> Martijn van Oosterhout writes:
> > I beleive you can set it to EXTERNAL, which it will always toast.
>
> I don't think that will help; if the overall row size is below the
> threshold, the code is not going to pick it apart t
Hi all,
I'm in the planning stages of replacing a MySQL DB using ISAM tables
with PostgreSQL 8.1.x on Suse 10.0. I think that sentence right there
will tell you why!
Anyway, one of the columns in one of the tables is a big chunk of XML
(500 to 500KB). I'm not normally a fan of that kind of
Hola , soy estudiante universitario y estoy interesado en
trabajar con PostgresSQL y me gustaría que me ayudaran mandándome información sobre
él
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any
more complicated than storing the XML into a bytea field? Do I have to
worry about character encoding? All my XML is in utf-8.
tia,
arturo
---(end of broadcast)---
TIP 9: In
From: Tom Lane <[EMAIL PROTECTED]>
To: "Ricardo Perez Lopez" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] '1 year' = '360 days' Date: Sat, 23 Oct 2004
19:52:50 -0400
"Ricardo Perez Lopez" <[EMAIL PROTECTED]> w
Hello everyone:
I'm a PostgreSQL newbie, working now with dates, times, timestamps and
intervals.
I have three questions about the above:
FIRST:
I have observed that, for PostgreSQL, one year is actually 360 days:
SELECT '1 year'::timestamp = '360 days'::timestamp;
?column?
-
Hello
We're experiencing weird behaviours with both Postgres 7.3.x and 7.4.1
versions, relating to views based on views including fields based upon
plpgsql functions. Attached is a .sql file showing our problems, from a
co-worker who doesn't have immediate access to this mailing list.
Here's t
don't want them to see certain
views or functions definitions because of privacy concerns.
Thanks for any support
Laurent Perez
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11
var/lib/pgsql/bases/redife and touched it again, and that
worked good, but now with the table supervisor that is not the
solution.
???
thanks for your help
Adrian Perez Camarena
IFE
43 matches
Mail list logo