Hannu Krosing wrote:
> On R, 2005-08-12 at 15:47 -0400, Bruce Momjian wrote:
> > This has been saved for the 8.2 release:
> >
> > http://momjian.postgresql.org/cgi-bin/pgpatches_hold
>
> Is there any particular reason for not putting it in 8.1 ?
I thought there was still uncertainty about th
On R, 2005-08-12 at 15:47 -0400, Bruce Momjian wrote:
> This has been saved for the 8.2 release:
>
> http://momjian.postgresql.org/cgi-bin/pgpatches_hold
Is there any particular reason for not putting it in 8.1 ?
--
Hannu Krosing <[EMAIL PROTECTED]>
---(end of bro
Tom Lane wrote:
> I wrote:
> > I'll see about installing an initdb-time kluge to make it use OUT
> > parameters.
>
> Done:
>
> regression=# SELECT * FROM pg_stat_file('postgresql.conf');
> length | atime | mtime | ctime
> | isdir
> +---
Martijn van Oosterhout writes:
> Here is a patch to the documentation clarifying some minor issues.=20
> The first is to the main SPI documentation clarifying that SPI isn't
> available unless there is a current snapshot (leading to the "no
> snapshot has been set" error).
This is wrong.
> The
Martijn van Oosterhout writes:
> As per discussion on -hackers, type input functions can be called prior
> to there being a current snapshot, causing any queries you execute to
> fail with the "no snapshot has been set" error. So I propose to simply
> have SPI_connect fail right off the bat and do
[Please CC any replies]
Hi,
As per discussion on -hackers, type input functions can be called prior
to there being a current snapshot, causing any queries you execute to
fail with the "no snapshot has been set" error. So I propose to simply
have SPI_connect fail right off the bat and document tha
[Please CC any replies]
Hi,
Here is a patch to the documentation clarifying some minor issues.
The first is to the main SPI documentation clarifying that SPI isn't
available unless there is a current snapshot (leading to the "no
snapshot has been set" error).
The second clarifies when the get_
I wrote:
> I'll see about installing an initdb-time kluge to make it use OUT
> parameters.
Done:
regression=# SELECT * FROM pg_stat_file('postgresql.conf');
length | atime | mtime | ctime
| isdir
++--
Bruce Momjian writes:
> Tom Lane wrote:
>> I suppose as long it's just this one function at stake, we could imagine
>> fixing the pg_proc row after-the-fact (later in the initdb sequence).
>> Pretty klugy but something nicer could get done in the 8.2 time frame.
> Yes, see my earlier email --- we
Tom Lane wrote:
> Bruce Momjian writes:
> > SELECT pg_ls_dir
> > FROM(
> > SELECT pg_ls_dir(t1.setting)
> > FROM(SELECT setting FROM pg_settings
> > WHERE NAME = 'log_directory') AS t1
> > ) AS t2,
> >
Andreas Pflug wrote:
> Bruce Momjian wrote:
> >
> > Also, do we have a way to return columns from a system-installed
> > function? I really don't like that pg_stat_file() to returns a record
> > rather than named columns. How do I even access the individual record
> > values?
>
> As in pg_setti
Bruce Momjian writes:
> SELECT pg_ls_dir
> FROM(
> SELECT pg_ls_dir(t1.setting)
> FROM(SELECT setting FROM pg_settings
> WHERE NAME = 'log_directory') AS t1
> ) AS t2,
> (SELECT setti
Bruce Momjian wrote:
Also, do we have a way to return columns from a system-installed
function? I really don't like that pg_stat_file() to returns a record
rather than named columns. How do I even access the individual record
values?
As in pg_settings:
SELECT length, mtime FROM pg_file_stat
Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
Bruce Momjian wrote:
Well, if they mix log files and non-log files in the same directory, we
would have to filter based on the log_filename directive in the
application, or use LIKE in a query.
.. which is what pg_logdir_ls does. An
Marko Kreen wrote:
> On Sat, Aug 13, 2005 at 11:12:18AM -0400, Bruce Momjian wrote:
> > Marko Kreen wrote:
> > > On Fri, Aug 12, 2005 at 10:06:21PM -0400, Bruce Momjian wrote:
> > > > Thanks. All seven applied.
> > >
> > > Good, but you missed one step: 'cvs remove API'
> >
> > Uh, I reread your
On Sat, Aug 13, 2005 at 11:12:18AM -0400, Bruce Momjian wrote:
> Marko Kreen wrote:
> > On Fri, Aug 12, 2005 at 10:06:21PM -0400, Bruce Momjian wrote:
> > > Thanks. All seven applied.
> >
> > Good, but you missed one step: 'cvs remove API'
>
> Uh, I reread your emails and couldn't find what file
Marko Kreen wrote:
> On Fri, Aug 12, 2005 at 10:06:21PM -0400, Bruce Momjian wrote:
> > Thanks. All seven applied.
>
> Good, but you missed one step: 'cvs remove API'
Uh, I reread your emails and couldn't find what file to remove. Which
ones?
--
Bruce Momjian| http:
Tom Lane wrote:
> Bruce Momjian writes:
> > What I can imagine making things very easy is a readonly GUC that returns
> > the current log file name.
>
> ... which unfortunately is not going to happen since the backends can't
> see inside the syslogger process to know what it's doing.
That's a sh
On Fri, Aug 12, 2005 at 10:22:32PM -0400, Bruce Momjian wrote:
> Michael Fuhr wrote:
> > ECPG ignores SAVEPOINT if it's the first statement of a transaction:
ECPGtrans() ignores the statement because of this check:
/*
* if we are not in autocommit mode, already have committed the
* transa
Bruce Momjian writes:
> What I can imagine making things very easy is a readonly GUC that returns
> the current log file name.
... which unfortunately is not going to happen since the backends can't
see inside the syslogger process to know what it's doing.
ATM I think the best you can do is look
Andreas Pflug <[EMAIL PROTECTED]> writes:
> Bruce Momjian wrote:
>> Well, if they mix log files and non-log files in the same directory, we
>> would have to filter based on the log_filename directive in the
>> application, or use LIKE in a query.
> .. which is what pg_logdir_ls does. And it's robu
"Bruce Momjian"
wrote:[EMAIL PROTECTED]
> William ZHANG wrote:
> > Make sure the lib directory is in the PATH.
> > I tested it in MinGW.
> >
> > $ ecpg main.pgc
> > $ gcc main.c -I../include -L../lib -lecpg
> > $ export PATH=$PATH:"/c/Program Files/PostgreSQL/8.0/lib"
> > $ ./a.exe
> > [1772]: EC
Hi!
attached is a patch against psql that makes psql's tabcomplete code
ROLES aware, adds SET SCHEMA and basic CREATE DATABASE/TRIGGER support
as well as some other minor things.
In addition to this I modified \du to display a list of roles with some
additional information(createrole,connection li
On Fri, Aug 12, 2005 at 10:06:21PM -0400, Bruce Momjian wrote:
> Thanks. All seven applied.
Good, but you missed one step: 'cvs remove API'
--
marko
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Bruce Momjian wrote:
True, but that is more for the application. I don't imagine a user
looking at that from psql would have a problem.
However, you asked for a query that looks like pg_ls_logdir() and here
it is:
SELECT pg_ls_dir
FROM(
SEL
25 matches
Mail list logo