The difference between a Tab and a newline is that tab is a universally
recognized single ascii character while newline is in flux. Aside from this,
a tab is a quasi-viewable character as the cursor will not go to the middle
of the tab. Meaning if the tab takes up the space of 10 characters, you
co
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Wed, Mar 23, 2005 at 12:13:33PM -0500, Greg Stark wrote:
> >
> > Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :)
>
> Shouldn't ALTER TABLE DROP CONSTRAINT followed by ALTER TABLE ADD
> CONSTRAINT work? It does for me in simple t
Thank you all for your input, and thanks about the tip on ethereal - cool
program. Here's what I've found out from today's testing:
The total size of the recordset that is being served up is about 500kb.
When serving across a network, the time to deliver the records to the client
is largely depen
Vernon <[EMAIL PROTECTED]> writes:
> C:\Program Files\PostgreSQL\8.0>runas /user:user01
> cmd.exe
> Enter the password for user01:
> Attempting to start cmd.exe as user "\user01" ...
> A new command prompt window is popup. In the new
> command prompt window, I have the following:
> ~~
You need to set your pg_hba.conf file to allow trusted authentication
for 127.0.0.1
i.e.
hostall all 127.0.0.1/32 trust
Vernon wrote:
Here is my situation:
C:\Program Files\PostgreSQL\8.0>runas /user:user01
cmd.exe
Enter the password
Here is my situation:
C:\Program Files\PostgreSQL\8.0>runas /user:user01
cmd.exe
Enter the password for user01:
Attempting to start cmd.exe as user "\user01" ...
~~~
A new command prompt window is popup. In the new
command prompt window
Sven Willenberger <[EMAIL PROTECTED]> writes:
> I have been experiencing an issue with plperl and PostgreSQL 8.0.1 in
> that after calling a plperl function memory does not get released.
AFAICT the result of spi_exec_query gets released fine, as soon as it's
no longer referenced within perl. Perh
On Mar 23, 2005, at 2:42 PM, Klint Gore wrote:
Rows inserted into inherited tables are visible to the parent. It's
effectively the same as having a union all on the 2 tables. Using the
only qualifier is how you stop the "union" happening.
This explains it.
Thanks!
Scott
--
I have been experiencing an issue with plperl and PostgreSQL 8.0.1 in
that after calling a plperl function memory does not get released. Two
different systems and each show different symptoms:
1) system: FreeBSD 5.3-Stable i386 with 1 GB RAM, dual Xeon P4
processors.
script: plperl issues an SP
On Wed, 23 Mar 2005 11:48:46 -0800, Scott Frankel <[EMAIL PROTECTED]> wrote:
>
> Close. Thanks for the very helpful suggestions!
>
> As I read the doco on rules and dissect the rule I've constructed, one
> issue
> remains: the UPDATE in my rule causes additional rows to be added to
> the pare
On Wed, 23 Mar 2005 12:30:29 -0800, Dann Corbit <[EMAIL PROTECTED]> wrote:
> 1. Excellent stability
Not in my experience.
> 2. Excellent scalability
Well, its an 800lb gorilla, so it starts off with enough momentum.
> 3. Superb toolset
Used sqlplus lately?
> 4. After-market support produc
On Tue, Mar 22, 2005 at 09:04:42PM -0600, Tony Caduto wrote:
>
> CREATE OR REPLACE FUNCTION mytest();
> RETURNS VOID as
> $$
> DECLARE
> mytestvar varchar;
> mytestvar2 integer;
> BEGIN
> mytestvarr = 'bla';
> select testfield from nonexistanttable where testfield = 2
> INTO myt
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lonni J
Friedman
Sent: Wednesday, March 23, 2005 6:06 AM
To: Joshua D. Drake
Cc: Randy Samberg; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres oracle emulation question
On Tue, 22 Mar 2005 20:38
Aha you are right. I tried this but set log min error statement
instead and so *that* didn't work.
Setting the right variable worked and I can now see the plan.
Thanks!!
--elein
On Wed, Mar 23, 2005 at 01:05:30PM -0700, Michael Fuhr wrote:
> On Wed, Mar 23, 2005 at 11:38:21AM -0800, elein wrote:
[EMAIL PROTECTED] (elein) writes:
> I cannot get debug_print_plan to print the query plan to the
> log.
/*
* Print plan if debugging.
*/
if (Debug_print_plan)
elog_node_display(DEBUG1, "plan", plan, Debug_pretty_print);
Looks like you also need to
On Wed, Mar 23, 2005 at 12:13:33PM -0500, Greg Stark wrote:
>
> Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :)
Shouldn't ALTER TABLE DROP CONSTRAINT followed by ALTER TABLE ADD
CONSTRAINT work? It does for me in simple tests. It's a little
more work than a single ALTER TABL
try select * from ONLY people.
also check out this query
select relname,people.* from people join pg_class on
people.tableoid=pg_class.oid;
and
select relname,people.* from ONLY people join pg_class on
people.tableoid=pg_class.oid;
Jim
-- Original Message ---
From: Scott F
Title: postgresql max memory (pl/Perl)
hi
in my application i select data from my database and i store it into a pl/perl variable $myClob.
the quantity of data is very big (around 250Mo, growing to 800Mo). and next i write this data into a file.
with Oracle, it works, but with Oracle i get
On Wed, Mar 23, 2005 at 11:38:21AM -0800, elein wrote:
>
> I cannot get debug_print_plan to print the query plan to the
> log. I have set it in the postgresql.conf file and bounced
> the server. The output is simply not there. show shows
> that the value is set, but no output.
What's your log_
I’m trying to install the version of tsearch2
distributed with pg 8.0.1. “make” and “make install”
runs with no apparent problems, but “make installcheck” fails.
Looking at the diffs, I would guess that the differences are
inconsequential. But I would like to be sure before proceeding.
OK, I've taken the PII 233 that had win2K pro on it, and installed winXP
home. Reloaded psql 8.0.1 and the database and ran the exact same query.
Recall with win2K it took 4000ms to get the data to the client (about 1500
rows) and on XP it takes 290ms the first time, and about 250ms every time
the
Close. Thanks for the very helpful suggestions!
As I read the doco on rules and dissect the rule I've constructed, one
issue
remains: the UPDATE in my rule causes additional rows to be added to
the parent table. How is that possible? How can it be suppressed?
i.e.: My rule specifies that whe
I cannot get debug_print_plan to print the query plan to the
log. I have set it in the postgresql.conf file and bounced
the server. The output is simply not there. show shows
that the value is set, but no output.
If someone can respond Right Now I'd very much appreciate
it. I cannot get onto i
Thanks to everyone for your comments on postgres oracle emulation. It
was very helpful.
Randy
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 8:38 PM
To: Lonni J Friedman
Cc: Randy Samberg; pgsql-general@postgresql.org
Subject: Re: [GENER
Title: RE: [GENERAL] pl/perl problem
yes, it works
exactly what i needed, thanks a lot
-Message d'origine-
De : Richard Huxton [mailto:dev@archonet.com]
Envoyé : mardi 22 mars 2005 12:41
À : FERREIRA William (COFRAMI)
Cc : 'Sean Davis'; pgsql-general@postgresql.org
Objet : Re: [GENER
Title: RE: [GENERAL] pl/perl problem
thanks a lot
with your example and the example of Richard it works fine
-Message d'origine-
De : Sean Davis [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 22 mars 2005 12:51
À : FERREIRA William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [
> > The confusing thing for me is that so far, the only
> consistent pattern
> > here is that machines running win2k Pro take roughly 4 seconds to
> > deliver the data to the client, while win XP machines perform much
> > better (<200ms to deliver recordset). I've tried installing QoS
> > pac
I wrote:
> Grumble ... I seem to have managed to promote intagg from
> broken-on-64bit-platforms to broken-on-every-platform ...
> will look into a fix tomorrow.
Ron's problem is essentially a double-free bug. In this patch:
2005-01-27 16:35 tgl
* contrib/intagg/: int_aggregate.c, int_
"A. Mous" <[EMAIL PROTECTED]> writes:
> The confusing thing for me is that so far, the only consistent pattern here
> is that machines running win2k Pro take roughly 4 seconds to deliver the
> data to the client, while win XP machines perform much better (<200ms to
> deliver recordset). I've tried
For the sake of further comparison, I added another computer to the
comparison. Another Celeron 2400, running win XP again, but only 256MB ram.
All records returned to client in 200ms (slightly longer than the 2400
machine with 500MB ram). Recall that the win2K box with 256MB Ram (PIII
1.8) took
"Sim Zacks" <[EMAIL PROTECTED]> writes:
> A query written on any client should return the same result. The query being
> the visible appearance on the screen.
This is presupposing the answer to the question at hand. I do not agree
with the above premise; it would seem to imply, for example, expan
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:
>> active backend server processes. I would like to know
>> what is a active backend server processes.
> In PostgreSQL every connection spawns a new backend that operates on the
> database sem
Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> PostgreSQL doesn't have such issues with blocking, so only difference
> between INSERT and INSERT DELAYED from PostgreSQL's standpoint
> would be waiting and not for the result...
With the right client-side code you can transmit multiple queries before
Sergey Levchenko <[EMAIL PROTECTED]> writes:
> I am not able to get work lower and upper functions on postgresql
> v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux.
> Locale: ru_RU.KOI8-R
> createdb -E UNICODE test
I think the problem is you selected a database encoding that doe
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Greg Stark wrote:
> > I want all my foreign key constraints to be deferrable. They were all
> > created
> > with the default (not deferrable).
> > Is it enough to just do update pg_constraint set condeferrable = 't' where
> > contype = 'f';
>
>
Michael Fuhr wrote:
On Wed, Mar 23, 2005 at 04:07:59PM +, Richard Huxton wrote:
Don't forget pg_class isn't in your database, it's shared by all.
Each database has its own pg_class:
You're quite right Michael, I'm talking rubbish. Why is it always when I
don't bother to read what I'm writing
Adrianna Pinska <[EMAIL PROTECTED]> writes:
> More specifically, I've been looking for a way to persuade postgresql
> to output the create script for a single object - without much
> success. It seems that pg_dump can output a dump of the entire
> database schema or a dump of a single table, but n
Yeah, thanks. I did see that post about the QoS and it doesn't help in this
case.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: March 23, 2005 9:51 AM
To: A. Mous
Cc: 'Richard Huxton'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Simple query takes a long tim
I use a modified form of option 3 with an ON UPDATE RULE the update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KEY,
lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id),
dm_user_address INTEGER NOT NULL DEFAULT 0,
Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> PostgreSQL doesn't have such issues with blocking, so only difference
> between INSERT and INSERT DELAYED from PostgreSQL's standpoint
> would be waiting and not for the result...
An insert can be blocked if there's a UNIQUE constraint and another
tran
> Just installed the 8.0 version for Windows. As a Unix guy, I
> would like to do things through the command prompt. I have
> trouble to bring up it. After bringing up the "psql to
> template1" as the same user of the installation
> configuration, it disappears right after I type in the passwor
Sean Davis <[EMAIL PROTECTED]> writes:
> On Mar 22, 2005, at 10:04 PM, Tony Caduto wrote:
>> Also if you happen to use PLperl or any of the other ones, do they
>> actually do better checking than PLpgsql? Last time I used a PLperl
>> function it didn't do any checking at creation either.
> I t
Queries are issued from, and time values are report in pgAdminIII.
-Original Message-
From: Magnus Hagander [mailto:[EMAIL PROTECTED]
Sent: March 23, 2005 9:31 AM
To: A. Mous; Richard Huxton
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Simple query takes a long time on win2K
On Wed, Mar 23, 2005 at 04:07:59PM +, Richard Huxton wrote:
> Don't forget pg_class isn't in your database, it's shared by all.
Each database has its own pg_class:
SELECT relname, relkind, relisshared
FROM pg_class
WHERE relname = 'pg_class';
relname | relkind | relisshared
--+--
If I have a relation and create a multicolumn index on all the
attributes,
would the index be bigger than the relation itself?
would it be more efficient to keep the relation ordered on all the
attribute if I have
a lot of additions?
I have relations that are only incremental in time and they are h
"A. Mous" <[EMAIL PROTECTED]> writes:
> None of these tests were run over a network - all local.
Nonetheless, the client-to-server communication goes through the Windows
TCP stack, because that's the only comm protocol we support on Windows.
Notice that your EXPLAIN ANALYZEs show the query as exe
Dawid Kuroczko wrote:
On Wed, 23 Mar 2005 14:50:47 +, Richard Huxton wrote:
ON.KG wrote:
Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
MySQL?
or any other way to delay inserting?
What precisely does this do?
It adds an insert into a 'do this' queue and returns. From
Just installed the 8.0 version for Windows. As a Unix
guy, I would like to do things through the command
prompt. I have trouble to bring up it. After bringing
up the "psql to template1" as the same user of the
installation configuration, it disappears right after
I type in the password.
How to br
So, does this lend evidence to the theory that the difference is due to
insufficient RAM in all of the win2K pro machines?
-Original Message-
From: Magnus Hagander [mailto:[EMAIL PROTECTED]
Sent: March 23, 2005 9:29 AM
To: A. Mous; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Simp
Yes, it is quite a range of hardware, and even within the win2k pro machines
there is quite a range of hardware which is why I would expect all of them
to produce slightly different latency times to serve up the records. Yet,
all are serving in 4 seconds! If I saw a pattern that suggested that th
> None of these tests were run over a network - all local.
> Given that the hardware is very different, however, I did
> find it strange that all win2k (Pro, not server) served up
> the records in almost exactly the same time, while the 2.4
> celeron is 80ms!
Note that the granularity of the
On Wed, 23 Mar 2005 14:50:47 +, Richard Huxton wrote:
> ON.KG wrote:
> > Hi
> >
> > Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> > MySQL?
> >
> > or any other way to delay inserting?
>
> What precisely does this do?
It adds an insert into a 'do this' queue and r
> You're right, the Celeron 2400 is much faster than the 200,
> but not that much more than the 1800, and all win2k
> (professional) machines are serving up the records in exactly
> the same amount of time.
>
> Across a network (issuing the query from the 2400 celeron win
> XP to the 233 PII w
Thanks It's the problem.
/David
Richard Huxton wrote:
David Gagnon wrote:
Hi all,
I just created a new db wich userX is owner. I log via pgAdminIII
with the same user but I can't update the pg_class.
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'
I get:ERROR: permission denied for rel
On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:
> I'm a new user of postgreSQL
>
> I was loking at the documentation and testing some
> things and I make:
>
> select * from pg_stat_database;
>
> pg_stat_database is writen on the table of page 317,
> one os the outputs is numbackend
David Gagnon wrote:
Hi all,
I just created a new db wich userX is owner. I log via pgAdminIII
with the same user but I can't update the pg_class.
You are a datdba but not a superuser :). You have to be a super user
to update pg_class.
Sincerely,
Joshua D. Drake
UPDATE pg_class SET reltriggers =
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
> "This option can only be set at server start or in the postgresql.conf
> file."
> Perhaps I've been misunderstanding the "or" clause? Does the "or"
> clause refer to the fact that it can be sent as an option at server
> start or changed with a
You're right, the Celeron 2400 is much faster than the 200, but not that
much more than the 1800, and all win2k (professional) machines are serving
up the records in exactly the same amount of time.
Across a network (issuing the query from the 2400 celeron win XP to the 233
PII win2k) the records
How long does it take for the _second_ and _third_ times?
Just for reference. The reason we want to know about subsequent runs
is that things will be cached.
Are the drives on the machine very different?
This is where I am leaning without any further information because
the older machine (in theor
In article <[EMAIL PROTECTED]>,
"ON.KG" <[EMAIL PROTECTED]> writes:
> Hi
> Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> MySQL?
> or any other way to delay inserting?
Every INSERT in PostgreSQL is delayed in some sense: firstly, it is
not visible to anyone else until
David Gagnon wrote:
Hi all,
I just created a new db wich userX is owner. I log via pgAdminIII with
the same user but I can't update the pg_class.
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'
I get:ERROR: permission denied for relation pg_class
I do that on my dev env. The only diff
I am not able to get work lower and upper functions on postgresql
v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux.
Locale: ru_RU.KOI8-R
createdb -E UNICODE test
psql test
test=> SET client_encoding TO KOI8;
SET
test=> SELECT t FROM t1;
t
ÐÐ
tEsT
(2 rows)
I'm a new user of postgreSQL
I was loking at the documentation and testing some
things and I make:
select * from pg_stat_database;
pg_stat_database is writen on the table of page 317,
one os the outputs is numbackends that is the number
of
active backend server processes. I would like to know
wh
None of these tests were run over a network - all local. Given that the
hardware is very different, however, I did find it strange that all win2k
(Pro, not server) served up the records in almost exactly the same time,
while the 2.4 celeron is 80ms! In terms of processor speed, that difference
in
Walker, Jed S wrote:
Hi,
I am an experienced Oracle DBA and I am now working on building a PostgreSQL
database for a project. Part of the lure for this was the no-cost licensing
as we'll possibly be putting instances of this new system into many local
sites. At this time we are planning to build li
Le mardi 22 mars 2005 à 17:55 +, Konstantinos Agouros a écrit :
> does this work in any way (PG 7.4.7 and OSX 10.3), so I can access postgres
> as data source from say excel?
I use OpenOffice.org and JDBC
Tony
---(end of broadcast)---
TIP 9:
Hello,
it's true?
tarif=# select ('10:10:10'::time,'10min'::interval) overlaps
('18:00:00'::time, '6hours'::interval);
overlaps
--
t
(1 row)
I think not. There is problem in overflow one parametr.
tarif=# select ('06:10:10'::time,'1min'::interval) overlaps
('18:00:00'::time, '5hour
On Wed, 2005-03-23 at 05:25, Walker, Jed S wrote:
> Hi,
>
> I am an experienced Oracle DBA and I am now working on building a PostgreSQL
> database for a project. Part of the lure for this was the no-cost licensing
> as we'll possibly be putting instances of this new system into many local
> sites
They are quite different hardware.
How long does it take for the _first_ time you do the query on the Celeron
machine? The first time. Wait until everything has started up first and the
machine is quiescent.
How long does it take for the _second_ and _third_ times?
Do the same for all the machin
Hi all,
I just created a new db wich userX is owner. I log via pgAdminIII with
the same user but I can't update the pg_class.
UPDATE pg_class SET reltriggers = 0 WHERE relname = 'ic'
I get:ERROR: permission denied for relation pg_class
I do that on my dev env. The only difference I saw beetwee
ON.KG wrote:
Hi
Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
MySQL?
or any other way to delay inserting?
What precisely does this do?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 3: if posting/reading thr
On Wed, Mar 23, 2005 at 07:31:22PM +0300, ON.KG wrote:
> Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> MySQL?
>
> or any other way to delay inserting?
What problem are you trying to solve? Are you aware that PostgreSQL
uses Multiversion Concurrency Control (MVCC) so
Hi
Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
MySQL?
or any other way to delay inserting?
Thanx
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column
On Tue, 22 Mar 2005, Scott Frankel wrote:
> Syntax troubles.
>
> What is the proper syntax for using FROM ONLY table_name in an UPDATE
> statement? According to the docs, In a FROM clause, I should be able to
> use the ONLY keyword preceding the table name. This throws an error:
>
> UPDATE
On Mar 23, 2005, at 8:51 AM, Shaun Clements wrote:
Hi Sean
Ive chosen the table structure on purpose.
Im transforming data from one table to another. The problem is still
there.
I receive the column name from a query in one table, and then need to
update the table with that column name in anoth
Shaun Clements wrote:
Hi Sean
Ive chosen the table structure on purpose.
Im transforming data from one table to another. The problem is still there.
I receive the column name from a query in one table, and then need to update
the table with that column name in another.
This needs to be done dynami
Hello list,
I need to define an audit system that would be easyli include or exclude
certain tables, the process is a purchase order where many users changes
the info in diferent ways, the requerimient is to log the stamp and user
of the change on a table and additionaly log a snapshot of the th
On Tue, 22 Mar 2005 20:38:13 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> Lonni J Friedman wrote:
>
> >On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
> ><[EMAIL PROTECTED]> wrote:
> >
> >
> >>
> >>Does anyone know if there is a way in Postgres to emulate Oracle, in other
> >>words make P
Greg Stark wrote:
I want all my foreign key constraints to be deferrable. They were all created
with the default (not deferrable).
Is it enough to just do
update pg_constraint set condeferrable = 't' where contype = 'f';
No - the constraints are actually enforced by triggers - Just just
normal
Title: FW: [GENERAL] PLPGSQL
Hi Sean
Ive chosen the table structure on purpose.
Im transforming data from one table to another. The problem is still there.
I receive the column name from a query in one table, and then need to update the table with that column name in another.
This needs to
On Wed, Mar 23, 2005 at 14:10:30 +0200,
Adrianna Pinska <[EMAIL PROTECTED]> wrote:
>
> More specifically, I've been looking for a way to persuade postgresql
> to output the create script for a single object - without much
> success. It seems that pg_dump can output a dump of the entire
> databa
On Mar 23, 2005, at 7:56 AM, Shaun Clements wrote:
Is there no way in pgplsql
to call on a dynamic column.
I need to be able to dynamically determine the latest month column
within a dataset, and to get that columns data.
I am unfamiliar with other languages within Postgres
Kind Regards,
Shaun
Title: [GENERAL] PLPGSQL
Is there no way in pgplsql
to call on a dynamic column.
I need to be able to dynamically determine the latest month column within a dataset, and to get that columns data.
I am unfamiliar with other languages within Postgres
Kind Regards,
Shaun Clements
Hi Jed,
On Wed, 2005-03-23 at 04:25 -0700, Walker, Jed S wrote:
> I am an experienced Oracle DBA and I am now working on building a PostgreSQL
> database for a project. Part of the lure for this was the no-cost licensing
> as we'll possibly be putting instances of this new system into many local
On Wed, 23 Mar 2005 07:32:08 -0500, Sean Davis <[EMAIL PROTECTED]> wrote:
> You can look at the system catalogs. In particular, look at:
>
> http://www.postgresql.org/docs/current/static/catalogs.html
> http://www.postgresql.org/docs/current/static/catalog-pg-proc.html
Thanks - the info you get
Am Mittwoch, 23. März 2005 12:25 schrieb Walker, Jed S:
> I'd like to know your opinions on support for PostgreSQL.
> 1. Do you think I should purchase commercial support (at least for the
> initial development and release)?
> 2. Do you have recommendations on what companies are good and a good val
You can look at the system catalogs. In particular, look at:
http://www.postgresql.org/docs/current/static/catalogs.html
http://www.postgresql.org/docs/current/static/catalog-pg-proc.html
You can do something like
select proname,prosrc from pg_proc;
as an example. You could use one of the procedu
Hello,
I'm working on a project which uses postgresql (7.4.x), and a lot of
the project code is in functions, views, etc. in a postgresql
database. I would like to create an automated process for extracting
all this code to individual text files (which can be managed through a
version control sys
> - what about storing a signed document? it's possible that newline
>conversion makes the signature invalid. How would you restore the
original
>document? Before you answer think of:
>a) a client running on a platform different from the one that inserted
> the document;
>b) a
> Hi,
>
> I have a table with about 1500 records. My query is very
> basic: SELECT * FROM foo;
>
> With postgres 8.0.1 on Win XP (Celeron 2400, 500MB RAM) it
> returns the results in about 80ms. The same query on the
> same database, tested on three different win2k machines all
> running 8.
A. Mous wrote:
Hi,
I have a table with about 1500 records. My query is very basic: SELECT *
FROM foo;
With postgres 8.0.1 on Win XP (Celeron 2400, 500MB RAM) it returns the
results in about 80ms. The same query on the same database, tested on three
different win2k machines all running 8.0.1, take
Hi,
I am an experienced Oracle DBA and I am now working on building a PostgreSQL
database for a project. Part of the lure for this was the no-cost licensing
as we'll possibly be putting instances of this new system into many local
sites. At this time we are planning to build little logic into the
Shaun Clements wrote:
Can you assign the value of a dynamic record value.
For example
sales_month1_x := RECORDNAME.quote_ident('month1_'||quote_literal(yr2));
You're right - it won't work. PLPGSQL has strict type-checking, so it's
no good for this sort of stuff. Perhaps pl/tcl/perl/python would be
On Mar 22, 2005, at 10:04 PM, Tony Caduto wrote:
Ok,
here is a example
CREATE OR REPLACE FUNCTION mytest();
RETURNS VOID as
$$
DECLARE
mytestvar varchar;
mytestvar2 integer;
BEGIN
mytestvarr = 'bla';
select testfield from nonexistanttable where testfield = 2
INTO mytestvar2;
On Wed, 23 Mar 2005, Sim Zacks wrote:
In any case, there are 2 correct solutions to the problem for the case of
postgresql.
1) Database standard - postgresql chooses a newline standard and every
client must support that if they support postgresql. Either put the onus on
the client developers to ove
In any case, there are 2 correct solutions to the problem for the case of
postgresql.
1) Database standard - postgresql chooses a newline standard and every
client must support that if they support postgresql. Either put the onus on
the client developers to override the OS standard and support the
Hi,
I have a table with about 1500 records. My query is very basic: SELECT *
FROM foo;
With postgres 8.0.1 on Win XP (Celeron 2400, 500MB RAM) it returns the
results in about 80ms. The same query on the same database, tested on three
different win2k machines all running 8.0.1, takes roughly 4 s
On Wed, 23 Mar 2005, Sim Zacks wrote:
While I would agree with you that from a purely technical standpoint, the
user inserted into the database a CRLF and a query with just an LF does not
exactly match that, from a users and more practical perspective, that does
not make sense at all. That is why I
Title: ++ [GENERAL] PLPGSQL
Adding to that.
Can you assign the value of a dynamic record value.
For example
If I have written dataset returned, into a record.
I now want to call on a particular column value from the first row.
The column name is dynamic.
Can I use something like this
sal
Title: [GENERAL] PLPGSQL
Hi All
Im trying to assign the value of a dynamic variable, to a variable.
How is this done in PostgresQL. Is this allowed in Postgres Procedural Language
Here is my attempt.
variable1:= quote_ident('variable_'||quote_literal(year));
Where the variable is call
100 matches
Mail list logo
