[EMAIL PROTECTED] says...
> A partial index is a index on a subset of a table. The case I can think of
> is a list of transactions, some of which are yet to be billed. They have a
> BillID field which is NULL. since this is the recent set it is queried quite
> often, so you can build an index li
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I renamed a couple tables, and the names of their
> corresponding sequences remained the same. This causes
> a problem because when importing - the create table
> statements create sequences with different names, then
> the setval() statements us
> The only reason PG views aren't
> updateable by default is (AIUI) a lack of agreement on how they should
> work for complex view definitions.
Actually I think it's more that no one has felt like tackling it. The
SQL spec only requires views to be updatable when they are "sufficiently
simple", an
On Wed, 17 Dec 2003, Ron St-Pierre wrote:
> Stephan Szabo wrote:
>
> >On Wed, 17 Dec 2003, Ron St-Pierre wrote:
> >
> >
> >
> >>On a daily basis I place a lot of data into the empty table dailyList,
> >>and from that data update certain fields in currentList. I thought that
> >>using a function wo
Ron St-Pierre <[EMAIL PROTECTED]> writes:
> On a daily basis I place a lot of data into the empty table dailyList,
> and from that data update certain fields in currentList. I thought that
> using a function would be a good way to do this(?). However I get the
> following error when I run update
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> pg_dump has evidently not gotten the word. If we think the backend's
>> behavior is right then we'd better change pg_dump to suppress trying
>> to GRANT permissions on untrusted languages.
> There should not be any permissions, so
Stephan Szabo wrote:
On Wed, 17 Dec 2003, Ron St-Pierre wrote:
On a daily basis I place a lot of data into the empty table dailyList,
and from that data update certain fields in currentList. I thought that
using a function would be a good way to do this(?). However I get the
following error wh
On Wed, 17 Dec 2003, Ron St-Pierre wrote:
> On a daily basis I place a lot of data into the empty table dailyList,
> and from that data update certain fields in currentList. I thought that
> using a function would be a good way to do this(?). However I get the
> following error when I run updateC
On a daily basis I place a lot of data into the empty table dailyList,
and from that data update certain fields in currentList. I thought that
using a function would be a good way to do this(?). However I get the
following error when I run updateCurrentData():
ERROR: set-valued function calle
Tom Lane wrote:
> Hm. The backend flat-out rejects all attempts at GRANT on untrusted
> languages, even if you are superuser and the grantee is too. I'm not
> totally sure about the rationale for that (Peter?)
Why would you need it? It's only going to create fuss about useless
functionality.
Try this link to OpenOffice and its postgres-sdbc-driver.
http://dba.openoffice.org/drivers/postgresql/
I have Installed OO on RedHat and tested that I can connect postgres -
which it does without any dramas, but I havent done much more than that.
So I am not sure as to what the limit is on the
> Tom Lane wrote:
>> [ scratches head ... ] Right at the moment I don't see where
>> ShutdownExprContext gets called during a ReScan operation. I'm quite
>> sure it once was ... there may be another bug here ...
After further looking I've realized that memory is misserving me here;
having ReScan
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Any guidance on the preferred fix?
We cannot fix this by changing ExecScanSubPlan as you suggest.
That would amount to saying that all plans have to be run to completion,
which destroys LIMIT to name just one unpleasant consequence.
I suspected
On Wed, 2003-12-17 at 15:25, Tom Lane wrote:
> Christopher Murtagh <[EMAIL PROTECTED]> writes:
> > Am I missing something obvious?
>
> The permissions were granted to PUBLIC, not to newuser, and so the
> REVOKE doesn't do anything. You'd need to revoke rights from PUBLIC and
> then grant them bac
--On Wednesday, December 17, 2003 16:08:04 -0400 "Marc G. Fournier"
<[EMAIL PROTECTED]> wrote:
Anyone doing this? it looks simple enough, but am wondering if anyone has
found any admin utilities/frontends for it, or have any 'suggested
schemas' different then the examples provided ...
I know O
On Wed, 17 Dec 2003, Christopher Murtagh wrote:
> On Wed, 2003-12-17 at 13:54, Stephan Szabo wrote:
> > I think you probably want to revoke create on the public schema. Create on
> > databases controls the creation of schemas.
> > From the grant page:
>
> Hrm, thanks for the reply. I tried that
Anyone doing this? it looks simple enough, but am wondering if anyone has
found any admin utilities/frontends for it, or have any 'suggested
schemas' different then the examples provided ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> Am I missing something obvious?
The permissions were granted to PUBLIC, not to newuser, and so the
REVOKE doesn't do anything. You'd need to revoke rights from PUBLIC and
then grant them back to whomever should have them.
On Wed, 2003-12-17 at 13:54, Stephan Szabo wrote:
> I think you probably want to revoke create on the public schema. Create on
> databases controls the creation of schemas.
> From the grant page:
Hrm, thanks for the reply. I tried that too. Here's what I got (below).
Am I missing something obviou
Bernd Helmle wrote:
Don Isgitt wrote:
Hi,
gds2=# copy survey_match from '/home/djisgitt/perl/fixsvy.dat' with
delimiter as '>';
ERROR: could not open file "/home/djisgitt/perl/fixsvy.dat" for
reading: Permission denied
File sysem permissions are
[EMAIL PROTECTED] perl]$ ls -l /home/djisgi
It would be good if u can give text of the view and table structure of
the two tables.
Some of the things u can do is.
VACCUM and ANALYZE tables;
Create index on coulmn specified in where clause of the query.
Manoj
claudia wrote:
Hi, I developing a program using postgres and linux like operat
On Wed, 17 Dec 2003, Christopher Murtagh wrote:
> Greetings,
>
> I'm trying to create a user without create privileges and I don't seem
> to be able to do it. I could be clueless, but after my revoke
> statements, the new user still seems to be able to create dbs, and then
> have full privileges
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> [ pg_dump script failed with ]
> ERROR: language "plperlu" is not trusted
> and it gave a line number, which contained the following:
> GRANT ALL ON LANGUAGE plperlu TO postgres WITH GRANT OPTION;
Hm. The backend flat-out rejects all attempts at
Hello javier garcia,
Hello Bob;
Some time ago I were using Postrges along with Excel via Microsoft Query and
ODBC. I just remember that there was a problem when trying to see views but
it worked with single tables. Perhaps you can experiment with that.
This problem can be over come by
On Wed, 2003-12-17 at 13:20, Christopher Murtagh wrote:
> I'm trying to create a user without create privileges and I don't
> seem to be able to do it. I could be clueless, but after my revoke
> statements, the new user still seems to be able to create dbs, and
> then have full privileges on them.
[EMAIL PROTECTED] says...
> > Ditto for FB. If you want to extend the code, though, you have to give
> > those changes back to the community - the licence is more GPL than BSD.
> maybe you need to clarify what you think of when you say "extensible".
> postgresql has sql extensions like "cre
Tom Lane wrote:
Marek Lewczuk <[EMAIL PROTECTED]> writes:
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Sure ... just hack one or two
Miso Hlavac wrote:
Hello,
Sorry for just stupid question, but I need use md5 function in 7.4
When I write:
select md5('text');
ERROR: Function md5("unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecast
On 17/12/2003 07:59 Marek Lewczuk wrote:
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
You could try something like
myfield integer
On Wed, Dec 17, 2003 at 09:37:07AM +, Richard Huxton wrote:
> On Wednesday 17 December 2003 08:47, Miso Hlavac wrote:
> > Hello,
> >
> > Sorry for just stupid question, but I need use md5 function in 7.4
> > When I write:
> > select md5('text');
> > ERROR: Function md5("unknown") does not exis
On Wednesday 17 December 2003 08:47, Miso Hlavac wrote:
> Hello,
>
> Sorry for just stupid question, but I need use md5 function in 7.4
> When I write:
> select md5('text');
> ERROR: Function md5("unknown") does not exist
> Unable to identify a function that satisfies the given argument
>
On Wednesday 17 December 2003 07:59, Marek Lewczuk wrote:
> I'm curious if the default scheme for sequence name (which is created
> with SERIAL data type) can be changed -- currently all sequences are
> named like this: __seq -- can it be changed for
> e.g. seq ???
Your two options seem to be:
On Wed, Dec 17, 2003 at 09:47:01AM +0100, Miso Hlavac wrote:
> Sorry for just stupid question, but I need use md5 function in 7.4
> When I write:
> select md5('text');
> ERROR: Function md5("unknown") does not exist
> Unable to identify a function that satisfies the given argument types
>
Marek Lewczuk <[EMAIL PROTECTED]> writes:
> I'm curious if the default scheme for sequence name (which is created
> with SERIAL data type) can be changed -- currently all sequences are
> named like this: __seq -- can it be changed for
> e.g. seq ???
Sure ... just hack one or two places in t
On Wed, Dec 17, 2003 at 08:59:03AM +0100, Marek Lewczuk wrote:
> I'm curious if the default scheme for sequence name (which is created
> with SERIAL data type) can be changed -- currently all sequences are
> named like this: __seq -- can it be changed for
> e.g. seq ???
You'd have to hack t
Hello,
Sorry for just stupid question, but I need use md5 function in 7.4
When I write:
select md5('text');
ERROR: Function md5("unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
where is problem?
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Fri, Dec 12, 2003 at 04:24:32AM +0100, Florian G. Pflug wrote:
>> Am I right to assume that updating to 7.4 will have the same effekt as
>> updating to 7.3.5?
> No, you're not. You can update to 7.3.5 by just dropping the new
> executables into plac
Apologies if this is a double post - I'm sure I sent a similar e-mail to
the list, but it seems to have disappeared in the ether.
Id there a definitive list of what replication options are currently
available for 7.4 (and 7.5), and what their relative strengths and
weaknesses are; ease of use, con
Sorry I should have added that the trigger needs to create a new keyword
record if the join in the trigger fails to locate the keyword in the
keyword table.
Hopefully you can create the trigger yourself.
The keyword table is effectively a distinct list of all keywords inserted
into the data table
How about using two tables; one to hold the keyword and its (last
allocated) sequence value, and the second to store your data as below.
create table Keyword (
keyword varchar(32),
sequence integer,
primary key(keyword)
)
create table Data (
id serial,
sequence int,
keyword varchar(32
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Thanks.
ML
---(end of broadcast)---
TIP
Paul Ganainm wrote:
Hi all,
Following up on another thread, here is a comparison between FB and PG
from an FB'ers POV. BTW, FB is the love-child of Open-Source-Interbase.
I would love to have this comparison in a table form and posted on web. Let FB
guys chip in and make it more correct..
The
42 matches
Mail list logo
