>
>
> That seems like a remarkably strange definition of a primary key.
> Are all of those columns really identification of an object, and
> not properties of the object?
>
> In any case, I'll bet a lot of money that your can't-update problem
> is related to the fuzzy behavior of floating-point co
Marco Fochesato writes:
> CREATE TABLE public.forniture_ee
> (
> id_cliente integer NOT NULL,
> pod character varying(14) NOT NULL,
> id_fornitore integer NOT NULL,
> mese integer NOT NULL,
> anno integer NOT NULL,
> imponibile_fornitura double precision NOT NULL,
> lettura character
> On 02.07.2018, at 17:59, Marco Fochesato wrote:
>
>
>>
>> I would suggest writing a self-contained script that creates the table,
>> inserts a single record, and updates that record. Present that for
>> consideration along with a description or capture of the results of running
>> the s
>> On 02.07.2018, at 17:59, Marco Fochesato wrote:
>>
>>
>>>
>>> I would suggest writing a self-contained script that creates the table,
>>> inserts a single record, and updates that record. Present that for
>>> consideration along with a description or capture of the results of running
>>
On 07/02/2018 09:59 AM, Marco Fochesato wrote:
I would suggest writing a self-contained script that creates the
table, inserts a single record, and updates that record. Present
that for consideration along with a description or capture of the
results of running the script on
On Mon, Jul 2, 2018 at 8:59 AM, Marco Fochesato wrote:
>
>
>> I would suggest writing a self-contained script that creates the table,
>> inserts a single record, and updates that record. Present that for
>> consideration along with a description or capture of the results of running
>> the script
>
> I would suggest writing a self-contained script that creates the table,
> inserts a single record, and updates that record. Present that for
> consideration along with a description or capture of the results of running
> the script on your machine.
>
>
But not all the records fail the update..
On Mon, Jul 2, 2018 at 8:38 AM, Marco Fochesato wrote:
> anything else to make the situation more clear (like errors in the
>> logfile, or anything else you think is relevant)
>>
> No errors in the GUI, no errors in PgAdmin.log
>
>
I would suggest writing a self-contained script that creates the
>
> postgres version
>
10, but I have loaded the database in older versions of Postgresql and the
problem remain.
> your table structure
>
CREATE TABLE public.forniture_ee
(
id_cliente integer NOT NULL,
pod character varying(14) NOT NULL,
id_fornitore integer NOT NULL,
mese integer NOT NUL
On 07/02/2018 08:31 AM, Marco Fochesato wrote:
Please reply to list also.
Ccing list.
Do you mean the Primary Key is constructed from 20 columns?
yes.
Are there any error messages and if so what are they?
No error messages
To answer your questions will need to see(per previous
pinker writes:
> Something strange happened to me right now. I'm trying to compare results
> from one query with rewritten version and everything is ok with this order:
> WITH abc AS (SELECT 1) SELECT 1
> except all
> SELECT 1
> but when I'm trying other way around it throws an error:
> SELECT 1
On 07/02/2018 07:51 AM, Marco Fochesato wrote:
Dear all,
I have a table with 21 columns.
Primary key is done with 20 of these colums.
Do you mean the Primary Key is constructed from 20 columns?
I have 3.313 records.
I don't know why, but I'm not able to update some of these records.
What i
Il 02/07/2018 16:51, Marco Fochesato ha scritto:
Dear all,
I have a table with 21 columns.
Primary key is done with 20 of these colums.
I have 3.313 records.
I don't know why, but I'm not able to update some of these records.
I don't understand, it seems that I'm not able to fetch.
Could you pos
Hi Marco,
I think more information would give to us a better picture.
can you please post the following?
postgres version
your table structure
how you are updating the records
if the problem is reproducible directly from the postgres prompt
how you are fetching results after the update
anyt
> I have a table with 21 columns.
> Primary key is done with 20 of these colums.
Oh, okay. What data types do these encompass?
> I don't know why, but I'm not able to update some of these records.
> I don't understand, it seems that I'm not able to fetch.
You mean you can't query them with all 2
Dear all,
I have a table with 21 columns.
Primary key is done with 20 of these colums.
I have 3.313 records.
I don't know why, but I'm not able to update some of these records.
I don't understand, it seems that I'm not able to fetch.
It happens with Pgadmin, with Python Psycopg2 and also through L
Hi!
Something strange happened to me right now. I'm trying to compare results
from one query with rewritten version and everything is ok with this order:
WITH abc AS (SELECT 1) SELECT 1
except all
SELECT 1
but when I'm trying other way around it throws an error:
SELECT 1
except all
WITH abc AS (S
On Mon, Jul 2, 2018 at 10:14 AM, Łukasz Jarych wrote:
>
> Hi,
>
> i see. thank you
>
> I am using:
>
> [image: image.png]
>
> Best,
> Jacek
>
> pon., 2 lip 2018 o 16:03 Adrian Klaver
> napisał(a):
>
>> On 07/02/2018 06:57 AM, Łukasz Jarych wrote:
>> > Hi,
>> >
>> > "
>> > Strange. "audit_sq" loo
Hi,
i see. thank you
I am using:
[image: image.png]
Best,
Jacek
pon., 2 lip 2018 o 16:03 Adrian Klaver
napisał(a):
> On 07/02/2018 06:57 AM, Łukasz Jarych wrote:
> > Hi,
> >
> > "
> > Strange. "audit_sq" looks like an invalid sequence table. I went
> > here,https://www.postgresql.org/docs/9.
On 07/02/2018 06:57 AM, Łukasz Jarych wrote:
Hi,
"
Strange. "audit_sq" looks like an invalid sequence table. I went
here,https://www.postgresql.org/docs/9.6/static/sql-createsequence.html,
and checked all the way back to version 7.1 and "maxvalue" has been a
column since back then.
What ver
Hi,
"
Strange. "audit_sq" looks like an invalid sequence table. I went here,
https://www.postgresql.org/docs/9.6/static/sql-createsequence.html, and
checked all the way back to version 7.1 and "maxvalue" has been a column
since back then.
Maybe skip that table for now? It even says the last value
=?UTF-8?Q?=C5=81ukasz_Jarych?= writes:
> I am trying to use :
> "select * from clone_schema('public','Version8',true) but i am getting
> error:
> "Column "max_value" does not exist.
> LINE 1: SELECT last_value, max_value, start_value, increment_by, min...
> HINT: Maybe you wanted to point to col
Hi ,
thank you !
You have right:
[image: image.png]
Hmm i thought that i am creating this table " audit_sq " within clone
schema and this function is complete.
How can i fix this?
Best,
Jacek
pon., 2 lip 2018 o 13:51 Victor Noagbodji
napisał(a):
> Hello,
>
> Can you check if the table "
Hi,
i am trying to use postgresql clone schema function:
https://www.postgresql.org/message-id/CANu8FiwiBiAjYgdehYBkJcSRFd6ZFFnN5kDJE7TG4rad5BNXZQ%40mail.gmail.com
I created function clone_schema in public schema:
[image: image.png]
I am trying to use :
"select * from clone_schema('public','
24 matches
Mail list logo
