On Wed, Jan 6, 2010 at 11:13 PM, Mike Landis mlan...@pnmx.com wrote:
Can you please stop displaying the email addresses on bug reports? It's one
thing to require an email address - it's another thing entirely to publish
it for spam address harvesting bots.
This is an example page...
Mike Landis mlan...@pnmx.com writes:
When I execute the following SQL:
SELECT COUNT(*) FROM information_schema.tables WHERE table_name='proxies'
in the PGAdmmin 1.10.0, rev 7945-7946 query tool, I get 1 (the correct
answer). When I run the exact same SQL in a C program, I get a result set
Robert Haas escribió:
On Wed, Jan 6, 2010 at 11:13 PM, Mike Landis mlan...@pnmx.com wrote:
Can you please stop displaying the email addresses on bug reports? It's one
thing to require an email address - it's another thing entirely to publish
it for spam address harvesting bots.
This is
mich...@x054:[/data/home/
michael]ls -ld /
drwxr-xr-x 27 root system 4096 Jan 04 17:20 /
mich...@x054:[/data/home/michael]ls -ld /usr
drwxr-xr-x 43 root system 4096 Jan 05 13:40 /usr
mich...@x054:[/data/home/michael]ls -ld /usr/local
drwxr-xr-x 19 root system
Michael Felt mamf...@gmail.com writes:
I suppose I could turn on audit and see if it is trying to access a hard
coded directory. But, in any case, I would update the error message to at
least mention the directory name it is having issues with.
Well, the problem is what to print? The failure
Well, there is an argument that a system call is using to get somewhere?
Even if it is a number, it is something. I could do an ncheck or whatever to
at least find what it is calling.
As I am not at all familiar with the code - just give me source to debug,
and I'll work from that.
On Thu, Jan
Michael Felt mamf...@gmail.com writes:
On Thu, Jan 7, 2010 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, the problem is what to print? The failure we are trying to report
is exactly that we *can't get* the name of the directory.
Well, there is an argument that a system call is using
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes:
I found pgbench sometimes receives responces of UPDATE 0 from HEAD server.
When I re-tested pgbench with 8.4.2 server, all of the results were UPDATE
1.
Are there known issues in HEAD for concurrent updates?
I suspect it might have
mich...@x054:[/data/prj/postgresql-8.4.2/src]grep cwd */*.c
Well, unless you redefine it...
port/exec.c:#define getcwd(cwd,len) GetCurrentDirectory(len, cwd)
port/exec.c:charcwd[MAXPGPATH],
port/exec.c:if (!getcwd(cwd, MAXPGPATH))
port/exec.c:
On Thu, Jan 7, 2010 at 9:16 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Robert Haas escribió:
On Wed, Jan 6, 2010 at 11:13 PM, Mike Landis mlan...@pnmx.com wrote:
Can you please stop displaying the email addresses on bug reports? It's
one
thing to require an email address - it's
On Thu, Jan 7, 2010 at 10:00 AM, Michael Felt mamf...@gmail.com wrote:
mich...@x054:[/data/prj/postgresql-8.4.2/src]grep cwd */*.c
Well, unless you redefine it...
port/exec.c:#define getcwd(cwd,len) GetCurrentDirectory(len, cwd)
If you look at the context of this #define you'll see that it
I wrote a simple program - just calling getcwd() and I added some extra text
to exec.c - to know where it is at. You should recognize it.
mich...@x054:[/data/home/michael]ls -l /usr/local/pgsql/bin/mytest
-rwx--1 root system 4793 Jan 07 15:39
/usr/local/pgsql/bin/mytest
I turned on audit - it continues to say michael as user for accountability.
Notice: su changes to /home/postgres and initdb changes to
/usr/local/pgsql/bin
FS_Chdirmichael OK Thu Jan 07 16:06:35 2010
su Global
change current directory to:
Michael Felt mamf...@gmail.com writes:
I ran my test program with larger and smaller MAXPGPATH constants. 2046
(1023 * 2) was the largest I tested and it worked fine. When it was shorted
the call failed. I did not test the error message.
[ scratches head... ] This seems to be misbehavior of
Try the following, where
mystring is an extension of std::string...
mystring sql( SELECT COUNT(*) FROM information_schema.tables
WHERE table_name='proxies' );
int
GetIntFromSQL(
mystring sql )
{
// if there's more than one
record in the ResultSet, still only returns the first float
int
On Thu, Jan 7, 2010 at 7:51 AM, Mike Landis mlan...@pnmx.com wrote:
Try the following, where mystring is an extension of std::string...
It seems to me this would be a lot easier if you could attach a
complete program that someone could just compile, instead of code
fragments that are missing
On Thu, Jan 7, 2010 at 11:39 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
I have to say that the error message that is produced by the above
test case could easily send one looking in the wrong direction, and
could perhaps stand to be improved. Could we
Mike Landis wrote:
html
body
font color=#FFPick a database and table that exists, configure
the string cconstants, compile and run the attached cpp, get 0 instead of
1 (that you get in pgAdmin...brbr
You realize that information_schema only shows you tables that have
permissions on,
Mike Landis wrote:
Pick a database and table that exists, configure the string
cconstants, compile and run the attached cpp, get 0 instead of 1 (that
you get in pgAdmin...
Where's can I download the libpq source? Maybe I can find and/or fix
the problem myself.
Your program works fine for
On Thu, Jan 7, 2010 at 7:31 PM, Mark Kirkwood
mark.kirkw...@catalyst.net.nz wrote:
Mike Landis wrote:
Pick a database and table that exists, configure the string cconstants,
compile and run the attached cpp, get 0 instead of 1 (that you get in
pgAdmin...
Where's can I download the libpq
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes:
I found pgbench sometimes receives responces of UPDATE 0 from HEAD server.
When I re-tested pgbench with 8.4.2 server, all of the results were UPDATE
1.
Are there known issues in HEAD for concurrent updates?
There are now :-(. I've
Tom Lane t...@sss.pgh.pa.us wrote:
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes:
I found pgbench sometimes receives responces of UPDATE 0 from HEAD server.
When I re-tested pgbench with 8.4.2 server, all of the results were UPDATE
1.
Are there known issues in HEAD for
i am learning to use reply all, but having reply go to the list by default,
rather than the last person that replies might be useful as well.
On Thu, Jan 7, 2010 at 4:08 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Jan 7, 2010 at 9:16 AM, Alvaro Herrera
alvhe...@commandprompt.com
(I forgot to cc -bugs...)
Mike Landis wrote:
Two things strike me as odd about that...
1) What's the logic behind the owner of a table not automatically
getting a readonly privilege like SELECT?
Owner always has select on a table they have created.
2) I think it would be more logical to
Mike Landis wrote:
At 09:09 PM 1/7/2010, you wrote:
I suspect they do not. Its all in the permissions.
There's no user account control enabled on this Vista machine,
therefore effectively wide open, hence different platform behavior or
at least a difference between the behavior in pgAdmin
25 matches
Mail list logo