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 t
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. Outsid
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 function
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 tbl_a
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 VACU
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
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
ch
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
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 fro
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 te
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 whethe
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).
Eventual
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 th
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 .profil
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 case-in
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
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 erro
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 an
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 mean
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
select xpath_string($xml$
baz
$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.
TV
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 in
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 pas
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 com
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 installed
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 t
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 b
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 wo
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 equivale
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 u
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
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 pr
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 wr
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
command
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 ma
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
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 suppo
Hello !
How to force POSTGRES to use all virtual processors at included
Hyper-Trading ?
--
С уважением,
Евгений Кононов
Администратор ООО "Технопросистем". mailto:[EMAIL
PROTECTED]
---(end of broadcast)---
TIP 9: In vers
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 on
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 server
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 set
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 gi
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 obtai
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
lo
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 (like
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
"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.
> T
"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
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$
baz
$xml$
,'//f:bar/text()');
This does not give me back "baz" as I was expecting it to... It seems like
xpath is igno
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 Mu
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 P
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;
>
>
> 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 w
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 cre
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 used
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 tab
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 fir
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 possibili
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 tab
Harpreet Dhaliwal wrote:
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 Ke
72 matches
Mail list logo
