In Postgres 10 Windows
invoking g_dump exe with
pg_dump.exe -b -f b.backup -Fc -h -U admin -p 5432 mydb
causes error
pg_dump: too many command-line arguments (first is "-p")
Try "pg_dump --help" for more information.
How to fix this ?
In earlier versions it worked.
correct-local-time-in-postgres
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, x,nsa))[1]::text::numeric AS tasusumma,
(xpath('ns:NtryDtls/ns:TxDtls/ns:Refs/ns:EndToEndId/text()',
x,nsa))[1] AS orderinr
FROM (
SELECT
unnest(xpath('/ns:Document/ns:BkToCstmrStmt/ns:Stmt/ns:Ntry',
x,nsa)) as x, nsa, x as xo
FROM t
) Ntry
This references
AS tasusumma
,
unnest(xpath('/ns:Document/ns:BkToCstmrStmt/ns:Stmt/ns:Ntry/ns:NtryDtls/ns:TxDtls/ns:Refs/ns:EndToEndId/text()',
x,nsa))::text AS orderinr
FROM t;
should produce
endaaatasusumma orderinr
XX00221059842412 150.00 PV04131
XX00221059842412 0.38 null
Andrus.
Hi!
Thank you.
In "PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"
it returns two empty rows. How to make it work in this version ?
In "PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 32-bit" it works.
And
ndToEndId/text()',
x,nsa))::text AS orderinr
FROM t;
Parsing can done in other ways e.q. using xslt stylesheet for tranformation
or in client side ASP.NET 4.6 MVC if this is more reasonable.
Posted also in
http://stackoverflow.com/questions/3739/how-to-parse-xml-with-optional
nsert into ko values ('G');
WITH func_cte AS (
SELECT crtKAIVE(ko.doktyyp)
FROM ko
)
SELECT (crtKAIVE).*
FROM func_cte;
but got strange error
ERROR: syntax error at or near ""
LINE 18: )
How to fix ?
Andrus.
Posted also in
http://stackoverflow.com/questions/37231624/how-to-use-table-row-values-as-function-parameters
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
"PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 32-bit" it works.
It looks like in 9.1 reassign owned should replaced with revoke commands.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
mydb using script below but still got error
ERROR: role "vantaa" cannot be dropped because some objects depend on it
DETAIL: privileges for database mydb
How to drop role?
Andrus.
set local role admin; -- admin is not superuser but is member of
mydb_owner
CREATE ROLE vantaa;
grant
user farukkugay ;
but got error
ERROR: role "farukkugay" cannot be dropped because some objects depend on it
SQL state: 2BP01
Detail: privileges for schema public
How to to delete user ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
, vantaa and farukkugan delete script causes error which I
described. For farukkugan it occurs also if running under superuser.
So it looks like it should be possible for non-superusers also.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
privileges for schema public
So even superuser cannot delete.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;
-- Restrict some tables:
revoke all on kasutaja,kaspriv,logifail from vantaa cascade;
grant select on kaspriv,kasutaja to vantaa;
grant update (eesnimi, nimi,email,amet,islocked,telefon,language,vabakuup)
on kasutaja to vantaa;
grant insert on logifail to vantaa;
Andrus.
--
Sent via pgsql-general
r who invokes this command if this helps.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and
drops this user in all cases without dropping data ?
Or maybe there is some command or simpler commands in postgres ?
Using Postgres 9.1+
Posted also in
http://stackoverflow.com/questions/32988702/how-to-drop-user-in-all-cases-in-postgres
Andrus.
nd finish or is postgres hanging ?
- Currently it is running 15 hours. How many hours it takes to finish ?
How to speed up this query ?
Using
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
Windows 2003 x64 server with 4 GB RAM.
Posted also in
http://stackoverflow.com/
turns null value.
I also tried to cast result to tebool
select test1.test::tebool from test left join test1 on false;
and
select null::ebool
This returns also null. So Postgres allows null values in this type instance.
There are no problems.
Andrus.
--
Sent via pgsql-general mailing l
that such record variable can created ?
Andrus.
CREATE DOMAIN tebool AS bool DEFAULT false NOT NULL;
create temp table test ( test tebool ) on commit drop ;
CREATE OR REPLACE FUNCTION test()
RETURNS numeric AS $$
DECLARE
r_test test;
begin
return 0;
end; $$ lan
create every column
separately using separate xpath.
Andrus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e products and document info.
Code creates table containing one row for every product and adds same header
fields to all rows.
Whu this will not work ?
Andrus.
as "{"John
Smith"}"
How to force it to appear as John Smith ?
Can this code improved, for example, merging create temp table ... select
and update into single statement ?
Andrus.
create temp table t(x xml) on commit drop;
product code rows if ContactFirstName element is missing ?
In result ContactFirstName column should have null on other value.
Using Postgres 9.1
Andrus.
Testcase :
create temp table t(x xml) on commit drop;
insert into t values('
TEST
n in code below but problem persists.
Andrus.
SELECT 'ALTER TABLE ' || quote_ident(n.nspname) || '.'
|| quote_ident(c.relname) || ' ' ||
string_agg(
' ALTER COLUMN ' || quote_ident(a.attname) || ' TYPE varchar(' ||
i.character_maxim
8 to
20:00, so perfomance is hopafully not an issue. Which to use ?
Using current_date in check constraint causes database restore failure.
not valid should be added or this check should be moved to holydays check
trigger.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general
Hi!
>A correction to this. As it stands, it will show times like the following:
Thank you.
I posted your solution as alternative to Erwin answer in
http://stackoverflow.com/questions/26608683/how-to-find-first-free-start-times-from-reservations-in-postgres
Andrus.
in
pyha table ?
Andrus.
Testcase is:
create table pyha (pyha date primary key);
insert into pyha(pyha) values('2014-10-29');
create table yksus2(yksus char(10) primary key);
insert into yksus2 values ('JOHN'),('MARY');
CREATE EXTENSION btree_gist;
CREATE TABLE reserv
T tsrange(start::timestamp without time zone, finish::timestamp
without time zone );
$BODY$ language sql immutable;
-- Workers
create table yksus2( yksus char(10) primary key);
insert into yksus2 values ('JOHN'), ('MARY');
-- public holidays
create table pyha( pyha date
olumn_name = a.attname)
WHERE t.typname = 'bpchar'
AND c.relkind = 'r'
AND n.nspname <> 'pg_catalog' and not attisdropped
group by 1
)
select prefix || ' '|| body || ';' as statement
from stem
Is this prefect ?
Andrus.
> i.column_name = a.attname)
>WHERE t.typname = 'bpchar'
> AND c.relkind = 'r'
> AND n.nspname <> 'pg_catalog' and not attisdropped;
How to create single alter table command for every table ?
Can we use string concat aggregate function or window functions or plpgsql or
something other ?
Andrus.
t found column which holds
char column defined width.
How get it or is it better to re-write this query using informational_schema
?
How to change this query so that it creates single alter table command for
every table
(with multiple alter column clauses) to increase conversion speed ?
Andrus.
Hi!
also, it generates statement which tries to change all columns to one character
length columns.
Andrus.
From: Andrus
Sent: Monday, October 06, 2014 8:11 PM
To: Melvin Davidson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Converting char to varchar automatically
Hi!
>SEL
pg_attribute a ON a.attrelid = c.oid
> JOIN pg_type t ON t.oid = a.atttypid
> WHERE t.typname = 'char'
> AND n.nspname <> 'pg_catalog';
It does not return any data.
Andrus.
alter column commands and PERFORMs them ?
Any tables have primary keys with char(n) columns and foreign keys on them.
Foreign keys are deferrable and initially immediate.
Will foreign keys allow to perform such alter table alter column commands ?
Or is there better way.
Andrus.
easonable to replace char with varchar.
Andrus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
approximately 800 ms
So it looks like thee is no difference in sequential scan speed and thus no
need to change char types.
Andrus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
storedasafixed-sizedfield
inPostgres.Itistreatedexactlythesameas
varchar(n)exceptforbeingpadded
So char type does not take more space than varchar.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
d kellaaeg and you can create a
functional index that >uses the same calculation. That would be the easiest
way to use this.
Thank you.
I solved this by creating composite index on 3 columns and re-writing query
as Tom recommended.
It looks like Tom's recommendation is simpler for me.
|kellaaeg <= ?someparam
How to fix or other way to speed this query?
Posted also in
http://stackoverflow.com/questions/26161561/how-to-create-composite-index-in-postgres-9
Andrus.
0, 32-bit"
Posted also in
http://stackoverflow.com/questions/26165745/how-find-greatest-tuple-before-given-2-column-tuple-in-postgres-fast
Andrus.
t;t"
at line
RECURSIVE t(n) AS (
recursive b as ( shown in comment
with clause is used to create some non recursive queries (a) .
After them recursive query is defined (b) and after it there are some other
non-recursive queries (c)
Using Postgres 9.1 and above.
Andrus.
untime.
FoxPro expression a+b produces trailing spaces after a .
To get same result I need to + or other operator with this behaviour.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
perator for strings or should some other
notation used ?
I tried:
CREATE OR REPLACE FUNCTION public.concatkeepspaces(left bpchar, right
bpchar)
RETURNS bpchar
LANGUAGE sql IMMUTABLE
AS $BODY$
SELECT concat($1,$2);
$BODY$;
CREATE OPERATOR public.+ (
leftarg = bpchar,
rightarg = bpchar,
proced
How to create string concatenation operator which preserves trailing spaces
on CHAR(n) type columns ?
I tried code below, but it returns AB (without spaces).
How to force it to return A B (keep space after A) ?
Andrus.
CREATE OR REPLACE FUNCTION public.stringconcat(left text, right text
Where to get this fix in binary form for Windows 32-bit ?
Here, but you will need to wait until 9.3.5 is out:
http://www.postgresql.org/download/windows/.
When 9.3.5 or Windows x32 nightly build or test build will be out ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general
But I wouldn't
call that a reliable fix. You'd be better off applying the patch.
Where to get this fix in binary form for Windows 32-bit ?
pg_dump.exe uses files below [1]. Is it sufficient to replace libpq.dll file
?
Where to get its compiled version or how to compile it in Windows ?
[1]
l
p works OK.
Is it OK to use --inserts parameter ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. pg_dump -V returns
pg_dump (PostgreSQL) 9.3.0
Server is x64 :
PostgreSQL 9.3.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit
Can this cause the issue ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
. pg_dump -V returns
pg_dump (PostgreSQL) 9.3.0
Server is x64 :
PostgreSQL 9.3.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit
Can this cause the issue ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
ress and compile something to add diagnozing if this
can help.
Maybe this message can improved to include more details about the reason.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g under VMWare, 2 cores
Apache and Mono 3.2.8 with mod_mono MVC4 applicati is also running in this
server
Client:
Windows computer running 9.3 pg_dump.exe over in LAN but external IP address
(1.2.3.4) is used
It worked if server was Widows 2003 server running earlier Postgres 9
without SSL.
(actual.load,0) as actual,
coalesce(budget.load,0)-coalesce( actual.load,0) as difference
from budget full join actual on (job)
order by contractdate
but this does not distribute budget load to employee rows.
I posted this also in
http://stackoverflow.com/questions/21664842/how-to-distribute-bud
e index tempkaivetoode on tempkaive(toode);
create index tempalgemutoode on tempalgsemu(toode);
and using exists.
Will your suggestion run faster ? Is it reasonable to switch to use your
suggestion ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
MB
Is my setting shared_buffers= 2400MB reasonable in Windows ?
Andrus.
efix";"%t ";"configuration file"
"log_timezone";"Europe/Helsinki";"configuration file"
"logging_collector";"on";"configuration file"
"max_connections";"100";"configuration file"
"max_stack_depth";"2MB";"environment variable"
"port";"5432";"configuration file"
"shared_buffers";"128MB";"configuration file"
"TimeZone";"Europe/Helsinki";"configuration file"
> Also, what is the total memory in the server?
In devel computer where tests are performed, 4 GB
Real server has 16 GB RAM
Real server is for Postgres for this database and ASP.NET MVC3 application
which uses this same database from postgres.
Can settings in real server changed to increase perfomance ?
Andrus.
de)
In development computer from where explain was posted and problem with copy
of database also occurs:
"shared_buffers";"128MB";"configuration file"
> You likely want to bump that up closer to 1GB.
I changed it. Thank you very much.
Andrus.
o.toode = i.toode);
Is this best fix ?
Andrus.
From: Andrus
Sent: Monday, September 23, 2013 6:06 PM
To: Jayadevan M
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query runs forever after upgrading to 9.3
Hi,
thank you.
>Could you please post EXPLAIN for that query?
As recomm
wide?
tempalgsemu has 14 columns
tempkaive has 31 columns
structures are below. Too structure was posted in separate letter.
Andrus.
tempalgsemu :
Field Field Name TypeWidthDec Index Collate Nulls
NextStep
1 ID
is below. It contains 509873 records .
tempkaive and tempalgsemu are big temporary tables created earlier this
transaction. They do not have indexes and have lot of records.
Andrus.
CREATE TABLE firma1.toode
(
grupp character(1),
toode character(20) NOT NULL,
ribakood character(20),
ribakood2
-09-23 15:57:08+03SELECT * FROM toode WHERE toode in (SELECT toode
FROM tempkaive)OR toode in (SELECT toode FROM tempalgsemu)
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
-bit 9.3 in Windows 7 x64 ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ifoexpens and not rid.calculrow
and (not dok.inventuur or rid.kogus<>0 )
GROUP BY 1
) doksumma
left join bilkaib on bilkaib.dokumnr=doksumma.dokumnr and bilkaib.alusdok='LO'
WHERE dok.dokumnr=doksumma.dokumnr
Should this code split into multiple commands to find which part causes
exception or other idea ?
Andrus.
... RaiseException(text, variadic text[])
..
VARIADIC is keyword, not datatype
Thank you.
I tried code below but got error shown in comment.
No idea what I'm doing wrong.
Andrus.
CREATE OR REPLACE FUNCTION RaiseException(text, variadic text[] )
RETURNS void LANGUAGE plpgsql AS
Than you very much.
It worked.
I tried to extend it to pass message parameters. Tried code below but got
syntax error. How to pass message parameters ?
Andrus.
CREATE OR REPLACE FUNCTION RaiseException(text, variadic )
RETURNS void LANGUAGE plpgsql AS
$BODY$
BEGIN
RAISE EXCEPTION $1, $2
I’m looking for a way to raise error from sql select if some condition is met.
Tried code below to got error shown in comment.
How to fix ?
Andrus
CREATE OR REPLACE FUNCTION "exec"(text)
RETURNS text AS
$BODY$
BEGIN
EXECUTE $1;
RETURN $1;
this error occurs ?
Andrus.
2012-06-30 15:51:04 EEST ERROR: duplicate key value violates unique constraint
"klient_pkey"
2012-06-30 15:51:04 EEST DETAIL: Key (kood)=(20037 ) already exists.
2012-06-30 15:51:04 EEST STATEMENT: insert into klient (
kood,
nimi,
pgsql code block ?
Andrus.
'%red%' then 1 else 0 end
+case when productname ilike '%cat%' then 1.7 else 0 end
+case when productdescription ilike '%cat%' then 0.7 else 0 end
from products
order by 1 desc
limit 100
This allows to define relevance.
Is my solution reasonable ?
Andrus
--
is.
Using PostgreSQL 8.2.7 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2
20061115 (prerelease) (Debian 4.1.1-21)
Should I install some contribs to 8.2 or is it better to upgrade server ?
Where to find step by step instructions making this work ?
Andrus.
some ASP.NET
CMS seems best.
Latest Orchad does not run in Mono and PostgreSQL.
Which software is best for PostgreSql ?
Andrus.
crashed server.
pgAdmin shows that there is only public schema without any tables.
Actually there was two schemas with lot of tables.
How to fix this so old data is accessible ?
Andrus.
rom
dynamicwrapper( crosstab('select * from sales', 'select distinct store
from sales' )) x
Where to find generic dynamicwrapper stored procedure which fixes this by
building dynamic query itself or other idea ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
split 1 column
into 3 columns in result without
building query string manually ?
I posted this also in
http://stackoverflow.com/questions/9162497/how-to-generate-crosstab-with-3-columns-for-every-store-in-postgresql
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
12','ST1',400)... ('312','STN',600);
create table budget (
account char(10),
store char(10),
budget numeric(12,2) );
insert into budger values
('311','ST1',200)... ('311','STN',300)
('312','ST1',500)... ('312','STN',700);
Some account and store values may be missing from tables.
Andrus.
for this ?
template0 is read-only, how to connect to and update it using pgAdmin ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Would seem to be one of two things:
1) The initdb is being done before the locale is changed.
or
2) The installation is overriding the locale, though I find this one less
possible than 1.
Thank you.
How to re-configure Postresql db cluster so that uses Debian default system
locale?
Andrus
="et_EE.UTF-8"
LC_NAME="et_EE.UTF-8"
LC_ADDRESS="et_EE.UTF-8"
LC_TELEPHONE="et_EE.UTF-8"
LC_MEASUREMENT="et_EE.UTF-8"
LC_IDENTIFICATION="et_EE.UTF-8"
LC_ALL=
and locale -a show after the above:)?
locale -a
C
en_US.utf8
et_EE.utf8
POS
|
postgres=CTc/postgres
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
plate1 requires exclusive access to cluster.
I cannot force all users to log out while creating new db.
So using template1 is not possible.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is it reasonable to use commands
export LC_COLLATE='et_EE.UTF-8'
export LC_CTYPE='et_EE.UTF-8'
apt-get -t squeeze-backports install postgresql-9.1 postgresql-common
postgresql-contrib
Will this force et_EE.UTF-8 locale ?
Andrus.
--
Sent via pgsql-general mailing
.
How to force server to use et_EE.UTF-8 as default locale without hard coding
it into application?
How to force command
CREATE DATABASE TEMPLATE = template0
to use et_EE.UTF-8 locale by default ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
template0 as
template.
How to create new database with et_EE.UTF-8 collation and character type ?
How to force Postgres installation to create template1 with et_EE.UTF-8
collation and character type ?
Andrus.
contain 0.. 2 salemans, no more:
'Aavo 19%, Peedu 15%'
'Lauri-21%,Peedu 15%'
'Taavi 21%'
Maybe in 8.1 it is possible to write 2 select statements. First will extract
first item and second select
will extract second item if second item exists ?
Andrus.
--
Sent
I tried it but got error in 8.1:
ERROR: function regexp_split_to_table(text, "unknown") does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
how to get data in 8.1 ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-g
vide example, please for 8.1. Or maybe CASE WHEN and substring
testing can also used.
Andrus.
Project table contains salesman names and percents as shown
below. Single comment column contains 1-2 salesman names and commissions.
How select normalized data from this table ?
Andrus.
CREATE TABLE project (
id char(10) primary key,
comment char(254)
);
insert into test values ('20
tros. Adding to postgresql to
startup requires different commands in different distros ?!
Andrus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
kernel.shmmax
419430400
according to
http://www.postgresql.org/docs/current/static/kernel-resources.html
this value should be written to /etc/sysctl.conf
I opened /etc/sysctl.conf but it does not contain this value.
How to make this setting persistent ?
Andrus.
--
Sent via pgsql-general mailing
this there quick guide how to change most important settings.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
achine seems to have 2 GB of ram.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
posssible ? This is dedicated server.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is fresh OS install, only Postgresql server will run in this virtual
maschine.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
~) but 113 is to be
installed
E: Broken packages
root@EEPOLDB01:~#
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ray,
thank you.
Did you do "apt-get update" after adding the line to the source list?
Yes I tried. I tried it again and it looks like the instructons provided in
debian site are invalid.
How to fix ?
Andrus.
root@EEPOLDB01:~# cat /etc/apt/sources.list
deb http://www.backports.
postgresql 8.4 installed.
How to uninstall postgresql 8.4 before installing debian ?
Andrus.
in 8.1+ many char(n) type columns must be in uppercase in database.
What is best way to force this ?
Should insert and update triggers created for every table or is there better
way,
for example by creation domain or adding some attribute to column and
creating global trigger?
Andrus
8.1+ database contains separate schemas for every company named company1,
company2, companyi.
order tables in those schemas contain trigger like for company1:
CREATE OR REPLACE FUNCTION dok_seq_trig() RETURNS "trigger"
AS $$BEGIN
IF NEW.tasudok IS NULL AND NEW.doktyyp!='O' THEN
NEW.tasudo
o invoke asmx web service call (= http POST request) from
PostgreSql server which reads http response to xml_import table ?
How to call stored procedure periodically after every one hour in server?
In this case we can create stored procedure, client side code is not
nessecary at
all.
Andrus.
implemented ?
Andrus.
-Algsõnum-
From: Francisco Figueiredo Jr.
Sent: Saturday, October 08, 2011 11:26 PM
To: Andrus
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to add xml data to table
I think this approach is much better as you can solve everything on
server itself
?
Using npgsql and C# in ASP .NET / Mono.
Andrus.
CREATE TABLE products (
SupplierCode char(20) primary key,
SegmentId char(8),
GroupId char(8),
ClassId char(8),
SeriesId char(8),
VendorId char(2),
PartNumbrt char(27),
Name Text,
Warranty Numeric(6,2),
Price Numeric(10,4),
Quantity Numeric(8,2
1 - 100 of 586 matches
Mail list logo
