Hi,
Could any one please tell me what is statement ID of table? How to get it
and in which scenarios it can be helpful? Any documentation or example about
statement ID would also really helpful for me.
Thanks,
Jignesh
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.17view=markup
that the package that's standard in recent Fedora is uuid 1.6.1 from
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
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
use type NUMERIC(10,6)
Pavel Stehule
p.s. current name of this database is PostgreSQL, shortly Postgres :)
2009/10/11 Andre Lopes lopes80an...@gmail.com:
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
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? Any
Pavel Stehule pavel.steh...@gmail.com writes:
2009/10/11 Andre Lopes lopes80an...@gmail.com:
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
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,
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
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
On Sun, Oct 11, 2009 at 11:05 AM, Otandeka Simon Peter
sotand...@gmail.com 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
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.
I
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 is
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 have a
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:
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 pointing
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 alias has
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 minor stylistic point.
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
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
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
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
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, 旭斌 裴 peixu...@yahoo.com.cn 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;
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
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd p...@dbginc.com 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
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.
2009/10/11 Scott Marlowe scott.marl...@gmail.com:
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,
27 matches
Mail list logo