Ð ??, 01.04.2004, Ð 08:00, [EMAIL PROTECTED] ÐÐÑÐÑ:
> I know I'm probably being a bomb tosser, but would it be practical to
> incorporate, like the serial type, and automatic GUID type?
>
> While I love PostgreSQL, I am frequently forced to deal with Oracle and
> MSSQL. While there is a great deal
I know I'm probably being a bomb tosser, but would it be practical to
incorporate, like the serial type, and automatic GUID type?
While I love PostgreSQL, I am frequently forced to deal with Oracle and
MSSQL. While there is a great deal of focus on making PostgreSQL a good
competitor to Oracle, m
On Thu, 1 Apr 2004, Christopher Kings-Lynne wrote:
> > Is your timeline based on the assumption of doing all the work yourself?
> > If so, how about farming out some of it? I'd be willing to contribute
> > some effort to PITR. (It's been made clear to me that Red Hat really
> > wants PITR in 7.5
Christopher Kings-Lynne wrote:
> > Is your timeline based on the assumption of doing all the work yourself?
> > If so, how about farming out some of it? I'd be willing to contribute
> > some effort to PITR. (It's been made clear to me that Red Hat really
> > wants PITR in 7.5 ;-))
>
> What is Re
Is your timeline based on the assumption of doing all the work yourself?
If so, how about farming out some of it? I'd be willing to contribute
some effort to PITR. (It's been made clear to me that Red Hat really
wants PITR in 7.5 ;-))
What is RedHat's interest in PostgreSQL? Last time I heard th
Some of this looks at first glance like it doesn't belong in an
interface library - maybe we should be wrapping more in #ifdef FRONTEND ?
cheers
andrew
Dann Corbit wrote:
After making the following change in port.h:
/* vvv */
/* open() replacemen
Do you know if postgres made assumption on the
access time time stamp for the files on his
own file sistem ? If not I'm wondering if
mount a partition with the option "anotime"
can improve the disk i/o performance.
Regards
Gaetano Mendola
---(end of broadcast)---
After making the following change in port.h:
/* vvv */
/* open() replacement to allow delete of held files */
extern int win32_open(const char*,int,...);
#ifdef _MSC_VER
#define openwin32_open
#else
#define open(a,b,...) win
On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote:
> > On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote:
> >
> >> I'm a little frustrated
> >>
> >> select * from mytable where mystring = 'foo';
> >>
> >> Uses an index
> >>
> >> select * from mytable where mystring like 'foo';
> >>
> >> Does not use an index
On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote:
> I'm a little frustrated
>
> select * from mytable where mystring = 'foo';
>
> Uses an index
>
> select * from mytable where mystring like 'foo';
>
> Does not use an index.
>
> I know Tom is not to excited about this, but I think it is a serious
> pro
>
> On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote:
>
>> I'm a little frustrated
>>
>> select * from mytable where mystring = 'foo';
>>
>> Uses an index
>>
>> select * from mytable where mystring like 'foo';
>>
>> Does not use an index.
>>
>> I know Tom is not to excited about this, but I think it is
>Bruce Momjian wrote
> Tom Lane wrote:
> > "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > > [ expecting to finish PITR by early June ]
> >
> > > Is this all still OK for 7.5? (My attempts at cataloguing
> changes has
> > > fallen by the wayside in concentrating on the more
> important task of
> > >
On Wed, 31 Mar 2004, Tom Lane wrote:
> Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> > BTW... PITR, Windows port, possibly Tablespaces and more... Does the
> > core team intend to use 8.0 instead of 7.5?
>
> It's premature to have that discussion yet, IMHO. When we get close
> to beta and know what
I'm a little frustrated
select * from mytable where mystring = 'foo';
Uses an index
select * from mytable where mystring like 'foo';
Does not use an index.
I know Tom is not to excited about this, but I think it is a serious
problem. What really brings me to this is that I just installed 7.4.2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 31 Mar 2004, Tom Lane wrote:
> > Is this all still OK for 7.5? (My attempts at cataloguing changes has
> > fallen by the wayside in concentrating on the more important task of
> > PITR.) Do we have a planned freeze month yet?
>
> There'
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> BTW... PITR, Windows port, possibly Tablespaces and more... Does the
> core team intend to use 8.0 instead of 7.5?
It's premature to have that discussion yet, IMHO. When we get close
to beta and know what the feature list will look like, we can think
a
Tom Lane wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
> > [ expecting to finish PITR by early June ]
>
> > Is this all still OK for 7.5? (My attempts at cataloguing changes has
> > fallen by the wayside in concentrating on the more important task of
> > PITR.) Do we have a planned freeze mon
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Is your timeline based on the assumption of doing all the work yourself?
> If so, how about farming out some of it? I'd be willing to contribute
> some effort to PITR. (It's been made clear to me that Red Hat really
> wants PITR in 7.5 ;-))
Hey, us Debian
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 31 Mar 2004, Tom Lane wrote:
> I'd be willing to contribute some effort to PITR. (It's been made clear
> to me that Red Hat really wants PITR in 7.5 ;-))
Wow! That's exciting news :-) Does Red Hat also want some more enterprise
feat
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> [ expecting to finish PITR by early June ]
> Is this all still OK for 7.5? (My attempts at cataloguing changes has
> fallen by the wayside in concentrating on the more important task of
> PITR.) Do we have a planned freeze month yet?
There's not really
Andrew Dunstan wrote:
> Bruce Momjian wrote:
>
> >Andrew Dunstan wrote:
> >
> >
>
>
> wow. that was nearly 3 months ago ...
Oh, I remember why I kept this email now. I am going to try to code
this.
> Subsequent discussion suggested we should add "syntax-errors" to the
> allowed values (and
On Wed, 31 Mar 2004, Philip Warner wrote:
> At 12:13 AM 31/03/2004, Bruce Momjian wrote:
> >Yes, they have to check for a proper exit from pg_dump, but there is
> >still a file sitting around after the dump, with no way to tell if it is
> >accurate.
>
> Why don't we write a hash into the header o
Fabien COELHO <[EMAIL PROTECTED]> writes:
> I wish I had some way of referencing objects that I need to designate
> (say, an attribute, an index, a table, a constraint, and so on).
AFAIK, all objects that you might need to designate can be identified
using the scheme employed in pg_depend and pg_d
"Tony and Bryn Reina" <[EMAIL PROTECTED]> writes:
> For the actual command, I'm just saying 'pg_dump -d dbname > dboutput.sql'
"-d" is the --inserts switch.
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will
Bruce Momjian wrote:
Andrew Dunstan wrote:
wow. that was nearly 3 months ago ...
I wrote:
If nobody is working on this I am prepared to look at it:
. Allow logging of only data definition(DDL), or DDL and modification
statements
Here are some options:
1. change the type of
> > I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
> > past, pg_dump would dump database backups using COPY to restore the
> > data. This time it appears that it has individual INSERTs for each
> > tuple. Perhaps I'm missing this in the latest documentation, but I
> > thought
Am Mittwoch, 31. März 2004 13:14 schrieb Tony Reina:
> I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
> past, pg_dump would dump database backups using COPY to restore the
> data. This time it appears that it has individual INSERTs for each
> tuple. Perhaps I'm missing this in
I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
past, pg_dump would dump database backups using COPY to restore the
data. This time it appears that it has individual INSERTs for each
tuple. Perhaps I'm missing this in the latest documentation, but I
thought COPY was the default
>Marc G. Fournier wrote
> Does anyone know how ppl like Oracle handle this? Are system catalogs
> like this open to all users?
The system catalogs for Oracle and most other systems I know of are
secure.
In both Oracle and Teradata the "system tables" are actually views,
which are actively gran
29 matches
Mail list logo
