I’m brand new to Postgresql and working on moving an existing large DB
into it. I’m trying to get uuid-ossp functions to work. I know the
UUID type is installed, but I need the generate functions. I’ve
installed postgresql-server and postgresql-contrib from the postgresql
yum repos (working with
Well, the only file that shows up is the uninstall file? Thats a little
odd.
Looks like I'll be rebuilding from source on monday...joyous.
On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
> Chris spotts writes:
> > I’m brand new to Postgresql and working on moving an
> > existing large DB into i
Thanks, I got it installed from source and got uuid-ossp working. One
of the easier installs from source for a major app that I've done.
Appreciate the help.
Chris
On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote:
> Chris spotts writes:
> > I’m brand new to Postgresql and working on moving an
On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote:
> Well, the only file that shows up is the uninstall file? Thats a
> little odd.
I see these files on my 8.4 :
/usr/share/pgsql/contrib/uninstall_uuid-ossp.sql
/usr/share/pgsql/contrib/uuid-ossp.sql
See second one. It is there. uuid support
FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3
I'm planning on rolling my own from source as well.
Dave Kerr
Chris spotts wrote:
Thanks, I got it installed from source and got uuid-ossp working. One
of the easier installs from source for a major app that I've done.
Appreciate
On Sat, 2009-04-04 at 13:03 -0700, David Kerr wrote:
> FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3
I am about to announce OpenSuSE 11+ and SLES 10+ RPMs soon, really soon,
which will include all features that PGDG Fedora/RH/CentOS RPMs have. If
you are not in a hurry, you may wai
Go figure, eh? It wasn't there when I installed the RHEL version. But
its all good.
Chris
On Sat, 2009-04-04 at 22:28 +0300, Devrim GÜNDÜZ wrote:
> On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote:
> > Well, the only file that shows up is the uninstall file? Thats a
> > little odd.
>
> I s
Where can I get uuid-ossp for windows? Also where can I get citext for windows.
These two are missing from the windows installer.
Thanks.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <[EMAIL PROTECTED]> wrote:
> Where can I get uuid-ossp for windows? Also where can I get citext for
> windows.
>
> These two are missing from the windows installer.
Search the archives. There was a conversation about this in the last
week or two. Bas
Hi.
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
On Tue, Feb 26, 2008 at 9:44 PM, Tim Uckun <[EMAIL PROTECTED]> wrote:
Where can I get uuid-ossp for windows? Also where can I get citext for windows.
These two are missing from the windows installer.
Search the
On Wed, Feb 27, 2008 at 3:44 AM, Tim Uckun <[EMAIL PROTECTED]> wrote:
> Where can I get uuid-ossp for windows? Also where can I get citext for
> windows.
>
> These two are missing from the windows installer.
uuid-ossp is missing because until a few days ago the underlying
uuid-ossp wasn't porte
> citext is not part of core PostgreSQL or something we have any
> intention to include in the Windows distribution at this time.
Is there an alternative for people wanting a case insensitive collation?
---(end of broadcast)---
TIP 4: Have you sea
On Feb 27, 2008, at 16:59 , Tim Uckun wrote:
citext is not part of core PostgreSQL or something we have any
intention to include in the Windows distribution at this time.
Is there an alternative for people wanting a case insensitive
collation?
ORDER BY lower(foo) ?
Michael Glaesemann
g
Hi All,
I am trying to build the uuid-ossp contrib module for PostgreSQL 8.3.4.
I am building on Solaris x86 with Sun Studio 12.
I built the ossp-uuid version 1.6.2 libraries and installed them,
however, whenever I attempt to build the contrib module I always end up
with the following error:
---
Bruce McAlister <[EMAIL PROTECTED]> writes:
> I am trying to build the uuid-ossp contrib module for PostgreSQL 8.3.4.
> I am building on Solaris x86 with Sun Studio 12.
> I built the ossp-uuid version 1.6.2 libraries and installed them,
> however, whenever I attempt to build the contrib module I a
>
> Um ... did you run PG's configure script with --with-ossp-uuid?
> It looks like either you didn't do that, or configure doesn't know
> to look in the place where you put the ossp-uuid header files.
>
Doh, I missed that, however, I have now included that option but it
still does not find the
Hi.
Um, you are reconfigure of postgresql then. It is necessary to specify
with-ossp-uuid.
Regards,
Hiroshi Saito
- Original Message -
From: "Bruce McAlister" <[EMAIL PROTECTED]>
To: "pgsql"
Sent: Wednesday, October 29, 2008 8:01 AM
Subject: [GENERAL
Bruce McAlister <[EMAIL PROTECTED]> writes:
> When I run configure with the above options, I end up with the following
> configure error:
> checking for uuid_export in -lossp-uuid... no
> checking for uuid_export in -luuid... no
> configure: error: library 'ossp-uuid' or 'uuid' is required for OSS
Do I need to use a specific version of the ossp-uuid libraries for this
module?
The 1.6.2 stable version which you use is right.
Regards,
Hiroshi Saito
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
>
> Huh. Nothing obvious in your info about why it wouldn't work. I think
> you'll need to dig through the config.log output to see why these link
> tests are failing. (They'll be a few hundred lines above the end of the
> log, because the last part of the log is always a dump of configure's
>
>
> The 1.6.2 stable version which you use is right.
>
Thanks, we managed to get it working now. Thanks for the pointers.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bruce McAlister <[EMAIL PROTECTED]> writes:
> In addition to the missing configure option, it turned out to be missing
> LDFLAGS parameters, I just added -L/usr/lib to LDFLAGS and it all built
> successfully now.
Bizarre ... I've never heard of a Unix system that didn't consider that
a default pla
>
> Bizarre ... I've never heard of a Unix system that didn't consider that
> a default place to look. Unless this is a 64-bit machine and uuid
> should have installed itself in /usr/lib64?
>
It is a rather peculiar issue, I also assumed that it would check the
standard locations, but I thought
Bruce McAlister <[EMAIL PROTECTED]> writes:
>> Bizarre ... I've never heard of a Unix system that didn't consider that
>> a default place to look. Unless this is a 64-bit machine and uuid
>> should have installed itself in /usr/lib64?
> It is a rather peculiar issue, I also assumed that it would
(previously posted to the pgsql-performance list)
Hello,
We're in the process of designing the database for a new service, and
some of our tables are going to be using UUID primary key columns.
We're trying to decide between:
* UUIDv1 (timestamp/MAC uuid) and
* UUIDv4 (random uuid)
And the
Does anyone have a install or the proper files (not the source) to install
the uuid-ossp contrib files for 8.4? The one thing that I think that
EnterpriseDB install is lacking in is the contrib modules that have been in
the previous postgres version installation. Is this something that is going
t
On Tue, 22 Dec 2015 11:07:30 -0600
Brendan McCollam wrote:
> (previously posted to the pgsql-performance list)
>
> Hello,
>
> We're in the process of designing the database for a new service, and
> some of our tables are going to be using UUID primary key columns.
>
> We're trying to decide b
Hello Michael,
In the EnterpriseDB installer, uuid-ossp contrib module is available but
not loaded/enabled by default. To enable uuid-ossp module simply run the
uuid-ossp.sql file ("share\contrib\uuid-ossp.sql").
This is something that i did:
psql.exe -U postgres -d postgres -f share\contrib
Thanks, that worked perfectly.
Best Regards
Michael Gould
"Sachin Srivastava" wrote:
>Hello Michael,
>
>In the EnterpriseDB installer, uuid-ossp contrib module is available but
>not loaded/enabled by default. To enable uuid-ossp module simply run the
>uuid-ossp.sql file ("share\cont
29 matches
Mail list logo
