you can create a primary key to associate with each row in the table
On 10/12/09, A. Kretschmer wrote:
> In response to Jignesh Shah :
>> Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
>> associated with prepared query(not table) to improve performance of
>> building
>>
On Sun, Oct 11, 2009 at 10:01:52PM -0500, Peter Hunsberger wrote:
> This is interesting, I just ran a similar issue the other day.
> Clearly there is a wide range of read / write scenarios that Postgres
> should be able to cover. These days, I have a lot of designs leaning
> more toward the data w
In response to Jignesh Shah :
> Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
> associated with prepared query(not table) to improve performance of building
> query. I just need to find plan using statement ID and execute it. I don't
> know
> how to do this.
Please, an
2009/10/11 Scott Marlowe :
>> The postgresql database uses the table full scan.but in oracle, the similar
>> SQL uses the index full scanning,speed quickly many than postgresql.
>
> Yep, PostgreSQL isn't Oracle. It's a trade off. In pgsql indexes
> don't contain visibility info, so all index loo
Bill Todd wrote:
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
no, but in recent versiosn, you can use SAVEPOINT to achieve much the
same effect.
http://www.postgresql.org/docs/current/static/sql-savepoi
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
> ...more stuff...
> COMMIT;
> COMMIT;
Postgresql uses savepoints.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Real quick, plain text is preferred on these lists over html. I don't
care myself so much.
On Sun, Oct 11, 2009 at 7:17 PM, 旭斌 裴 wrote:
>
> I have a 30,000,000 records table, counts the record number to need for 40
> seconds.
> The table has a primary key on column id;
>
> perf=# explain select
On Mon, 12 Oct 2009, ?? ? wrote:
perf=# select count(*) from test;
In PostgreSQL, if you're selecting every record from the table for a count
of them, you have to visit them all no matter what. The most efficient
way to do that is with a full table scan. Using an index instead requires
mo
Dear Colleagues,
Due to numerous deadline extension requests from potential CISSE 2009
authors, the CISSE organizing committee has decided to extend the paper
submission deadline to 10/26/2009. Please note that this is a hard
deadline, so that the technical committees can perform their paper
revie
I have a 30,000,000 records table, counts the record number to need for 40
seconds.
The table has a primary key on column id;
perf=# explain select count(*) from test;
...
-
Aggregate (cost=603702.80..603702.81 rows=1 width=0)
-> Seq scan on test (cost=0
On Oct 11, 2009, at 1:14 AM, Devrim GÜNDÜZ wrote:
http://download.fedora.redhat.com/pub/epel/5/i386/repoview/letter_u.group.html
http://download.fedora.redhat.com/pub/epel/5/x86_64/repoview/letter_u.group.html
Many thanks; it was a 32 vs 64 bit library problem, solved.
--
-- Christophe Pettus
On Sat, Oct 10, 2009 at 01:14:56PM -0700, Adrian Klaver wrote:
> sql_str = "ALTER TABLE " + $xn + " OWNER TO xdev;"
> sql_str += "GRANT ALL ON TABLE " + $xn + " TO xdev;"
> sql_str += "REVOKE ALL ON TABLE " + $xn + " FROM PUBLIC;"
> sql_str += "GRANT SELECT ON TABLE " + $xn + " TO PUBLIC;"
One min
Yep,
it is probably a bug though.
Adrian Klaver wrote:
>
> On Sunday 11 October 2009 2:48:02 pm SunWuKung wrote:
>> Right,
>> I replace the table alias irq to instreq and the function works.
>> I don't know what could have been the problem: is irq a reserved word, or
>> it's because the table
On Sunday 11 October 2009 2:48:02 pm SunWuKung wrote:
> Right,
> I replace the table alias irq to instreq and the function works.
> I don't know what could have been the problem: is irq a reserved word, or
> it's because the table alias has the same name then the function name.
>
> Thanks for point
Right,
I replace the table alias irq to instreq and the function works.
I don't know what could have been the problem: is irq a reserved word, or
it's because the table alias has the same name then the function name.
Thanks for pointing me to the right direction.
SWK
SunWuKung wrote:
>
>
> Y
Yes, I use it as a table alias inside the function.
Select ..
irq.instreq_min_metcount,
irq.ref_deptype,
irq.instreq_aggrfunc
>From .. instrument_requirement irq ON
Adrian Klaver wrote:
>
> On Sunday 11 October 2009 2:20:32 pm SunWuKung wrote:
>> Hi,
>> I ha
On Sunday 11 October 2009 2:20:32 pm SunWuKung wrote:
> Hi,
> I have a plpgsql function called irq(IN ulist integer[], .)
> It works fine on 8.1 Linux
>
> On 8.4 on windows XP running the function gives an error message (Undefined
> column: 7 ERROR: record "rec" has no field "instreq_id") wich
Hi,
I have a plpgsql function called irq(IN ulist integer[], .)
It works fine on 8.1 Linux
On 8.4 on windows XP running the function gives an error message (Undefined
column: 7 ERROR: record "rec" has no field "instreq_id") wich is strange
because the underlying query does return that column.
On Sun, Oct 11, 2009 at 11:05 AM, Otandeka Simon Peter
wrote:
>
> Hi,
>
> Is it possible to give a user rights(update,select,insert) rights on a
> database and not necessary doing that for one relation at a time?
Rights don't work that way in pgsql. Each type of object has types of
rights that m
Could you tell me if there is a way to know if trigger is invoked by the
code from another trigger?
For instance, table A Trigger deletes table B record. While in table B
trigger, I want to know whether this was triggered from table A.
Thank you,
Naoko
Hi,
Is it possible to give a user rights(update,select,insert) rights on a
database and not necessary doing that for one relation at a time?
I have many tables in the database but I don't want this user to be able to
delete a relation. Granting the user rights per table is gonna
take a lot of tim
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
associated with prepared query(not table) to improve performance of building
query. I just need to find plan using statement ID and execute it. I don't
know how to do this.
Thanks,
Jignesh
On Sun, Oct 11, 2009 at 8:06 PM, A
Pavel Stehule writes:
> 2009/10/11 Andre Lopes :
>> I have designed a database using MySql, but now I decided to move to
>> PostGre. I hava decimal fields with DECIMAL(10,6). How to convert this
>> fields to PostGre?
> use type NUMERIC(10,6)
DECIMAL works just fine too; it's an alias for NUMERIC
In response to Jignesh Shah :
> Hi,
>
> Could any one please tell me what is statement ID of table?
There isn't such ID, but every table has an OID, an Object Identifier.
> How to get it and
The (hidden) column "oid" of pg_class contains this OID.
> in which scenarios it can be helpful? An
Hello
use type NUMERIC(10,6)
Pavel Stehule
p.s. current name of this database is PostgreSQL, shortly Postgres :)
2009/10/11 Andre Lopes :
> Hi,
>
> I have designed a database using MySql, but now I decided to move to
> PostGre. I hava decimal fields with DECIMAL(10,6). How to convert this
> fie
Hi,
I have designed a database using MySql, but now I decided to move to
PostGre. I hava decimal fields with DECIMAL(10,6). How to convert this
fields to PostGre?
Best Regards,
André.
Hello Bill,
some words to the installation of PostgreSQL on Windows:
There are 3 user accounts involved:
a) the Administrator account (or user with Administration privilege)
- This user is running the installer. It should have Administrator
privileges, because only Admins are allowed to register
On Sat, 2009-10-10 at 22:47 -0400, Tom Lane wrote:
> Hmph. I don't know if there's more than one uuid package in the wild,
> but I see from
> http://cvs.fedoraproject.org/viewvc/rpms/uuid/devel/uuid.spec?revision=1.17&view=markup
> that the package that's standard in recent Fedora is uuid 1.6.1 f
29 matches
Mail list logo
