Mike, Jan,
> Michael Ansley wrote:
>
> With the latest release, I think you can do:
>
> EXEC ''SELECT * FROM '' || $1;
>
> or
>
> DECLARE SQL VARCHAR;
> ...
> SQL = ''SELECT * FROM '' || $1;
> EXEC SQL;
>
> or something similar (it may be EXECUTE), which uses the dynamic sql
> elements of pl
"Jens Hartwig" <[EMAIL PROTECTED]> writes:
> I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
> "include/config.h" to 16384, recompiled and reinstalled the sources.
> [ but it didn't take ]
Either you didn't do a full recompile (best to "make clean" then "make
all"), or you neglec
Foreign keys are not supported in that version :p see:
http://www.postgresql.org/devel-corner/docs/
"" wrote:
> I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
> be the problem?
Hello all,
I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
"include/config.h" to 16384, recompiled and reinstalled the sources. After
having restarted the backend I tried to create a table with three
varchar(5000)-columns and tried to add three character-values with each 4000
cha
Greetings.
I'm working with a product provided by a third part that interfaces to
data housed in a database of your choice. Previously, my choice was
MySQL - apparently it handled certain queries too slowly, so I'm giving
PostgreSQL a shot. Here's the query:
SELECT
a.Number,
a.Code,
a.Te
Ian,
Thanx - I figured the same about the ambiguity. I'll keep tryin' to
debug this with the vendor, then.
-Brice
Ian Harding wrote:
>
> Brice Ruth wrote:
>
> > Greetings.
> >
> > I'm working with a product provided by a third part that interfaces to
> > data housed in a database of your cho
I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?
I am thinking of the same thing, because in postgreSQL 6.5, I hear that they
have no foreign keys, and 7.x does. I want to see how they work!
Mark A. Summers wrote in message <9547no$2c9n$[EMAIL PROTECTED]>...
>Currently I am running 6.5.3 should I upgrade to 7.0.3 -- Any advantages or
>should I
>I am compiling postgresql 7.1beta4. How would i change the 8k row
> limit?
There is no 8k row limit anymore. But if there were, you would modify a
#define in the source code and recompile (check the docs for more
details).
- Thomas
Isn't this equivalent to?
update table1 set na1=
(select table2.na1 from table2 where
table1.no=table2.no);
Which can also be invalid if there can be
multiple rows returned by the subselect
since there'd be no way to know which
table2.na1 you'd want without more info.
On Fri, 2 Feb 2001,
On Thu, 1 Feb 2001, Brice Ruth wrote:
->SELECT
-> a.Number,
-> a.Code,
-> a.Text
->FROM
-> b,
-> a
->WHERE
-> (b.Id = a.Id) AND
These next two statements are very ambiguous. Make them explicit as you have
with "(b.Id = a.Id)" and "(b.d_Id = 'key3')"
Also, be sure that 'key3' is how what y
Brice Ruth writes:
> SELECT
> a.Number,
> a.Code,
> a.Text
> FROM
> b,
> a
> WHERE
> (b.Id = a.Id) AND
> (VersionId = 'key1') AND
> (Category = 'key2') AND
> (b.d_Id = 'key3')
> ORDER BY
> a.Number;
>
> (my apologies: I had to 'mangle' the table/column names because of NDA)
>
I not run update in Pgsql
please tell me other method
thanks
==
update table1 a set na1=
(select table2.na1 from table2,table1
where table1.no=table2.no
and a.no=table1.no);
Greetings.
I'm working with a product provided by a third part that interfaces to
data housed in a database of your choice. Previously, my choice was
MySQL - apparently it handled certain queries too slowly, so I'm giving
PostgreSQL a shot. Here's the query:
SELECT
a.Number,
a.Code,
a.Te
Saluton,
On Tue, Jan 30, 2001 at 10:22:23AM +0700, Jaruwan Laongmal wrote:
> Dear Sir.
> Would you like to inform me how to modify type in table?
> For example , I define type as varchar(14) , but I want to modify to varchar(120).
>How to do this.
If it is not too much data, the easiest would b
Has been removed from the LDP website.
J
--
--
CommandPrompt - http://www.commandprompt.com
OpenDocs, LLC. - http://www.opendocs.org
LinuxPorts - http://www.linuxports.com
LDP - http://www.linuxdoc.org
--
Instead of asking why a piece of software is using "19
Justin Clift <[EMAIL PROTECTED]> writes:
> I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on
> Linux (Mandrake Linux 7.2).
> [ bogus roundoff behavior in date/time display ]
This is a known silliness in the Mandrake distribution: their default
compiler flags include both -O3 a
I need to pass an array of INT4 to a function ( variable number of
elements).
How do i declare the array-parameter, and how do i know how many elements i
recieved?
/Sveinung
Hi all,
I'm having trouble with what MAY BE a bug in PL/PGSQL for PG 7.0.3 on
Linux (Mandrake Linux 7.2).
It appears pl/pgsql is munging values. When I pass it a 'time' value,
the value is altered without my code touching it. This is evidenced by
the stripped down function below :
CREATE FUNC
cbell wrote:
> Hello everyone, I was hoping someone could help me with this...
>
> I'm running postgres 7.02 on redhat 6.2, apache 1.3.14 and mod_perl
> 1.24_01. I'm also using perl modules DBI 1.14 and DBD-Pg-0.95 to acces
> the Postgres database.
>
> Everytime my inventory file gets updated, I
[EMAIL PROTECTED] wrote:
> Hi there
>
> I have a table with char and int fields. From my form I get no values back
> for int fields when they are left blank. This causes the SQL insert to
> fail.
>
> field type
> name char
> id int2
> city char
>
> insert into table (name,id,city) values (
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
> Ok, so there is actually two standards then. Is this documented
> anywhere? Is this is something that is going to change? I don't want
> to write and app and have things "break" during and upgrade :)
I mean you can be caseful. Not changes planne
On Mon, 5 Feb 2001, Ross J. Reedstrom wrote:
> On Mon, Feb 05, 2001 at 05:15:47PM +0100, Karel Zak wrote:
> >
> > test=# select date_part('dow','2001-02-11'::timestamp);
> > date_part
> > ---
> > 0
> >
> > test=# select to_char('2001-02-11'::timestamp, 'D');
> > to_char
> >
On Mon, Feb 05, 2001 at 05:15:47PM +0100, Karel Zak wrote:
>
> test=# select date_part('dow','2001-02-11'::timestamp);
> date_part
> ---
> 0
>
> test=# select to_char('2001-02-11'::timestamp, 'D');
> to_char
> -
> 1
>
>
> date_part is based on zero - use range 0-
Keith,
Try:
select to_char('now'::timestamp,'Dy');
to_char
-
Mon
(1 row)
--
DAY = full upper case day name (9 chars)
Day = full mixed case day name (9 chars)
day = full lower case day name (9 chars)
DY = abbreviated upper case
On Mon, 29 Jan 2001, Keith Perry wrote:
> Greetings,
>
> I notice some talk about date problems and interestingly enough planning
> out an application in which I will need to be able to manipulate dates.
> I notice however that there seems to be a discrepancy with the day or
> week in 7.0.3
>
When declaring parameters try using varchar rather than varchar(255). I have used
text successfully in the past.
-Original Message-
From: Ken Corey [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, February 04, 2001 6:38 AM
To: [EMAIL PROTECTED]
Subject:Hrm...why is this wrong?
In
Mr. Richter,
> I wrote that function, wich doesn't work. I want to hand
> over the name
> of the tables(relation_table, update_table) and a
> column(column_to_fill). The intention is, to use the
> function also with
> other tables(not hard coded).
1. Try using type VARCHAR instead of TEXT for t
I'm interested by TOAST, and I have asked several questions on the subject...
I haven't tested them yet...
First I thought that the type bytea allows storing of binary data, a BSOB
(Binary Small OBject).
Secondly that by using a binary cursor you have access to the raw data as it
is stored in the
You could send the column name directly into your c function. For example:
c_function_name(NEW.col1, NEW.col2, NEW.col3). Otherwise I am not sure how
to send NEW into a C function. You could try declaring NEW in your C
function as a tuple.
-Original Message-
From: Joe Conway [SMTP
Greetings,
I notice some talk about date problems and interestingly enough planning
out an application in which I will need to be able to manipulate dates.
I notice however that there seems to be a discrepancy with the day or
week in 7.0.3
---
pmhcc=# select date_part('dow','now'::timestamp);
Folks,
I wrote that function, wich doesn't work. I want to hand over the name
of the tables(relation_table, update_table) and a
column(column_to_fill). The intention is, to use the function also with
other tables(not hard coded).
BUT this error appears :
psql:restructure.sql:32: ERROR:
Hi there,
I am compiling postgresql 7.1beta4. How would i change the 8k row
limit?
--
Manny C. Cabido
e-mail:[EMAIL PROTECTED]
[
Bruce,
Thanks for replying (I know you're a busy man :)
Any chance to have it backported to 7.1 or maybe in contrib???
This is a feature w all gonna lack (with GiST...)
Regards,
On Mon, 29 Jan 2001, Bruce Momjian wrote:
> > Hi Bruce,
> >
> > Any idea when it's due for??
> > I've been thining
Dear Sir.
Would you like to inform me how to modify type
in table?
For example , I define type as varchar(14) , but
I want to modify to varchar(120). How to do this.
Thank you so much
Jaruwan
Maybe the functions lo_import and lo_export is what you're looking for?
regards,
robert gravsjo
Olivier PRENANT wrote:
> Hi,
>
> Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat
> file.
>
> It seems quite easy with php; But how can I do it from psql??
>
> TIA
>
Dear Sir,
I will highly appreciated if anyone could
inform me how to solve the following problems in Postgres.
Specifically, sometimes there are the following messages
informed by postgres.
NOTICE: Message from PostgreSQL
backend:
37 matches
Mail list logo
