Re: [GENERAL] Bind message has 6 results formats but query has 5 columns

umns of a table, then you shouldn't > add the fields of the table in the query component. After dropping a column > you could have a select result of 5 columns and fields for 6 columns. > > Best regards, > Teemu Juntunen > > - Original Message - > From: "J

[GENERAL] Bind message has 6 results formats but query has 5 columns

Windows XP, Using Delphi 7 ADO SQL Query Component to Drop/Delete a Column from a simple table. When I then try to query the table I get this error: "Bind message has 6 results formats but query has 5 columns" Obviously I need to refresh the connection or table but how? I have tried ADOConnectio

Re: [GENERAL] Restoring Database from Data directory backup.

On Jul 14, 12:57 pm, J Ottery <[EMAIL PROTECTED]> wrote: > Using XP Pro and Postgres 8.3 > I made a backup of the "Data" directory of the Postgres Installation > to another place on the hard disk. > Now the customer has uninstalled postgres then reinstalled a new o

[GENERAL] Restoring Database from Data directory backup.

Using XP Pro and Postgres 8.3 I made a backup of the "Data" directory of the Postgres Installation to another place on the hard disk. Now the customer has uninstalled postgres then reinstalled a new one. Of course the original tables are all gone. Is there a method of retrieving the original tables

[GENERAL] Date Formatting for dd/mm/yyyy

Hi all. I am using Postgres 8.3 with Windows XP Pro. System date format is dd/MM/ Having problems when I writing records to a database with a single 'date' type field. e.g. FieldByName('Date').ASString:='2/2/2003' When the row is viewed in pgAdmin it is always 1899-12-30 I have tried chang

[GENERAL] Postgre Deployment and Installation options

I am trying to distribute PostgreSQL with my applications but and need to simplify the installation procedure as much as possible for obvious reasons. Installing it to Windows environments only. Currently I prompt the end user to just start the postgre-8.3.msi install from an icon. This however

Re: [GENERAL] Postgres on shared network drive

On Apr 11, 5:34 pm, [EMAIL PROTECTED] ("A. Kretschmer") wrote: > am Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes: > > > Using windows XP and TCP/IP network. > > > I install PostgreSQL on a client PC and put the data files on a > > networ

[GENERAL] PostgresSQL on a networked drive with multiple users

Thanks Craig for making me look like an idiot. I feel bad now. When I posted I suspected that what you have just replied with was the case. I have some leaning to do on this. Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:/

[GENERAL] Postgres on shared network drive

Using windows XP and TCP/IP network. I install PostgreSQL on a client PC and put the data files on a networked drive (instead of the local drive). Postgres as user and localport. This works well. Now I install postgresSQL on another client machine and point it to the same data directory on the n

[GENERAL] OLEDB vs ODBC to access postgres

I am using a grid component (delphi) connected via Postgres ODBC , and via Datasource - ADOTable - ADOConnection to a postgres database. All works well. Tried using the PostgreSQL Native Provider, built a working connection string. It connects OK but I have only read access to the data (in the gri

[GENERAL] Using MicroOLAP DAC to connect to Database - Problem with Grid

Running Windows XP. Delphi 7 programming environment Installed PostgreSQL. Downloaded and installed TRIAL MicroOLAP DAC components for postgreSQL. Linked to a DBGrid component via PSQLTable and Datasource. I can connect to and view the table in the grid BUT if I try to add (post) a record (just b