On 09/30/2011 11:41 PM, John R Pierce wrote:
On 09/30/11 2:09 AM, J.V. wrote:
Some tables have millions of rows,
well, something like UPDATE tablename SET
id=generate_series(1,numberofrows); will update every row to a
sequential value. However, I have no idea how you would match the
foreign ke
On 09/30/11 2:09 AM, J.V. wrote:
Some tables have millions of rows,
well, something like UPDATE tablename SET
id=generate_series(1,numberofrows); will update every row to a
sequential value. However, I have no idea how you would match the
foreign key references in other tables to these new
On 30 September 2011 11:20, J.V. wrote:
> For tables that already exist and have a foreign key relationship, is there
> an equivalent alter statement for the statement below?
>
> Does this mean that if table xxx.id primary key value changes, the foreign
> key value will change as well?
They do if
For tables that already exist and have a foreign key relationship, is
there an equivalent alter statement for the statement below?
Does this mean that if table xxx.id primary key value changes, the
foreign key value will change as well?
If this is the case, then would not have to match up all
On 09/30/11 1:28 AM, John R Pierce wrote:
On 09/30/11 1:23 AM, John R Pierce wrote:
convert the fields to bigint which are 64 bit and not likely to wrap
around any time in this century
indeed, this is as simple as ...
alter table tblname alter column id type bigint;
of course, you'll nee
On 09/30/11 1:23 AM, John R Pierce wrote:
convert the fields to bigint which are 64 bit and not likely to wrap
around any time in this century
indeed, this is as simple as ...
alter table tblname alter column id type bigint;
of course, you'll need to alter all the FK fields that refer to
On 09/30/11 1:13 AM, J.V. wrote:
thanks for the help, we have a production schema with 80 tables and a
few of the tables have consumed the max limit for the id field, so I
have to write a program (stored functions would be the fastest way to
do this), that will go and drop the sequence, create
On 09/30/11 12:59 AM, J.V. wrote:
What data types do I have access to in a stored proc?
I cannot seem to find the stored procedure manual.
http://www.postgresql.org/docs/current/static/plpgsql.html
I am not speaking of database field/column data types, but rather
stored proc data types.
What data types do I have access to in a stored proc?
I cannot seem to find the stored procedure manual.
I am not speaking of database field/column data types, but rather
stored proc data types.
Regards,
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
On 09/30/11 12:24 AM, J.V. wrote:
What I want to do however is within a stored procedure make a call and
store all tables in a given schema in a list.
so procedure1 calls procedure2 (not sure why this extra level of
procedures, but I'm playing along)
and procedure2 does SELECT table_name fro
Yes, I know that one.
What I want to do however is within a stored procedure make a call and
store all tables in a given schema in a list.
Is this something you can answer?
thanks
J.V.
On 9/29/2011 3:25 AM, Richard Huxton wrote:
On 29/09/11 02:33, J.V. wrote:
Is is possible within a store
On 29/09/11 02:33, J.V. wrote:
Is is possible within a stored procedure to read all the tables in a
schema into a list?
[snip]
I need to extract this meta-data for a project.
Apart from information_schema mentioned elsewhere, start psql with -E
and then try \dt and similar - it will show you
On 09/28/11 6:33 PM, J.V. wrote:
Is is possible within a stored procedure to read all the tables in a
schema into a list?
From that list and for each table is it possible to find the foreign
keys in that table?
From that list of foreign keys, is it possible to find out which field
in which
Is is possible within a stored procedure to read all the tables in a
schema into a list?
From that list and for each table is it possible to find the foreign
keys in that table?
From that list of foreign keys, is it possible to find out which field
in which table the FK corresponds to?
I n
Damian Georgiou wrote:
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
decommissioned so I am unable to check exactly what version it was though it
was version 8 under winxp.
I am now running postgres 8.2.5 U
Damian Georgiou wrote:
Hi All,
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
ERROR: function sp_schedulefromdate("unknown") does not exist
LINE 1: select sp_scheduleFromDate('2008-01-01');
Hi All,
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
decommissioned so I am unable to check exactly what version it was though it
was version 8 under winxp.
I am now running postgres 8.2.5 Under OSX 10.5.3
Harpreet Dhaliwal wrote:
> lately I have been looking at difference between a Stored
> Proc and User Defined Functions in other RDBMS like Sql
> Server / Oracle.
Nomenclature varies wildly between different Database
Management Systems. Be careful.
The SQL standard (2005) speaks of "SQL-invoked
Hi,
lately I have been looking at difference between a Stored Proc and User
Defined Functions in other RDBMS like Sql Server / Oracle.
However, in postgresql, I think Stored Procs are wrapped around in User
Defined functions, if I am not wrong.
The following is the list of main differences b/w a St
Hi,
> > 2) Is CREATE FUNCTION pretty much a logical equivalent to CREATE
> > PROCEDURE in other RDBMSs?
>
> I not sure how it is in other DBs, but a little differention is here; in
> current state is not available create routines that retuns tuple.
Stored procs can returns tuples... but I'd li
On Tue, 11 Jul 2000, Randall Parker wrote:
> I'm trying to figure out how to do in Postgres what I already pretty well understand
>in
> DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
> in a table using those args in a where clause, and then return a boolean
I'm trying to figure out how to do in Postgres what I already pretty well understand
in
DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
in a table using those args in a where clause, and then return a boolean result of
whether a matching row was found. Or pote
22 matches
Mail list logo