David Fetter <[EMAIL PROTECTED]> writes:
> On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote:
>> Since there's no "(array) ANY op scalar" syntax,
> Why isn't there? Is it forbidden by the SQL standard?
Well, the spec has
::=
::= |
On Tue, Jun 19, 2007 at 07:36:02PM -0400, Tom Lane wrote:
> "Rhys Stewart" <[EMAIL PROTECTED]> writes:
> > Is regex searching not functioning (as i expect it to?)
>
> ~ expects the pattern on the right, not the left. So it's taking your
> array entries as patterns, which don't match the data 'Tra
Hey,
I'm sure that'd be greatly appreciated, most other major servers and
DBs have a similar feature, and that's what the systray is for, i.e.,
viewing major user-installed services.
- Naz.
Tony Caduto wrote:
> Bruce Momjian wrote:
>> Naz Gassiep wrote:
>>
>>> I'm using PG on windows for the
Hi,
It provides a very quick and easy status check (running or not) as
well as right click access to start/stop and any other basic admin
features that may be appropriate. I'd be happy with seeing whether it
was running, as well as start/stop accessible via one right click. It's
the same as
jef peeraer <[EMAIL PROTECTED]> writes:
> Tom Lane schreef:
>> That's a foreign-key check, which is supposed to be done as the owner of
>> the table. You did not show us who owns table clienten, but I think
>> that role must be missing the intended(?) membership in deterp_group.
> registratie=# \
On Jun 20, 2007, at 12:53 PM, Talha Khan wrote:
THE ACTUAL TEST:
DROP RULE account_login_no_update ON account_login;
UPDATE account_login set originating_source = 'xxx';
Now the update should not effect the child table but it does,
evident
from the output of the following query:
On Jun 16, 2007, at 6:26 AM, Noah Heusser wrote:
I want to implement a trigger-function witch can fill the following
table.
Each data manipulation (INSERT, UPDATE or DELETE) gets logged.
The function should work as trigger on diffrent tables.
CREATE TABLE logtable (
operationCHAR(6) C
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a
Bruce McAlister wrote:
> Hi All,
>
> I have enabled autovacuum in our PostgreSQL cluster of databases. What I
> have noticed is that the autovacuum process keeps selecting the same
> database to perform autovacuums on and does not select any of the others
> within the cluster. Is this normal behav
Alvaro Herrera writes:
The problem is probably the ulimit.
The problem occurrs on i386, but not on 64bit architecture.
Tested 5 machines.
3 i386 FreeBSD 6.2
2 AMD64 FreeBSD 6.2
The 64 bit machines, with postgresql compiled from ports, worked.
One of the machines had default OS limit. The se
Tom Lane schreef:
jef peeraer <[EMAIL PROTECTED]> writes:
i get this when i try to insert a record into a table. all permissions /
privileges seems ok, but probably i missed something. i am running a
8.1.3 on linux.
registratie=> INSERT INTO clienten
(anoniem,geslacht,leeftijd,origine,team_i
Kris Jurka <[EMAIL PROTECTED]> writes:
> On Fri, 22 Jun 2007, tomasz brymora wrote:
>> I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select,
>> some left outer joins and puts the results into a temporary table. Works
>> great when I run in pgAdmin.
>>
>> Then I try to use in a
jef peeraer <[EMAIL PROTECTED]> writes:
> i get this when i try to insert a record into a table. all permissions /
> privileges seems ok, but probably i missed something. i am running a
> 8.1.3 on linux.
> registratie=> INSERT INTO clienten
> (anoniem,geslacht,leeftijd,origine,team_id,hulpverle
I was testing how
> foreign keys would work in this case and ran into this.
>
> Is this really a bug? If not, what am I doing wrong please?
Here is what the postgresql manual says about this:
A serious limitation of the inheritance feature is that indexes (including
unique constraints) and
for
On Fri, 22 Jun 2007, tomasz brymora wrote:
I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select,
some left outer joins and puts the results into a temporary table. Works
great when I run in pgAdmin.
Then I try to use in an iBatis sqlmap as a 'select' and get this when
tr
Greetings!
I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select, some
left outer joins and puts the results into a temporary table. Works great when
I run in pgAdmin.
Then I try to use in an iBatis sqlmap as a 'select' and get this when trying to
execute it:
org.postgresql.
People,
either I don't understand how partitions works or I think I found a bug
here.
I'm using PostgreSQL-8.2.4 with Gentoo.
The code explains:
# First I create the table regs with 2 partitions:
create table regs (rID serial primary key, name text, number int);
create table regs_00 ( CHECK (
i get this when i try to insert a record into a table. all permissions /
privileges seems ok, but probably i missed something. i am running a
8.1.3 on linux.
registratie=> INSERT INTO clienten
(anoniem,geslacht,leeftijd,origine,team_id,hulpverlener_id) VALUES
('true','45','58','864','30','22
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > Now, combined (sorry for the convoluted query, it is build
> > automatically by an app).
>
> > EXPLAIN SELECT DISTINCT p.id
> > FROM partes_tecnicos p,
> > rel_usr_sector_parte_tecnico r, active_users
> -Original Message-
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bob Pawley
> Sent: 22 juin 2007 14:15
> To: Postgresql
> Subject: [GENERAL] Establishing a primary key
>
>
> I have numerous entries in a column of table 1, some of which are
duplicated.
>
> I need to transfe
Bob Pawley wrote:
I have numerous entries in a column of table 1, some of which are
duplicated.
I need to transfer this information to table 2 so that I have column
that can be used as a primery key.
Any help is appreciated.
So, I take it you're wanting to have this so that table 1 stays a
Henk - CityWEB <[EMAIL PROTECTED]> writes:
> On Thu, 21 Jun 2007, Tom Lane wrote:
>> FWIW, the only occurrences of that specific message text are in
>> PageIndexTupleDelete and PageIndexMultiDelete, so you can be pretty sure
>> that this is just a corrupted-index problem. Once you've identified
>>
On Thu, 21 Jun 2007, Tom Lane wrote:
> "Henka" <[EMAIL PROTECTED]> writes:
> > I happened to notice this error in the log when my application was refused
> > a db connection (quite unexpectedly):
>
> > PANIC: corrupted item pointer: offset = 3308, size = 28
> > LOG: autovacuum process (PID 181
On Jun 22, 2007, at 14:11 , cluster wrote:
What is the fan-out (number of child nodes) on each B-tree node in
postgresql? Is it dependent of the size of the keys being indexed?
If so: How?
In B-trees all non-leaf nodes have a bunch of pointers to its child
nodes. What is the size of such
What is the fan-out (number of child nodes) on each B-tree node in
postgresql? Is it dependent of the size of the keys being indexed? If
so: How?
In B-trees all non-leaf nodes have a bunch of pointers to its child
nodes. What is the size of such a pointer?
Thanks
---(en
Fellow Postgressors,
I took over an existing PG 8.0 database running on Windows XP. I need to
update a view so I know I need to drop the existing view and all the objects
that depend on it.
The DB is large enough that I can't just look through it with PGAdmin.
In
an organized way,
On Jun 22, 2007, at 10:16 , Fernando Schapachnik wrote:
Maybe this is already solved in more advanced releases, but just in
case.
VIEW active_users:
SELECT * FROM users WHERE active AND ((field IS NULL) OR (NOT field));
You could also rewrite this as
SELECT *
FROM users
WHERE active
AND
On Jun 22, 2007, at 10:16 , Fernando Schapachnik wrote:
EXPLAIN SELECT DISTINCT p.id
Can you provide EXPLAIN ANALYZE? I suspect that when you rewrote the
query it changed how the planner took into account the statistics. If
your statistics are off, perhaps this changes how the planner
r
What is the fan-out (number of child nodes) on each B-tree node in
postgresql? Is it dependent of the size of the keys being indexed? If
so: How?
In B-trees all non-leaf nodes have a bunch of pointers to its child
nodes. What is the size of such a pointer?
Thanks
--
I have numerous entries in a column of table 1, some of which are duplicated.
I need to transfer this information to table 2 so that I have column that can
be used as a primery key.
Any help is appreciated.
Bob Pawley
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> A rewritten query still exhibits the same behavior:
> EXPLAIN ANALYZE SELECT DISTINCT p.id
> FROM partes_tecnicos p
> WHERE
> p.id IN
> (SELECT r.id_parte_tecnico FROM
> rel_usr_sector_parte_tecnico r, active_users u
> WHER
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> En un mensaje anterior, Tom Lane escribió:
>> Is this query really what you want to do? Because the OR overrides all
>> the join conditions, meaning that rows having p.id_cola_por_ambito=1
>> AND p.id_situacion!=6 must produce Cartesian products a
Hi,
Can anyone help me out with funciton(s) to write a debug output in a perl
function on postgres.
Thanks,
~Harpreet
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > Now, combined (sorry for the convoluted query, it is build
> > automatically by an app).
>
> > EXPLAIN SELECT DISTINCT p.id
> > FROM partes_tecnicos p,
> > rel_usr_sector_parte_tecnico r, active_users
"Charles Mortell" <[EMAIL PROTECTED]> writes:
> I took over an existing PG 8.0 database running on Windows XP. I need to
> update a view so I know I need to drop the existing view and all the objects
> that depend on it.
> The DB is large enough that I can't just look through it with PG
Jasbinder Singh Bali wrote:
my $query = "SELECT sp_insert(" . $a . "," . $b . "," . $c . ")";
my $exec_query = spi_exec_query($query);
here i'm calling a function sp_insert and passing parameters a,b,c to it.
Is this the right usage to spi_exec_query?
http://www.postgresql.org/docs/8.2/static
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> Now, combined (sorry for the convoluted query, it is build
> automatically by an app).
> EXPLAIN SELECT DISTINCT p.id
> FROM partes_tecnicos p,
> rel_usr_sector_parte_tecnico r, active_users u
> WHERE ((r.id_parte_tecnico=p.id AND r.id_usr=u.id AN
my $query = "SELECT sp_insert(" . $a . "," . $b . "," . $c . ")";
my $exec_query = spi_exec_query($query);
here i'm calling a function sp_insert and passing parameters a,b,c to it.
Is this the right usage to spi_exec_query?
Thanks,
~Jas
On 6/22/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote:
Hi
I was wondering if its necessary to download DBI::PgSPI package from
CPAN to use spi_exec_query in perl
No. Using plperl is the way to go. See the docs there are examples under
plperl.
Joshua D. Drake
or it can be used without downloading the above mentioned
On Jun 22, 2007, at 10:50 AM, Charles Mortell wrote:
Fellow Postgressors,
I took over an existing PG 8.0 database running on Windows XP. I
need to
update a view so I know I need to drop the existing view and all
the objects
that depend on it.
The DB is large enough that I can't just look
Joshua D. Drake wrote:
Dave Page wrote:
Except the administrator account is disabled by default on Vista.
Huh? What I am confused about, and I don't pretend in anyway to
understand Vista but I just bought my wife a new vista machine and the
default user (the one created during setup) was an
On Jun 22, 2007, at 4:09 AM, Richard Huxton wrote:
Joost Kraaijeveld wrote:
Hi,
I want to write a sql script in which I backup a database and restore
a new (altered) version of that database. Is that possible? If so ,
can anyone give me an example of how to do that?
I can run it from any comman
Hi
I was wondering if its necessary to download DBI::PgSPI package from CPAN to
use spi_exec_query in perl
or it can be used without downloading the above mentioned package. I've
tried using spi_exec_query without that package
but doesn't work.
Thanks,
Jas
On Jun 21, 2007, at 8:08 PM, brian wrote:
Michael Glaesemann wrote:
On Jun 21, 2007, at 17:35 , brian wrote:
I have a lookup table with a bunch of disciplines:
To answer your ordering question first:
SELECT id, name
FROM discipline
ORDER BY name = 'other'
, name;
id |name
+--
ABHANG RANE wrote:
Hi,
If I have created a plpgsql function, is there a way I can look again at
the create statement of that function. I need to know what exactly is
there in the function.
From psql: \df+ my_function
From command-line: pg_dump --schema-only my_database > my_db_dump.sql
Seco
ABHANG RANE wrote:
Hi,
If I have created a plpgsql function, is there a way I can look again at
the create statement of that function. I need to know what exactly is
there in the function.
select * from pg_proc where proname = 'foo'
or
\df+ function_name
Thanks
Abhang
--
Hi,
Let me simplify it in lamer terms.
Basically, you have a cycle in your relations schema. i.e.
rel A: att-x, att-y
rel B: att-y, att-z
rel C: att-z, att-x
The only way to join these three without loosing a lot of information (aside
from some very weird corner cases which i won't mention here)
Hi,
If I have created a plpgsql function, is there a way I can look again
at the create statement of that function. I need to know what exactly
is there in the function.
Thanks
Abhang
---(end of broadcast)---
TIP 3: Have you checked our extensi
Diego Manilla Suárez wrote:
> Hi. I have a few databases created with UNICODE encoding, and I would
> like to be able to search with accent insensitivity. There's something
> in Oracle (NLS_COMP, NLS_SORT) and SQL Server (don't remember) to do
> this, but I found nothing in PostgreSQL, just the
Maybe this is already solved in more advanced releases, but just in
case.
VIEW active_users:
SELECT * FROM users WHERE active AND ((field IS NULL) OR (NOT field));
Table users has index on text field login.
EXPLAIN SELECT * from active_users where login='xxx';
"Vincenzo Romano" <[EMAIL PROTECTED]> writes:
>> Or wrap it around SQL function:
>
> That's the way I'm doind now even if in a slightly different way.
> 20+ million calls will badly slooow down the DB insertions
Are you sure? How much?
> and require you to know the exact name of the implicit se
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a sma
Dave Page wrote:
Joshua D. Drake wrote:
Dave Page wrote:
Except the administrator account is disabled by default on Vista.
Huh? What I am confused about, and I don't pretend in anyway to
understand Vista but I just bought my wife a new vista machine and the
default user (the one created dur
I think it would be greatly helpful if the insert...returning could be
seen as a "select" statement and, thus, being usable in the way I
have described. I suspect that the insert...returning is actually
implemented as an inser plus a select.
You can create a function which does the INSERT RET
Naz Gassiep wrote:
> I'm using PG on windows for the first time (as of about 6 minutes ago).
> I was thinking that it would be great to have a system tray icon with a
> running indicator, kind of like the way Apache2.x for windows has, or
> even MSSQL. Perhaps the PG logo with a small white circle
On 6/22/07, Dave Page <[EMAIL PROTECTED]> wrote:
[snip]
Exactly what I wrote. By default, the .\Administrator account is
disabled on Vista so you cannot login to it, or runas it. It's easy to
re-enable from the Users and Groups MMC snapin of course.
Ah yes, but I don't recall doing anything
D.J. Heap wrote:
On 6/22/07, Dave Page <[EMAIL PROTECTED]> wrote:
[snip]
Except the administrator account is disabled by default on Vista.
What do you mean?
Exactly what I wrote. By default, the .\Administrator account is
disabled on Vista so you cannot login to it, or runas it. It's easy
Vincenzo Romano <[EMAIL PROTECTED]> writes:
> I need to create a huge SQL script to load 20+ M rows in a DB.
> I've been force to wrap the inserts into PG functions.
> I can write them in either SQl or PLPgSQL but don't know
> whether this can make a big difference as far as time of
> overall execu
On Thursday 21 June 2007 15:47:17 Dawid Kuroczko wrote:
> On 6/21/07, Vincenzo Romano <[EMAIL PROTECTED]> wrote:
> > Hi all.
> > I'd like to do the following:
> >
> > insert into t1
> > values (
> > 'atextvalue',(
> > insert into t2
> > values ( 'somethingelse' )
> > ret
On 6/22/07, Dave Page <[EMAIL PROTECTED]> wrote:
[snip]
Except the administrator account is disabled by default on Vista.
What do you mean?
If you logon as an administrator then by default Vista drops a lot of
priviledges, but you can get them back to execute a program that
requires them by
Joshua D. Drake wrote:
BTW, and this is completely off topic but Vista really doesn't seem
nearly as bad as all the geeks would make it out to be. It seems a nice
evolutionary step ... although it seems a step toward MacOSX ;)
Oh it's certainly got nice eye candy, and is quite easy for the new
Hi all.
I need to create a huge SQL script to load 20+ M rows in a DB.
I've been force to wrap the inserts into PG functions.
I can write them in either SQl or PLPgSQL but don't know
whether this can make a big difference as far as time of
overall execution is concerned.
Somewhere else I've been t
Dave Page wrote:
D.J. Heap wrote:
On 6/21/07, Lee Keel <[EMAIL PROTECTED]> wrote:
The first thing you have to do is disable the User Access Control.
No you don't, actually. Just start the installer from an elevated
command prompt (Right-click on Command Prompt in the start menu and
choose
D.J. Heap wrote:
On 6/21/07, Lee Keel <[EMAIL PROTECTED]> wrote:
The first thing you have to do is disable the User Access Control.
No you don't, actually. Just start the installer from an elevated
command prompt (Right-click on Command Prompt in the start menu and
choose Run As Administrat
David Goodenough wrote:
>
> I have a table that consists of a set of regular expressions, a
priority
> and a result. I need to be able to match field in another table
against
> the set of regular expressions (ordered by priority) and use the first
result.
>
> Reading the documentation I can see
On 6/21/07, Lee Keel <[EMAIL PROTECTED]> wrote:
The first thing you have to do is disable the User Access Control.
No you don't, actually. Just start the installer from an elevated
command prompt (Right-click on Command Prompt in the start menu and
choose Run As Administrator, change to the
At 01:58 AM 6/22/2007, dfx wrote:
I tryied it but get errors on create user postgres.
Is there some workaround?
Upgrade to Windows XP SP2? Or Win2K?
Regards,
Link.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a gree
On Friday 22 June 2007, David Goodenough wrote:
> I have a table that consists of a set of regular expressions, a priority
> and a result. I need to be able to match field in another table against
> the set of regular expressions (ordered by priority) and use the first
> result.
>
> Reading the do
Is this a permanent limitation of GIN, or is a fix possible?
Permanent. You could check user input by querytree() function --- if it returns
'T' string then fullscan will be needed. If your tsquery is produced by
plainto_tsquery() call then it will not find any result, so you can show to user
v
I have a table that consists of a set of regular expressions, a priority
and a result. I need to be able to match field in another table against
the set of regular expressions (ordered by priority) and use the first result.
Reading the documentation I can see how to put the regular expression
int
Joost Kraaijeveld wrote:
Hi,
I want to write a sql script in which I backup a database and restore
a new (altered) version of that database. Is that possible? If so ,
can anyone give me an example of how to do that?
I can run it from any command prompt (psql -U postgres template1 <
my_db.backup
Thomas Kellerer wrote:
> Hmm. At least for updating LOBs, "my method" should be "legal".
> This is a quote from jdbc-3_0-fr-spec.pdf
>
> "The setBinaryStream and setObject methods may also be used to set a
Blob
> object as a parameter in a PreparedStatement object. The
setAsciiStream,
> setCharact
Finally, I'd like to bring up my first question again.
Is there any plan to support BLOB and CLOB in future releases?
Don't you guys need a standard LOB feature? I no longer need it, though ;-p
With the current large objects feature, I don't think it's not difficult to
support it...
Thanks,
eb
EBIHARA, Yuichiro wrote on 22.06.2007 09:28:
Hmm. At least for updating LOBs, "my method" should be
"legal". This is a quote from jdbc-3_0-fr-spec.pdf
"The setBinaryStream and setObject methods may also be used
to set a Blob object as a parameter in a PreparedStatement
object. The setAsciiStr
Hi,
I want to write a sql script in which I backup a database and restore a new
(altered) version of that database. Is that possible? If so , can anyone give
me an example of how to do that?
I can run it from any command prompt (psql -U postgres template1 <
my_db.backup)but I would like i
Thomas,
> > According to JDBC 3.0 specifiction, those 4 methods may not be
> > compatible to BLOB/CLOB. Some databases may support them to
> access LOB
> > data but not all databases.
> >
> Hmm. At least for updating LOBs, "my method" should be
> "legal". This is a quote from jdbc-3_0-fr-spec
EBIHARA, Yuichiro wrote on 22.06.2007 08:34:
Thomas,
Thank you for your comment.
I found that using getBinaryStream(), setBinaryStream(),
getCharacterStream()
and setCharacterStream() to handle LOBs across different DBMS
is much more
portable (and reliably) than using the Clob()/Blob() meth
Hi,
> > I found that using getBinaryStream(), setBinaryStream(),
> > getCharacterStream()
> > and setCharacterStream() to handle LOBs across different DBMS
> > is much more
> > portable (and reliably) than using the Clob()/Blob() methods.
>
> According to JDBC 3.0 specifiction, those 4 methods
79 matches
Mail list logo