1) how can I tell which users are in my group?
2) I have granted all to a group but they can not alter my table.. is that correct?
I'm using 7.2
Travis
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Wed, Oct 15, 2003 at 01:53:49PM -0500, Alejandro Forero Cuervo wrote:
> > In 7.4 there will be error codes.
>
> Does that imply that the socket-level protocol for backend /
> frontend communication will change in version 7.4?
Yes.
> > > Do those strings get translated to different lang
On Wed, 15 Oct 2003 08:43:07 -0700 Dennis Gearon <[EMAIL PROTECTED]> wrote:
> >$count = pg_numrows( $result);
> >for( $i = 0; $i < $count; $i++){
...
> in case of no rows, maybe do:
>
> $count = pg_numrows( $result);
> while ( 0 < $result ){
...
shouldn't make a difference; in php, the condition
On Wed, Oct 15, 2003 at 11:00:10AM -0700, Mark Harrison wrote:
>
> Is there a way to optimize count(*) such that it does not have
> to do a sequential scan? We use this on some big tables and it
> is slowing down processing quite a lot.
No. There's a busload of discussion on this topic in the a
Tom Lane wrote:
Edmund Dengler <[EMAIL PROTECTED]> writes:
Normally, when I am comparing rows, I do want NULL <> NULL.
No, you still haven't got the point. NULL is not equal to NULL, and
it is not not-equal-to NULL either. The result of the comparison is
NULL, not true or false. This is
On Mon, 6 Oct 2003, CSN wrote:
> Every now and then my connection to my remote server
> will disconnect. If I was using the psql commandline,
> "ps" will show it's still running (after I log back
> on). Is there a way to get access to the running psql
> process again, or cause it to disconnect and
I would guess most likely not. There are a few mysql features that postgres
doesn't have (for example mysql_insert_id) but there are still ways to do
them in postgers. I doubt it will be very hard.
- Original Message -
From: "Errol Neal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
On Wed, 15 Oct 2003, Dennis Gearon wrote:
>
> >$count = pg_numrows( $result);
> >for( $i = 0; $i < $count; $i++){
> >$row = pg_fetch_object( $result, $row);
> >...
> >}
> >
> >if you want it to work.
> >
> >
> >
> in case of no rows, maybe do:
>
> $count = pg_numrows( $result);
> while
On Wed, 15 Oct 2003, Mike Leahy wrote:
> I increased those variables you suggested, and that seems to have increased
> the memory allocated to the process in windows.
>
> Also, I tried the same query I was using, but with some actual values
> specified in the where statement - that got it to use t
Muhyiddin A.M Hayat wrote:
Dear all,
I Have This table
trx_date trx_time descriptions
payment_method debet credit balance creator
10/09/2003 21:55:02 Resto Billing 13.800,00 Paid:
1
PostgreSQL
I am using Microsoft Visual FoxPro to connect VIA ODBC using both
a DSN connection and a DSNLess Connection. The DSNLess connection is
Wy... slower than the DSN connection and I am having a problem
trying to figure out what ODBC settings affect performance this much.
using DSN
Alejandro Forero Cuervo writes:
> I could also parse the error string and try to detect what went
> wrong based on it, but I'd rather stay away from that option,
> which doesn't look very maintainable. Or should I do that?
In 7.4 there will be error codes.
> Do those strings get
This should definitely be a FAQ.
The semantics of MVCC (multi-version concurrency control) means that you
can't just store a number somewhere in the header of the table like some
other database systems do.
Try a count(*) on Oracle and you will see similar behavior. They use
MVCC also.
> -Or
My guess is this will happen natually after using postgres for a short time.
(That's what happened to me.)
- Original Message -
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
To: "scott.marlowe" <[EMAIL PROTECTED]>
Cc: "Errol Neal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, Oct
Alvaro Herrera writes:
> Yes, unless you leave to lc_messages option defined to "C".
> Unfortunately this cannot be changed at runtime by non-superusers, I
> don't know why.
Because otherwise any random user could obscure his actions in the server
log by setting the language to something the admi
On Wed, Oct 15, 2003 at 12:44:55PM -0600, scott.marlowe wrote:
> All the rest if pretty straight forward hacking, having converted or
> helped to convert a few other MySQL tools to Postgresql recently.
Of course, to get maximum performance you should drop the MySQL support
and instead of coding
On Wed, 15 Oct 2003, Errol Neal wrote:
> Hi all,
>
> Not sure if this is a question for a php list or this one, but I'll give it
> a shot and
> if I am wrong, please do not crucify me. :-)
>
> There is a php based sourceforge project called mailwatch.
> (http://www.sourceforge.net/projects/mai
> In 7.4 there will be error codes.
Does that imply that the socket-level protocol for backend /
frontend communication will change in version 7.4?
> > Do those strings get translated to different languages, for
> > instance?
>
> Yes.
I guess that rules out the option of parsing them to
On Wed, 15 Oct 2003, David So wrote:
> Hi All
>
>
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?
If you need performance either get a copy of BSD or Linux and run it on
that, or get the nati
Hi,
scott.marlowe wrote, On 10/14/2003 9:54 PM:
On Tue, 14 Oct 2003, CoL wrote:
hi,
Pavel Stehule wrote, On 10/14/2003 5:47 PM:
> Yes, you can use plsh
>
> http://developer.postgresql.org/~petere/plsh.html
>
> regards
> Pavel
or plperl, or plphp too :)
I think the new version must run in safe
Thanks for the quick reply,
could you please elaborate or give me some pointers on Nested Transactions or Savepoints( which you are talking about in your reply to the first problem)
thanks in advance,
regards
vatsal
On Tue, 2003-10-14 at 23:49, Stephan Szabo wrote:
On Tue, 14 Oct
You need to create the plpgsql language in your database first. See
http://www.faqs.org/docs/ppbook/c19610.htm for how to do this.
Hope this helps,
[EMAIL PROTECTED]
[EMAIL PROTECTED] ("Thomas LeBlanc") wrote in message news:<[EMAIL PROTECTED]>...
> I copied an example from the help:
>
> CREATE
Mark Harrison writes:
> Is there a way to optimize count(*) such that it does not have
> to do a sequential scan?
No. If you need to count a lot, you need to store the information
separately.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
Hello.
I'm new to PostgreSQL and I'm using it for some project. I
am currently creating an entity engine that provides a web
interface, which is oriented towards end users, to the database
based on some enriched description of the tables (from which it
also generates the SQL cod
On Wed, Oct 15, 2003 at 09:14:09AM -0400, Bruce Momjian wrote:
> I think SRA's version has better performance because it is a native
> Windows version, rather than using Cygwin, and it does threading, rather
> than CreateProcess() to start each database session.
I asked SRA a month ago or so if t
We're looking into moving some data from mysql to postgresql, and
notice that count(*) does not seem to be a constant-time function
as it seems to be in mysql.
planb=# explain select count(*) from assets;
QUERY PLAN
"Stephen" <[EMAIL PROTECTED]> writes:
> Is it normal for plain VACUUM on large table to degrade performance by over
> 9 times? My database becomes unusable when VACUUM runs. From reading
> newsgroups, I thought VACUUM should only slow down by 10% to 15%.
We have heard reports of very significant s
On Wed, Oct 15, 2003 at 10:37:27AM +0530, Vatsal wrote:
> could you please elaborate or give me some pointers on Nested
> Transactions or Savepoints( which you are talking about in your reply to
> the first problem)
Nested transactions are not implemented in Postgres, and won't be in the
next rel
Hello,
Is it normal for plain VACUUM on large table to degrade performance by over
9 times? My database becomes unusable when VACUUM runs. From reading
newsgroups, I thought VACUUM should only slow down by 10% to 15%. Other MVCC
databases like MySQL InnoDB can even VACUUM discretely (runs internal
Edmund Dengler <[EMAIL PROTECTED]> writes:
> Normally, when I am comparing rows, I do want NULL <> NULL.
No, you still haven't got the point. NULL is not equal to NULL, and
it is not not-equal-to NULL either. The result of the comparison is
NULL, not true or false. This is consistent with the i
Thanks a lot guys for prompt and informative reply.
regards
vatsal
___
**Disclaimer
Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confide
$count = pg_numrows( $result);
for( $i = 0; $i < $count; $i++){
$row = pg_fetch_object( $result, $row);
...
}
if you want it to work.
in case of no rows, maybe do:
$count = pg_numrows( $result);
while ( 0 < $result ){
$result--;
$row = pg_fetch_object( $result, $row);
...
}
or
$
Ah there in lies the problem. I have my database encoding set to LATIN1
and I have this value stored in my table and can even write SQL to search
against it:
select *
from mdc_products
where description ~* '?'
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT -
I guess it comes back to the semantics of NULL. As has been pointed out in
many a database course, what we mean by NULL changes, and how we want to
use NULL changes on circumstances.
Normally, when I am comparing rows, I do want NULL <> NULL. In
this specific instance, no value has been assigned t
If the code is hard coded to use the built in mysql function calls, you
can replace them with postgresql calls or add a layer of database
abstraction. Once you dump the schema into postgres and make whatever
datatype etc, changes that need to be made you should be able to test
the application by r
On Wed, 15 Oct 2003 10:16:29 -0400 Errol Neal <[EMAIL PROTECTED]> wrote:
> There is a php based sourceforge project called mailwatch.
> (http://www.sourceforge.net/projects/mailwatch) It logs data from the excellent
> Mailscanner security product into a mysql database. Now, I am not a php
> progr
To get a list of the non-default tables in your database, do this:
SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg_%';
If you really want all of the tables, including the ones PostgreSQL
creates by default, just do this:
SELECT tablename FROM pg_tables;
Hope this helps,
[EMAIL PROT
Hi all,
Not sure if this is a question for a php list or this one, but I'll give it
a shot and
if I am wrong, please do not crucify me. :-)
There is a php based sourceforge project called mailwatch.
(http://www.sourceforge.net/projects/mailwatch) It logs data from the excellent
Mailscanner secu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Openoffice has a nice formbuilder which can be used to create Frontends
to any DB accisble by odbc. It claims to be as good as access, but with
the beneffit of all the power of Postgres or any other db engine. There
are some docs accessible from the Op
On Wednesday 15 October 2003 05:34, David So wrote:
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?
I know one person who was quite happy with the windows version from
http://www.dbexperts.net/. H
David So wrote:
> Hi All
>
>
>
> For deploying PostgreSQL on Windoz platform, which one is a better
> option (performance, reliability) ? Thru Cygwin or Paid version from
> SRA?
I think SRA's version has better performance because it is a native
Windows version, rather than using Cygwin, and i
so the only way i come around this problem is dump my db. drop the db. and
do a initdb with the right settings and run my dump on the new one?
how can i figure out which locale is set on the suse machine (i am a linux
novice, sorry)?
which locale i should set on the suse machine for use in a ge
Hi,
CSN wrote:
Just wondering - is there something similar to this
(clustering) for PostgreSQL? If so, how does it
compare?
http://www.mysql.com/press/release_2003_30.html
Marketing... they're lying the hell out of anything.
"mission critical business apps" *muhahaha*
"640K are enough for everybo
Dear all,
I Have This table
Table Billing:
id
trx_date trx_time depart payment_method
billing_amount amount_paid
balance creator
1 10/09/2003
21:55:02 Resto
Visa 13.800,00
Stephan, thanks for the response.
I increased those variables you suggested, and that seems to have increased
the memory allocated to the process in windows.
Also, I tried the same query I was using, but with some actual values
specified in the where statement - that got it to use the indexes
On Wednesday 15 October 2003 04:36, CSN wrote:
> Just wondering - is there something similar to this
> (clustering) for PostgreSQL? If so, how does it
> compare?
>
> http://www.mysql.com/press/release_2003_30.html
What does this do and how?
--
Richard Huxton
Archonet Ltd
--
On Tue, 14 Oct 2003, Mike Leahy wrote:
> CREATE INDEX tbl_censo_poblacion_1993_manzana_idx ON tbl_censo_poblacion_1993
> ( dubicacion, zona, manzana );
>
> Then I try a query such as:
>
> select count(*) as POBLACION, (dubicacion || zona || manzana) as COD_MANZANA
> from tbl_censo_poblacion_1993 g
Hi,
is there any good trigger tutorial on the net ??
thx
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore you
Hi All
For deploying PostgreSQL on Windoz platform, which one is a
better option (performance, reliability) ? Thru Cygwin or Paid version from
SRA?
Any option for hot backup?
Thank you
49 matches
Mail list logo
