2008-07-03_21:17:50-0400 Ron Peterson <[EMAIL PROTECTED]>:
> 2008-06-29_09:44:01-0400 Taha Ozket <[EMAIL PROTECTED]>:
>
> > I have a ldap group, "pgsql-developers". I have an user (user1) member
> > of this group;
> > ...
> > How can I change this line for give login permission to
> > pgsql-develo
2008-07-02_12:22:51-0400 jcvlz <[EMAIL PROTECTED]>:
> On Wed, Jul 2, 2008 at 8:35 AM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> > http://www.sqlmaestro.com/products/postgresql/
> >
> > I've used the PHP Code Generator with great success for simple stuff
> > like you describe. You could then write
2008-06-29_09:44:01-0400 Taha Ozket <[EMAIL PROTECTED]>:
> I have a ldap group, "pgsql-developers". I have an user (user1) member
> of this group;
> ...
> How can I change this line for give login permission to
> pgsql-developers members?
If you have pam available, you could do pam authentication
Tom Lane wrote:
Klint Gore <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Would you be willing to send me a "pg_dump -s" (ie, just schema no
>> data) dump of this DB? Off-list of course.
>>
> attached. created with pg_dump 8.3.3 win32 to the 8.3.1 win32 server.
Thanks. When I reload this
Hi folks,
I need to load xml data in to database can you tell me they way how do
I import xml data into postgresql database.
lets dat this is the xml file
Harry Potter
J K. Rowling
2005
29.99
Learning XML
Erik T. Ray
2003
39.95
so finally the tab
Gregory Stark <[EMAIL PROTECTED]> writes:
> That's just a special case of what would be expected to happen with memory
> allocation anyways though. Few allocators return memory to the OS anyways.
Well, that does happen on Linux for instance. Since Matt knew in his
original report that the xpath l
Valter Douglas Lisbôa Jr. wrote:
Hello all, I have a perl script thats load a entire day squid log to a
postgres table. I run it at midnight by cronjob and turns off the indexes
before do it (turning it on after). The script works fine, but I want to
change this to a diferent approach.
I'd li
On Thursday 03 July 2008, Richard Huxton <[EMAIL PROTECTED]> wrote:
> You might want to partition the table monthly. That will make it easier
> to manage a few years from now.
> http://www.postgresql.org/docs/current/static/ddl-partitioning.html
Definitely pay attention to this point ... it's pret
On Thursday 03 July 2008 13:03:49 Joshua D. Drake wrote:
> On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisbôa Jr. wrote:
> > Hello all, I have a perl script thats load a entire day squid log to a
> > postgres table. I run it at midnight by cronjob and turns off the indexes
> > before do it (t
Valter Douglas Lisbôa Jr. wrote:
Hello all, I have a perl script thats load a entire day squid log to a
postgres table. I run it at midnight by cronjob and turns off the indexes
before do it (turning it on after). The script works fine, but I want to
change this to a diferent approach.
I'd li
On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisbôa Jr. wrote:
> Hello all, I have a perl script thats load a entire day squid log to a
> postgres table. I run it at midnight by cronjob and turns off the indexes
> before do it (turning it on after). The script works fine, but I want to
>
You can preprocess text (replace accent by nothing) before
to_tsvector or to_tsquery
Oleg
On Thu, 3 Jul 2008, [EMAIL PROTECTED] wrote:
Hi again:
I am trying to create a full text configuration to ignore word accents in
my searches. My approach is similar to simple dicionary one, but i want
On Thu, Jul 03, 2008 at 11:11:26AM -0400, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > Not entirely sure why, but it'll probably have
> > something to do with avoiding ambiguity in the grammar.
>
> Right. The problem is the Berkeley-era decision to put index opclasses
> into the sy
Gwyneth Morrison <[EMAIL PROTECTED]> writes:
> What I am actually trying to get past is:
> DELETE FROM data_table1
> using data_table2 INNER JOIN
> data_table1 ON data_table1.fkey =
> data_table2.pkey;
The equivalent to that in Postgres would be
On Thu, Jul 3, 2008 at 7:29 AM, Hermann Muster <[EMAIL PROTECTED]> wrote:
>
> I just found the time to try that out and it worked! Thank you for your
> help. I actually had no idea about using schemas in PostgreSQL. It was easy
> to setup and db_link isn't needed anymore. I hope I won't run into an
On Thu, 2008-07-03 at 16:59 +0200, Csaba Nagy wrote:
> [snip] It is likely possible to do (using PREPARE TRANSACTION) [snip]
I was wrong, you can't do it with that either, see:
http://www.postgresql.org/docs/8.2/static/sql-prepare-transaction.html
Maybe there is some feature to attach/deattach to
Hello all, I have a perl script thats load a entire day squid log to a
postgres table. I run it at midnight by cronjob and turns off the indexes
before do it (turning it on after). The script works fine, but I want to
change this to a diferent approach.
I'd like to insert on the fly the log lin
Sam Mason <[EMAIL PROTECTED]> writes:
> You just want an extra set of brackets; i.e.:
> CREATE INDEX token_position_func ON token ((position+1));
> Should do the trick. Not entirely sure why, but it'll probably have
> something to do with avoiding ambiguity in the grammar.
Right. The problem
"cinu" <[EMAIL PROTECTED]> writes:
Could anyone please tell me where I am going wrong and if there is a way I can
get the same behaviour that I am getting while I am executing the through psql
prompt.
a) you might try hitting return occasionally in your email :)
b) you maybe need to put a SEL
On Thu, 2008-07-03 at 16:59 +0200, Csaba Nagy wrote:
> If you'll say what you really want
> to do, I bet you'll get a lot more useful advices...
Oh, and you should use the general list only for these kind of
questions, hackers is for discussion about hacking on the postgres code
itself. And cross-
J Ottery wrote:
Hi all.
I am using Postgres 8.3 with Windows XP Pro.
System date format is dd/MM/
Having problems when I writing records to a database with a single
'date' type field.
I may be confused here. You say writing was your problem but it sounds
like the problem is when you read
On Thu, 2008-07-03 at 19:56 +0530, cinu wrote:
> Could anyone please tell me where I am going wrong and if there is a
> way I can get the same behaviour that I am getting while I am
> executing the through psql prompt.
You're mistake is that you think a transaction is related to your
terminal, but
"Gregory Stark" <[EMAIL PROTECTED]> writes:
> CREATE INDEX token_position_func on (token(position+1))
Ooops, I misread that as if "token" were a function and not the table. Sam
Mason had the right syntax. Sorry.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me ab
On 03/07/2008 14:40, Long Cui wrote:
I install PostgreSQL 8.3.3 in Windows XP, and set Path environment
viarable to C:\Program Files\PostgreSQL\8.3\bin, when I enter "create
database mydb;" it successed, however when "createdb mydb;" told me
syntax error. Dose the Path set wrong or I need to se
I install PostgreSQL 8.3.3 in Windows XP, and set Path environment viarable
to C:\Program Files\PostgreSQL\8.3\bin, when I enter "create database mydb;"
it successed, however when "createdb mydb;" told me syntax error. Dose the
Path set wrong or I need to set other viarables?
<[EMAIL PROTECTED]> writes:
> Hi all:
>
> I'm trying to create a functional index into column position of token
> table (see below). I want to make something like:
>
> CREATE INDEX token_position_func
> ON token (position+1);
>
> but I get:
>
> test=# CREATE INDEX token_position_func
> test-# ON t
use...
ps auxw | grep postgres
--- On Wed, 7/2/08, Fernando Dominguez <[EMAIL PROTECTED]> wrote:
> From: Fernando Dominguez <[EMAIL PROTECTED]>
> Subject: [GENERAL] pg_ctl start check sum failed
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 11:30 PM
> Hello,
>
> I try
Bill Moran wrote:
In response to Hermann Muster <[EMAIL PROTECTED]>:
Hello everyone,
I already asked about that a couple of days ago, but didn't get an
satisfying solution for my problem which is following:
I need to create a view that does a query on a second database on the
same Postg
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote:
> From: Gwyneth Morrison <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 7:12 PM
> --- On Wed, 7/2/08, Gwyneth Morrison
> <[EMAIL PROTECTED]> wrote:
On Thu, Jul 03, 2008 at 11:50:39AM +0200, [EMAIL PROTECTED] wrote:
> test=# CREATE INDEX token_position_func
> test-# ON token (position+1);
> ERROR: syntax error at or near "+"
> LINE 2: ON token (position+1);
>
> I read that I can do "ON function(column)" but, is there a built-in
> function in
Scott Marlowe wrote:
Take a look here, in the notes section:
http://www.postgresql.org/docs/8.3/interactive/sql-delete.html
on the using keyword.
Thank you for your reply Scott,
I guess this is where the confusion started for me.
It says here in your reference that the using clause is n
Hi again:
I am trying to create a full text configuration to ignore word accents in
my searches. My approach is similar to simple dicionary one, but i want to
remove accents after converting to lower.
Is it the only way to do it to develop another .c and write my own
dict_noaccent.c, and then com
am Thu, dem 03.07.2008, um 11:50:39 +0200 mailte [EMAIL PROTECTED] folgendes:
> Hi all:
>
> I'm trying to create a functional index into column position of token
> table (see below). I want to make something like:
>
> CREATE INDEX token_position_func
> ON token (position+1);
>
> but I get:
>
>
Hi all:
I'm trying to create a functional index into column position of token
table (see below). I want to make something like:
CREATE INDEX token_position_func
ON token (position+1);
but I get:
test=# CREATE INDEX token_position_func
test-# ON token (position+1);
ERROR: syntax error at or nea
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Well, you tell me --- *you* reported a behavior that isn't obviously
> explained by the bug we found.
In case it wasn't clear, the bug found was a intra-transaction memory leak.
When the transaction ended the memory would be reclaimed. That doesn't seem to
On Wed, 2 Jul 2008, Tom Lane wrote:
John DeSoi <[EMAIL PROTECTED]> writes:
Is there an easy way to change '/' to be treated like '-' ? I've
looked over the documentation several times and could not find
anything. Even just a way to get the two tokens 'home' and 'work'
without the joined form wo
On Wed, Jul 2, 2008 at 6:09 PM, Chandra Barnett
<[EMAIL PROTECTED]> wrote:
>
>
> Bah. Must be pgAdmin, then. In its role creation dialogue, INHERIT is
> definitely off by default. Guess that's not you guys, though. Sorry to have
> impugned your judgement... =)
Fixed in SVN. Sorry for the confusi
Hi,
On Wed, 02 Jul 2008, Tom Lane <[EMAIL PROTECTED]> writes:
> Are there any foreign keys referencing this table? If so, you're
> probably running out of memory for the list of pending trigger events
> (to verify that the FK constraint isn't violated by the delete).
>
> Allowing the triggers to
On Thu, Jul 3, 2008 at 1:49 AM, Klint Gore <[EMAIL PROTECTED]> wrote:
> I'm running it under my own account which has adminstrator rights.
> Peak memory usage was about 540m which brought the total usage for the
> machine to about half the physical memory allocated (3g total).
> Is there a binary
In general there seem to be a lot of ways that people wish they
could tweak the text search parser, and telling them to write
their own parser isn't a very helpful response for most folk.
I don't have an idea about how to improve the situation, but
it seems like something that should be thought
40 matches
Mail list logo
