Hi,
I am using Postgresql 8.0.3 in Fedora Core 4.
In my database, it contains a sequence. And, I need to alter the range
of this sequence and restart it to the start of the new range at
00:00:00 on 1st January on every year. 5 seconds before and after that
time, I need to prevent users from calli
Anyone have recommendations on tools/utilities or SQL approaches to
quickly break apart a large imported flat file into normal forms,
ideally 1NF or 2NF?
I noticed this tool for mySQL which captures what I am looking for:
http://www.sqldbu.com/eng/sections/tips/normalize.html
Given the fi
Hi all.
What'd be the right place to put a "feature request" for the next releases and
for bugs in the current one?
Thanks.
--
Reg me Please
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgres
--- On Tue, 11/20/07, Finn Lassen <[EMAIL PROTECTED]> wrote:
> Here is a VB code snippet:
> Dim dbOut As ADODB.Connection
> Dim rsOut As ADODB.Recordset
> Set dbOut = New ADODB.Connection
> Set rsOut = New ADODB.Recordset
> .ConnectionString = "Driver={PostgreSQL
> ANSI};Se
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Ugh, you're right of course! Somehow I had this wrong. So I tried to
> create an index on the xml[] result by casting to text[] but I got the
> "function must be immutable" error. Is there any reason the xml[] to
> text[] cast is not immutable?
Hmm ...
> AFAICT that's exactly what it does.
>
> regression=# select xpath('//[EMAIL PROTECTED]"mykey"]/text()',
> 'ABC key="mykey">XYZRSTDEF');
>xpath
> ---
> {XYZ,RST}
> (1 row)
>
> regression=#
>
> Of course this is of type xml[], but you can cast to text[] and then
> index.
Ugh, you're
Bruno Lavoie <[EMAIL PROTECTED]> writes:
> Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
[ shrug... ] Text sort ordering is dependent on the locale you use.
If these folk want C-locale sorting, they need to initdb in C locale.
regards, tom lane
-
Hello guys,
Posted this msg on general & hackers list to get most accurate responses
as possible...
I plan to use PG with an OpenCRX project... but I read that there's some
probs with PG and strings comparisons Is it true?
Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
Thanks
Brun
Steve Atkins wrote:
>
> On Nov 20, 2007, at 3:41 PM, Tom Lane wrote:
>
>> "Sander Steffann" <[EMAIL PROTECTED]> writes:
>>> I would be happy if it would support IPv6 :-) Are there plans to make
>>> ip6r
>>> or something like that?
>>
>> What's the point? You might as well use the regular inet t
I'm new to this, so please bear with me.
Here is a VB code snippet:
Dim dbOut As ADODB.Connection
Dim rsOut As ADODB.Recordset
Set dbOut = New ADODB.Connection
Set rsOut = New ADODB.Recordset
With dbOut
.ConnectionString = "Driver={PostgreSQL
ANSI};Server=localhost;Port=54
Thanks to all the testing, feedback and bug reports the community has
performed with the first and second betas, we now have our third beta
of 8.3.
We hope that this will be our last beta before release candidate
so please download and continue testing to ensure that any issues
you raised have hav
On Mon, 2007-11-19 at 08:24 -0500, Bill Moran wrote:
> In response to Ow Mun Heng <[EMAIL PROTECTED]>:
> >
> > Even with the regular vacuuming and even a vacuum full ( on my test DB)
> > I still see that perhaps something is wrong (from the below)
> >
> > (I got this gem from the mailling list a
On Nov 20, 2007, at 3:41 PM, Tom Lane wrote:
"Sander Steffann" <[EMAIL PROTECTED]> writes:
From: "Harald Fuchs" <[EMAIL PROTECTED]>
Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and
be happy.
I would be happy if it would support IPv6 :-) Are there plans to
make ip6r
or so
"Sander Steffann" <[EMAIL PROTECTED]> writes:
> From: "Harald Fuchs" <[EMAIL PROTECTED]>
>> Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and be happy.
> I would be happy if it would support IPv6 :-) Are there plans to make ip6r
> or something like that?
What's the point? You mig
Hi, I am developing a windows application and will statically link pgsql
frontend with as part of final binary (so that it will not require
libpq.dlland other dll at runtime). Any pointers on how to do it? Do
we have to
compile the source code to generate a new lib file ?? Anyone with prior
experie
Hi,
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 19, 2007 7:21 PM
Subject: Re: [GENERAL] IP addresses
In article <[EMAIL PROTECTED]>,
"Tom Allison" <[EMAIL PROTECTED]> writes:
I am planning on doing a LOT of work with ip addresses and tho
"Matt Magoffin" <[EMAIL PROTECTED]> writes:
> Should the xpath() function return 3 individual text nodes like this:
> /[EMAIL PROTECTED]"mykey"]/text() => {
> value1,
> value2,
> value3
> }
> rather than concatenating these into a single text node result?
AFAICT that's exactly what it does
On Nov 20, 2007, at 1:04 PM, Josh Harrison wrote:
I ran vacuum full on this table already. I haven't re-indexed it. But
this will not affect the table size...right...since indexes are stored
separately?
Yes, but your indexes are probably bloated at this point, so to reduce
the space they
On Tue, 2007-11-20 at 13:04 -0500, Josh Harrison wrote:
> On Nov 20, 2007 11:13 AM, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> > On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
> >
> > > There were a couple of things we noted.
> > > 1. Tablesize twice as much than oracle-- Im not sure if p
On Nov 20, 2007 11:13 AM, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
>
> > There were a couple of things we noted.
> > 1. Tablesize twice as much than oracle-- Im not sure if postgres null
> > columns has any overhead since we have lots of n
On 11/20/07, Josh Harrison <[EMAIL PROTECTED]> wrote:
> We are working on migrating our database from oracle to postgres.
> Postgres tablesize is twice than oracle tablesize for all my
> tables.And so the query also takes twice as much time than oracle. So
> we were checking to see what makes post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 20 Nov 2007 10:49:25 -0500
Walter Vaughan <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
>
> > It's that time, after a wildly successful conference last October in
> > Portland, Oregon we are now beginning to ramp up for the East Coast
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 20 Nov 2007 10:49:25 -0500
Walter Vaughan <[EMAIL PROTECTED]> wrote:
> Perhaps a future East coast event could just take over an Embassy
> Suites and have the entire event self contained. At least in a place
> like that, you have a hot breakfa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 20 Nov 2007 11:50:03 +0300 (MSK)
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Are there any possibilities to sponsor me and Teodor ?
I will contact off list about this.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt
On Tue, 2007-11-20 at 08:38 -0800, [EMAIL PROTECTED]
wrote:
>
> For e.g, if I did a pg_dump backup a week ago, and the system crash
> today, but I'm able to get all the files
> in /usr/local/pgsql/data/pg_xlog, can I still recover my database to
> the latest state?
No, pg_dump never allows any
Hello Scott,
Thanks for clear my doubt. Yes, I'm planning to do PITR backup.
Another question, from what I understand, when there are data transaction going
on, postgres will store in the log file, which is in
/usr/local/pgsql/data/pg_xlog, when these data will finally save it into
/database/pg
On 20 nov, 12:35, [EMAIL PROTECTED] (Reg Me Please) wrote:
> Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto:
>
>
>
> > I'm using Microsoft Visual Foxpro 9 developing an ERP application,
> > using PostgreSQL 8.2.5 and ODBC connection in version 7.
>
> > If I upgrade my ODBC drivers to us
On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
> There were a couple of things we noted.
> 1. Tablesize twice as much than oracle-- Im not sure if postgres null
> columns has any overhead since we have lots of null columns in our
> tables.Does postgresql has lots of overhead for null col
Joshua D. Drake wrote:
It's that time, after a wildly successful conference last October in
Portland, Oregon we are now beginning to ramp up for the East Coast 08
conference! The current plan is to host a two day conference of
Tutorials (new) and Talks on March 28th and 29th. The currently
desig
On Nov 20, 2007 8:10 AM, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> 2007/11/20, Josh Harrison <[EMAIL PROTECTED]>:
> > We are working on migrating our database from oracle to postgres.
> > Postgres tablesize is twice than oracle tablesize for all my
> > tables.
> Interesting. Which postgresql
Il Tuesday 20 November 2007 15:01:53 T.J. Adami ha scritto:
> I'm using Microsoft Visual Foxpro 9 developing an ERP application,
> using PostgreSQL 8.2.5 and ODBC connection in version 7.
>
> If I upgrade my ODBC drivers to use "PostgreSQL ANSI", becomes an
> error like this:
>
> "function saldo_es
I'm using Microsoft Visual Foxpro 9 developing an ERP application,
using PostgreSQL 8.2.5 and ODBC connection in version 7.
If I upgrade my ODBC drivers to use "PostgreSQL ANSI", becomes an
error like this:
"function saldo_estoque("unknown", "unknown", "unknown", "unknown",
timestamp without time
2007/11/20, Josh Harrison <[EMAIL PROTECTED]>:
> We are working on migrating our database from oracle to postgres.
> Postgres tablesize is twice than oracle tablesize for all my
> tables.
Interesting. Which postgresql version?
>And so the query also takes twice as much time than oracle.
This is ev
Josh Harrison escribió:
> > On 11/19/07, Josh Harrison <[EMAIL PROTECTED]> wrote:
> >
> > > I have 2 tables with 2 cols each( 1 numeric(8,0) and 1 varchar(3) ).
> > > In table1 both the cols are filled and in table2 the varchar colm is null
> There were a couple of things we noted.
> 1. Tablesiz
We are working on migrating our database from oracle to postgres.
Postgres tablesize is twice than oracle tablesize for all my
tables.And so the query also takes twice as much time than oracle. So
we were checking to see what makes postgres slower than oracle even
for basic full tablescan queries.
Alex Drobychev wrote:
> I agree with this maybe 98% - but not 100%. :-) Unfortunately
> performance can change rather unpredictably when the DB stops
> fitting in memory - say, 3-4 months after a production roll-out, too
> late for profiling experiments. :-(
Surely you're capable of inven
Are there any possibilities to sponsor me and Teodor ?
Oleg
On Mon, 19 Nov 2007, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It's that time, after a wildly successful conference last October in
Portland, Oregon we are now beginning to ramp up for the East Coast 08
con
37 matches
Mail list logo
