Hi,
If I have a series of Insert statements within a loop in a function on the
same table.
Would an Insert be able to see the values of previous insert in that table ?
I just wanted to know, when would the records be committed, as in, is it
after the whole function is done for with its execution
Hi,
I want to set up a database server that is connected to the Internet.
Therefore, I want my users to use SSL/TLS certificates. I provide these
certificates to the users, so I can control the information that is in
there. Now, I know that I can set up PostgreSQL to use SSL/TLS, but I am
unable
am Mon, dem 09.07.2007, um 2:53:48 -0400 mailte Jasbinder Singh Bali
folgendes:
Hi,
If I have a series of Insert statements within a loop in a function on the
same
table.
Would an Insert be able to see the values of previous insert in that table ?
Inside this function, yes. Outside the
Jasbinder Singh Bali wrote:
Hi,
If I have a series of Insert statements within a loop in a function on
the same table.
Would an Insert be able to see the values of previous insert in that
table ?
I just wanted to know, when would the records be committed, as in, is
it after the whole
My scenario is something like this. I'll try to make it modular and simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on tbl_abc; (fires trigger A)
End Function A
Start Trigger A
check the value of col_abc in
Hi,
I'd like to query a sequence's increment value from the system catalog. I
tried looking at
http://www.postgresql.org/docs/8.1/static/catalog-pg-class.html but I'm
stuck here.
Any ideas/help would be appreciated.
Thanks,
Wouter Gazendam
Tom Lane wrote:
Gerhard Hintermayer [EMAIL PROTECTED] writes:
... x should be y
I do get these messages one 2 of my servers running mostly on identical
data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
Update.
I thought the fixed error was related to running
On mán, 2007-07-09 at 11:24 +0400, Viatcheslav Kalinin wrote:
Jasbinder Singh Bali wrote:
If I have a series of Insert statements within a loop in a function on
the same table.
Would an Insert be able to see the values of previous insert in that
table ?
Functions are run in a single
Jasbinder Singh Bali wrote:
My scenario is something like this. I'll try to make it modular and
simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on tbl_abc; (fires trigger A)
End Function A
Start Trigger A
On mán, 2007-07-09 at 03:34 -0400, Jasbinder Singh Bali wrote:
My scenario is something like this. I'll try to make it modular and
simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on tbl_abc; (fires trigger A)
have you tried:
select * from my_seq;
or are you looking for the functions currval() or lastval()
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html
gnari
On mán, 2007-07-09 at 09:43 +0200, Wouter Gazendam wrote:
Hi,
I'd like to query a sequence's increment value from
On 7/9/07, Viatcheslav Kalinin [EMAIL PROTECTED] wrote:
Jasbinder Singh Bali wrote:
My scenario is something like this. I'll try to make it modular and
simple.
Start Function A (Written in plperlu with no subtransactions)
Insert 1 on tbl_abc; (fires trigger A)
Insert 2 on
Jasbinder Singh Bali wrote:
One reason I see that new insert does't see the values of old insert
is because as soon as socket connection is established, my trigger
returns and 1st insert is complete even though I'm not sure whether
the unix tools server has already inserted values in table
On 7/9/07, Viatcheslav Kalinin [EMAIL PROTECTED] wrote:
Jasbinder Singh Bali wrote:
One reason I see that new insert does't see the values of old insert
is because as soon as socket connection is established, my trigger
returns and 1st insert is complete even though I'm not sure whether
Hi,
Gabriele I had the same problem when I switched from MySQL to PostgreSQL
(although I was not so pleased with DB-Designer no support, not open source,
bugs with average size models, ...).
I had a look around and I could not find anything satisfying (with the same
criteria as you).
On mán, 2007-07-09 at 05:22 -0400, Jasbinder Singh Bali wrote:
The only difference between you test case my a sample test case that I
would provide is the Perform part in the trigger function.
In my program Perform part is about opening a socket connection with a
Unix Tools server that
Hello, friends.
OS FreeBSD 6.2, Postgresql 8.2.4
Postgresql does not search case-insensitive russian regexp unicode
patterns. Postgres is working under user pgsql with login class (in
/etc/login.conf):
postgres:\
:lang=ru_RU.UTF-8:\
:setenv=LC_COLLATE=C:\
:tc=default:
In
Ah, 'select * from my_seq;' did the trick.
I mistakenly assumed that all information entered in DDL statements would
end up in the system catalog.
Thank you for the quick response,
Wouter Gazendam
On 7/9/07, Ragnar [EMAIL PROTECTED] wrote:
have you tried:
select * from my_seq;
or are you
No, ILIKE also does case-sensitive search.
I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php
Is it about this issue? And will it be fixed someday?
Sergey Levchenko wrote:
Just use: select street from people where street ILIKE 'зелен%';
select with
On Mon, Jul 09, 2007 at 04:00:01PM +0400, alexander lunyov wrote:
I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php
Is it about this issue?
Yes.
And will it be fixed someday?
Likely. In the meantime lower() can come to the rescue.
Karsten
--
GPG key
Gerhard Hintermayer wrote:
Tom Lane wrote:
Gerhard Hintermayer [EMAIL PROTECTED] writes:
... x should be y
I do get these messages one 2 of my servers running mostly on
identical data. The servers are unix-based and are running 8.1.8
under linux (Gentoo).
Update.
I thought the fixed error
On Jul 9, 2007, at 4:38 AM, Jasbinder Singh Bali wrote:
On 7/9/07, Viatcheslav Kalinin [EMAIL PROTECTED] wrote:
Jasbinder Singh Bali wrote:
One reason I see that new insert does't see the values of old insert
is because as soon as socket connection is established, my trigger
returns and 1st
Karsten Hilbert [EMAIL PROTECTED] writes:
On Mon, Jul 09, 2007 at 04:00:01PM +0400, alexander lunyov wrote:
I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php
Is it about this issue?
Yes.
And will it be fixed someday?
Likely. In the meantime lower()
On Mon, Jul 09, 2007 at 09:50:42AM -0400, Tom Lane wrote:
On Mon, Jul 09, 2007 at 04:00:01PM +0400, alexander lunyov wrote:
I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php
Is it about this issue?
Yes.
And will it be fixed someday?
Likely.
select xpath_string($xml$?xml version=1.0 ?
f:foo xmlns:f=foo
f:barbaz/f:bar
/f:foo
$xml$
,'//f:bar/text()');
This does not give me back baz as I was expecting it to... It seems like
xpath is ignoring the namespace directives in the source XML document.
Hi,
Thanks Pavel. Here's my working function. Maybe it will save someone
else some time.
CREATE OR REPLACE FUNCTION Production_Tracking.GetTopLevelParent()
RETURNS SETOF record AS
$BODY$
DECLARE
initial_rec RECORD;
rec RECORD;
parentbc varchar;
toplevelparentbc varchar;
BEGIN
FOR
Does plpgsql has something equivalent to plperl $_SHARED or plpythonu global
dictionary GD?
Thanks,
Zlatko
---(end of broadcast)---
TIP 6: explain analyze is your friend
does anyone know which version of pam uses pam_pgsql?
and where found it? im also in need of a howto on how to since i have very
little knowledge as of today on this matter
cheers
kris
I¹m new to postgreSQL. I¹m running Windows Vista Home Premium. I tried
installing it (I had to turn off UAC), enabling user postgres¹ for running
it as a Service. But I¹m encountering some really bizarre problems...
First, every time I try psql¹ or createdb¹ in the command line, it says
the
Richard Eng wrote:
I’m new to postgreSQL. I’m running Windows Vista Home Premium. I tried
installing it (I had to turn off UAC), enabling user ‘postgres’ for
running it as a Service. But I’m encountering some really bizarre
problems...
First, every time I try ‘psql’ or ‘createdb’ in the
On 09/07/2007 16:49, Richard Eng wrote:
First, every time I try ‘psql’ or ‘createdb’ in the command line, it
says the password does not match user ‘richard’. I suppose this is
because I’m logged in to Windows as ‘richard’. ‘richard’ is my Windows
account (administrator) under which I
Hello,
I would like to be able to grant a user the ability to completely
reset a database for testing purposes. If possible, I would like the
user to be able to do a dropdb followed by a createdb, but without
allowing this user to create any database. In other words, I would
like the user to
On Mon, Jul 09, 2007 at 02:13:55PM -0400, Tim Olsen wrote:
like the user to be granted createdb permission for only a particular
database. I don't believe this is possible in postgresql. Is there a
dropdb-followed-by-createdb equivalent the user could use?
The reason it isn't possible is
Tim Olsen wrote:
Hello,
I would like to be able to grant a user the ability to completely
reset a database for testing purposes. If possible, I would like the
user to be able to do a dropdb followed by a createdb, but without
allowing this user to create any database. In other words, I
On 7/9/07, Andrew Sullivan [EMAIL PROTECTED] wrote:
On Mon, Jul 09, 2007 at 02:13:55PM -0400, Tim Olsen wrote:
like the user to be granted createdb permission for only a particular
database. I don't believe this is possible in postgresql. Is there a
dropdb-followed-by-createdb equivalent
Andrew Sullivan [EMAIL PROTECTED] writes:
On Mon, Jul 09, 2007 at 02:13:55PM -0400, Tim Olsen wrote:
like the user to be granted createdb permission for only a particular
database. I don't believe this is possible in postgresql. Is there a
dropdb-followed-by-createdb equivalent the user
On Mon, Jul 09, 2007 at 02:42:17PM -0400, Tim Olsen wrote:
I take it the privilege table directly references the database by some ID
number?
Well, sort of. It's going to be very hard to enforce anything in
advance, though.
The reason I ask is because this sort of privilege is possible in
On Mon, Jul 09, 2007 at 02:50:02PM -0400, Tom Lane wrote:
A SECURITY DEFINER function (living in some other database of course)
could accomplish this without going outside Postgres.
Good point. I was originally imagining a sort of scripted QA
environment, and sudo for that sort of thing is
On Jul 1, 3:09 pm, [EMAIL PROTECTED] (D. Dante Lorenso) wrote:
I want to select several rows of data and have them returned in a single
record with the rows joined by a delimiter. It would be great if this
could be done in a generic way possibly using the GROUP BY like this:
I recently wrote
Hello,
We have 2 altogether databases owned by two different users.The
requirement is ,by using a back up dump of a database owned by some
other user,We will need to restore the other DB which is owned
completely by other user.
The problem what we are facing is,if we try to use pg_restore
Greetings.
During the development of a database often there is a need to change a
field's declaration from, say, VARCHAR(32) to, say, VARCHAR(64).
Having to go through and find all pertinent uses of VARCHAR(32) in the table
definitions (where it may be a foreign key) and in functions (where it
Hello, I want to have pg use fast indexing for ~ operator. Is setting
C locale for this is still necessary? If yes, is it enough to
initdb/createdb with C locale? If it is not enough, why setting locale
to C and starting postmaster still gives other locale, for example,
pl_PL, in
postmaster log
I have a database with a table that adds 3 records a day, I am
delete records older than 2 days.
I am vacuuming it once a day , I am having an issue that the disk usage
is continually rising. i.e. the space been flagged as free by the vacuum
process isn't being reused.
Please find below a
My script running as superuser needs to install plpgsql using
CREATE LANGUAGE plpgsql;
in 8.2+
Which is the best way to check that this command does not cause error ?
Is it best to use
select true from pg_language where lanname='plpgsql'
for checking for plpgsql existance before running
Hi,
I am mailing on behalf of the Database Systems Lab, Indian Institute of
Science(IISc), Bangalore, India. We have implemented three new operators
internal to the PostgreSQL 8.1.2 engine in
order to support queries on multilingual data(english and hindi as of
now). It can be extended to
Hello !
How to force POSTGRES to use all virtual processors at included
Hyper-Trading ?
--
С уважением,
Евгений Кононов
Администратор ООО Технопросистем. mailto:[EMAIL
PROTECTED]
---(end of broadcast)---
TIP 9: In
Please, I need to know where the catalog tables (pg_class, pg_attrdef...) are
located in the postgresql rdbms. Because I can not see them in the pgAdminII
interface, like other tables or objects. And I can not find any reference about
where this information is, please any help would be welcome.
Hello together,
the documentation of PGSQL 8.0 tells me, that extract(dow ...) will
return 0 for Sundays. I know that this behaviour depends on the
language settings on MSSQL, so that I have to correct this settings
with an offset. What is the behaviour in PGSQL? Does the dow result
also depend
I know this is a delicate topic which must be approached cautiously.
Let's have a server which feed data to multiple slaves, usually using
direct online connections. Now, we may want to allow those client to
sync the data to a local replica, work offline and then resync the
data back to the
What secret resipy of PostgreSQL (insert more faster than delete)?
I doing an investigation on PostgreSQL, I figure out PostgreSQL powerful in
inserting data into the database.
We normally, expect that insert more slow than select and delete queries
because database have to create a row then
Perry Smith wrote:
I see. So, in effect he has:
ORDER BY NULL DESC, start_date ASC;
or
ORDER BY start_date DESC, NULL ASC;
Not exactly. He has (first sort clause) *and* (second sort clause), not or.
Both sort clauses operate at all rows.
You are sort of correct in that for any
does anyone know which version of pam uses pam_pgsql?
and where found it? im also in need of a howto on how to since i have very
little knowledge as of today on this matter
cheers
kris
Hi all,
I´ve got a strange problem, hope you could help. I´ve got a table (a ) with
n tuples, and two fields , birthplace and birth date. There´s another table (
say b) with m tuples, where i´ve got a lot of polygons ( with their code, same
as bithplace). Now i want to make a join, to
Hi,
I am designing my database and I was wondering whether my table row
size effects the performance of querying my table. Please note that my
table is being designed to hold high volume of records and I do not
plan to do (select *) for retrieving them. That is I plan to only
query a few of those
On 7/9/07, Andrew Sullivan [EMAIL PROTECTED] wrote:
This is for software that we intend to distribute as open-source. I'd
like
to keep the createdb (to any db) and sudo requirements for running tests
to
a minimum.
I think you're going to need to think about this more. If people can
look
On Jul 5, 2007, at 15:53 , David F. Johnson wrote:
During the development of a database often there is a need to change a
field's declaration from, say, VARCHAR(32) to, say, VARCHAR(64).
Is there a simple way to make a user-defined type that is a specific
declaration of a built-in type
On 7/9/07, Mike [EMAIL PROTECTED] wrote:
I am designing my database and I was wondering whether my table row
size effects the performance of querying my table. Please note that my
table is being designed to hold high volume of records and I do not
plan to do (select *) for retrieving them. That
E.J. Moloney [EMAIL PROTECTED] writes:
I have a database with a table that adds 3 records a day, I am delete
records older than 2 days.
I am vacuuming it once a day , I am having an issue that the disk usage is
continually rising. i.e. the space been flagged as free by the vacuum process
Tim Olsen [EMAIL PROTECTED] writes:
I take it the privilege table directly references the database by some ID
number?
You've got it backwards: there is no separate privilege table. We
attach privilege ACLs to the catalog entries of the objects they describe.
Hence, no object, no ACL.
The
Mike [EMAIL PROTECTED] writes:
I am designing my database and I was wondering whether my table row
size effects the performance of querying my table.
yes
If your table is large and you're reading all the rows then you'll be limited
by the i/o rate. If your rows are twice as big it will take
AFAIK, contrib/xml2 doesn't support namespaces for XPath expressions
at all. Wait for PostgreSQL 8.3 :-)
On 7/9/07, CG [EMAIL PROTECTED] wrote:
select xpath_string($xml$?xml version=1.0 ?
f:foo xmlns:f=foo
f:barbaz/f:bar
/f:foo
$xml$
,'//f:bar/text()');
This does not give me back baz as I
On 09/07/2007 18:33, Raymond O'Donnell wrote:
I you have a look through the (reasonably recent) archives of this list,
Whoops - that should have been If you - sorry for any confusion.
Ray.
---
Raymond O'Donnell, Director of
On 7/7/07, Евгений Кононов [EMAIL PROTECTED] wrote:
Hello !
Hi Evgenij,
How to force POSTGRES to use all virtual processors at included
Hyper-Trading ?
What OS are you using, and what's hyper-trading? Hyper threading
by any chance? That's the OSes responsibility, not the databases.
--
С
Can't wait... Got to have it now. :(
I patched xpath.c and created a function which takes a third parameter which
are the known namespaces in a space delimited hash list ... I based the patch
on some example code from the libxml website which works perfectly from the
command line. However, in
On Saturday 07 July 2007, Lew wrote:
So if your RDBMS sorts NULLs after all other values, then from
select start_date from show_date
order by
case when start_date CURRENT_DATE then start_date end desc,
case when start_date = CURRENT_DATE then start_date end asc;
all rows with
With DROP CASCADE, he can get rid of
everything within
the schema at a blow, so this is really pretty close to the same
functionality.
but beware of cross-schema dependencies! e.g., a DROP SCHEMA CASCADE of
schema X containg a table that has a column defined using a domain from
schema Y will
henryJack wrote:
What secret resipy of PostgreSQL (insert more faster than delete)?
I doing an investigation on PostgreSQL, I figure out PostgreSQL powerful in
inserting data into the database.
We normally, expect that insert more slow than select and delete queries
because database have to
I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10? Probably
the recommondation will be to compile 8.2 on 6.10, but I've only
Hi,
I have a quasi materialized view that's maintained by INS, UPD, and
DEL triggers on several child tables.
The tables involved have different structures, but I needed a single
view for selecting records based on a few common fields. This
approach is much faster than querying the separate
Karsten Hilbert wrote:
Just to clarify: lower() on both sides of a comparison
should still work as expected on multibyte encodings ? It's
been suggested here before.
lower() on both sides also does not working in my case, it still search
for case-sensitive data. String in this example have
Hi,
I keep getting this duplicate unique key constraint error for my primary key
even
though I'm not inserting anything duplicate. It even inserts the records
properly
but my console throws this error that I'm sure of what it is all about.
Corruption of my Primary Key can be one of the
71 matches
Mail list logo