stopped the few that did not. There was a reported some
utf8 error.
I was hoping to be able to have all the dbs convert to utf8 for consistency,
but at least I have everything migrated.
From: Scott Whitney [mailto:sc...@journyx.com]
Sent: Thursday, October 10, 2013 4:08 PM
To: Marc Fromm; pgsql
I need to convert a bunch of my databases to utf8 before I can migrate them to
postgresql 8.4. Is there a command that during the pg_dumpall process the
encoding can be changed from latin1 to utf8?
This is the error I get when migrating the databases from 8.1 to a machine
running 8.4
psql:pgdbs
Thursday, October 10, 2013 1:55 PM
To: Marc Fromm; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] move dbs from 8.1 to 8.4
On 10/10/2013 01:17 PM, Marc Fromm wrote:
I built a new server running centos 6.4 and postgresql 8.4. I backed up all the
databases from the old server running fedora and
anks
I am using 8.4 just because it's what gets installed with CentOS6.4.
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Thursday, October 10, 2013 1:55 PM
To: Marc Fromm; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] move dbs from 8.1 to 8.4
On 10/10/2013 01:17 PM, Marc
, how do I migrate the databases with their tables
and data and migrate the latin1 encoded databases?
Thanks
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Marc Fromm
Sent: Thursday, October 10, 2013 1:17 PM
To: pgsql-admin@postgresql.org
Subject
I built a new server running centos 6.4 and postgresql 8.4. I backed up all the
databases from the old server running fedora and postgresql 8.1 using this
script.
#!/bin/bash
# Backup all Postgresql databases
# Location of the backup logfile.
logfile="/var/lib/pgsql/backups/logs/pg_back.log"
#
.
DB size :3500 GB
pg_catalog size: 2GB
select count(*) from pg_tables;
120'884
select count(*) from pg_indexes;
219'082
select count(*) from pg_attribute;
2'779'199
Server: 48 GB RAM & 12 cores
regards,
Marc Mamin
--
Sent via pgsql-admin mailing list (pgsql-admi
Thanks Tom, I just discovered that. I reworked the php so the quotes surround
the regexp.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, March 28, 2013 1:07 PM
To: Marc Fromm
Cc: Craig James; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select exact
records are returned even though the ILIKE statement shown
below returns records that do have the word art.
$search = "art";
$strSQL2 = "WHERE (title ILIKE '%$search%' OR description ILIKE '%$search%') ";
Thanks for the insight.
From: Craig James [mailto:c
f I create a select statement using WHERE description = 'art' I get no results
even though the word art is in some records description field.
Thanks
Marc
Hello,
if I try to SET log_connections = true
(as super user, for another role)
I get the error: parameter "log_connections" cannot be set after
connection start.
I find it a bit surprising as this wouldn't affect the current session.
best regards,
Marc Mamin
('Paraeducator',
'1', '9.50', '9.50', '9/16/2011', '6/10/2012', 'fdfd', 'fdfd', 'fdfd', 'firstn
lastn', '3351', 'emai...@mail.com', '2', 'This position mostly tutors,
instructs, or directly assists students. Less than half of the position tasks
are clerical or support duties.', '10', '28', 'all', '70%',
'09-20-2011');SELECT currval(id);
Marc
id:
INSERT INTO Addresses (address, city, state, postalcode) VALUES ('123 Main
St.','Springfield','MA','01109') RETURNING id;
Thanks
Marc
Oops,
not my day :-)
many thanks,
Marc Mamin
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Montag, 12. September 2011 12:16
To: Marc Mamin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] how can I get "initial_value"(setting_name) ?
On
available, I guess that
following may prove useful:
- reset_setting (setting_name [, is_local])
- (read)initial_value(setting_name)
best regards,
Marc Mamin
CREATE OR REPLACE FUNCTION public.cic_set_memory_plan (p_plan varchar)
returns int AS
$$
BEGIN
--LSORT, MSORT, LMAINT, RESET
if p_plan
otherwise here is a howto foe moving tables and indexes one by one:
http://blog.lodeblomme.be/2008/03/15/move-a-postgresql-database-to-a-different-tablespace/
HTH,
Marc Mamin
know if this is a known problem. I searched the mailing list
with no success. I can provide a full log of a complete restore, without and
with -j.
Thanks,
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Is there a way to query a unix timestamp date? In the database the orderdate
field is a unix timestamp.
I would like to create the where clause to a query on a specific date like
December 17, 2010.
Select * from orders where orderdate = '12/17/2010';
Thanks
Marc
, unless it is
hidden. Is there a way to tell the script to ignore them?
GRANT SELECT ON TABLE sql_languages to tom;
ERROR: relation "sql_languages" does not exist
Thanks
Marc
Marc Fromm
Information Technology Specialist II
Financial Aid Department
Western Washington University
Phone: 360-650-3351
Fax: 360-788-0251
odbc.ini file? It is currently just a blank
file.
Thanks for any help.
Marc
Hello,
I'd like to check how reasonable our Fillfactors settings are (for
indexes),
but I'm not sure which statistics can be used for this.
best regards,
Marc Mamin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
created.
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Tuesday, February 08, 2011 3:36 PM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] phpPgAdmin configuration
Le 09/02/2011 00:27, Marc Fromm a écrit :
> Yes, the database server is on the
simple but I cannot seem to see it.
-Original Message-
From: barb...@bariloche.com.ar [mailto:barb...@bariloche.com.ar]
Sent: Tuesday, February 08, 2011 4:57 PM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] phpPgAdmin configuration
Hello:
Is it a passwordless account? I
Yes, the database server is on the same server as the http server.
The complete error message is just "Login failed."
There is nothing in the pg_log file, that the FAQ's say to check.
Marc
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto
try to login to phpPgAdmin with a user account that I created, using the
CREATE USER command, I get the login failed message.
What else do I need to configure to allow access with phpPgAdmin?
Thanks
Marc
There were no links or other helpful information provided. Has anyone upgraded
from 8.1 to the latest version 9.0.1? Can you do it in one jump?
Can it be done using yum on a RHEL server?
Thanks
Marc
et the
expected result:
pg_dump -i -v -nXXX -T 'XXX.*2008*' -T ' XXX.*2009*' -T ' XXX.*201001*' -T
XXX.'*201002*' .
seems that the use of the -n flag requires to use these schema names within the
patterns ...
best regards,
Marc Mamin
>
I try the same pattern with psql dt\, I get the expected list of
tables to exclude...
pg_dump --version
pg_dump (PostgreSQL) 8.3.9
I'd appreciate some help.
best regards,
Marc Mamin
phone,explanation,reason,status)
VALUES ('zzz','zzz','zzz','zzz','zzz','zzz','zzz^M
zzz', . . . )
Any ideas on what is generating the ^M and breaking up the sql statement so
that it cannot be executed?
Marc
erences to this tablespace.
What should I do to safely get rid of this tablespace:
- Is there a way to obtains all dependent objects of a tablespace ?
- How is this error triggered ? comes it from a check of the folder
content, or from the catalog ?
many thanks,
Marc Mamin
/v8.3.11/win32/
ftp://developer.postgresql.org/pub/binary/v8.2.17/win32/
They will propogate to the main download pages in 24 hours.
That's odd ... wonder why v8.3 and v8.2 were overlooked ... but v8.4 was
moved?
Marc G. FournierHub.Org Hosting Solu
created with no errors
The only problem is it did not create the sequence for the primary key.
Do I have to manually create the sequence or did I miss a step in exporting and
creating the table?
Thanks
Marc
Hello,
I experienced a similar issue with 8.2.x having a duplicate value in a
primary key !
In our case it definitively happened as the plates got out of space, so
I did put the fault on us, not on Postgres :-)
regards,
Marc Mamin
-Original Message-
From: pgsql-admin-ow
ramming, but wouldn't it be a good idea to
add/integrate the pigz source in pg_dump ? There is a least no concern to have
about the License.
regards,
Marc
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tino Schw
each 3-500 GB...
A better way would be to have a configuration option to tell which compression
tool should be used internally by pg_dump.
best regards,
Marc Mamin
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf O
tom format in order to take advantage
of the parallel restore enhancement, but this would force me to give
pigz up, hence loosing performances with pg_dump.
Is there a way to combine the custom format with pigz?
feature request ?
best regards,
Marc Mamin
if I have any GiST indexes and hash indesxes on interval
columns?
Is there a command to reindex all databases at once or must I do each
individually?
Thanks
Marc
I have a column that contains user email addresses. I need to update all email
address in the column that end with @cc.edu to @ss.edu and retain the
information (the user name) that exists before the @ symbol. Is there an update
query that can edit part of a column record?
Marc
sql-sql/2006-05/msg00023.php
Can someone points me to the script, or is there a better approach to
create such a role ?
Thanks,
Marc Mamin
RANT ALL ON TABLE classification_guide_jobs TO postgres;
69
70
71 --
72 -- PostgreSQL database dump complete
73 --
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, June 17, 2009 10:10 AM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [A
emp')
SQL error:
ERROR: duplicate key violates unique constraint
"classification_guide_cats_pkey"
id is a primary key
nextval(('"classification_guide_job_id_seq"'::text)::regclass)
Could the primary key count have been reset so that it is starting at 1 again?
The primary key id is up to 128.
Thanks
Marc
great, thanks a lot...
On Tuesday 05 May 2009 17:11:35 Tom Lane wrote:
> Marc Cousin writes:
> > On Tuesday 05 May 2009 16:35:11 Tom Lane wrote:
> >> Hmm ... is it likely that index entries with pathid = 120 are *very* few
> >> and far between in jobid order
On Tuesday 05 May 2009 16:35:11 Tom Lane wrote:
> Marc Cousin writes:
> > [ can't cancel this query ]
> >
> > Index Scan using file_jpfid_idx on file (cost=0.00..7327212.07
> > rows=2128 width=104)
> >Index Cond: (pathid = 120)
> >
> >
Hi, I'm having a problem cancelling a query.
I've already had sometimes this kind of problem, but not this hard (and I
didn't find anything searching the archives, but still I remember seeing
discussions about this). Usually, it cancels in a few seconds to a minute.
I've run this query an hou
n the
following link:
http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacu
umlazy.c.diff?r1=1.61.2.1&r2=1.61.2.2
Where can I find this patch and is there a specific way to apply the
patch?
Your help is appreciated.
Regards
Marc
' else 'n' end ||'|'||
case when proisstrict =true then 'y' else 'n' end ||'|'||
case when proretset =true then 'y' else 'n' end ||'|'||
provolatile ||'|'||
pronargs ||'|'||
I care with it in a special way in my situation ?
many thanks,
Marc Mamin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
from the Oracle DB to the Postgresql DB?
Marc
ow['alert']);
echo "\n\n";
$count++;
}
}
if ($w_number==""){echo "Enter a W number!\n\n";}
echo "End of line";
pg_free_result($result);
pg_close($dbconn);
?>
-Original Message-
From: Scott Marlowe [mailto:scott.mar
My results are missing the first record as you explained.
-Original Message-
From: iog...@free.fr [mailto:iog...@free.fr]
Sent: Friday, January 02, 2009 10:09 AM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] access data in php
On Fri, 2 Jan 2009, Marc Fromm wrote
)){ . . . }
I have to execute this code a second time before the while loop
$results = pg_query($dbconn,$query);
If I do not execute the $results line a second time the while loop does not
work properly.
Why is $results loosing its value when it hits the while loop?
Thanks
Marc
ntFirstName',
'$txtStudentLastName',
'$txtStudentAlert',
'now()'
)";
How do I do an insert on this table and have the primary key "id" update with
the record?
thanks
Marc
he backup of the table
file, without actually explaining what edits to make. I made no edits and it
appears the data is all restored that was missing from the departments table.
-Original Message-
From: val [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 5:57 AM
To: pgsql-admi
do I restore smsdepartments to the
table called departments in the sms database?
Thanks
Marc
d with any
items in the database, owner is always listed as postgres.
Marc
restore with a starting point, and
that postgres is a good place to start.
Marc
9MB
Fedora Core 5: alldb.gz is only 15MB
Any ideas as to why the red hat box pg_dumpall file is about twice the size?
Marc
make a new database based on
template0 does that mean that database cannot accept connections?
Thanks
Marc
hat is already being done on a nightly basis prior to the backup.
thanks
Marc
ement-5360
then 5362, missing 5361.
Thanks
Marc
/usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
Why is there no -p 5432 on the red hat box? I assume the port is needed. What
do I need to do to have the postmaster running on port 5432 like on the fedora
box?
Thanks
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
base directory (the databases) as the -c flag seems to do. I
tried to use pg_restore but I receive a message stating the pg_dumpall file is
an invalid archive.
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
postgresql, so far all I have found are the postgresql.org documents which are
a little vague on the subject.
I must assume there is a better method than my long process that does not bloat
the size of the base directory (the databases) as the -c flag seems to do.
Marc
--
Sent via pgsql-admin
db2 postgres
I tried to drop a user but was denied with the message, ". . . some objects
depend on it."
Why isn't the -O flag not removing the owner from all objects?
Thanks
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
stgresql-$i-$timeslot-database.gz"
I would like to remove all owners from all objects so when I do a restore all
objects are owned by postgres. Can I just tack on -O after -U postgres?
/usr/bin/pg_dumpall -ch 127.0.0.1 -U postgres -O | gzip >
"$backup_dir/postgresql-all-$timeslot-datab
On Tuesday 24 June 2008 16:56:10 Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > I'm having a problem with plpgsql functions leaking memory.
>
> Your example shows absolutely no memory leak here, in either 8.3.3
> or CVS HEAD.
>
> > I see the
Hi,
I'm having a problem with plpgsql functions leaking memory.
I've reproduced the problem with this simple function here :
CREATE OR REPLACE FUNCTION ftest()
RETURNS boolean AS
$BODY$BEGIN
INSERT INTO test2 values (1);
RETURN true;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
test2 table is a
with buggy kernels; consider
updating your system.
Now I'm interested in a way to get the list of all corrupted objects.
The only way I know is to check the errors of pg_dump or vacuum.
Is there a faster way, something like "vacuum check_only" ?
Thanks,
Marc Mamin
--
Sent via pgsq
to create the database once I "su" to postgres, using CREATE
DATABASE, but I do not know how to restore a database as I do in the shell as
listed above.
Thanks
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
e a way to have postgresql let the user no the entry attempt was
declined? What is the best way to handle these situations?
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
One of our databases when viewed in phpgadmin does not display the
actions on one of the tables in browse mode. I changed ownership of the
database to postgres and still the one table does not display the
actions.
Is there a command I can run to enable the Actions on this table?
Thanks
Marc
I've installed it and it works. Thanks a lot.
On Saturday 12 April 2008 01:01:06 Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > I'm having a strange problem : I created a view in a database, and I
> > cannot restore it after a pg_dump. ...
> >
wrong.
It looks like a parsing problem to me (as it sometimes work and sometimes not
with exactly the same query)
On Tuesday 08 April 2008 15:24:33 Sergio Gabriel Rodriguez wrote:
> May be your problem is ORDER BY in a view, try to delete ORDER BY clause
>
> Sergio.
>
> On Tue, Apr
ostgreSQL for a while now ...
Thanks in advance.
On Friday 04 April 2008 15:21:52 Marc Cousin wrote:
> I've forgotten to add this information :
>
> Version :
> infocentre_dte=# SELECT * from version();
>
anagement_systeme_memoire.devicenumber)::text) AS
devicenumber FROM
winaudit.winaudit_management_systeme_memoire GROUP BY
winaudit_management_systeme_memoire.computer) memoire ORDER BY CASE WHEN
(memoire.devicenumber = '{1,2}'::text[])
THEN 2 WHEN (memoire.devicenumber
Hi,
I'm having a strange problem : I created a view in a database, and I cannot
restore it after a pg_dump.
I'm creating this view :
CREATE VIEW vj_icsi_integration_winaudit_isiparc AS
SELECT DISTINCT objet.c_barre ,
resume.computer ,
Hi,
I cannot select any other role than public in the privileges tab in pgadmin
1.8.2. I see this for at least schemas and tables.
Is it a known bug, a normal behavior, an unknown bug ? :)
Cheers
Marc Cousin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
I add to the pgdump command to initiate the cascade?
3.) Is it best practice to drop the schema and dependant objects?
Thanks,
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
re than 16 * max_fsm_relations. The default is
2. This option can only be set at server start.
Do I increase max_fsm_pages or max_fsm_relations, or both.
Does "only be set at server start" mean to alter the settings in
postgresql.conf and then restart the postmaster?
Marc
--
ore the schema to the newdb.
psql -U postgres newdb < /tmp/template_name
4.) I create a database, using the newdb as a TEMPLATE
CREATE DATABASE databasename2 TEMPLATE newdb;
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
When I restore from a pg_dumpall file, I am required to peform the following
steps or else all the records in the databses are duplicated. If I only empty
the data/base folder I get al sorts of errors. I find in necessary to wipe the
entire data folder and rebuild it with initdb. Is there a bet
d.
Thanks
Marc Fromm
Information Technology Specialist II
Financial Aid Department
Western Washington University
Phone: 360-650-3351
Fax: 360-788-0251
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ontains all the data from the old database.
Is there a way to just get the old database design into a new database?
Thanks
Marc
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-admin
er but the process (ps
ax | grep post) is listed as /usr/bin/postgres
using the command "service postgresql start" starts postmaster but the
process (ps ax | grep post) is listed as /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
And both are the same thing?
Thanks
Marc Fromm
es "service postgresql start" start the postmaster and all of
postgres, but it is not mentioned in the documentation?
What is the correct way to stop and start postgresql?
thanks
Marc Fromm
Information Technology Specialist II
Financial Aid Department
Western Washington University
Phone
doing
this since moving to FreeBSD 6.x ... no patches required ...
--
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED] MSN . [EMAIL PROTECTED]
Yahoo . yscrappy Skype: hub.org
my DB intense activity, I have
no proof autovacuum started itself...
What am I missing here?
Thanks for help or hints.
--
A bientôt
==
Jean-Marc Pigeon Internet
[EMAIL PROTECTED] (Paul Lambert) writes:
>Marc G. Fournier From: wrote:
>> This is one of those 'stupid questions I hate to ask' ... I've rechecked the
>> docs to make sure I haven't missed something stupid, and unless I'm blind,
>> I haven't .
mand \
invalid command \n
invalid command \n
invalid command \.
and other errors ... so I'm obviously missing something that is probably
obvious to everyone else ... am I dumping wrong? If I use '--inserts',
it, of course, works like a charm, its only when I try and use COPY
Hi,
I'm having this problem on Windows 2003-SP1, with Postgresql 8.2.
At a certain moment (after several hours of use, randomly), the postgresql
server stops responding. When checking in the log, I see this message
repeatedly :
Could not send data to client: Unknown winsock error 10055
The prob
On Thursday 07 June 2007 18:40:37 Joshua D. Drake wrote:
> Abraham, Danny wrote:
> > Hi,
> >
> > I am migrating from Sybase to Postgres.
> >
> > trying to get a hold on the issue of future releases feature list.
> >
> > 1. Where can I find the feature list for 8.3 ? When is it expected?
>
> The ro
as well as possible.
Thanks a lot for feedback...
Marc Cousin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ich I can load
> data from flat files like (CSV, TXT) directly to Postgres Tables.
>
>
>
> Thanks & Regards
>
>
>
> M.AHRAM KHAN
>
>
>
>
>
>
>
>
-
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [
It seems to be what occurred : the windows client crashed ...
Still, it's a bit of a problem to have a filesystem full in a matter of
minutes just because a client machine crashed while having an SSL connection
opened on the postgresql server...
On Thursday 29 March 2007 19:40:18 Peter Koczan wr
minute...
Thanks in advance
Marc
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Sorry , my mistake:
The "postmaster.log" that I mentioned is defined in our Postgres start
script:
startproc -u <@DB_USER@> $PGSQL_BIN -D <@INSTALL_DIR@>/postgresql-data \
>> <@INSTALL_DIR@>/postgresql/postmaster.log 2>&1
Marc
---
ill I still get the postgres error in perl if I set redirect_stderr =
on in postgresql.conf ?
Thanks,
Marc
on Windows 2003.
try:
psql -c "select version();" template1
I believe 'psql --version' gives you version of psql, not the server itself,
while select version(); wil give you the server ...
-
Marc G. Fournier Hub.Org Networking Services (htt
sert
) then
return new;
end if;
Marc
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
>Trigger based solution where same trig can be used for any number of
tables by changing the parameter.
>Will throw one of 2 exceptions on failure to use sequence for the
insert.
Many thanks,
This seems to be the simplest solution,
Marc
---(end of bro
1 - 100 of 237 matches
Mail list logo
