Philip Warner <[EMAIL PROTECTED]> writes:
> It's a real pity about pg_get_userbyid - the output for non-existant users
> is pretty near useless. I presume it's there for convenience of a specific
> piece of code.
No, I imagine it's just that way because it seemed like a good idea at
the time. Re
It seems -S option for postmaster (detaching ttys) does not exist in
postgresql.conf. Is there any reason for this?
--
Tatsuo Ishii
At 12:13 19/09/00 -0400, Tom Lane wrote:
>
>Say what? (... tries it ...) Fascinating. I wouldn't rely on this
>behavior however; the fact that it works today is a totally unintended
>consequence of a change I made for column alias support. Next week
>ruleutils.c might try to access the underly
I have just noticed that VACUUM doesn't always call
FlushRelationBuffers(); it does so only if it wants to truncate
the relation (ie, shrink the physical file).
This is OK for normal purposes but it's bad for pg_upgrade, which
is invoking VACUUM just to ensure that on-row transaction status bits
..
> The general issue still remains: if a database contains an inconsistency
> or error, introduced by whatever means (and there'll always be bugs),
> a pg_dump failure is likely to be the first notice a dbadmin has about it.
> So it behooves us to make sure that pg_dump issues error
Hi,
Is there a problem? I haven't received anything today...
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: [EMAIL PROT
Karel Zak writes:
> I don't want make some changes to contrib/odbc, because it's out of
> me... but I have a question, Why in the contrib/odbc/odbc.c are total
> same function as in oracle_compat.c (like ascii(), ichar(), repeat())?
The odbc.c file is for installing the set of ODBC compatibil
On Tue, 19 Sep 2000, Tom Lane wrote:
> Yes, this mistake needs to be detected earlier. The stored view
> contains both the name and the OID of the referenced table. It should
> *not* accept a new table with same name and different OID, since there's
> no guarantee that the new table has anythi
John McKown <[EMAIL PROTECTED]> writes:
> OK, I hope ya'll don't mind a thought from a newbie. And I hope this is
> the right forum to ask about this. I was wondering if it would be possible
> (no I don't have the expertise!) to extend one of the system tables. What
> I was hoping for was somewher
Philip Warner <[EMAIL PROTECTED]> writes:
>>> The reason that changing pg_dump is a superior solution for this problem
>>> is that there's only one place to change, not umpteen dozen ...
>>
>> Well at least two, unless you like the following:
>>
>> zzz=# select * from pg_views;
>> ERROR: cache
Philip Warner <[EMAIL PROTECTED]> writes:
> create table test (f1 int);
> create view v_test as select f1+1 as f11 from test;
> drop table test;
> create table test (f1 int);
> select * from v_test;
> ERROR: has_subclass: Relation 19417 not found
> which not very helpful
Karel Zak <[EMAIL PROTECTED]> writes:
> I don't want make some changes to contrib/odbc, because it's out of
> me... but I have a question, Why in the contrib/odbc/odbc.c are total
> same function as in oracle_compat.c (like ascii(), ichar(), repeat())?
contrib/odbc was a quick hack just before
Alex Sokoloff <[EMAIL PROTECTED]> writes:
> Of course, if an alias for ichar is carried forward I
> can write code for the current postgres that won't
> break with future releases. I realize that I might end
> up being the only person on the planet who ends up
> using ichar, and that may not be su
On Mon, Sep 18, 2000 at 11:17:19AM -0700, Alfred Perlstein wrote:
> If you re-order an exported emum you are going to complete break binary
> compatibility, either bump the major or add the entries at the end.
The later is what I did so far.
> However there's another problem even if you add at t
OK, I hope ya'll don't mind a thought from a newbie. And I hope this is
the right forum to ask about this. I was wondering if it would be possible
(no I don't have the expertise!) to extend one of the system tables. What
I was hoping for was somewhere to store the "options" used to create
columns.
On Tue, 19 Sep 2000, Alex Guryanow wrote:
> Hi,
>
> How can I convert char* to Datum to pass a string to the SPI_modifytuple function?
A little explore src/include/utils/atd/builtins.h...
(charin(), textin() ...etc.)
Karel
> > Since you can write extensions to PostgreSQL that reach far into the OS,
> > it does make sense to execute those extensions under a "non priviledged"
> > user, and not postgres.
>
> Agreed.
>
> > This OS user would somehow be tied to the username that the client
> > passes as his credential
> New proposal: forget ichar(), give the function two entries chr() and
> char().
OK, I will send patch for this and send domumentation for all
oracle_compat.c routines...
I don't want make some changes to contrib/odbc, because it's out of
me... but I have a question, Why in the contrib/odbc
Hi,
How can I convert char* to Datum to pass a string to the SPI_modifytuple function?
regards,
Alex
19 matches
Mail list logo
