I have a ques - say I have a table that has 10 columns. But in a simple
select query from that table, I use just 3 columns. I want to know
whether even for fetching 3 columns, read happens for all the 10 columns
and out of that the required 3 columns are returned ? ie Does the
complete row with all
Satish Burnwal (sburnwal) wrote:
I have a ques - say I have a table that has 10 columns. But in a simple
select query from that table, I use just 3 columns. I want to know
whether even for fetching 3 columns, read happens for all the 10 columns
and out of that the required 3 columns are returned
In response to Satish Burnwal (sburnwal) :
> I have a ques - say I have a table that has 10 columns. But in a simple
> select query from that table, I use just 3 columns. I want to know
> whether even for fetching 3 columns, read happens for all the 10 columns
> and out of that the required 3 colum
Hi.
I need to export data from the database to external file. The difficulty is
that only data modified or added since previous export should be written to the
file.
I consider adding "modification_time" timestamp field to all the
tables that should be exported. Then I can set this field to now()
Thank you for the answer Grzegorz.
> if you have a primary key on the table, and you should, you might get better
> performance using LEFT JOIN.
Well as far as I know, the result of such JOIN is a cartezian product, which is
not exactly what I need. I need the same structure as table 'data' has
zhong ming wu wrote:
After explicitly specfying these paths with --with-libs and
with-includes postgres configure is still choking
on readline.
Doing this is painful, but one hack you can try is pointing:
export LD_LIBRARY_PATH=/home/me/local/lib
I've used that combined with setting --with
On Thu, Apr 15, 2010 at 4:10 AM, Bruce Momjian wrote:
>> > PPAS 8.1 = PostgreSQL 8.1
>> > PPAS 8.3x = PostgreSQL 8.2 base (plus HOT and wal_writer)
>> > PPAS 8.4 = PostgreSQL 8.4 (plus compatibility)
>> > PPAS 9 [is planned to] = PostgreSQL 9.0
>>
>> So there was no actual 8.3 base release of PPAS
Hi, I have granted ALL permissions on 'techtable' to 'user1'.
techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn
where pc.relnamespace=pn.oid and pn.nspname='techdb' and
pc.relname='techtable';
relname | relacl
---+-
In response to dipti shah :
>
> Hi, I have granted ALL permissions on 'techtable' to 'user1'.
>
> techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where
> pc.relnamespace=pn.oid and pn.nspname='techdb' and pc.relname='techtable';
> relname |
Thanks Kretschmer but I have seen those function. The below query returns
error but you could see that 'user1' has ALL permissions on table
'techtable'.
techdb=# SELECT has_table_privilege('user1', 'techtable', 'ALL');
ERROR: unrecognized privilege type: "ALL"
techdb=# select pc.relname, pc.rela
gvim írta:
> I'm running PostgreSQL 8.4.3 on OS X Snow Leopard via MacPorts and I'm
> getting strange inconsistent errors such as:
>
> dbuser-# select * from log_form;
The error is here above. You had a "-#" prompt, saying
that you already started another statement in a previous line
but you haven
In response to dipti shah :
> Thanks Kretschmer but I have seen those function. The below query returns
> error
> but you could see that 'user1' has ALL permissions on table 'techtable'.
>
> techdb=# SELECT has_table_privilege('user1', 'techtable', 'ALL');
> ERROR: unrecognized privilege type:
Okay. Thanks.
Dipti.
On Thu, Apr 15, 2010 at 3:20 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to dipti shah :
> > Thanks Kretschmer but I have seen those function. The below query returns
> error
> > but you could see that 'user1' has ALL permissions on table 'tec
Great!! Your help is very valuable!!
-Original Message-
From: Justin Graf [mailto:jus...@magwerks.com]
Sent: Wednesday, April 14, 2010 7:35 PM
To: Bill Moran
Cc: Satish Burnwal (sburnwal); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query is stuck
I suggest writting something lik
On Thu, Apr 15, 2010 at 12:29 AM, Tom Lane wrote:
> Bruce Momjian writes:
>> Merlin Moncure wrote:
>>> aside: anyone know if postgres properly handles csv according to rfc4180?
>
>> Wow, I had no idea there was an RFC for CSV.
>
> Me either. I'd bet the percentage of "CSV"-using programs that ac
hi
2010/4/14 Adrian von Bidder :
> -> vacuum can run concurrently to other stuff, so it's not necessary to
> wait before it finishes.
> -> in most cases, autovacuum should do the Right Thing(tm) atomatically, so
> you should not need to call vacuum manually.
>
> This is with a recent pg version.
Alan Millington wrote:
> If you think that smallints are more bother than they are worth, perhaps you
> should remove support for smallints completely. Then people would know where
> they stood. (Or you could make smallint a synonym for int.)
smallint can be used usefully -- you just need to kn
On Wed, 2010-04-14 at 22:53 -0400, Bruce Momjian wrote:
> Damian Carey wrote:
> > On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce wrote:
> > > Joshua D. Drake wrote:
> > >>
> > >> Mostly, I think you will find that the back end developers aren't fond
> > >> of Java and thus, it doesn't get much lov
The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/...
files I seem to need to build pl/java. they exist in the 32bit version
but at least of them, Makefile.global, appears quite build specific.
$ ls -l 8.4-community/lib/pgxs/src/
total 91
-r--r--r-- 1 postgres postgres 1
John R Pierce wrote:
The tarball for 64bit 8.4.3 on Solaris Sparc is missing some
./pgxs/... files I seem to need to build pl/java. they exist in the
32bit version but at least of them, Makefile.global, appears quite
build specific.
Yeah, it seemed pretty obvious from the error you were runn
Hi,
Is Postgres's byte escape syntax something that could be set by the client?
I am running into a strange problem when I access postgres try two
different Ruby ORM's. I am guessing that one of them is doing
something funny to the client connections.
Looking at the Ruby C-driver, it's calling P
Howard Yeh writes:
> Is Postgres's byte escape syntax something that could be set by the client?
Well, indirectly --- it's affected by the standard_conforming_strings
setting.
> I am running into a strange problem when I access postgres try two
> different Ruby ORM's. I am guessing that one of t
Greg Smith wrote:
John R Pierce wrote:
The tarball for 64bit 8.4.3 on Solaris Sparc is missing some
./pgxs/... files I seem to need to build pl/java. they exist in the
32bit version but at least of them, Makefile.global, appears quite
build specific.
Yeah, it seemed pretty obvious from the
On Tue, Apr 13, 2010 at 10:04 PM, Tom Lane wrote:
> Jorge Arevalo writes:
>> I'm sorry, because this may be a simple question: I'm programming a C
>> function that returns a set (PostgreSQL 8.4). The function crash, and
>> I'm trying to
>> debug it. I've read:
>
>> http://www.postgresql.org/docs/
John R Pierce wrote:
Last night, I started trying to piece together the environment for
./configure for postgres based on what pg_config gives me, but it
aborted pretty early with missing stuffs... by then it was 1am and I
was fried so I am taking a fresh look this morning... k, I'm already
John R Pierce writes:
> getting this error from thte ./configure:
> configure:16808: error: cannot compute sizeof (off_t)
That's pretty weird. Look into the config.log output to see why that
particular test program is failing. (The relevant bit will probably be
a few hundred lines before th
Would this syntax work in PostgreSQL?
|INSERT INTO MyTable (FirstCol, SecondCol)
VALUES ('First',1),
|| ('||Second||',2),|
| ('||Third||',3),|
| ('||Fourth||',4),|
| ('||Fifth||',5)||
|
Inserting 5 rows in a single Insert? (I am trying to implement this
solution across many different backends) w
dear all -
I am not supposed to ask this. But, the question is I have 2
databases DB_1 and DB_2. I have a script that loads few tables in DB_1. The
2 databases are identical. In case , if database DB_1 is dropped, Is there
any command that I can issue to use the DB_2?
Regards
On 15/04/2010 20:44, Ozz Nixon wrote:
> Would this syntax work in PostgreSQL?
>
> |INSERT INTO MyTable (FirstCol, SecondCol)
> VALUES ('First',1),
> || ('||Second||',2),|
> | ('||Third||',3),|
> | ('||Fourth||',4),|
> | ('||Fifth||',5)||
> |
> Inserting 5 rows in a single Insert? (I am trying to i
Ozz Nixon escribió:
> Would this syntax work in PostgreSQL?
>
> |INSERT INTO MyTable (FirstCol, SecondCol)
> VALUES ('First',1),
> || ('||Second||',2),|
> | ('||Third||',3),|
> | ('||Fourth||',4),|
> | ('||Fifth||',5)||
Yes, it works (without all those funny || though)
--
Alvaro Herrera
Tom Lane wrote:
John R Pierce writes:
getting this error from thte ./configure:
configure:16808: error: cannot compute sizeof (off_t)
That's pretty weird. Look into the config.log output to see why that
particular test program is failing. (The relevant bit will probably be
a few
John R Pierce wrote:
> Tom Lane wrote:
> >John R Pierce writes:
> >>getting this error from thte ./configure:
> >>configure:16808: error: cannot compute sizeof (off_t)
> >
> >That's pretty weird. Look into the config.log output to see why that
> >particular test program is failing. (The rele
On 4/15/2010 11:59 AM, John R Pierce wrote:
The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/...
files I seem to need to build pl/java. they exist in the 32bit version
but at least of them, Makefile.global, appears quite build specific.
So, it seem to be painful to compile t
On Thu, Apr 15, 2010 at 10:45 AM, Tom Lane wrote:
> Howard Yeh writes:
>> Is Postgres's byte escape syntax something that could be set by the client?
>
> Well, indirectly --- it's affected by the standard_conforming_strings
> setting.
is this something that could be set at runtime? Does it apply
Alvaro Herrera wrote:
... 8.4.3 ... I'm jumping sideways and trying a different attack
on my actual problem, which is building pl/java HEAD for 64bit
solaris sparc w/ 8.4.3 and JDK 1.5.0_23... rather than building
the entire postgres tree, I replicated the couple missing files from
the 32bit
Andy Colson wrote:
On 4/15/2010 11:59 AM, John R Pierce wrote:
The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/...
files I seem to need to build pl/java. they exist in the 32bit version
but at least of them, Makefile.global, appears quite build specific.
So, it seem to be
My hba file has:
local all postgresmd5
hostall admin 127.0.0.1/32 md5
hostall dbuser127.0.0.1/32 md5
But that still allows users other than postgres to attempt to login as
postgres. Is there
gvim wrote:
My hba file has:
local all postgresmd5
hostall admin 127.0.0.1/32 md5
hostall dbuser127.0.0.1/32 md5
But that still allows users other than postgres to attempt to login as
postgr
create database db_1 template db_2;
This will create a new DB_1 using DB_2 as template. Otherwise, you'll
change your code to connect to DB_2 instead of connecting to DB_1.
--
Jorge Godoy
On Thu, Apr 15, 2010 at 14:49, akp geek wrote:
> dear all -
>
> I am not supposed to a
On Thu, Apr 15, 2010 at 1:49 PM, Raymond O'Donnell wrote:
> On 15/04/2010 20:44, Ozz Nixon wrote:
>> Would this syntax work in PostgreSQL?
>>
>> |INSERT INTO MyTable (FirstCol, SecondCol)
>> VALUES ('First',1),
>> || ('||Second||',2),|
>> | ('||Third||',3),|
>> | ('||Fourth||',4),|
>> | ('||Fifth|
Thank you
On Thu, Apr 15, 2010 at 8:49 PM, Jorge Godoy wrote:
> create database db_1 template db_2;
>
> This will create a new DB_1 using DB_2 as template. Otherwise, you'll
> change your code to connect to DB_2 instead of connecting to DB_1.
>
> --
> Jorge Godoy
>
>
>
> On Thu, Apr 15, 20
Dear List
I need to build a postgres on a linux machine that I don't have root access.
I built readline from source and installed it with prefix of /home/me/local
readline library are in /home/me/local/lib and headers files are in
/home/me/local/include/readline
After explicitly specfying these
I have compiled some C (pljava.c) for solaris sparc 64 bit, setup the
LD_LIBRARY_PATH so postgres can find it, and try and load it.
me=# CREATE FUNCTION sqlj.java_call_handler() RETURNS language_handler
AS 'pljava'LANGUAGE C;
ERROR: could not load library "/opt/mystuff/pljava/pljava.so":
John R Pierce writes:
> I have compiled some C (pljava.c) for solaris sparc 64 bit, setup the
> LD_LIBRARY_PATH so postgres can find it, and try and load it.
> me=# CREATE FUNCTION sqlj.java_call_handler() RETURNS language_handler
> AS 'pljava'LANGUAGE C;
> ERROR: could not load library
zhong ming wu writes:
> I need to build a postgres on a linux machine that I don't have root access.
> I built readline from source and installed it with prefix of /home/me/local
If you don't have root you're going to be in for a lot of pain here.
Linux is not designed to be friendly to libraries
Tom Lane wrote:
John R Pierce writes:
I have compiled some C (pljava.c) for solaris sparc 64 bit, setup the
LD_LIBRARY_PATH so postgres can find it, and try and load it.
me=# CREATE FUNCTION sqlj.java_call_handler() RETURNS language_handler
AS 'pljava'LANGUAGE C;
ERROR: cou
46 matches
Mail list logo
