On 2006-04-22, Wes <[EMAIL PROTECTED]> wrote:
> I have a C application (libpq) that uses partitioning. I create parent
> tables 'header' and 'detail'. The application reads opens multiple
> connections, creates the child tables, and uses COPY to import the data:
>
> open connection 1
> begin
On 2006-04-21, "Brandon Metcalf" <[EMAIL PROTECTED]> wrote:
> What is the best way to handle timestamps with a timezone of IDT? I
> see that I could modify src/backend/utils/adt/datetime.c to support
> IDT, but what is the best solution?
>
> Basically, I have an application where I'm grabbing the
On Sat, Apr 22, 2006 at 01:10:34AM +0200, Nicolas Baradakis wrote:
> Tyler MacDonald wrote:
>
> > I see this continuining to be a problem for the postgresql community
> > given how many GPLed projects use libpq. freeradius might be fixable with a
> > change in their license, but for postgresql
On Sat, Apr 22, 2006 at 08:45:49AM +0530, Mavinakuli, Prasanna (STSD) wrote:
> Hello Martijin,
>
> I have one more doudt ..while building libpq.so we are not specifying
>
> --enable-thread-safety
>
> Will it make any difference..?
Well, if you don't, the libpq won't know anything about thread
Martijn van Oosterhout wrote:
> On Sat, Apr 22, 2006 at 01:10:34AM +0200, Nicolas Baradakis wrote:
> > As PostgreSQL is participating in Google Summer of Code 2006, perhaps
> > the GnuTLS support could be a student's project.
>
> Before someone runs off to consider this, I've already done it. My
>
On Sat, Apr 22, 2006 at 03:47:51PM +0200, Nicolas Baradakis wrote:
> Martijn van Oosterhout wrote:
> > Before someone runs off to consider this, I've already done it. My
> > preliminary patch is here:
> >
> > http://svana.org/kleptog/temp/gnutls.patch
>
> I'm speechless. Everything is mostly done
> If this is the first child table of "header", which it presumably is, then
> the pg_class row for "header" has to be updated to set relhassubclass. Since
> you do not commit the create before continuing, this backend continues to
> hold a row lock on the updated, uncommitted pg_class row while yo
-Original Message-
From: "Martijn van Oosterhout"
Sent: 22/04/06 15:11:38
To: "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] Debian package for freeradius_postgresql module
> Well, you need to be careful here. Just installing GnuTLS support as is
> will break the latest release of
On Sat, Apr 22, 2006 at 04:30:21PM +0100, Dave Page wrote:
> > Well, you need to be careful here. Just installing GnuTLS support as is
> > will break the latest release of psqlODBC, because they do things with
> > libpq that it wasn't really designed for.
>
> Err, what? It uses PQsocket & PQgetss
-Original Message-
From: "Martijn van Oosterhout"
Sent: 22/04/06 16:44:33
To: "Dave Page"
Cc: "pgsql-general@postgresql.org"
Subject: Re: [GENERAL] Debian package for freeradius_postgresql module
> I don't disagree that this is proper use of the API, but I don't think
> the original crea
Agent M wrote:
Sorry, but you misunderstand- nowhere am I interested in the role's
password. My previous suggestion was to add a password to set session
authorization itself so that if the authorization were to be reset, it
would need to be done with that password; the password itself could be
"Dave Page" writes:
> From: "Martijn van Oosterhout"
>> Well, you need to be careful here. Just installing GnuTLS support as is
>> will break the latest release of psqlODBC, because they do things with
>> libpq that it wasn't really designed for.
> Err, what? It uses PQsocket & PQgetssl, both of
On Sat, Apr 22, 2006 at 01:23:51PM -0400, Tom Lane wrote:
> "Dave Page" writes:
> > Err, what? It uses PQsocket & PQgetssl, both of which are official,
> > supported functions that may be being used by countless other apps for
> > all we know.
>
> Dave, weren't you paying attention to the recent
-Original Message-
From: "Tom Lane"<[EMAIL PROTECTED]>
Sent: 22/04/06 18:23:58
To: "Dave Page"
Cc: "kleptog@svana.org",
"pgsql-general@postgresql.org"
Subject: Re: [GENERAL] Debian package for freeradius_postgresql module
> Dave, weren't you paying attention to the recent discussion? G
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Why don't you just use "SET SESSION AUTHORIZATION somerole", and then scan
> the to-be-executel sql scripts for any occurence of "reset session
> authorization",
> and ignore the script it matches.
What would probably be better is a way to do SET S
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
Why don't you just use "SET SESSION AUTHORIZATION somerole", and then scan
the to-be-executel sql scripts for any occurence of "reset session
authorization",
and ignore the script it matches.
What would probably be better is a wa
I'd like to be able to connect to postgres, and automatically assume a specific
role.
I imagine something like
create role myuser ;
create role dev noinherit ;
create role admin noinherit superuser ;
grant dev to myuser ;
grant admin to myuser ;
Now, I'd like a connect as "myuser/admin" to be e
What resource do I need to increase to avoid the error above?
Trying to do a straight select against a table with 6 million records.
So far tried increasing SHMMAX to 512MB
---(end of broadcast)---
TIP 6: explain analyze is your friend
Francisco Reyes <[EMAIL PROTECTED]> writes:
> What resource do I need to increase to avoid the error above?
Process memory allowed to the client; this is not a server-side error.
regards, tom lane
---(end of broadcast)---
TI
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> I'd like to be able to connect to postgres, and automatically assume a
> specific role.
Why don't you just connect as that role to begin with? This seems like
a pretty low-value frammish.
regards, tom lane
---
Hi List
I have maybe an easy question but i do not find an answer, i have this
SQL query:
SELECT geom,group,production_facs FROM south_america
WHERE municipio = ''
OR municipio = 'ACRE'
OR municipio = 'ADJUNTAS'
OR
Important stuff: Fedora Core 2, postgresql-7.4.7-3.FC2.1 Also, I know
*nothing* about PostGreSQL, SQL, or databases in general :-)
I installed the RPMs and the service starts and runs. I added a user
and gave it a password, and gave the psql user "postgres" a different
password. But I can log
I expect that you will need to post and explain analyze results of this query
so that members of
the list can give you better feedback.
--- Bert <[EMAIL PROTECTED]> wrote:
> Hi List
> I have maybe an easy question but i do not find an answer, i have this
> SQL query:
>
> SELECT geom,group,prod
> I installed the RPMs and the service starts and runs. I added a user
> and gave it a password, and gave the psql user "postgres" a different
> password. But I can log on with neither. No, I didn't forget the
> passwords :-)
when you first start postgres you need to specify the database you ar
On Sat, Apr 22, 2006 at 06:18:18PM -0700, Richard Broersma Jr wrote:
>
> you can reference the following page for ideas:
> http://www.postgresql.org/docs/7.4/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF
>
> but to get started I would recommend:
> "
> TYPE DATABASEUSERI
My first thought would be to consider changing the municipio column to an
int and listing the full names in another table.
In this scenario would you be able to search something like
where municipio>1 and municipio <20
If not you may still get improvements from an int search instead of a string
s
> Is whitespace important? Tabs? The number of spaces?
> Ohhhkyyy... so, what settings would be needed to get usable logs?
> Set everything that has "log" in the name to "true"?
--postgresql.conf
redirect_stderr = true
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.l
27 matches
Mail list logo
