I will recommend using the 'text' data type in that case for better
performance if you do not want to define the length...
Thank you,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Are there any negatives to not specifying
I guess TOAD uses OCI to interact with the database so there might be
problems connecting TOAD with PostgreSQL...
A query builder that I have used in the past and works fine with PostgreSQL
was "Active Query Builder Free Edition" (
http://www.softpedia.com/get/Internet/Servers/Database-Utils/Acti
If set have the max_fsm_pages set correctly, that makes VACUUM faster and
removes the need for VACUUM FULL or REINDEX. Should be slightly more than
the total number of data pages which will be touched by updates and deletes
between vacuums.
Thanks,
Shoaib Mir
EnterpriseDB (www.enterprise
[EMAIL PROTECTED] skrev:
I really like TOAD for building Oracle queries. Is there a TOAD-like,
FOSS query builder for PostgreSQL?
Hi,
I use Toad for Oracle too.
pgAdminIII is included Postgres, its good but I prefer pg lightning
admin which I've been using daily for almost a year now. It's s
On Saturday 09 December 2006 03:48 Tom Lane's cat, walking on the keyboard,
wrote:
> Well, CLUSTER does not guarantee that the data remains sorted --- as
> soon as you do any updates it won't be anymore. So the planner can
> never assume that a plain seqscan delivers correctly sorted output.
And
On Sat, Dec 09, 2006 at 11:35:39AM +0100, Luca Ferrari wrote:
> And when the cluster is rebuilt? I mean, in theory, a clustered index should
> be sorted at any point in time, that means I've got much cost for
> insert/update cause I need to sort again the index when I'm performing the
> insert/u
I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
Has anyone managed to fix that?
---(end of broadcast)---
TIP 6: explain analyze is your friend
DbVisualizer works fine with PostgreSQL and also has a query builder
http://www.dbvis.com/products/dbvis/
BTJ
On Sat, 09 Dec 2006 10:51:50 +0100
Marcus Engene <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] skrev:
> > I really like TOAD for building Oracle queries. Is there a TOAD-like,
> >
On Sat, Dec 09, 2006 at 12:10:16PM +0100, Harald Fuchs wrote:
> I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
> stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
> Has anyone managed to fix that?
What exactly is the problem? Does it not compile or something?
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> On Sat, Dec 09, 2006 at 12:10:16PM +0100, Harald Fuchs wrote:
>> I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
>> stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
>> Has anyone managed to fix
On Sat, Dec 09, 2006 at 12:48:34PM +0100, Harald Fuchs wrote:
> > What exactly is the problem? Does it not compile or something?
>
> Yes:
>
> $ make USE_PGXS=1
> sed 's,MODULE_PATHNAME,$libdir/ip4r,g' ip4r.sql.in >ip4r.sql
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
> -Wdeclar
A variable called search_path is set to public at the begining of the
fuzzystrmatch script.
Can anyone tell me what it does?
Cheers,
t.n.a.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
On Sat, Dec 09, 2006 at 12:08:08PM +, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?
Check the documentation for the details, but it's basically:
- The list of schemas to look in when given a t
2006/12/9, Martijn van Oosterhout :
On Sat, Dec 09, 2006 at 12:08:08PM +, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?
Check the documentation for the details, but it's basically:
- The lis
On Dec 09 12:52, Tomi N/A wrote:
> 2006/12/9, Martijn van Oosterhout :
> >Check the documentation for the details, but it's basically:
>
> I would have, but I don't know where the documentation is. The README
> in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.
Google does. Search for
On Dec 9, 2006, at 21:52 , Tomi N/A wrote:
I would have, but I don't know where the documentation is. The README
in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.
It's not specific to fuzzymatch (or any other contrib module): it's a
feature of the PostgreSQL server itself.
Mi
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> Looking at CVS, line 967 is a blank line, so I have to ask what version
> you're compiling. I notice the CVS tree got some patches two months ago
> for 8.2 but there has been no release since then. Perhaps you should
> try the lates
On Sat, Dec 09, 2006 at 02:48:15PM +0100, Harald Fuchs wrote:
> This was it!
>
> I assumed that the ip4r-1.0.tgz presented on the PgFoundry site was
> the most recent version. After getting the five files via CVS,
> everything seems to work now.
It might be an idea to either file a bug, or email
Martijn van Oosterhout writes:
> At a guess your table is not big enough to make an index worthwhile. If
> your table is only a few pages long, it's just not efficient to lookup
> an index first.
> If you post the results of EXPLAIN ANALYZE we can tell you for sure.
Actually, it would be interest
I'd like to rename a table but am unsure how this will affect the
primary key. That is, the table currently being named 'service', it has
a pkey named 'service_id_pkey'. I'd like to change the table name to
'service_provider' (which would mean i'd get 'service_provider_id_pkey').
There's a sec
Hey All-
It seems like there should be an easily-found answer to this, but if
there is, I can't find it.
I am simply trying to drop a role.
So, before dropping it I need to reassign all its owned objects
(REASSIGN OWNED, very handy) and then revoke all privilges it has had
assigned to it.
* Tom Darci ([EMAIL PROTECTED]) wrote:
> I've been looking into using the function aclcontains() in conjunction
> with the table pg_class, in order to determine which objects a role has
> been granted privilges to. And while this seems promising, I'm still not
> having any luck formulating the sq
On 9 Dec 2006 at 18:22, brian wrote:
> I'd like to rename a table but am unsure how this will affect the
> primary key. That is, the table currently being named 'service', it has a
> pkey named 'service_id_pkey'. I'd like to change the table name to
> 'service_provider' (which would mean i'd get
23 matches
Mail list logo
