Hello,
I have some software products which support RHEL5 for x86 and x86_64. Each
of them uses PostgreSQL 8.3.12 as a data repository. They all embed the same
PostgreSQL binaries.
Now I'm trying to support both RHEL5 and RHEL6 with minimal effort (but with
safety). If possible, I want to con
Thank you all for the replies -
On Wed, Mar 16, 2011 at 3:05 PM, Igor Neyman wrote:
> Select id, sum(col1) from tab
> Where id > 10
> Group by id
> Having sum)col1) >30;
>
> Spend some time reading basic SQL docs/books - it'll help you
> tremendously.
I have already read many SQL-docs (really) a
Hi.
I've been trying to get a connection working to a PostgreSQL server
through the socket-level protocol. I've therefore been looking at
fe-connect.c and fe-protocol3.c in the src/interfaces/libpq folder.
Reading those sources, I understood, that the startup message should
begin with a request f
Hi:
I'm trying to determine who has what privs for what tables. Couldn't find any
canned views for that (but may have missed it). Or is there a query that can
get this from the metadata somehow?
Thanks in Advance.
Guillaume Yziquel writes:
> However, when I try to send this as the first thing, I get disconnected
> by the server. Reading what the psql program does, I first get an 8 byte
> message containing this:
> \000\000\000\008\004\210\022/
> This seems to work, but I'm at a loss
"MauMau" writes:
> Now I'm trying to support both RHEL5 and RHEL6 with minimal effort (but with
> safety). If possible, I want to continue to use PostgreSQL 8.3.12 built on
> RHEL5 for a while. Then, I'd like to ask some questions:
I'd recommend rebuilding the executables on RHEL6 if possible,
"Gauthier, Dave" writes:
> I'm trying to determine who has what privs for what tables. Couldn't find
> any canned views for that (but may have missed it). Or is there a query that
> can get this from the metadata somehow?
You could try using has_table_privilege() in a join between pg_class an
On Thursday, March 17, 2011 7:48:37 am Gauthier, Dave wrote:
> Hi:
>
> I'm trying to determine who has what privs for what tables. Couldn't find
> any canned views for that (but may have missed it). Or is there a query
> that can get this from the metadata somehow?
>
> Thanks in Advance.
http:
information_schema.table_privileges has it. Thanks !
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, March 17, 2011 10:59 AM
To: pgsql-general@postgresql.org
Cc: Gauthier, Dave
Subject: Re: [GENERAL] Getting users/privs for tables.
On Thursday, March 17, 2011 7:48:37 am Gau
Le Thursday 17 Mar 2011 à 10:48:50 (-0400), Tom Lane a écrit :
> Guillaume Yziquel writes:
> > However, when I try to send this as the first thing, I get disconnected
> > by the server. Reading what the psql program does, I first get an 8 byte
> > message containing this:
>
> >
Does anyone have any experience using pgwatch from Cybertec? What is
your opinion of its functionality?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a fundamental difference between a primary key and a unique index?
Currently we have primary keys on tables that have significant amounts of
updates performed on them, as a result the primary key indexes are becoming
significantly bloated. There are other indexes on the tables that al
Hi All
Now, I am using postgres-8.4.0 and psqlodbc-08.03.0400-1 and
unixODBC-2.2.14-000.01 driver to connect
to the databse. Again having the same issue . One of the queries I executed
from my application have got stuck for an
indefinite amount of time causing my application to hang. So I cored
Le Thursday 17 Mar 2011 à 16:08:55 (+0100), Guillaume Yziquel a écrit :
> Le Thursday 17 Mar 2011 à 10:48:50 (-0400), Tom Lane a écrit :
> > Guillaume Yziquel writes:
>
> For now, when sending \000\003\000\000 and only this, the server seems
> to disconnect. The recv() call on the socket returns
On Mar 17, 2011, at 6:19 AM, Voils, Steven M wrote:
> Is there a fundamental difference between a primary key and a unique index?
> Currently we have primary keys on tables that have significant amounts of
> updates performed on them, as a result the primary key indexes are becoming
> signific
We use PG COPY to successfully in PG 8 to copy a database between two
servers. Works perfectly.
When the target server is PG 9, *some* fields of type timezonetz end up
garbled. Basically the beginning of the string is wrong:
152037-01-10 16:53:56.719616-05
It should be 2011-03-16 or similar.
In
Hi,
I'm using the autodoc regression database available at
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/regressdatabase.sql?rev=1.2&content-type=text/x-cvsweb-markup
This has several schemas that have cross-schema foreign key constraints
such as the following:
autodoc=> \d pr
On Thursday, March 17, 2011 10:10:49 am Brent Gulanowski wrote:
> We use PG COPY to successfully in PG 8 to copy a database between two
> servers. Works perfectly.
>
> When the target server is PG 9, *some* fields of type timezonetz end up
> garbled. Basically the beginning of the string is wrong:
I'm noticing some interesting behavior around timestamp and extract epoch,
and it appears that I'm getting a timezone applied somewhere.
Specifically, If I do:
select EXTRACT( EPOCH FROM '2010-01-31 00:00:00'::TIMESTAMP WITHOUT TIME
ZONE ); == 1264924800
select EXTRACT( EPOCH FROM '2010-04-01 00:0
Looks like a quick search says I need to specify the timezone...
On Thu, Mar 17, 2011 at 11:22 AM, bubba postgres
wrote:
>
> I'm noticing some interesting behavior around timestamp and extract epoch,
> and it appears that I'm getting a timezone applied somewhere.
>
> Specifically, If I do:
> sele
no.. still confused.
I assume it's storing everythign in UTC.. did I need to specify a timezone
when I inserted?
On Thu, Mar 17, 2011 at 11:24 AM, bubba postgres
wrote:
> Looks like a quick search says I need to specify the timezone...
>
>
> On Thu, Mar 17, 2011 at 11:22 AM, bubba postgres > w
ok got it.
select EXTRACT( EPOCH FROM '2010-04-01 00:00:00'::TIMESTAMP WITHOUT TIME
ZONE at time zone 'utc' );
On Thu, Mar 17, 2011 at 11:32 AM, bubba postgres
wrote:
> no.. still confused.
> I assume it's storing everythign in UTC.. did I need to specify a timezone
> when I inserted?
>
>
>
> O
On Thu, Mar 17, 2011 at 6:19 AM, Voils, Steven M wrote:
> Is there a fundamental difference between a primary key and a unique index?
> Currently we have primary keys on tables that have significant amounts of
> updates performed on them, as a result the primary key indexes are becoming
> signific
On Thu, Mar 17, 2011 at 12:51 PM, Scott Marlowe wrote:
> On Thu, Mar 17, 2011 at 6:19 AM, Voils, Steven M
> wrote:
>> Is there a fundamental difference between a primary key and a unique index?
>> Currently we have primary keys on tables that have significant amounts of
>> updates performed on t
Thanks for the reply. I should have mentioned in the first post that we do
delete significant amounts of the table which I thought was the cause of the
bloat. We are already performing automatic vacuums nightly.
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
S
Thanks for the reply, that's what I was looking for. I just wasn't sure if
there was another compelling advantage to use primary keys instead of a unique
index.
-Original Message-
From: Scott Ribe [mailto:scott_r...@elevated-dev.com]
Sent: Thursday, March 17, 2011 12:13 PM
To: Voils, S
FYI, I implemented Pavel's suggestion to use:
course_begin_date::date IN (
'20100412','20100510','20100607','20100712','20100830','20100927','20101025','20101122','20101213','20110110','20110207','20110307'
)
instead of
to_char(course_begin_date,'MMDD') IN (
'20100412','20100510','20100
Dne 17.3.2011 19:29, Davenport, Julie napsal(a):
> I have not yet had time to try Tomas' suggestion of bumping up the work_mem
> first (trying to figure out how to do that from within a coldfusion script).
> Many thanks for all your help guys!
Well, just execute this 'SQL query' just like the o
Adrian Klaver Thursday 17 March 2011 19:18:25
> On Thursday, March 17, 2011 10:10:49 am Brent Gulanowski wrote:
> > We use PG COPY to successfully in PG 8 to copy a database between two
> > servers. Works perfectly.
> >
> > When the target server is PG 9, *some* fields of type timezonetz end up
>
I have set up a pg database server for my organization on a cloud server
using PG 8.2;
I am trying to provide connections to the db for some members using MS
Access. I developed a small MS Access application using Windows ODBC - it
works fine from my house.
I have this line in pg_hba.conf:
Ho
On 03/17/11 2:29 PM, Joseph Doench wrote:
I have setup a pg database server formy organizationon a cloud
serverusing PG 8.2;
I am trying to provide connections to the db for somemembers using MS
Access. I developed a small MS Access application using Windows
ODBC–it works fine from myhouse.
On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote:
> I have set up a pg database server for my organization on a cloud server
> using PG 8.2;
>
> I am trying to provide connections to the db for some members using MS
> Access. I developed a small MS Access application using Windows ODBC
My home ISP, our cloud server, and the office ISP are all separate entities.
I infer that the problem is with the office ISP - DSL provided by a phone
company.
Regards,
JPD
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, March 17, 2011 5:44 PM
On Thursday, March 17, 2011 2:50:18 pm Joseph Doench wrote:
> My home ISP, our cloud server, and the office ISP are all separate
> entities.
>
> I infer that the problem is with the office ISP - DSL provided by a phone
> company.
But you could not connect from two Wi-Fi locations either, that ten
I cannot think of any special reason why the cloud server would allow a
connection from my home versus any other location.
I will test another location or two.
Regards,
JPD
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, March 17, 2011 6:00 P
Any ideas??
Would it be possible that Postgresql would be using another encoding
for the identifiers when they aren't wrapped by double quotes?
On Tue, Mar 15, 2011 at 23:37, Francisco Figueiredo Jr.
wrote:
> Now, I'm using my dev machine.
>
> With the tests I'm doing, I can see the following:
On Thu, Mar 17, 2011 at 12:59 PM, Voils, Steven M
wrote:
> Thanks for the reply. I should have mentioned in the first post that we do
> delete significant amounts of the table which I thought was the cause of the
> bloat. We are already performing automatic vacuums nightly.
Automatic regular
On Thursday, March 17, 2011 3:20:16 pm Joseph Doench wrote:
> I cannot think of any special reason why the cloud server would allow a
> connection from my home versus any other location.
I do, it is called a firewall:) I would highly suggest checking what your
firewall rules on your cloud server
Considering the following example.
Tables A and B.
Table A contains some data.
Table B reefers to table A using FK with 'on delete cascade'. Table B
has a trigger on it, after delete per row
Now, is there any way I can tell in the trigger on table B that it has
been called from a direct delete on
Hello,
Thank you for your reply. I've been largely relieved. I understood the anser
was as follows:
[A1] Yes, it is safe to use PostgreSQL 8.3.12 on RHEL6.
It is recommended to rebuild it on RHEL6, however, it should be no problem
to use it without rebuilding it.
[A2] N/A because the answer
Don't know if this would work but could you check to see if the corresponding
PK exists on A?
It may also help to explain why you would want to do such a thing so that
someone may be able to provide an alternative solution as opposed to simply
responding to a generic feature question.
David
Is this the correct behavior? It seems like if I specify the utc offset it
should be 0, not 16.. It seems to be the opposite behavior from extract
epoch.
select extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' ) as defhour,
extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' at time zone 'PST'
Joe Abbate writes:
> I'm using this to validate a tool I'm building and I get an error on the
> following query:
> autodoc=> SELECT conname::regclass FROM pg_constraint
> autodoc-> WHERE contype = 'u';
> ERROR: relation "product_product_code_key" does not exist
Ummm ... pg_constraint.con
"Francisco Figueiredo Jr." writes:
> Would it be possible that Postgresql would be using another encoding
> for the identifiers when they aren't wrapped by double quotes?
No. I'm betting this is a client-side bug ... but you haven't told us
what the client-side code is.
Hi Tom,
On 03/18/2011 12:17 AM, Tom Lane wrote:
Joe Abbate writes:
I'm using this to validate a tool I'm building and I get an error on the
following query:
autodoc=> SELECT conname::regclass FROM pg_constraint
autodoc->WHERE contype = 'u';
ERROR: relation "product_product_code_ke
HI Tom,
On 03/18/2011 12:42 AM, Joe Abbate wrote:
For my immediate needs, the query was actually the target of a NOT IN
subquery of a query against pg_index (trying to exclude tuples of
indexes for UNIQUE constraints) and I've solved that by using conrelid
in the subquery (and indrelid in the
Dear all,
I have a simple query mentioned below :
select count(*) from page_content where (content like '%Militant%'
OR content like '%jihad%' OR content like '%Mujahid%' OR
content like '%fedayeen%' OR content like '%insurgent%' OR content
like '%terrORist%' OR
content like '%cadre%' OR
47 matches
Mail list logo
