(Moved to -hackers)
Log Message:
---
Tablespaces. Alternate database locations are dead, long live tablespaces.
Sweet :)
There are various things left to do: contrib dbsize and oid2name modules
need work, and so does the documentation. Also someone should think about
COMMENT ON
My only guess is that getaddrinfo in your libc has a bug somehow that is
corrupting the stack (hance the improper backtrace), then crashing.
It could be libc on AIX, I suppose, but it strikes me as sort of odd
that nobody else ever seens this. Unless nobody else is using AIX
5.1, which
Hi,
Is there any reason that the following shouldn't work:
CREATE TABLE my_new_table (LIKE my_composite_type);
I get the following error (in 7.4.2):
ERROR: my_composite_type is a composite type
With the improved handling of composite types,
will this work in 7.5?
Cheers
--
Mark Gibson gibsonm
On Thu, Jun 17, 2004 at 06:06:12PM -0400, Bruce Momjian wrote:
When you say init directory, what do you mean? /bin?
No. The place where the init scripts (which cause postgres to start)
live.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes
First time I posted a question using complicated example, but this time I'll
be wiser and simplify the question:
What is SPI equivalent for libpq PQftable PQFtablecolumn functions ?
Regards !
---(end of broadcast)---
TIP 6: Have you
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Comment on TABLESPACE is impossible, no? Tablespaces are a global
relation and pg_description isn't.
Well, it has the same issues as COMMENT ON DATABASE, which we support,
though crudely.
Perhaps we should think about creating a shared
Mark Gibson [EMAIL PROTECTED] writes:
Is there any reason that the following shouldn't work:
CREATE TABLE my_new_table (LIKE my_composite_type);
Probably not. I can think of reasons why we might not want to let you
INHERIT from a composite type, but LIKE is just a one-time copy-the-
Hi!
since we have a lot of databases here that suffer from pg_dump's
deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from
the upcoming 7.5 release.
This version works much better, but it is not possible to dump a
complete cluster using pg_dumpall in a 7.3 or 7.4 compatible way
Darko Prenosil [EMAIL PROTECTED] writes:
What is SPI equivalent for libpq PQftable PQFtablecolumn functions ?
There is none. SendRowDescriptionMessage gets the column ID info by
rooting around in the targetlist of the SELECT query, and you'd have
to do the same.
The documentation for PQexecPrepared says:
(There is not currently a provision to obtain different result
columns in different formats, although that is possible in the
underlying protocol.)
Would anyone be interested in a patch to allow this?
I could, for example, change
joseph speigle [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] pgsql]$ initdb --locale=ko_KR --lc-messages=C -E unicode -D
`pwd`/unidata
Is that a valid combination of locale and encoding? The locale setting
implies a particular encoding, but unfortunately Postgres has no way to
tell which one.
Thanks (again) Tom, I'll try to do as You suggested.
I was poking around backend libpq, but was unable to find where exactly
that information is prepared and send to libpq buffer.
Regards !
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Darko Prenosil [EMAIL PROTECTED]
Cc:
Peter Eisentraut [EMAIL PROTECTED] writes:
Shachar Shemesh wrote:
According to the docs, domains are not meant for that purpose, but
for changing constraints of a type. Is it possible to define a domain
that will have the same defaults and constraints as the base type,
but will have different
Shachar Shemesh [EMAIL PROTECTED] writes:
I have defined a datatype called varcharci, shamelessly yanking the
input, output, recv and send functions from varchar. This means (as far
as I understand things) that this type is binary compatible with varchar.
Use text, not varchar.
Why is
Abhijit Menon-Sen [EMAIL PROTECTED] writes:
The documentation for PQexecPrepared says:
(There is not currently a provision to obtain different result
columns in different formats, although that is possible in the
underlying protocol.)
Would anyone be interested in a patch to
Hello:
A user of the PgSqlClient ADO.NET provider is having problems
when with timestamp and time values, he has a postgres 7.4.1
postgres install in a Suse machine.
The provider works implements v3.0 of the postgres protocol handling
timestamp andtime in binary format, the problem seems to be
Tom Lane wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Comment on TABLESPACE is impossible, no? Tablespaces are a global
relation and pg_description isn't.
Well, it has the same issues as COMMENT ON DATABASE, which we support,
though crudely.
Perhaps we should think about
=?ISO-8859-1?Q?Carlos_Guzm=E1n_=C1lvarez?= [EMAIL PROTECTED] writes:
What is the supposed format that should be expected for time and
timestamp values in binary format ??
Depends whether you built the server with --enable-integer-timestamps
or not.
There are any way to retrieve the value
Hello:
Depends whether you built the server with --enable-integer-timestamps
or not.
Thanks :)
Sure: don't use binary I/O.
hehe ... :-\ i will do ... thanks again :)
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
---(end of broadcast)---
Mark (see I remembered your name), where are we on this patch? It needs
docs and include has to be redone. Should I remove the include part of
the patch, add docs, and apply it?
---
[EMAIL PROTECTED] wrote:
Where are
At 2004-06-18 13:11:19 -0400, [EMAIL PROTECTED] wrote:
Would anyone be interested in a patch to allow this?
Yes, but not the way you suggest. The ... approach forces calling
code to know *when it is written* how many result columns there will
be, because you'd have to actually write that
Dave Page [EMAIL PROTECTED] writes:
I'm getting the following error when trying to initdb with CVS tip.
creating template1 database in C:/msys/1.0/local/pgsql/data/base/1 ...
ERROR: could not open segment 1 of relation 1663/1/1255 (target block
26189776): No such file or directory
The
Quoth [EMAIL PROTECTED] (Bruce Momjian):
Andrew Sullivan wrote:
On Thu, Jun 17, 2004 at 01:12:10PM -0400, Bruce Momjian wrote:
Well, the bad news is that this backtrace isn't very useful.
No kidding. It's pretty frustrating.
My only guess is that getaddrinfo in your libc has a bug
Santo Quartarone [EMAIL PROTECTED] writes:
What's the safest email browser?
less is pretty safe, more or less ;-).
You didn't specify what sort of platform you wanted to use; the
choices vary, considerably, between platforms.
--
(format nil [EMAIL PROTECTED] cbbrowne cbbrowne.com)
Although DROP TABLESPACE can detect tables existing in the target
tablespace, it doesn't have any way to detect schemas that reference
that tablespace as their default tablespace. Thus you can get
implementation-level failures like this one:
$ mkdir /tmp/junk
regression=# create tablespace junk
On Fri, 18 Jun 2004, Tom Lane wrote:
Although DROP TABLESPACE can detect tables existing in the target
tablespace, it doesn't have any way to detect schemas that reference
that tablespace as their default tablespace. Thus you can get
implementation-level failures like this one:
Of course.
On Fri, 2004-06-18 at 08:24, Chris Browne wrote:
Santo Quartarone [EMAIL PROTECTED] writes:
What's the safest email browser?
less is pretty safe, more or less ;-).
You didn't specify what sort of platform you wanted to use; the
choices vary, considerably, between platforms.
I'd say pine
On Fri, 18 Jun 2004, Tom Lane wrote:
Gavin Sherry [EMAIL PROTECTED] writes:
Is it really that bad? NamespaceCreate() could just touch a file at
pg_tablespaces/tablespaceoid/MyDatabaseId/namespace oid and
RemoveSchema() could remove it.
No, because that wouldn't be rollback-safe. You'd
On Fri, 18 Jun 2004, Tom Lane wrote:
Gavin Sherry [EMAIL PROTECTED] writes:
If we just wanted to make the error message more user friendly, perhaps we
could *gulp* store the tablespace name in PG_VERSION.
That's actually not a bad idea from a debugging standpoint. But I don't
see that it
Where are we on this?
---
Tom Lane wrote:
Manfred Koizar [EMAIL PROTECTED] writes:
I understand you, honestly. Do I read between your lines that you
didn't review my previous vacuum.c refactoring patch? Please do.
Were are we on this?
---
Andreas Pflug wrote:
Tom Lane wrote:
This has got portability issues (fopen(ab))
My doc says b is ignored on ansi systems, and recommends using it. Do
you have other experiences?
and
We have twelve days until July 1, feature freeze.
Looking at our list:
Win32 - need service manger code, installer is outside project
Tablespaces - patch installed; discussing implementation and
administration details.
Nested transactions - submitted, with phantom xids; only needs trigger
Is there a TODO here? No one explained why frozen tuples are important.
---
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
On 6/12/2004 3:45 PM, Tom Lane wrote:
I don't think it would help very much to define a
Actually, this is the current state of this issue.
---
Andreas Pflug wrote:
Tom Lane wrote:
Andreas Pflug [EMAIL PROTECTED] writes:
Answering my own question, the distribution of the current logfile
name could
Well, it has the same issues as COMMENT ON DATABASE, which we support,
though crudely.
Perhaps we should think about creating a shared version of
pg_description so we could have more reasonable support for comments
on shared objects. I'm not in a hurry for this but it would be a
reasonable TODO
Tom Lane said:
Dave Page [EMAIL PROTECTED] writes:
I'm getting the following error when trying to initdb with CVS tip.
creating template1 database in C:/msys/1.0/local/pgsql/data/base/1 ...
ERROR: could not open segment 1 of relation 1663/1/1255 (target block
26189776): No such file or
ERROR: tablespace 292909 has been deleted
How about schema default tablespace 292909 has been deleted?
Chris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
Bruce Momjian said:
We have twelve days until July 1, feature freeze.
Looking at our list:
Win32 - need service manger code, installer is outside project
Tablespaces - patch installed; discussing implementation and
administration details.
Nested transactions - submitted, with phantom
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
ERROR: tablespace 292909 has been deleted
How about schema default tablespace 292909 has been deleted?
Yeah, I was wondering if we could finger the specific schema that
was causing the problem, but the place that would detect the error
couldn't
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Perhaps we should think about creating a shared version of
pg_description so we could have more reasonable support for comments
on shared objects. I'm not in a hurry for this but it would be a
reasonable TODO item.
Just add a comment text
Andrew Dunstan [EMAIL PROTECTED] writes:
I am still hopeful that we can get a significant plperl improvement before
feature freeze, including shared data space, set returning funcs,
composite returning funcs, triggers and an spi query mechanism. It will be
touch and go and we might not make
41 matches
Mail list logo