ne is functional: in an unique constraint you can allow NULL
values and ignore them. A primary key does not allow this.
Respectfully,
Jorge Maldonado
Regards,
Luca.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to you
way I think of it is, that since the SQL standard does not mention
indices an INDEX (UNIQUE or otherwise) is just the databases application
of a constraint. So for practical purposes they are the same thing.
Respectfully,
Jorge Maldonado
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent v
On 09/30/2013 04:20 PM, hugh holston wrote:
I cant understand why I am not able to access and open my openclinica
webpage, . So what do I do.
My guess is you will get a answer sooner here:
https://community.openclinica.com/forums/users-email-forum
--
Adrian Klaver
adrian.kla...@gmail.com
n reference multiple columns...
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
rom the postgres
command-line or the configuration file, and in turn are overridden by
per-user settings; both are overridden by per-session settings.
regards
mk
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make chan
in the function. Could be
you wrote BEGIN; instead of BEGIN ... END;
Thanks and Regards
Kaleeswaran Velu
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
a de Desenvolupament Organitzatiu i Personal
Edifici Vèrtex. Planta 3
Pl. Eusebi Güell, 6
08034 - Barcelona
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
he PostgreSQL - sql mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
be simpler:
test=> SELECT extract(epoch from b) from a;
date_part
---
2592000
7776000
15552000
(3 rows)
As the b field is already an interval.
Regards
Ian Barwick
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To
On 01/16/2013 09:26 AM, James Sharrett wrote:
Integer
Well copy is returning a string, so try changing the type. You will have
to parse that string for the count.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to
ifferently than from sql query in GET DIAGNOSTIC
since the format and information in the string (when run outside of the
function) are exactly the same.
Execute strSQL into export_count;
What is export_count DECLAREd as?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing l
the form
COPY count
The count is the number of rows copied.
"
So it looks like you will need to parse the string for the count.
Thanks in advance,
James
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
ump or modify a partial dump or create your own script.
Thanks a lot!
Emi
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
dump only the global items.
Edward W. Rouse
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
specific without more information. In a
particular the condition/field being tested and values being tested for.
Respectfully,
Jorge Maldonado
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http
atin1, the french character
cannot be auto-loaded.
You might get an answer sooner at:
https://groups.google.com/group/mybatis-user
Thanks.
--
Emi
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscrip
tor-j-reference-charsets.html
"All strings sent from the JDBC driver to the server are
converted automatically from native Java Unicode form to
the client character encoding, including all queries sent "
>
> Thanks a lot!
> Emi
>
>
--
Adrian Klaver
adrian.kla...@gm
rgds Kjell Inge Ø
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
t was the pg_dump command you used?
--
Rgds
Kjell Inge Øygard
Electronic Chart Centre
www.ecc.no <http://www.ecc.no>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
net>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
9 total transactions thus far, in 70
> different postgresql slave installations (mixture of 8.3.3 and 8.3.13) (we
> are a shipping company),
> until i got this error report from a user yesterday.
>
> What could be causing this? How could i further investigate this?
The only thing I co
Well the question to ask is if it is declared CHAR was that done for a
legitimate reason? One reason I can think of is to have leading 0s in a
'number'. Might want to double check that code downstream is not
depending on CHAR behavior.
--
Adrian Klaver
adrian.kla...@gmail.com
--
S
e path
in your script.
*pg_dump: aborting because of server version mismatch*
-e
All database backups complete!
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
what I was looking for or
missed it.
On Thu, Mar 1, 2012 at 1:36 PM, Adrian Klaver wrote:
For future reference including the Postgres version would be
helpful. This area ownership/grants/etc has undergone a lot of changes over
the various versions.
I specified above I was using 9.1 PostgreS
it's tables. Can we start fresh and assume I just got the request to
change the specified database and all of it's tables, sequences,
views,& triggers to Lauren?
See above. For future reference including the Postgres version would be
helpful. This area ownership/grants/etc has undergon
ror message would be helpful:)?
A common reason for this is a firewall between the client and server that is
preventing connection to the server port.
Another reason is a pg_hba.conf that has not been configured to allow
connections
from the client.
--
Adrian Klaver
adrian.kla...@gmail.com
--
r=b.chr
> ^
>
> ** Error **
>
> ERROR: schema "dbo" does not exist
> SQL state: 3F000
> Character: 761
Do you in fact have a schema dbo?
If so can you access the schema and table using some other method, for instance
using psql?
--
A
efault) will be filled in by the planner with a constant
null
expression.
"
If you want all the gory details read through section 37, in particular 37.3 :)
The above is why I use triggers now. It is a lot easier to follow the logic in
a
trigger than in a rule.
>
>
at is the error reported?
What do the Postgres logs show when you restore the data?
Do a pg_restore -l against the dump file. This will list the contents of
the dump. See if the schema and contents are there.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing
postgresql.conf. This
can create the illusion that only one schema is available in a database.
One way to check is to use the fully qualified name for a table you know
to be in the reports schema. Ex:
select * from reports.some_table;
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql
command line statement you are using?
Are doing both dumps as the same user?
Thanks
Edward W. Rouse
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
(4)::varbit(4);
varbit
1010
(1 row)
test(5432)aklaver=>SELECT 10::bit(4)::varbit(3);
varbit
101
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
ither char or
varchar depending on whether they are bit or bit varying.
In the first case you are basically doing an int-->char, for which there is a
built in cast.
In the second case you are doing int-->varchar for which there is not a cast.
--
Adrian Klaver
adrian.kla...@gmail.com
--
at the Manual is very helpful in this regard:)
http://www.postgresql.org/docs/9.0/interactive/datatype-character.html
character varying(n), varchar(n)variable-length with limit
character(n), char(n) fixed-length, blank padded
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql
On 01/19/2012 09:17 AM, Samuel Gendler wrote:
On Thu, Jan 19, 2012 at 8:20 AM, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote:
On Thursday, January 19, 2012 7:59:27 am Gary Stainburn wrote:
> The following code works in 8.4 but not 8.3.
> Anyone know why, or wh
8.3- I believe you could only call it as
SELECT * from date_range (asdate, afdate)::date AS asdate;
>
> Is there a way to use the integer only generate_series in 8.3 to generate
> dates by typecasting to/from integers?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sq
e
> FROM salesmen s
> WHERE s.id = accounts.sales_id
For completeness, you could also do:
UPDATE accounts
SET (contact_last_name,contact_first_name)=
(s.last_name,s.first_name)
FROM salesmen s
WHERE s.id = accounts.sales_id
Gets you a little closer to what you want:)
--
Adri
On Thursday, January 12, 2012 9:02:35 am David Johnston wrote:
>
>
> Adrian, you are not helping...if ON UPDATE CASCADE was enabled on "orders"
> the error in question would never have appeared and the UPDATE would have
> succe
TAIL: Key (id)=(11) is still referenced from table "orders".
> [/CODE]
>
> How does one accomplish my goal? Is this difficult to change or once
> that foreign key is created, are you stuck with that particular
> constraint?
You are pushing in the wrong directio
tmp_staging0109
tmp_staging0108
tmp_staging1229
(3 rows)
test(5432)aklaver=>SELECT fld_1 from name_test where fld_1 < 'tmp_staging'||
to_char(current_date-interval '10 days','MMDD') and fld_1 > 'tmp_staging0131';
fld_1
-
ld_1 desc limit 1;
fld_1
-
tmp_staging1229
>
> Thanks.
> Tony
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing li
tmp_staging0109
> tmp_staging1229
> tmp_staging0108
>
> How can I write this correctly?
As far as I can tell it is correct. 0108,0109 and 1229 are all less than 1230.
What happens if you do?:
select tablename from pg_tables where tablename like 'tmp_staging%' an
.1. Declaring Function Parameters
Search for RETURNS TABLE
>
> return
>
>
> Johnf
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
lhasindex
UNION
(SELECT relname
FROM pg_class
WHERE relhasoids
ORDER BY relpages);
>
>
> thanks,
> stefan
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Saturday, December 17, 2011 8:50:52 am John Fabiani wrote:
> As always I respect your insights - Adrian. I do understand what I did
> wrong in my first attempt at getting my statement to work. But it is
> either over my head or there is something missing. Where is the "from&qu
select foo.week_date, xchromasun._chromasun_getqtyordered(303,
> foo.week_date) as week_qty from
> (select ((date_trunc('week', '2011-11-20'::date )::date) + (i+6)) as
> week_date from generate_series(0,84,7)
> i ) as foo
>
> The above works!
>
> Johnf
&g
be nice:) If the above was it then that
explains the problem. First I think you are looking for psql not pgsql. Second
it should be psql -U postgres ...
>
> Regards, Mandana
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make c
ime' values by 1,000,000
to
make them seconds. Like:
SELECT ticket, "time"/100, author, field, oldvalue, newvalue
FROM ticket_change
where "time"/100
BETWEEN
extract(epoch from (date 'now' - integer '30')) AND
extract(epoch
WHERE
bint
BETWEEN
extract(epoch from (date 'now' - integer '30'))
AND
extract(epoch from (date 'now'));
bint
--
(0 rows)
That being said, if your time values are the order of magnitude shown they will
not meet the criteria abov
On Sunday, August 14, 2011 11:33:13 am David Harel wrote:
> On Sun, 2011-08-14 at 11:07 -0700, Adrian Klaver wrote:
> > On Sunday, August 14, 2011 10:15:43 am David Harel wrote:
> > > On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote:
> > > > On Saturday, Aug
On Sunday, August 14, 2011 10:15:43 am David Harel wrote:
> On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote:
> > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote:
> > > Greetings,
> > >
> > > I use Ubuntu 10.04. I have postgresql version 8.4.8
a
given value of integer the storage should be the same for each up to the limit
of the integer field. Would seem that whatever is putting values into time is
inflating the values if they are actually referring to contemporary time values.
>
>
>
> As you understand, I always ge
/www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-De
> bugger.html
>
> Any idea?
http://www.enterprisedb.com/docs/en/8.4/pgadmin/debugger.html
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make ch
1
> (1 row)
>
> is correct.
>
> But now if I do:
>
>
> select count(*) from table where col::text !~~* '%text%';
> count
> ---
> 98
> (1 row)
>
> Shouldn't it be 99? That is out of 100 records there is one that has
> "text
www.postgresql.org/docs/9.0/interactive/sql-explain.html
I believe you are looking for:
explain (ANALYZE, FORMAT YAML) create table...
>
> Does anybody has an idea how to retrieve the output of explain within pgsql
> and store this in a variable?
> An alternative would be any other wa
z_drop is being applied to the first parameter only.
Emi
EXECUTE test('', '1', '1', '1', '1', '1', '1', '1', '1', '', 1, 1, '1',
'0', '0', '0', '0&#
other?
>
> I believe something has changed perhaps in sql from 8.3 to 8.4, or I have
> missed something with restoring the files.
Did you do a full restore or selective?
>
>
> Any assistance offered will be appreciated.
--
Adrian Klaver
adrian.kla...@gmail.com
; any tuple that already exists in the table I want to get the id of the
> original tuple.
>
To your original question I am not aware of a way of returning the id of the
offending tuple, other than through a SELECT.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgs
he EXCEPTION to return that id instead of using a select to know wich was
> the id of the triple already existing in the table?
If the id is the PRIMARY KEY then it would be the same as the id you tried to
INSERT correct?
>
> Thanks,
> Filipe
--
Adrian Klaver
adrian.kla...@gmail
ics
t2
stone
serial_test
messages
binary_test
user_test
timestamp_test
role_t
py_test
money_test
lock_test
local_1
lang_test
interval_test
foob
fooa
fldlength
fk_1
default_test
csv_null
check_two
check_test
array_test
(29 rows)
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent
ado", "Completo")
GROUP BY o.data_fim;
'
language 'sql';
the column is t.status and not "Aguardando Pagto";
what's wrong ? thanks
Try single quotes, 'Aguardando Pagto'
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-
am I wrong?
>
> Johnf
Dollar quoting ? :
http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html
4.1.2.4. Dollar-Quoted String Constants
test(5432)aklaver=>SELECT $$D' Andes$$;
?column?
--
D' Andes
--
Adrian Klaver
adrian.kla...@gmail.com
tell me how can I make copy command to ignore the
data missing column ? as the data in file is unknown so it column name
is which is missing is not known in advance.
You can specify a column list to COPY. See here:
http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
Thanks
Amar
--
A
yyy-mm-dd'), -1), 'fmMonth')
> as prev_month_name
> from dual
>
>
> But i still miss some lines in order to properly explicit casts in the
> query
>
> cheers,
> iuri
My guess is you upgraded from a version prior to 8.3. In 8.3 many of the
impli
gt; need to add explicit type casts.
> QUERY: select to_date(date_trunc('month',add_months( $1
> ,1)),'-MM-DD') - 1
> CONTEXT: PL/pgSQL function "last_day" line 6 at SQL statement
>
>
> how would i apply the following solution
>
> date_trunc('
the search order for unqualified object names. What you can
see or do with those objects is determined by the privileges on those objects.
Those privileges come from either the role that created the object or are
GRANT(ed) by a sufficiently privileged role to another role.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
f there is such a schema. (If
not, $user is ignored.) "
"The default value for this parameter is '"$user", public' (where the second
part will be ignored if there is no schema named public). This supports shared
use of a database (where no users have private sc
g variants change a role's session default for a configuration
variable, either for all databases or, when the IN DATABASE clause is
specified, only for sessions in the named database. Whenever the role
subsequently starts a new session, the specified value becomes the session
de
IF to ELSEIF should fix it.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
E 1: ... cl.depart, cl.sessionid, cl.instrid, cl.classseq,(select fa..
^
Looks like the result of the 'select facility.." is being inserted into the
schedule column.
>
> Johnf
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
RETURN QUERY SELECT 10,20 UNION ALL SELECT 30,40;
> ELSE
> RETURN QUERY SELECT 60,70 UNION ALL SELECT 80,90;
> END IF;
> RETURN;
> END;
> $$ LANGUAGE plpgsql;
>
> SELECT * FROM foo(1);
> SELECT * FROM foo(2);
>
> Regards
>
> Pavel Stehule
>
cat event.csv | psql -f event.sql
What's the problem? Many thanks in advance.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
adrian
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
d combine this with results Y.
How is it possible to do this?
Thank you for your help.
Adrian.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
all coordinates in snps table.
Then I want to get those entries where sample 1 and sample 2 have in
common and sample 1 and sampl3 in common.
I do not know how to get these entries. Could any one help me please.
thank you.
adrian
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To
org/docs/8.4/interactive/app-psql.html
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
> anything about this in the archives or the data type documentation. Is
> there something obvious that I'm I missing?
>
> Thanks,
>
> --
>
> Lee Hachadoorian
> PhD Student, Geography
> Program in Earth & Environmental Sciences
> CUNY Graduate Center
See here for e
ows:
drwxrwxr-x 3 ruby_process postgres
I have also tried moving the files to /tmp and performing the copy from
there, unsuccesfuly.
Any ideas would be appreciated. Thanks,
-Harold
Are you connecting to the database as a superuser to run the COPY command?
--
Adrian Klaver
adria
DECLARE
> pid_num bigint;
> BEGIN
> select into pid_num from select nextval($);
> RETURN pid_num;
> END;
> ' LANGUAGE 'plpgsql';
>
> -- and how will the trigger looks like
> ???
You know serial is just a shortcut for:
pid int NOT NULL
On 03/15/2010 10:24 AM, Daniel Guedes wrote:
Hi!, I don't want to receive more emails from postgresql.
Please remove my email from your delivery list.
Thanks
To unsubscribe go here:
http://www.postgresql.org/mailpref/pgsql-sql
Thanks,
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sen
a sin coche que sin Messenger
www.vivirmessenger.com
To unsubscribe go here:
http://www.postgresql.org/mailpref/pgsql-sql
Thanks,
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
drea
One thing I would do is rename your zones record variable. pgsql does
not deal well with a variable having the same name as a schema object,
in this case your table zones.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make
easiest solution would be to change the
search_path in:
citext.sql.in
uuid-ossp.sql.in
These files are found in the respective contrib directories. Uninstall the
modules. Rerun make and then reinstall.
From here:
http://www.postgresql.org/docs/8.4/interactive/ddl-schemas.html
"There is nothin
OP is talking about are variables that are coerced to being 'tables'. I can
see no mailing list for sqldf itself. The closet I could come is
https://stat.ethz.ch/mailman/listinfo/r-help
which seems to have quite a few discussions on sqldf and would probably be the
better place t
esql.org/docs/8.4/interactive/multibyte.html#AEN30078
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
t; Many thanx in advance,
>
> Best,
> Oliveiros
Can you show the SQL you are using?
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
>
> Thank your in advance for your help.
>
> regards,
> nico
>
> --
> Nico Mandery
I am going to assume that '--do something' is more complicated then getting the
mytable_id. If that is the case why not create an INSERT function/trigger that
does the 'someth
, PRIMARY KEY(company_id));
> Any ideas on how to fix this? Thank you,
> janneaa
I think more information is required. First the complete transaction. Second
the
complete error message, especially the part that explains what is causing the
CREATE INDEX command to fail. Third I do not see
hanks!!
>
If at all possible, try to move all that information into schema's of one
database. As it stands now you have a lot of moving parts to keep track of via
external processes. It is possible but you lose transactional support and trust
me that turns into a royal pain.
--
Adria
ook at Savepoint rollback and Database-level autocommit.
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
id | topic | message
+--+--
1 | My favorite food | I like lasagna!
2 | My favorite food | Pizza is also a favorite
3 | Are squares better then circles?
- "Peter Willis" wrote:
> Adrian Klaver wrote:
> > On Friday 03 April 2009 6:51:05 am Adrian Klaver wrote:
> >> On Thursday 02 April 2009 6:16:44 pm Adrian Klaver wrote:
> >>> Now I remember. Its something that trips me up, the RECORD in
> RETURN
On Friday 03 April 2009 6:51:05 am Adrian Klaver wrote:
> On Thursday 02 April 2009 6:16:44 pm Adrian Klaver wrote:
> > Now I remember. Its something that trips me up, the RECORD in RETURN
> > setof RECORD is not the same thing as the RECORD in DECLARE RECORD. See
> &g
On Thursday 02 April 2009 6:16:44 pm Adrian Klaver wrote:
>
>
> Now I remember. Its something that trips me up, the RECORD in RETURN setof
> RECORD is not the same thing as the RECORD in DECLARE RECORD. See below for
> a better explanation-
> http://www.postgresql.org/docs/8.3/i
is put a trigger on the table that
trims
the strings on INSERT or UPDATE.
>
>
>
> Volkmar
--
Adrian Klaver
akla...@comcast.net
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Thursday 02 April 2009 4:22:06 pm Peter Willis wrote:
> Adrian Klaver wrote:
> > Did you happen to catch this:
> > Note that functions using RETURN NEXT or RETURN QUERY must be called as a
> > table source in a FROM clause
> >
> > Try:
> > select * from te
- "Peter Willis" wrote:
> Adrian Klaver wrote:
> > On Wednesday 01 April 2009 4:31:20 pm Peter Willis wrote:
> >> Hello,
> >>
> >> I am having a problem with a FUNCTION.
> >> The function creates just fine with no errors.
> >
st_function" line 5 at SQL statement
You have declared function to RETURN SETOF. In order for that to work you need
to do RETURN NEXT. See below for difference between RETURN and RETURN NEXT:
http://www.postgresql.org/docs/8.3/interactive/plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTU
On Friday 20 February 2009 6:29:43 am Leif B. Kristensen wrote:
> On Friday 20. February 2009, Adrian Klaver wrote:
> >Actually you need both semicolons. One after the RETURN statement and
> > one after the END statement
> >See below for full details:
> >http://
Memo to self:
Remember hit reply all.
-- Forwarded Message --
Subject: Re: [SQL] Creating a function with single quotes
Date: Friday 20 February 2009
From: Adrian Klaver
To: "Leif B. Kristensen"
On Friday 20 February 2009 6:13:03 am you wrote:
> On Friday 20.
1 - 100 of 184 matches
Mail list logo
