On Fri, Jan 28, 2005 at 09:10:07PM -0500, Robert Bernier wrote:
> On January 28, 2005 05:06 pm, Mark Wong wrote:
> > I wanted to bounce the idea of a BOF at the Linux Symposium in
> > Ottawa and see if anyone would like to attend. The deadline to
> > proposal is Feb 1st, sort of short notice... I
On January 28, 2005 05:06 pm, Mark Wong wrote:
> I wanted to bounce the idea of a BOF at the Linux Symposium in
> Ottawa and see if anyone would like to attend. The deadline to
> proposal is Feb 1st, sort of short notice... I thought the dicussion
> could revolved around these two topics:
>
> Lin
On Fri, 28 Jan 2005, Steve Crawford wrote:
A couple of issues. I went to unsubscribe from one of the many PG
lists to which I'm subscribed so I went to my original confirmation
message and followed the directions. After a couple hours I got a
response that the password I used was not valid (I cut a
First you should use a ltree type for the uri field :
- you write it foo.bar instead of /foo/bar
- there are operators on ltree types to express "is parent of", "is
children of"
- these operators are indexed
Check the readme :
http://www.sai.msu.su/~megera/postgres/gist/ltree/
If you h
I think I’ve found a bug in PG 8.0 that occurs while
copying from CSV files.
I checked the bugs list but didn’t see anything
similar.
This occurs when reading a CSV file where one of the ‘text’
fields has
a blank line. I included an example that shows the
problem below.
I found that
Hi there,
I read back in Dec. that the debian packages for v8.0 will need to be
re-done completely and might be delayed because of that.
I was curious if they are out yet, and if not, is there a ftp site I
could point apt-get to in order to pick them up when they do become
available?
Tha
<[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> > CREATE PROCEDURE do_something
> > @song_id int,
> > @user_id int,
> > @method int,
> > @length int = 0,
> > @date_exact datetime,
> > @default_country int = null
> > AS
> >-- temporary variables
> >
"Ed L." <[EMAIL PROTECTED]> writes:
> I ask because it seems like "char" and char should match as type names,
> but don't.
No, they don't. char without any quotes is a SQL reserved word that
is equivalent to CHARACTER(1). "char" with quotes is not a reserved
word, by definition. For largely hi
Ralph Graulich <[EMAIL PROTECTED]> writes:
> CREATE VIEW view_table1 AS SELECT * FROM table1;
> -- create a rule for update
> CREATE OR REPLACE RULE ru_view_table1_update
> AS
> ON UPDATE TO view_table1 DO INSTEAD
>(
>-- insert a new record with the old id, old version number incremented
>
On Fri, 28 Jan 2005, Ed L. wrote:
> I ask because it seems like "char" and char should match as type names,
> but don't.
Unfortunately, "char" and char are actually different types in
declarations like that AFAIK. When in quotes it refers to the postgres
single byte single character type, IIRC
A couple of issues. I went to unsubscribe from one of the many PG
lists to which I'm subscribed so I went to my original confirmation
message and followed the directions. After a couple hours I got a
response that the password I used was not valid (I cut an pasted from
the confirmation message
I have searched the web/archives for a solution to this and have found a
few entries to my question but nothing definitive. In essence I have a
function that opens a cursor (refcursor). It would appear though that
one can only traverse the cursor forward-only and only one record at a
time; is there
I am seeing a minor error and curious to learn if it is user error
or a bug.
I have a function (using 8.1devel) that returns a set of rows listing
the sizes of the various components of a relation (indices, toast, etc).
Here's an example of a successful call:
select *
from relation_size_compon
Have you tried looking at this section of the manual?
http://www.postgresql.org/docs/7.4/interactive/plpgsql.html
It details all the PL/pgSQL language constructs - I found it fine when
converting from Oracle to Postgres...
Just make sure you have installed the pl/pgsql language in template1 or
y
Hello,
I posted the question below to the pgsql-sql list, but did not receive any
answer yet. Therefore I repost it on pgsql-general in hope for any
information regarding that issue. Thanks alot.
Best regards
... Ralph ...
---
given is a table with a version history kind of thing I am currently
> CREATE PROCEDURE do_something
> @song_id int,
> @user_id int,
> @method int,
> @length int = 0,
> @date_exact datetime,
> @default_country int = null
> AS
>-- temporary variables
>DECLARE
> @artist int,
> @sample int,
> @date varchar(32),
>
I'm told these lists were more appropriate for this kind of
announcement than hackers, so here it is.
- Forwarded message from Mark Wong <[EMAIL PROTECTED]> -
Date: Tue, 25 Jan 2005 16:59:16 -0800
To: pgsql-hackers@postgresql.org
From: Mark Wong <[EMAIL PROTECTED]>
Subject: [HACKERS] OLS
guegue <[EMAIL PROTECTED]> writes:
> i finally realized that name of the variable can no longer be the same
> as the name of a column in the select statement.
That generally didn't work before, either. I think it might have
accidentally failed to not work for record/rowtype variables, but those
a
"Joshua D. Drake" wrote:
> Andre Schnoor wrote:
> > Hi,
> >
> > I am moving from Sybase to pgsql but have problems with stored procedures.
> > The typical procedure uses
> >
> > a) named parameters,
> > b) local variable declarations and assignments
> > c) transactions
> > d) cursors, views, etc.
I have a table like this:
create table objects (
id serial primary key,
namevarchar not null,
parent integer references objects(id) default 1 not null,
uri varchar not null
) without oids;
The uri column is a denormalization for performance, storing a "
when i upgraded from 7.4 to 8 many of my functions no loger worked,
they all had something in common:
DECLARE
produto RECORD;
BEGIN
FOR producto IN SELECT producto FROM p LOOP
the error reported was: record "producto" is not assigned yet
i finally realized that name of the variable can no lo
--- "Frank D. Engel, Jr." <[EMAIL PROTECTED]>
escribió:
> a.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-
>
> declarations.html
> b. (same page)
> c. ?
> d.
>
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
>
> structures.html#PLPGSQL-RECORDS-ITERATING
>
>
> T
Does anyone have any suggestions for how to get the
testcase id's and suite's replicated to the production
database with out touching the other tables in there?
I would just do a pg_dump on selected tables, but
there are sequences in the DB for adding new suites,
and testcases and I don't want th
Andre Schnoor wrote:
Hi,
I am moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses
a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.
I can't seem to find these things in the Postgres function synta
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
a.
http://www.postgresql.org/docs/8.0/interactive/plpgsql-
declarations.html
b. (same page)
c. ?
d.
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-
structures.html#PLPGSQL-RECORDS-ITERATING
This brings about a new question: Doesn'
I'm running Postgres on a Redhat Linux 9 server to
keep track of testcases we run in our lab. The
interface to add new testcases to the DB is cumbersome
for adding large groups, well actually it isn't
possible really. So on the development Linux machine,
when someone writes a new test case and a
Hi,
I am moving from Sybase to pgsql but have problems with stored procedures.
The typical procedure uses
a) named parameters,
b) local variable declarations and assignments
c) transactions
d) cursors, views, etc.
I can't seem to find these things in the Postgres function syntax.
Procedures can
Suppose that you currently need 16 GB to cache everything now.
I would install (perhaps) 32 GB ram for the initial configuration.
The price of memory drops exponentially, and so waiting for the price to
drop will give a much lower expense for the cost of the RAM.
The reason to double the ram is t
On Fri, Jan 28, 2005 at 02:43:13AM -0500, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > A malicious user who can execute SELECT queries can already consume an
> > arbitrary amount of memory -- say, by disabling GEQO and self-joining
> > pg_class to itself 50 times. I'm not sure that
Without memory, the prices are roughly:
4x846 = $5500
4x848 = $6500
4x850 = $8000
Memory costs would be:
16GB (1GB DIMMs) = $3000
32GB (2GB DIMMs) = $7500
64GB (4GB DIMMs) = $24000
128GB (8GB DIMMs) = $6
The prices on the 4GB & 8GB DIMMs are bleeding edge of course. I see a
wide range of for t
De: [EMAIL PROTECTED]
Objet: Rép : [GENERAL] Extended unit
Date: 28 janvier 2005 18:18:18 GMT+01:00
À:[EMAIL PROTECTED]
I have done a new version with
- a new conversion function
- possibility to enter value as fraction
- addition of the operator + -
Alex Turner <[EMAIL PROTECTED]> writes:
> I have noticed that I can't set the shared buffers above 15512 which
> is exactly 128MB of RAM. Even if I set /proc/sys/kernel/shmmax above
> that, postgres refuses to start with a setting over 128MB.
Check your shmall setting, too.
I have noticed that I can't set the shared buffers above 15512 which
is exactly 128MB of RAM. Even if I set /proc/sys/kernel/shmmax above
that, postgres refuses to start with a setting over 128MB.
Anyone have any ideas about this?
I guess there are a couple of questions - would I ever need a sha
Miguel Angel Tribaldos Hervas wrote:
I want to do the import from the psql client. I try to find something like that:
INSERT INTO "controller" (notes, enabled, diagram, ...)
VALUES ('Example controller', TRUE, load_svg('controller.svg'), ...)
with diagram of type TEXT, and diagram field correc
With a Quad Opteron (4 memory slots per CPU), you could put 64GB of RAM
onto a single machine using 4GB DIMMs in every slot.
The other option is to explore static memory storage. It's probably too
expensive to put your entire DB onto such a device but moving just the
WAL there would give you a
This question pops about once a day...
can't the list server grep for "auto increment" and send a link to the
docs itself ;)
hi
How to get the current value of a auto
incrementing number generated using CREATE SEQUENCE
seqname START 1
Is there any way and if yes what is it. Can we run a
On Thu, 27 Jan 2005 20:17:29 -0800, Max <[EMAIL PROTECTED]> wrote:
> >
> >
> > With a Quad Opteron (4 memory slots per CPU), you could put 64GB of RAM
> > onto a single machine using 4GB DIMMs in every slot.
>
> We were talking about a similar solution today, but not quite as good as
> this. You r
On Jan 28, 2005, at 6:36 AM, sid tow wrote:
hi
How to get the current value of a auto
incrementing number generated using CREATE SEQUENCE
seqname START 1
Is there any way and if yes what is it. Can we run a
select query and may be a inbuilt function which will
return the current value of that
On Friday 28 Jan 2005 5:06 pm, sid tow wrote:
> hi
>
> How to get the current value of a auto
> incrementing number generated using CREATE SEQUENCE
> seqname START 1
>
> Is there any way and if yes what is it. Can we run a
> select query and may be a inbuilt function which will
> return the cu
Sid,
Postgres has an excellent documentation. You can find about what you
asked here:
http://www.postgresql.org/docs/8.0/static/functions-sequence.html
It always pays off to read the docs first.
Cheers,
Csaba.
On Fri, 2005-01-28 at 12:36, sid tow wrote:
> hi
>
> How to get the current val
hi
How to get the current value of a auto
incrementing number generated using CREATE SEQUENCE
seqname START 1
Is there any way and if yes what is it. Can we run a
select query and may be a inbuilt function which will
return the current value of that number?
Regards.
_
I want to do the import from the psql client. I try to find something like that:
INSERT INTO "controller" (notes, enabled, diagram, ...)
VALUES ('Example controller', TRUE, load_svg('controller.svg'), ...)
with diagram of type TEXT, and diagram field correctly escaped.
Best regards.
--
I want to do the import from the psql client. ... Something like that:
--
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Am Thu, 27 Jan 2005 14:14:32 -0500 hat Rick Schumeyer
<[EMAIL PROTECTED]> geschrieben:
Is there a way to import mdb files from Access into pg?
I found a web page for mdbtools but I can't get it to compile.
Have a look at Access2PgConverter here
http://www.talon.nl/eng/site/start/projects/main.
Miguel Angel Tribaldos Hervas wrote:
Hi,
how can I import a SVG file to a row?? The main problem is that it has many
postgres scape symbols. Can I utilize the
'text' type for that?
Have I to do some byte-stuffing before the import?
If you want to create a text-file with a COPY or INSERT statement a
Hi,
how can I import a SVG file to a row?? The main problem is that it has many
postgres scape symbols. Can I utilize the
'text' type for that?
Have I to do some byte-stuffing before the import?
Thanks
--
Miguel A. Tribaldos
---(end of broadcast)---
46 matches
Mail list logo
