[EMAIL PROTECTED] writes:
> Tom, below is the information you requested.
Well, the table definitions look ordinary enough, but this is odd:
> SPI Exec: 528474160 total in 69 blocks; 309634880 free (9674592
> chunks); 218839280 used
Something's leaking a lot of memory within a SPI call, which mea
I wholeheartedly support the approach BJ is advocating.
The notion that methods (functions) and variables (tables)
can be defined together is a very useful OO approach.
I too find it difficult to recall which functions "belong"
to which tables. Of course, some of my functions are very
generic and
Benjamin Smith <[EMAIL PROTECTED]> writes:
> FROM customers
> JOIN calendars ON
> (
> -- GIVE A CALENDAR OF POSSIBLE DAYS FOR DELIVERIES
> calendar.day < 20061201
> AND calendar.day >= 20060101
> )
Haven't you wr
Andre Lebedev wrote:
> Hello.
>
> Based on the information I was able to find so far, it seems that
> Postgres has the capability of authenticating users through x509
> certificate. But I can't find instructions on how to do it.
>
> Any help will be greatly appreciated!
>
It does not, unfortuna
[EMAIL PROTECTED] wrote:
> [EMAIL PROTECTED] wrote:
>> Everytime I try to install Postgre 8.2, I get the following error:
>>
>>
>> Failed to set permissions on the installed files. Please see the
>> logfile.
>>
>> The thing is, I'm telling PG to use my Administrator account (the
>> account I'm curr
Everytime I try to install Postgre 8.2, I get the following error:
Failed to set permissions on the installed files. Please see the
logfile.
The thing is, I'm telling PG to use my Administrator account (the
account I'm currently logged in as) and I'm pretty sure it has access
to everything.
Any
Regular expression and Group By
There is a varchar column which I need to group by an "uppered"
substring inside '[]' like in 'xxx[substring]yyy'. All the other lines
should not be changed.
I can do it using a union. I would like to reduce it to a single
query, but after much thought I can't. So
I have a situation that can be summarized to the following:
-- day in 20061215 format
Create table calendar (
day integer unique not null
);
Create table customers (
id serial unique not null,
name varchar,
address varchar,
);
Create table d
Great! I will take a look and let you know. I had rewritten the Provider
about a year ago as well. However, I did not have time to clean-up most of
the new bugs and decided to keep the code for myself. There is certain
interest in the US to the more capable Provider.
On 12/15/06, Jeremy Lea <[EMA
But SPI_exec() takes string containing an SQL command :-(
I need to pass previously prepared HeapTuple variable.
Best regards :-)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
wheel wrote:
> I seem to have a natural knack for hitting the ruts around here, which
> is exciting. I've tried to subscribe to the list using both yahoo and
> gmail email accounts and the webform always reports "The email address
> you entered does not appear to be valid." I would like to use e
Bruce Momjian <[EMAIL PROTECTED]> writes:
> wheel wrote:
>> I seem to have a natural knack for hitting the ruts around here, which
>> is exciting. I've tried to subscribe to the list using both yahoo and
>> gmail email accounts and the webform always reports "The email address
>> you entered doe
Hi !
I have a strange slow performance problem depending on client computer.
I have a postgresql server (8.1.3) running on an XP system (P4 3GHz,
1Go RAM).
I have 3 other computers from which I make request on the database : 2
XP(named 1 & 2) and 1 2K.
>From one XP(1) and from the 2K computer, I
Thank you all for the replies. Overcommit is indeed disabled - the
reason we disabled it is that this very same process caused the Linux
oom-killer to kill processes. This was perhaps two months ago. The
setting was changed to, and is currently set to: vm.overcommit_memory=2
...All has been well un
Hello.
Based on the information I was able to find so far, it seems that
Postgres has the capability of authenticating users through x509
certificate. But I can't find instructions on how to do it.
Any help will be greatly appreciated!
Regards,
Andre.
[EMAIL PROTECTED] wrote:
> Everytime I try to install Postgre 8.2, I get the following error:
>
>
> Failed to set permissions on the installed files. Please see the
> logfile.
>
> The thing is, I'm telling PG to use my Administrator account (the
> account I'm currently logged in as) and I'm pretty
> I also have not been able to duplicate the problem from multiple yahoo
> and gmail tests. I did however note that postgresql.org will not let you
> subscribe as [EMAIL PROTECTED] . Is .not even a valid suffix?
I wasn't able to create an account for pg_docs mailing list the other day. I
figured
Jeremy Lea wrote:
> - Runs multiple queries (using PQexec) if you pass a command with no
>parameters and IID_NULL for the return record set.
>
You should be aware that there is a security advantage to NOT being able
to do that, in fact.
On the plus side, it does allow servers older than 7.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I just started to write my first stored procedure in plpgsql and
installed a trigger for it.
The two Tables are:
CREATE TABLE ltlocation (
"id" integer DEFAULT nextval('ltlocation_id_seq'::text) NOT NULL,
name varchar(30) NOT NULL de
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Joshua D. Drake") wrote:
>
> I also have not been able to duplicate the problem from multiple yahoo
> and gmail tests. I did however note that postgresql.org will not let you
> subscribe as [EMAIL PROTECTED] . Is .not even a valid suffix?
>
>
If you have a dot in your gmail username, take it out. Gmail ignores
it and validation scripts often puke on it.
Then use that email as your reply to, not some nonexistent carp.
- Ian
On 12/13/06, wheel <[EMAIL PROTECTED]> wrote:
I seem to have a natural knack for hitting the ruts around here
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I seem to have a natural knack for hitting the ruts around here, which
> is exciting. I've tried to subscribe to the list using both yahoo and
> gmail email accounts and the webform always reports "The email address
> you entered does not appear to
On 12/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
90% of the value this would have is already available with views,
I think, without going outside bog-standard SQL:
Views also work fine, but one of the big advantages of having table
methods is that all the things your table can do are contained
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> That works fine, but wouldn't it be far more elegant if you could do
> this instead:
> CREATE TABLE person (
> id SERIAL PRIMARY KEY,
> firstname TEXT NOT NULL,
> lastname TEXT NOT NULL,
> FUNCTION name() RETURNS text AS $$ SELECT firstname || ' ' |
In the object-relational context, the definition of a "relation" is
much the same as the idea of a "class"; the columns in a table are
analogous to the attributes of a class. The names of Postgres' system
catalogs reflect this correlation (pg_class, pg_attribute).
Likewise, each tuple within a r
25 matches
Mail list logo
